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