Table Detail Report
RC_D_AMOUNT_CATEGORY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Dimension Amount Category |
| Definition: | Contains pre-defined currency range categories. |
| Table Type: | REFERENCE |
Column Detail - RC_D_AMOUNT_CATEGORY
| 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. |
| BEGIN_AMOUNT | DOUBLE | N | The beginning amount for this category. |
| 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. |
| CATEGORY_DESCRIPTION | VARCHAR(100) | N | The textual description of the given amount category. |
| END_AMOUNT | DOUBLE | N | The ending amount for this category. |
| 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. |
| 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_AMOUNT_CATEGORY_ID | DOUBLE | N | Uniquely identifies a given amount category. |
| 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_D_AMOUNT_CATEGORY
| Parent Column in RC_D_AMOUNT_CATEGORY (PK) | Child Table Name | Child Column Name | |
|---|---|---|---|
| Children: | RC_D_AMOUNT_CATEGORY_ID | RC_F_PATIENT_AR_BALANCE | RC_D_BAL_AMT_CATEGORY_ID |
| RC_F_PATIENT_AR_BALANCE | RC_D_UNBILLED_BAL_AMT_CAT_ID | ||
| RC_F_PATIENT_AR_BAL_SMRY | RC_D_BAL_AMT_CATEGORY_ID | ||
| RC_F_PATIENT_AR_BAL_SMRY | RC_D_UNBILLED_BAL_AMT_CAT_ID |
RC_D_BALANCE_GROUP
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Demension Balance Group |
| Definition: | This table contains the information about the balance groups to which an account can be associated. i.e. Selfpay, Institutional, Professional |
| Table Type: | REFERENCE |
Column Detail - RC_D_BALANCE_GROUP
| 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. |
| BALANCE_GROUP_TXT | VARCHAR(20) | N | Balance Group (i.e. Selfpay, Institutional, Professional) |
| 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. |
| LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
| RC_D_BALANCE_GROUP_ID | DOUBLE | N | Uniquely identifies a balance group. |
| 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_D_BALANCE_GROUP
| Parent Column in RC_D_BALANCE_GROUP (PK) | Child Table Name | Child Column Name | |
|---|---|---|---|
| Children: | RC_D_BALANCE_GROUP_ID | RC_F_BALANCE_AR | RC_D_BALANCE_GROUP_ID |
| RC_F_DAILY_BAL_AR_SMRY | RC_D_BALANCE_GROUP_ID |
RC_D_BALANCE_TYPE
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Dimension Balance Type |
| Definition: | This table contains the information about the balance types to which an account can be associated. |
| Table Type: | REFERENCE |
Column Detail - RC_D_BALANCE_TYPE
| 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. |
| BALANCE_STATUS | VARCHAR(20) | N | Contains the status of the balance. (i.e. DNFB, In-House, Billed, BD) |
| BALANCE_TYPE | VARCHAR(20) | N | Type of Balance (i.e. Debit - AR, Credit - AR, Zero - AR, B/D) |
| 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. |
| LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
| RC_D_BALANCE_TYPE_ID | DOUBLE | N | Uniquely identifies the different balance types to which an account can be associated. |
| 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_D_BALANCE_TYPE
| Parent Column in RC_D_BALANCE_TYPE (PK) | Child Table Name | Child Column Name | |
|---|---|---|---|
| Children: | RC_D_BALANCE_TYPE_ID | RC_F_ALL_AR_SMRY | RC_D_BALANCE_TYPE_ID |
| RC_F_BALANCE_AR | RC_D_BALANCE_TYPE_ID | ||
| RC_F_DAILY_BAL_AR_SMRY | RC_D_BALANCE_TYPE_ID | ||
| RC_F_PATIENT_AR_BAL_SMRY | RC_D_BALANCE_TYPE_ID |
RC_D_BILLING_ENTITY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Dimension Billing Entity |
| Definition: | This table contains data pertaining to the Billing Entity such as Name and Type. |
| Table Type: | REFERENCE |
Column Detail - RC_D_BILLING_ENTITY
| 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. |
| 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. |
| BILLING_ENTITY_NAME | VARCHAR(50) | N | Allows for the billing entity to have a different name than the organization to which it is related. |
| BILLING_ENTITY_TYPE | VARCHAR(40) | N | Shows whether the Billing entity is a Participating or Non-Participating Billing Entity. |
| DELIVERY_SYSTEM | VARCHAR(50) | N | Contains the name of the Delivery System. |
| 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. |
| LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
| MILL_BILLING_ENTITY_ID | DOUBLE | N | Contains the identifier of the Billing Entity on the Millennium database from which this row was derived. |
| MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the logical domain to which the row data belongs. |
| RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies data pertaining to the Billing entity such as Name and Type. |
| 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_D_BILLING_ENTITY
| Parent Column in RC_D_BILLING_ENTITY (PK) | Child Table Name | Child Column Name | |
|---|---|---|---|
| Children: | RC_D_BILLING_ENTITY_ID | RC_F_ADJUSTMENT | RC_D_BILLING_ENTITY_ID |
| RC_F_ALL_AR_SMRY | RC_D_BILLING_ENTITY_ID | ||
| RC_F_BALANCE_AR | RC_D_BILLING_ENTITY_ID | ||
| RC_F_CASH | RC_D_BILLING_ENTITY_ID | ||
| RC_F_CLAIM_EVENT | RC_D_BILLING_ENTITY_ID | ||
| RC_F_DAILY_BAL_AR_SMRY | RC_D_BILLING_ENTITY_ID | ||
| RC_F_DAILY_CDM_SMRY | RC_D_BILLING_ENTITY_ID | ||
| RC_F_DAILY_CLAIM_EVENT_SMRY | RC_D_BILLING_ENTITY_ID | ||
| RC_F_DAILY_DENIAL_SMRY | RC_D_BILLING_ENTITY_ID | ||
| RC_F_DAILY_TRANS_SMRY | RC_D_BILLING_ENTITY_ID | ||
| RC_F_DAYS_IN_AR_SMRY | RC_D_BILLING_ENTITY_ID | ||
| RC_F_DENIAL | RC_D_BILLING_ENTITY_ID | ||
| RC_F_DLY_CHRG_ASSOC_SMRY | RC_D_BILLING_ENTITY_ID | ||
| RC_F_GENERAL_AR_BALANCE | RC_D_BILLING_ENTITY_ID | ||
| RC_F_GENERAL_AR_BAL_TRANS | RC_D_BILLING_ENTITY_ID | ||
| RC_F_INVOICE_AR_BALANCE | RC_D_BILLING_ENTITY_ID | ||
| RC_F_INVOICE_AR_BAL_INV | RC_D_BILLING_ENTITY_ID | ||
| RC_F_INVOICE_AR_BAL_SMRY | RC_D_BILLING_ENTITY_ID | ||
| RC_F_MONTHLY_CDM_SMRY | RC_D_BILLING_ENTITY_ID | ||
| RC_F_MONTHLY_CLAIM_EVENT_SMRY | RC_D_BILLING_ENTITY_ID | ||
| RC_F_MONTHLY_DENIAL_SMRY | RC_D_BILLING_ENTITY_ID | ||
| RC_F_MONTHLY_TRANS_SMRY | RC_D_BILLING_ENTITY_ID | ||
| RC_F_MTH_CHRG_ASSOC_SMRY | RC_D_BILLING_ENTITY_ID | ||
| RC_F_NON_AR_BALANCE | RC_D_BILLING_ENTITY_ID | ||
| RC_F_NON_AR_BALANCE_TRANS | RC_D_BILLING_ENTITY_ID | ||
| RC_F_PATIENT_AR_BALANCE | RC_D_BILLING_ENTITY_ID | ||
| RC_F_PATIENT_AR_BAL_SMRY | RC_D_BILLING_ENTITY_ID | ||
| RC_F_REVENUE | RC_D_BILLING_ENTITY_ID | ||
| RC_F_VARIANCE | RC_D_BILLING_ENTITY_ID | ||
| RC_F_VAR_CLAIM_SMRY | RC_D_BILLING_ENTITY_ID | ||
| RC_F_VAR_LINE_ITEM_SMRY | RC_D_BILLING_ENTITY_ID |
RC_D_BILL_ITEM
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Dimension Bill Item |
| Definition: | This table contains bill item information such as activity type and charge description. |
| Table Type: | REFERENCE |
Column Detail - RC_D_BILL_ITEM
| 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. |
| ACTIVITY_TYPE | VARCHAR(40) | N | The type of activity associated with a given bill item. |
| 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. |
| CDM | VARCHAR(50) | Y | Charge Description Master Code. A client defined value representing a charge. |
| CHARGE_DESCRIPTION | VARCHAR(200) | N | The description of a charge associated to a given bill item. |
| CPT | VARCHAR(40) | N | The Current Procedural Terminology associated to a given bill item. |
| CPT_DESCRIPTION | VARCHAR(200) | Y | The description of a CPT associated to a given bill item. |
| DIAGNOSIS_CODE | VARCHAR(50) | Y | Contains diagnosis codes. |
| DIAGNOSIS_CODE_DESC | VARCHAR(200) | Y | Contains the description of the diagnosis code. |
| 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. |
| HCPCS | VARCHAR(200) | N | Contains the HCFA Common Procedural Coding System associated to a given bill item. |
| HCPCS_DESCRIPTION | VARCHAR(200) | Y | Contains the description for HCPCS. |
| LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
| MILL_BILL_ITEM_ID | DOUBLE | N | The bill item identifier from the Millennium Database Bill Item Table. |
| MILL_DIAGNOSIS_CD | DOUBLE | N | Identifies the code value for the diagnosis code. This column is derived from the code in the Charge_Mod table. |
| MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the logical domain to which the row data belongs. |
| PROCEDURE_CODE | VARCHAR(200) | N | The procedure code associated to a given bill item. |
| PROCEDURE_MODIFIER_TXT | VARCHAR(3) | Y | The modifier associated to the Procedure(CPT4 and HCPCS) code. |
| RC_D_BILL_ITEM_ID | DOUBLE | N | Uniquely identifies Bill Item information such as activity type and charge description. |
| REVENUE_CODE | VARCHAR(40) | N | The Revenue Code associated to a given bill item. |
| 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_D_BILL_ITEM
| Parent Column in RC_D_BILL_ITEM (PK) | Child Table Name | Child Column Name | |
|---|---|---|---|
| Children: | RC_D_BILL_ITEM_ID | RC_F_DAILY_CDM_SMRY | RC_D_BILL_ITEM_ID |
| RC_F_DLY_CHRG_ASSOC_SMRY | RC_D_BILL_ITEM_ID | ||
| RC_F_MONTHLY_CDM_SMRY | RC_D_BILL_ITEM_ID | ||
| RC_F_MTH_CHRG_ASSOC_SMRY | RC_D_BILL_ITEM_ID | ||
| RC_F_REVENUE | RC_D_BILL_ITEM_ID |