Table Detail Report
RC_F_DLY_CODING_ACT_SMRY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Daily Coding Action Summary |
| Definition: | This table will store monthly summarization of coding activity by coding personnel. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_DLY_CODING_ACT_SMRY
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVITY_DT_NBR | DOUBLE | N | The Cerner Julian number representing the date. |
| FIRST_PROCESS_DT_TM | DATETIME | N | The date/time that the first ETL process started that created this record. |
| LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
| MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Represents the transaction's logical domain. |
| RC_D_CODING_ACTION_ID | DOUBLE | N | Uniquely identifies the coding activity related to this fact row. |
| RC_D_DRG_ID | DOUBLE | N | Uniquely identifies the DRG associated tot the encounter related to this coding activity. |
| RC_D_ENCNTR_TYPE_CLASS_ID | DOUBLE | N | Uniquely identifies the encounter type class of the encounter associated to this coding activity. |
| RC_D_MEDICAL_SERVICE_ID | DOUBLE | N | Uniquely identifies medical service information such as type or category, that the patient is receiving in relation to this coding activity |
| RC_D_PRI_FIN_CLASS_ID | DOUBLE | N | Number that uniquely identifies the primary financial class related to this fact row. |
| RC_D_PRI_HEALTH_PLAN_ID | DOUBLE | N | Uniquely identifies the primary health plan related to this fact row. |
| RC_F_DLY_CODING_ACT_SMRY_ID | DOUBLE | N | unique generated number that identifies a row on the RC_F_MTH_CODING_ACT_SMRY table. |
| SHR_D_CODING_PRSNL_ID | DOUBLE | N | Uniquely identifies the coding personnel related to this coding activity. |
| SHR_D_LOCATION_ID | DOUBLE | N | Uniquely identifies location information such as facility and building name. |
| TOTAL_ACTIONS_COUNT | DOUBLE | N | The total actions count per coding personnel. |
| TOTAL_ENCOUNTER_COUNT | DOUBLE | N | The total number of encounters associated to this coding activity. |
| TOTAL_FE_BALANCE_AMT | DOUBLE | N | The total of the financial encounter balance amount for the patient who had the coding activity. |
| TOTAL_LENGTH_OF_STAY | DOUBLE | N | The total number of midnights the patient stays in the hospital, from admission to either discharge or coding activity date, which ever occurs first. |
| UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
| UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
| UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
| UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
| UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - RC_F_DLY_CODING_ACT_SMRY
| Child Column in RC_F_DLY_CODING_ACT_SMRY(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ACTIVITY_DT_NBR | OMF_DATE | DT_NBR |
| RC_D_CODING_ACTION_ID | RC_D_CODING_ACTION | RC_D_CODING_ACTION_ID | |
| RC_D_DRG_ID | RC_D_DRG | RC_D_DRG_ID | |
| RC_D_ENCNTR_TYPE_CLASS_ID | RC_D_ENCNTR_TYPE_CLASS | RC_D_ENCNTR_TYPE_CLASS_ID | |
| RC_D_PRI_FIN_CLASS_ID | RC_D_FINANCIAL_CLASS | RC_D_FINANCIAL_CLASS_ID | |
| RC_D_PRI_HEALTH_PLAN_ID | RC_D_HEALTH_PLAN | RC_D_HEALTH_PLAN_ID | |
| RC_D_MEDICAL_SERVICE_ID | RC_D_MEDICAL_SERVICE | RC_D_MEDICAL_SERVICE_ID | |
| SHR_D_LOCATION_ID | SHR_D_LOCATION | SHR_D_LOCATION_ID | |
| SHR_D_CODING_PRSNL_ID | SHR_D_PERSON | SHR_D_PERSON_ID |
RC_F_GENERAL_AR_BALANCE
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact General AR Balance |
| Definition: | This table contains data related to General AR account balances. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_GENERAL_AR_BALANCE
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVITY_DT_NBR | DOUBLE | N | **obsolete** This column is no longer being used. It has been replaced by the begin_dt_nbr and end_dt_nbr. A number representing the activity date. References the key in the OMF_DATE table. ** obsolete** |
| BALANCE_AMT | DOUBLE | N | ** Obsolete ** No longer used. Contains the Balance of the General AR account. *** Obsolete *** |
| BEGIN_BALANCE_AMT | DOUBLE | Y | The opening balance for the given activity date. |
| BEGIN_DT_NBR | DOUBLE | N | A number representing the begin date of this balance fact row. References the related row in the OMF_DATE table. |
| DAILY_ADJUSTMENT_AMT | DOUBLE | N | Contains the adjustment amount per day. |
| DAILY_PAYMENT_AMT | DOUBLE | N | Contains the payment amount per day. |
| END_BALANCE_AMT | DOUBLE | Y | The ending balance for the given activity date. |
| END_DT_NBR | DOUBLE | N | A number representing the end date of this balance fact row. References the related row in the OMF_DATE table. |
| FIRST_PROCESS_DT_TM | DATETIME | N | The date/time that the first ETL process started that created this record. |
| LAST_ADJUSTMENT_DT_NBR | DOUBLE | N | A number representing the most recent adjustment date of this fact row. References the related row on the OMF_DATE table. |
| LAST_PAYMENT_DT_NBR | DOUBLE | N | A number representing the most recent adjustment date of this fact row. References the related row on the OMF_Date table. |
| LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
| MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the logical domain to which the row data belongs. |
| RC_D_ACCOUNT_ID | DOUBLE | N | Uniquely identifies account information related to this fact. |
| RC_D_ACCOUNT_TYPE_ID | DOUBLE | N | Unique genereated number that identifies the row on the rc_d_account_type table related to this fact. |
| RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies billing entity information related to this fact row. |
| RC_F_GENERAL_AR_BALANCE_ID | DOUBLE | N | Uniquely identifies General AR Balance information. |
| TIME_ZONE_INDEX | DOUBLE | N | Stores the time zone from which the data was extracted. |
| TOTAL_ADJUSTMENT_AMT | DOUBLE | N | ** obsolete ** this column is no longer being used. Contains the total of the adjustments. ** obsolete ** |
| TOTAL_PAYMENT_AMT | DOUBLE | N | ** obsolete ** This column is no longer being used. Contains the total of the payments. ** obsolete ** |
| UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - RC_F_GENERAL_AR_BALANCE
| Child Column in RC_F_GENERAL_AR_BALANCE(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ACTIVITY_DT_NBR | OMF_DATE | DT_NBR |
| BEGIN_DT_NBR | OMF_DATE | DT_NBR | |
| END_DT_NBR | OMF_DATE | DT_NBR | |
| LAST_ADJUSTMENT_DT_NBR | OMF_DATE | DT_NBR | |
| LAST_PAYMENT_DT_NBR | OMF_DATE | DT_NBR | |
| RC_D_ACCOUNT_ID | RC_D_ACCOUNT | RC_D_ACCOUNT_ID | |
| RC_D_BILLING_ENTITY_ID | RC_D_BILLING_ENTITY | RC_D_BILLING_ENTITY_ID |
RC_F_GENERAL_AR_BAL_TRANS
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | RC_F_GENERAL_AR_BAL_TRANS |
| Definition: | Revenue Cycle Fact General Accounts Receivable Balance Transaction |
| Table Type: | ACTIVITY |
Column Detail - RC_F_GENERAL_AR_BAL_TRANS
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVITY_DT_NBR | DOUBLE | N | A number representing the activity date. References the key in the OMF_DATE table. |
| MILL_ACTIVITY_ID | DOUBLE | N | Number that identifies the row in the pft_trans_reltn millennium database table from which this row was derived. |
| MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the logical domain to which the row data belongs. |
| POST_DT_NBR | DOUBLE | N | A number representing the post date. References the key in the OMF_DATE table. |
| RC_D_ACCOUNT_ID | DOUBLE | N | Uniquely identifies a row on the Account Dimension row related to this fact row |
| RC_D_ACCOUNT_TYPE_ID | DOUBLE | N | Unique genereated number that identifies the row on the rc_d_account_type table related to this fact. |
| RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the Billing Entity Dimension row related to this fact row. |
| RC_D_TRANSACTION_ALIAS_ID | DOUBLE | N | Uniquely identifies a Transaction Alias Dimension row related to this fact row |
| RC_D_TRANSACTION_BATCH_ID | DOUBLE | N | Uniquely identifies a Transaction Batch Dimension row related to this fact row |
| RC_D_TRANSACTION_TYPE_ID | DOUBLE | N | Uniquely identifies a Transaction Type Dimension row realted to this fact row |
| RC_F_GENERAL_AR_BAL_TRANS_ID | DOUBLE | N | PRIMARY KEY |
| SHR_D_POSTING_PRSNL_ID | DOUBLE | N | Uniquely identifies a row on the Shared Person Dimension table that represents the person who posted the information about the related fact row |
| TIME_ZONE_INDEX | DOUBLE | N | Stores the time zone from which the data was extracted |
| TRANSACTION_AMT | DOUBLE | N | Contains the dollar amount associated to the given transaction |
| UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - RC_F_GENERAL_AR_BAL_TRANS
| Child Column in RC_F_GENERAL_AR_BAL_TRANS(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ACTIVITY_DT_NBR | OMF_DATE | DT_NBR |
| POST_DT_NBR | OMF_DATE | DT_NBR | |
| RC_D_ACCOUNT_ID | RC_D_ACCOUNT | RC_D_ACCOUNT_ID | |
| RC_D_ACCOUNT_TYPE_ID | RC_D_ACCOUNT_TYPE | RC_D_ACCOUNT_TYPE_ID | |
| RC_D_BILLING_ENTITY_ID | RC_D_BILLING_ENTITY | RC_D_BILLING_ENTITY_ID | |
| RC_D_TRANSACTION_ALIAS_ID | RC_D_TRANSACTION_ALIAS | RC_D_TRANSACTION_ALIAS_ID | |
| RC_D_TRANSACTION_BATCH_ID | RC_D_TRANSACTION_BATCH | RC_D_TRANSACTION_BATCH_ID | |
| RC_D_TRANSACTION_TYPE_ID | RC_D_TRANSACTION_TYPE | RC_D_TRANSACTION_TYPE_ID | |
| SHR_D_POSTING_PRSNL_ID | SHR_D_PERSON | SHR_D_PERSON_ID |
RC_F_INVOICE_AR_BALANCE
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Invoice AR Balance |
| Definition: | This table contains data related to client invoices. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_INVOICE_AR_BALANCE
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVITY_DT_NBR | DOUBLE | N | A number representing the activity date. References the key in the OMF_DATE table. |
| ADMIT_DT_NBR | DOUBLE | N | A number representing the admit date. |
| BALANCE_AMT | DOUBLE | N | ** Obsolete ** This column is no longer being used. Contains the invoice balance. ** Obsolete ** |
| BILL_AGE | DOUBLE | N | ** Obsolete ** This column is no longer being used. Contains the number of days that result from the difference between the current activity data and the transmission date of the bill. ** Obsolete ** |
| BILL_NUMBER_IDENT | VARCHAR(40) | N | Contains the display value associated to a bill number. |
| DAILY_ADJUSTMENT_AMT | DOUBLE | N | ** Obsolete ** - No longer used. Contains the adjustment amount per day. ** Obsolete ** |
| DAILY_CHARGE_AMT | DOUBLE | N | ** Obsolete ** - No longer used. Contains the daily charge amount per day. ** Obsolete **. |
| DAILY_PAYMENT_AMT | DOUBLE | N | ** Obsolete ** - No longer used. Contains the payment amount per day. ** Obsolete ** |
| DISCHARGE_DT_NBR | DOUBLE | Y | The Discharge Date of the Patient |
| FIN_NBR_IDENT | VARCHAR(50) | N | Financial Number of the patient |
| FIRST_PROCESS_DT_TM | DATETIME | N | The date/time that the first ETL process started that created this record. |
| INVOICE_AGE | DOUBLE | N | Contains the number of days that result from the difference between the current activity date and the submission date of the bill. |
| INVOICE_BALANCE_AMT | DOUBLE | Y | Contains the invoice balance due. |
| INVOICE_GENERATION_DT_NBR | DOUBLE | N | Date the invoice was generated. |
| INVOICE_LAST_ADJUSTMENT_DT_NBR | DOUBLE | N | Date of the last time a adjusment was made to the financial encounter. |
| INVOICE_LAST_PAYMENT_DT_NBR | DOUBLE | N | Date of the last time a payment was made against the invoice. |
| INVOICE_ORIG_BALANCE_AMT | DOUBLE | N | Contains the original invoice balance. |
| INVOICE_SUBMISSION_DT_NBR | DOUBLE | Y | The date the invoice was submited |
| INVOICE_TOTAL_ADJUSTMENT_AMT | DOUBLE | N | Contains the total of the adjustments at invoice level |
| INVOICE_TOTAL_CHARGE_AMT | DOUBLE | N | Contains the total of the charges at invoice level |
| INVOICE_TOTAL_PAYMENT_AMT | DOUBLE | N | Contains the total of the payments at invoice level |
| INVOICE_TRANSMISSION_DT_NBR | DOUBLE | N | The date the invoice was transmitted |
| LAST_ADJUSTMENT_DT_NBR | DOUBLE | N | ** Obsolete ** - No longer used. Date of the last time a adjusment was made to the financial encounter. ** Obsolete ** |
| LAST_CHARGE_DT_NBR | DOUBLE | N | ** Obsolete ** No longer being used. Date of the last time a charge was posted to the financial encounter. ** Obsolete ** |
| LAST_PAYMENT_DT_NBR | DOUBLE | N | ** Obsolete ** - No longer being used. Date of the last time a payment was made to the financial encounter. ** Obsolete ** |
| LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
| MILL_CORSP_ID | DOUBLE | N | Uniquely identifies the related BILL_REC row on Millennium. |
| MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the logical domain to which the row data belongs. |
| MILL_PFT_ENCNTR_ID | DOUBLE | N | Uniquely identifies the Millennium Profit Encounter record that relates to this fact row. |
| MRN_NBR_IDENT | VARCHAR(50) | N | Identifier of a medical record number. |
| ORIGINAL_BILL_DT_NBR | DOUBLE | N | ** Obsolete ** This column is no longer being used. A number representing the original bill date. References the key in the OMF_DATE table. ** Obsolete ** |
| RC_D_ACCOUNT_ID | DOUBLE | N | Uniquely identifies account information related to this fact. |
| RC_D_ACCOUNT_TYPE_ID | DOUBLE | N | Unique genereated number that identifies the row on the rc_d_account_type table related to this fact. |
| RC_D_AGE_BY_BILL_ID | DOUBLE | N | ** Obsolete ** This column is no longer being used. Relates this fact row to a specific age category. ** Obsolete ** |
| RC_D_AGE_BY_INVOICE_ID | DOUBLE | N | Relates this fact row to a specific age category. |
| RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the billing entity related to this fact row. |
| RC_D_BILL_PROPERTY_ID | DOUBLE | N | Uniquely identifies bill property information related to this fact row |
| RC_D_ENCNTR_TYPE_CLASS_ID | DOUBLE | N | Uniquely identifies encounter type class information related to this fact row |
| RC_F_INVOICE_AR_BALANCE_ID | DOUBLE | N | Uniquely identifies data related to client invoices. |
| SHR_D_LOCATION_ID | DOUBLE | N | Uniquely identifies location information related to this fact row. |
| SHR_D_PERSON_ID | DOUBLE | N | Uniquely identifies person information related to this fact row. |
| TIME_ZONE_INDEX | DOUBLE | N | Stores the time zone from which the data was extracted |
| TOTAL_ADJUSTMENT_AMT | DOUBLE | N | ** Obsolete ** No longer being used. The total of the adjustments. ** Obsolete ** |
| TOTAL_CHARGE_AMT | DOUBLE | N | ** Obsolete ** - No longer used. The total of the charges. ** Obsolete ** |
| TOTAL_PAYMENT_AMT | DOUBLE | N | ** Obsolete ** No longer used. The total of the payments. ** Obsolete ** |
| UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - RC_F_INVOICE_AR_BALANCE
| Child Column in RC_F_INVOICE_AR_BALANCE(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ACTIVITY_DT_NBR | OMF_DATE | DT_NBR |
| DISCHARGE_DT_NBR | OMF_DATE | DT_NBR | |
| INVOICE_GENERATION_DT_NBR | OMF_DATE | DT_NBR | |
| INVOICE_LAST_ADJUSTMENT_DT_NBR | OMF_DATE | DT_NBR | |
| INVOICE_LAST_PAYMENT_DT_NBR | OMF_DATE | DT_NBR | |
| INVOICE_SUBMISSION_DT_NBR | OMF_DATE | DT_NBR | |
| INVOICE_TRANSMISSION_DT_NBR | OMF_DATE | DT_NBR | |
| LAST_ADJUSTMENT_DT_NBR | OMF_DATE | DT_NBR | |
| LAST_CHARGE_DT_NBR | OMF_DATE | DT_NBR | |
| LAST_PAYMENT_DT_NBR | OMF_DATE | DT_NBR | |
| RC_D_ACCOUNT_ID | RC_D_ACCOUNT | RC_D_ACCOUNT_ID | |
| RC_D_ACCOUNT_TYPE_ID | RC_D_ACCOUNT_TYPE | RC_D_ACCOUNT_TYPE_ID | |
| RC_D_AGE_BY_BILL_ID | RC_D_AGE_CATEGORY | RC_D_AGE_CATEGORY_ID | |
| RC_D_AGE_BY_INVOICE_ID | RC_D_AGE_CATEGORY | RC_D_AGE_CATEGORY_ID | |
| RC_D_BILLING_ENTITY_ID | RC_D_BILLING_ENTITY | RC_D_BILLING_ENTITY_ID | |
| RC_D_BILL_PROPERTY_ID | RC_D_BILL_PROPERTY | RC_D_BILL_PROPERTY_ID | |
| RC_D_ENCNTR_TYPE_CLASS_ID | RC_D_ENCNTR_TYPE_CLASS | RC_D_ENCNTR_TYPE_CLASS_ID | |
| SHR_D_LOCATION_ID | SHR_D_LOCATION | SHR_D_LOCATION_ID | |
| SHR_D_PERSON_ID | SHR_D_PERSON | SHR_D_PERSON_ID |
RC_F_INVOICE_AR_BAL_INV
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Invoice AR Balance |
| Definition: | This table contains summarized client AR balance data at the account level. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_INVOICE_AR_BAL_INV
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
| ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
| ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
| ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
| ACTIVITY_DT_NBR | DOUBLE | N | A number representing the activity date. References the key in the OMF_DATE table. |
| BALANCE_AMT | DOUBLE | N | The invoice balance amount that is due. |
| BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
| END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
| FIRST_PROCESS_DT_TM | DATETIME | N | The date/time that the first ETL process started that created this record. |
| GENERATION_DT_NBR | DOUBLE | N | The date the invoice was generated. |
| INVOICE_AGE | DOUBLE | N | Contains the number of days that result from the difference between the current activity date and the submission date of the bill. |
| INVOICE_IDENT | VARCHAR(40) | N | Contains the display value assoicated to an invoice. |
| LAST_ADJUSTMENT_DT_NBR | DOUBLE | N | A number representing the most recent adjustment date of this balance fact row. References the key in the OMF_DATE table. |
| LAST_PAYMENT_DT_NBR | DOUBLE | N | Date of the last time a payment was made against the invoice. Related to the OMF_DATE table. |
| LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
| MILL_CORSP_ID | DOUBLE | N | Uniquely identifies the related row on the Millennium BILL_REC table |
| MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the related logical domain record. |
| ORIG_BALANCE_AMT | DOUBLE | Y | Contains the original invoice balance. |
| RC_D_ACCOUNT_ID | DOUBLE | N | Uniquely identifies account information related to this fact row. |
| RC_D_ACCOUNT_TYPE_ID | DOUBLE | N | Uniquely identifies account type information related to this fact row. |
| RC_D_AGE_BY_INVOICE_ID | DOUBLE | N | Relates this fact row to a specific age category. |
| RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifiies the billing entity related to this fact row. |
| RC_F_INVOICE_AR_BAL_INV_ID | DOUBLE | N | Contains accounts receivable balance invoice summary information. |
| SUBMISSION_DT_NBR | DOUBLE | N | The date the invoice was submitted. Relates to the OMF Date table. |
| TIME_ZONE_INDEX | DOUBLE | N | Stores the time zone from which the data was extracted. |
| TOTAL_ADJUSTMENT_AMT | DOUBLE | Y | The total adjustment made against the invoice. |
| TOTAL_CHARGE_AMT | DOUBLE | Y | The total charge made against the invoice. |
| TOTAL_PAYMENT_AMT | DOUBLE | Y | The total payment made against the invoice. |
| TRANSMISSION_DT_NBR | DOUBLE | N | The date the invoice was transmitted. |
| UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - RC_F_INVOICE_AR_BAL_INV
| Child Column in RC_F_INVOICE_AR_BAL_INV(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ACTIVITY_DT_NBR | OMF_DATE | DT_NBR |
| GENERATION_DT_NBR | OMF_DATE | DT_NBR | |
| LAST_ADJUSTMENT_DT_NBR | OMF_DATE | DT_NBR | |
| LAST_PAYMENT_DT_NBR | OMF_DATE | DT_NBR | |
| SUBMISSION_DT_NBR | OMF_DATE | DT_NBR | |
| TRANSMISSION_DT_NBR | OMF_DATE | DT_NBR | |
| RC_D_ACCOUNT_ID | RC_D_ACCOUNT | RC_D_ACCOUNT_ID | |
| RC_D_ACCOUNT_TYPE_ID | RC_D_ACCOUNT_TYPE | RC_D_ACCOUNT_TYPE_ID | |
| RC_D_AGE_BY_INVOICE_ID | RC_D_AGE_CATEGORY | RC_D_AGE_CATEGORY_ID | |
| RC_D_BILLING_ENTITY_ID | RC_D_BILLING_ENTITY | RC_D_BILLING_ENTITY_ID |