Table Detail Report
RCR_UPDATE_REGISTRY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle - Update Registry |
| Definition: | This table contains data related to Revenue Cycle analytics clean up and update scripts. |
| Table Type: | ACTIVITY |
Column Detail - RCR_UPDATE_REGISTRY
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| AUDIT_SCRIPT_NAME | VARCHAR(40) | Y | Column stores the name of the Audit script associated with a particular cleanup. |
| COMPLETED_DT_TM | DATETIME | Y | Stores the successful completion date time of the execution script. |
| CREATE_DT_TM | DATETIME | Y | Date and time the row was added. |
| EXECUTION_SCRIPT_NAME | VARCHAR(40) | N | Name of the cleanup Script. Update script/execution script. |
| LOCK_IND | DOUBLE | N | Indicates whether the script attached to the execution can be run toghether with another execution script or it has to be run stand alone. |
| PROCESS_BY_SLICE_IND | DOUBLE | N | Indicates whether we need to process the execution scripts in a batch or single mode. |
| QUALIFIED_CNT | DOUBLE | N | Number of rows which qualified in the qualification script. |
| QUAL_BEGIN_DT_TM | DATETIME | Y | Stores the begin date from the input prompt. |
| QUAL_END_DT_TM | DATETIME | Y | Stores the end date from the input prompt. |
| QUAL_SCRIPT_NAME | VARCHAR(40) | N | Name of the qualification script which qualifies a list of ids for the cleanup script to clean up. |
| RCR_UPDATE_REGISTRY_ID | DOUBLE | N | Unique generated number that identifies a single row on the RCR_UPDATE_REGISTRY table. |
| RECOMMENDED_RANGE_MTHS | DOUBLE | N | Recommended number of months that the update script can be run. |
| SLC_SIZE_CNT | DOUBLE | N | Indicates the maximum size of the slice. |
| START_DT_TM | DATETIME | Y | Stores the date and time the execution script was started. |
| SUMMARY_IND | DOUBLE | N | Indicates whether the summarization is required or not. |
| UPDATE_REQUEST_IDENT | VARCHAR(40) | N | The CR number to identify the clean up. |
| 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 - RCR_UPDATE_REGISTRY
| Parent Column in RCR_UPDATE_REGISTRY (PK) | Child Table Name | Child Column Name | |
|---|---|---|---|
| Children: | RCR_UPDATE_REGISTRY_ID | RCR_UPDATE_QUAL | RCR_UPDATE_REGISTRY_ID |
RC_AF_PATIENT_AR_BALANCE
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Ancillary Fact Patient AR Balance |
| Definition: | This table contains data related to a Patient AR Balance. |
| Table Type: | ACTIVITY |
Column Detail - RC_AF_PATIENT_AR_BALANCE
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACCOUNT_NBR_IDENT | VARCHAR(50) | N | Contains the identifier of a Patient AR Account. |
| 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. |
| DUNNING_LEVEL | VARCHAR(40) | N | Obsolete - No longer used on this table. Contains the collections state that a financial encounter is in. |
| 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. |
| FINANCIAL_STATUS | VARCHAR(40) | N | Obsolete - No longer used on this table. Status of the financial encounter. |
| FINANCIAL_SUB_STATUS | VARCHAR(40) | N | Obsolete - No longer used on this table. Sub status of the financial encounter. |
| FIN_NBR_IDENT | VARCHAR(50) | N | identifier of a financial number. |
| 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. |
| MRN_NBR_IDENT | VARCHAR(50) | N | Identifier of a medical record number. |
| RC_AF_PATIENT_AR_BALANCE_ID | DOUBLE | N | Uniquely identifies data related to the RC_F_Patient_AR_Balance table. |
| 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_AF_PATIENT_AR_BALANCE
| Parent Column in RC_AF_PATIENT_AR_BALANCE (PK) | Child Table Name | Child Column Name | |
|---|---|---|---|
| Children: | RC_AF_PATIENT_AR_BALANCE_ID | RC_F_BALANCE_AR | RC_AF_PATIENT_AR_BALANCE_ID |
| RC_F_CLAIM_EVENT | RC_AF_PATIENT_AR_BALANCE_ID | ||
| RC_F_DENIAL | RC_AF_PATIENT_AR_BALANCE_ID | ||
| RC_F_PATIENT_AR_BALANCE | RC_AF_PATIENT_AR_BALANCE_ID | ||
| RC_F_REVENUE | RC_AF_PATIENT_AR_BALANCE_ID | ||
| SHR_F_ENCOUNTER_VISIT | RC_AF_PATIENT_AR_BALANCE_ID |
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 |