Table Detail Report
RC_CLN_AREA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Clean Area |
Definition: | This table is used to store temporarily the Fact and Dimension data that has been extracted from the Millennium database and that is going to be loaded in to the data mart tables. |
Table Type: | ACTIVITY |
Column Detail - RC_CLN_AREA
Column Name | Type | Null? | Definition |
---|---|---|---|
DIMENSION_ID | DOUBLE | N | Contains a number that uniquely identifies a dimension table. |
LOAD_STATUS | VARCHAR(20) | N | Shows whether the data needs to be loaded (insert or update) or not (i.e. pending or processed status). |
MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the logical domain to which the row data belongs. |
PARENT_CLN_AREA_ID | DOUBLE | N | Identifies the parent ID row in the staging area. |
RCR_GSR_CONTEXT_ID | DOUBLE | N | Uniquely identifies the related GSR Context Identifier |
RC_CLN_AREA_ID | DOUBLE | N | Contains a number that uniquely identifies a row in the staging area. |
SHR_LONG_TEXT_ID | DOUBLE | N | Uniquely identifies the row on the shared long text table related to this staging area row. |
TABLE_NAME | VARCHAR(40) | N | Contains the Name of the Fact or Dimension table to which this data applies. |
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_CLN_AREA
Child Column in RC_CLN_AREA(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MILL_LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
RCR_GSR_CONTEXT_ID | RCR_GSR_CONTEXT | RCR_GSR_CONTEXT_ID | |
PARENT_CLN_AREA_ID | RC_CLN_AREA | RC_CLN_AREA_ID | |
SHR_LONG_TEXT_ID | SHR_LONG_TEXT | SHR_LONG_TEXT_ID |
Parent Column in RC_CLN_AREA (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RC_CLN_AREA_ID | RC_CLN_AREA | PARENT_CLN_AREA_ID |
RC_DNFB_CHG_BILLED_GTTD
Column Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle DNFB Charge Billed Global Temporary Table |
Definition: | This is a per-session temp table used by the DNFB evaluation process in determining billed charges for the encounters being evaluated. |
Table Type: | ACTIVITY |
Column Detail - RC_DNFB_CHG_BILLED_GTTD
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVITY_ID | DOUBLE | N | This id references the row on the trans_log table that corresponds to the initial posting of the charge that this row represents. |
CHARGE_ITEM_ID | DOUBLE | N | This id references a specific charge on the charge table that has been included on a bill related to the pft_encntr_id. |
NET_CHARGE_AMT | DOUBLE | N | This field represents the net charge amount for the current charge, taking credits into consideration. |
OFFSET_CHARGE_ITEM_ID | DOUBLE | N | This id references a specific row on charge table represents a credit of a charge that has been included on a bill related to the pft_encntr_id. |
PFT_CHARGE_ID | DOUBLE | N | This id references the pft_charge row associated with this charge. |
PFT_ENCNTR_ID | DOUBLE | N | This id identifies a specific financial encounter in the pft_encntr table for which the DNFB evaluation service is currently being executed for a specified date. |
RC_D_ACCOMMODATION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Accommodation |
Definition: | This table contains values related to the current type of accommodations in which the patient has been placed. |
Table Type: | REFERENCE |
Column Detail - RC_D_ACCOMMODATION
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCOMMODATION | VARCHAR(40) | N | Contains the current type of accommodations in which the patient (encounter) has been placed. ( ex. Private, Semi Private, etc.) |
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. |
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_ACCOMMODATION_CD | DOUBLE | N | Contains the Millennium Accommodation code from which this data was derived. |
RC_D_ACCOMMODATION_ID | DOUBLE | N | Uniquely identifies values related to a type of accommodation in which a patient has been placed. |
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_ACCOMMODATION
Parent Column in RC_D_ACCOMMODATION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RC_D_ACCOMMODATION_ID | RC_F_BALANCE_AR | RC_D_ACCOMMODATION_ID |
RC_F_DAILY_BAL_AR_SMRY | RC_D_ACCOMMODATION_ID | ||
RC_F_DAILY_CENSUS | RC_D_ACCOMMODATION_ID | ||
RC_F_PATIENT_AR_BALANCE | RC_D_ACCOMMODATION_ID | ||
RC_F_REVENUE | RC_D_ACCOMMODATION_ID | ||
SHR_F_ENCOUNTER_VISIT | RC_D_ACCOMMODATION_ID |
RC_D_ACCOUNT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Dimension Account |
Definition: | This table contains information related to an account such as account description and account sub type. |
Table Type: | ACTIVITY |
Column Detail - RC_D_ACCOUNT
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCOUNT_DESCRIPTION | VARCHAR(250) | N | The description related to an account. |
ACCOUNT_IDENT | VARCHAR(50) | N | Contains the external account number that relates to an account. |
ACCOUNT_SUB_TYPE | VARCHAR(40) | N | The sub type associated with an account (i.e. Client or General) |
ACCOUNT_TYPE | VARCHAR(40) | N | Account type like AR, Non AR etc. |
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. |
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_ACCOUNT_ID | DOUBLE | N | The account id from the millennium database account table. |
MILL_ACCOUNT_SUB_TYPE_CD | DOUBLE | N | Contains the code value indicating the sub type of account. |
MILL_ACCOUNT_TYPE_CD | DOUBLE | N | Contains the code value indicating the type of account. |
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 information related to an account such as account description and account sub type. |
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_D_ACCOUNT
Parent Column in RC_D_ACCOUNT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RC_D_ACCOUNT_ID | RC_F_ADJUSTMENT | RC_D_ACCOUNT_ID |
RC_F_CASH | RC_D_ACCOUNT_ID | ||
RC_F_GENERAL_AR_BALANCE | RC_D_ACCOUNT_ID | ||
RC_F_GENERAL_AR_BAL_TRANS | RC_D_ACCOUNT_ID | ||
RC_F_INVOICE_AR_BALANCE | RC_D_ACCOUNT_ID | ||
RC_F_INVOICE_AR_BAL_INV | RC_D_ACCOUNT_ID | ||
RC_F_INVOICE_AR_BAL_SMRY | RC_D_ACCOUNT_ID | ||
RC_F_NON_AR_BALANCE | RC_D_ACCOUNT_ID | ||
RC_F_NON_AR_BALANCE_TRANS | RC_D_ACCOUNT_ID | ||
RC_F_REVENUE | RC_D_ACCOUNT_ID |
RC_D_ACCOUNT_TYPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Dimension Account Type |
Definition: | Stores the details of the Account Type and Sub Type. |
Table Type: | REFERENCE |
Column Detail - RC_D_ACCOUNT_TYPE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCOUNT_SUB_TYPE | VARCHAR(50) | N | Description of the account sub type. |
ACCOUNT_TYPE | VARCHAR(50) | N | Description of the account type. For example: Patient, Cash, Revenue |
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_ACCOUNT_SUB_TYPE_CD | DOUBLE | N | Holds the account type code stored in the Millennium code set. |
MILL_ACCOUNT_TYPE_CD | DOUBLE | N | Holds the account type code number associated with the account type stored in Millennium. |
RC_D_ACCOUNT_TYPE_ID | DOUBLE | N | Unique genereated number that identifies a single row on the rc_d_account_type table. |
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_D_ACCOUNT_TYPE
Parent Column in RC_D_ACCOUNT_TYPE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RC_D_ACCOUNT_TYPE_ID | RC_F_ADJUSTMENT | RC_D_ACCOUNT_TYPE_ID |
RC_F_ALL_AR_SMRY | RC_D_ACCOUNT_TYPE_ID | ||
RC_F_CASH | RC_D_ACCOUNT_TYPE_ID | ||
RC_F_DAILY_CDM_SMRY | RC_D_ACCOUNT_TYPE_ID | ||
RC_F_DAILY_TRANS_SMRY | RC_D_ACCOUNT_TYPE_ID | ||
RC_F_GENERAL_AR_BAL_TRANS | RC_D_ACCOUNT_TYPE_ID | ||
RC_F_INVOICE_AR_BALANCE | RC_D_ACCOUNT_TYPE_ID | ||
RC_F_INVOICE_AR_BAL_INV | RC_D_ACCOUNT_TYPE_ID | ||
RC_F_INVOICE_AR_BAL_SMRY | RC_D_ACCOUNT_TYPE_ID | ||
RC_F_MONTHLY_CDM_SMRY | RC_D_ACCOUNT_TYPE_ID | ||
RC_F_MONTHLY_TRANS_SMRY | RC_D_ACCOUNT_TYPE_ID | ||
RC_F_NON_AR_BALANCE | RC_D_ACCOUNT_TYPE_ID | ||
RC_F_NON_AR_BALANCE_TRANS | RC_D_ACCOUNT_TYPE_ID | ||
RC_F_REVENUE | RC_D_ACCOUNT_TYPE_ID |