Table Detail Report
RC_F_CASE_MIX
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Case Mix |
| Definition: | This table represents the case mix value for encounters that have been coded. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_CASE_MIX
| 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. |
| ADMISSION_DT_NBR | DOUBLE | N | The Cerner Julian number representing the date the patient was admitted to the hospital. In the case of Observation patients, this is the date the patient was registered to the hospital. |
| ATTENDING_PHYSICIAN_START_TIME | DATETIME | Y | Identifies the date and time the attending physician was assigned |
| BALANCE_AMOUNT | DOUBLE | N | Uniquely identifies the balance amount for the encounter |
| BEGIN_CODING_DT_NBR | DOUBLE | N | The Cerner Julian number representing the date for which the first coding activity occurred. |
| BILL_DATE_NBR | DOUBLE | N | Date when the first bill was sent to the payor. |
| CODED_DATE_NBR | DOUBLE | N | Date when the coding for the of episode took place.. |
| DISCHARGE_DT_NBR | DOUBLE | N | The Cerner Julian number representing the date the patient was discharged from the hospital. |
| END_CODING_DT_NBR | DOUBLE | N | The Cerner Julian number representing the date for which the most recent coding activity occurred |
| FIN_NBR_IDENT | VARCHAR(50) | Y | The FIN of the patient whose encounter had the coding activity. |
| 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. |
| LENGTH_OF_STAY | DOUBLE | N | The cumulative number of days an encounter has been in a bed at midnight since admission. Additionally, if the patient is admitted and discharged on the same day, the Length of Stay is 1 day. |
| MILL_ENCOUNTER_ID | DOUBLE | N | The Encounter ID from Millennium that is related to this record. |
| MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | The Logical Domain Identifier from Millennium |
| MRN_NBR_IDENT | VARCHAR(50) | Y | Identifier of a medical record number. |
| MS_DRG_ID | DOUBLE | N | Uniquely identifies the diagnostic related group related to this fact row. |
| RC_D_ATTEND_PRSNL_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the attending Personnel in a given location in the fact table. |
| RC_D_CODING_STATUS_ID | DOUBLE | N | Uniquely identifies the coding status related to this fact row. |
| RC_D_ENCNTR_TYPE_CLASS_ID | DOUBLE | N | Uniquely identifies the encounter type class related to this record. |
| RC_D_MEDICAL_SERVICE_ID | DOUBLE | N | Uniquely identifies the medical service related to this record. |
| RC_D_NEWBORN_STATUS_ID | DOUBLE | N | Uniquely identifies the newborn status related to this record. |
| RC_D_PRI_DRG_ID | DOUBLE | N | Uniquely identifies the primary DRG related to this record. |
| RC_D_PRI_FINANCIAL_CLASS_ID | DOUBLE | N | Uniquely identifies the Primary Financial Class related to this record. |
| RC_D_PRI_HEALTH_PLAN_ID | DOUBLE | N | Uniquely identifies the Primary Health Plan related to this record. |
| RC_F_CASE_MIX_ID | DOUBLE | N | Uniquely represents a case mix value for encounters that have been coded. |
| SHR_D_ATTENDING_PRSNL_ID | DOUBLE | N | Uniquely identifies the attending personnel related to this coding activity. |
| 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 the patient encounter location for the activity date. |
| 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 | Contains the total of the adjustments. |
| TOTAL_CHARGE_AMT | DOUBLE | N | Represents the total charges for the encounter |
| TOTAL_PAYMENT_AMT | DOUBLE | N | Represents the total payments for the encounter |
| 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_CASE_MIX
| Child Column in RC_F_CASE_MIX(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | MILL_LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
| MS_DRG_ID | RC_D_DRG | RC_D_DRG_ID | |
| RC_D_PRI_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_FINANCIAL_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 | |
| RC_D_NEWBORN_STATUS_ID | RC_D_NEWBORN_STATUS | RC_D_NEWBORN_STATUS_ID | |
| RC_D_ATTEND_PRSNL_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
| SHR_D_LOCATION_ID | SHR_D_LOCATION | SHR_D_LOCATION_ID | |
| SHR_D_ATTENDING_PRSNL_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_CODING_PRSNL_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_PERSON_ID | SHR_D_PERSON | SHR_D_PERSON_ID |
RC_F_CASH
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Cash |
| Definition: | This fact table contains data related to payments. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_CASH
| 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. References the key in the OMF_DATE table. |
| BATCH_CREATED_DT_NBR | DOUBLE | N | A number representing the date the batch was created. References the key in the OMF_DATE table. |
| BILL_NUMBER_IDENT | VARCHAR(40) | N | Contains the display value associated to a bill number. |
| DISCHARGE_DT_NBR | DOUBLE | N | The number representing the date the patient who made the transaction was discharged. |
| FEDERAL_TAX_ID_NBR | VARCHAR(100) | Y | Contains the tax identification number assigned by the federal government. |
| FIN_NBR_IDENT | VARCHAR(50) | Y | Identifier of Financial Number |
| FIRST_PROCESS_DT_TM | DATETIME | N | The date/time that the first ETL process started that created this record. |
| GL_ACTIVITY_DT_NBR | DOUBLE | N | Contains the GL_ACTIVITY_DT_TM value from GL_TRANS_LOG table. |
| GL_CREATED_DT_NBR | DOUBLE | N | Contains the GL_CREATED_DT_TM number from the GL_TRANS_LOG table. |
| GL_IMPACT_DT_NBR | DOUBLE | N | Contains the GL_IMPACT_DT_TM value from GL_TRANS_LOG table. |
| INTERFACE_DT_NBR | DOUBLE | N | A number representing the date the interface date. References the key in the OMF_DATE table. |
| LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
| 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_CORSP_ID | DOUBLE | N | Number that identifies the row in the Bill_Rec Millennium database table from which this row was derived. |
| MILL_GL_TRANS_LOG_ID | DOUBLE | N | Uniquely identifies the related record on the GL_TRANS_LOG table. |
| MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the logical domain to which the row data belongs. |
| MILL_PFT_CHARGE_ID | DOUBLE | N | Identifies the Millennium record from which the data on this row was derived. |
| MRN_NBR_IDENT | VARCHAR(50) | Y | Identifier of medical record number. |
| PAYMENT_INFO | VARCHAR(40) | Y | Contains payment information such as credit card confirmation or check number. |
| PAYMENT_METHOD_DT_NBR | DOUBLE | N | A number representing the Payment Method Date. References the key in the OMF_DATE table. |
| PAYMENT_METHOD_NBR | DOUBLE | N | Contains the related check or credit card number. |
| PLACE_OF_SERVICE_DESC | VARCHAR(100) | Y | Contains a description of the place of service. |
| 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 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_ADMIT_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the admitting physician in a given location in the fact table. |
| RC_D_AR_GL_ALIAS_ID | DOUBLE | N | Uniquely identifies the AR GL record related to this row. |
| RC_D_ATTEND_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the attending physician in a given location in the fact table. |
| RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the Billing Entity Dimension Row related to this Fact row. |
| RC_D_BILL_TYPE_ID | DOUBLE | N | Uniquely identifies the Bill Type Dimension row related to this fact row. |
| RC_D_CONSULT_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the consulting physician in a given location in the fact table. |
| RC_D_ENCNTR_TYPE_CLASS_ID | DOUBLE | N | Uniquely identifies the encounter type class of the encounter associated to the payment. |
| RC_D_FINANCIAL_CLASS_ID | DOUBLE | N | Uniquely identifies the row on the Financial Class Dimension that relates to this fact row. |
| RC_D_GL_ALIAS_ID | DOUBLE | N | Uniquely identifies a GL Alias Dimension row related to this fact row. |
| RC_D_HEALTH_PLAN_ID | DOUBLE | N | Uniquely identifies a Health Plan Dimension Row related to this fact row. |
| 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 their encounter . |
| RC_D_ORDER_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the ordering physician in a given location in the fact table. |
| RC_D_PAYMENT_METHOD_ID | DOUBLE | N | Uniquely identifies a Payment Method Dimension Row related to this fact row. |
| RC_D_PERFORM_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the performing physician in a given location in the fact table. |
| RC_D_REFER_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the refering physician in a given location in the fact table. |
| RC_D_REND_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the rendering physician in a given location in the fact table. |
| RC_D_SUPERV_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the supervising physician in a given location in the fact table. |
| 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_LOCATION_ID | DOUBLE | N | Uniquely identifies the transaction location information 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_CASH_ID | DOUBLE | N | Uniquely identifies data related to payments. |
| REGISTRATION_DT_NBR | DOUBLE | N | The number representing the date the patient who made the transaction was registered to the hospital. |
| SERVICE_FACILITY_NAME | VARCHAR(100) | Y | The name of the facility where service was performed. |
| SHR_D_ADMIT_PHYSICIAN_ID | DOUBLE | N | Represents the person who was the admitting physician for the related fact row. |
| SHR_D_ATTEND_PHYSICIAN_ID | DOUBLE | N | Represents the person who was the attending physician for the related fact row. |
| SHR_D_CONSULT_PHYSICIAN_ID | DOUBLE | N | Represents the person who was the consulting physician for the related fact row. |
| SHR_D_ORDER_PHYSICIAN_ID | DOUBLE | N | Represents the person who was the ordering physician for the related fact rows. |
| SHR_D_PATIENT_LOCATION_ID | DOUBLE | N | Uniquely identifies the related patient location |
| SHR_D_PERFORM_PHYSICIAN_ID | DOUBLE | N | Represents the person who was the performing physician for the related fact row. |
| SHR_D_PERSON_ID | DOUBLE | N | Uniquely identifies a Person Dimension Row related to this fact row. |
| 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. |
| SHR_D_REFER_PHYSICIAN_ID | DOUBLE | N | Represents the person who was the referring physician for the related fact row. |
| SHR_D_REND_PHYSICIAN_ID | DOUBLE | N | Uniquely identifies a row on the shared person dimension table that represents the person who was the rendering/primary physician about the related fact row. |
| SHR_D_SUPERV_PHYSICIAN_ID | DOUBLE | N | Uniquely identifies supervising physician information related to this 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 a 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_CASH
| Child Column in RC_F_CASH(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ACTIVITY_DT_NBR | OMF_DATE | DT_NBR |
| ADMIT_DT_NBR | OMF_DATE | DT_NBR | |
| GL_ACTIVITY_DT_NBR | OMF_DATE | DT_NBR | |
| GL_CREATED_DT_NBR | OMF_DATE | DT_NBR | |
| GL_IMPACT_DT_NBR | OMF_DATE | DT_NBR | |
| INTERFACE_DT_NBR | OMF_DATE | DT_NBR | |
| PAYMENT_METHOD_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_BILL_TYPE_ID | RC_D_BILL_TYPE | RC_D_BILL_TYPE_ID | |
| RC_D_ENCNTR_TYPE_CLASS_ID | RC_D_ENCNTR_TYPE_CLASS | RC_D_ENCNTR_TYPE_CLASS_ID | |
| RC_D_FINANCIAL_CLASS_ID | RC_D_FINANCIAL_CLASS | RC_D_FINANCIAL_CLASS_ID | |
| RC_D_AR_GL_ALIAS_ID | RC_D_GL_ALIAS | RC_D_GL_ALIAS_ID | |
| RC_D_GL_ALIAS_ID | RC_D_GL_ALIAS | RC_D_GL_ALIAS_ID | |
| RC_D_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 | |
| RC_D_PAYMENT_METHOD_ID | RC_D_PAYMENT_METHOD | RC_D_PAYMENT_METHOD_ID | |
| RC_D_ADMIT_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
| RC_D_ATTEND_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
| RC_D_CONSULT_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
| RC_D_ORDER_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
| RC_D_PERFORM_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
| RC_D_REFER_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
| RC_D_REND_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
| RC_D_SUPERV_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_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_LOCATION_ID | RC_D_TRANSACTION_LOCATION | RC_D_TRANSACTION_LOCATION_ID | |
| RC_D_TRANSACTION_TYPE_ID | RC_D_TRANSACTION_TYPE | RC_D_TRANSACTION_TYPE_ID | |
| SHR_D_PATIENT_LOCATION_ID | SHR_D_LOCATION | SHR_D_LOCATION_ID | |
| SHR_D_ADMIT_PHYSICIAN_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_ATTEND_PHYSICIAN_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_CONSULT_PHYSICIAN_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_ORDER_PHYSICIAN_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_PERFORM_PHYSICIAN_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_PERSON_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_POSTING_PRSNL_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_REFER_PHYSICIAN_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_REND_PHYSICIAN_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_SUPERV_PHYSICIAN_ID | SHR_D_PERSON | SHR_D_PERSON_ID |
RC_F_CLAIM_EVENT
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Claim Event |
| Definition: | This table contains data related to claims. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_CLAIM_EVENT
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| BILL_NUMBER_IDENT | VARCHAR(40) | N | Contains the display value associated to a bill number. |
| BILL_VRSN_NBR | DOUBLE | N | The version of the bill that has been generated. |
| CLAIM_BILLED_AMT | DOUBLE | N | Contains the dollar amount billed on the claim. |
| CLAIM_EVENT_DT_NBR | DOUBLE | N | A number representing the date of the claim event. References the key in the OMF_DATE table. |
| DAYS_SINCE_DISCHARGE_CNT | DOUBLE | N | Contains the number of days since the encounter's discharge. |
| DAYS_SINCE_GENERATION_CNT | DOUBLE | N | Contains the number of days since the generation of the claim. |
| DAYS_SINCE_SUBMISSION_CNT | DOUBLE | N | Contains the number of days since the submission of the claim. |
| 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_CORSP_ID | DOUBLE | N | Identifies the row in the Bill_Rec table in the Millennium database from which the data for this table was derived. |
| MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the logical domain to which the row data belongs. |
| PRIORITY_SEQ_NBR | DOUBLE | N | Sequence that defines the hierarchy for insurance responsibility. |
| RC_AF_PATIENT_AR_BALANCE_ID | DOUBLE | N | Uniquely identifies data related to the RC_F_Claim_Event table. |
| RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the billing entity dimension row related to this fact row. |
| RC_D_BILL_TYPE_ID | DOUBLE | N | Uniquely identifies the bill type related to this fact row. |
| RC_D_CLAIM_EVENT_TYPE_ID | DOUBLE | N | Uniquely identifies a claim event type dimension row related to this fact row. |
| RC_D_FINANCIAL_CLASS_ID | DOUBLE | N | Uniquely identifies the financial class related to this fact row. |
| RC_D_HEALTH_PLAN_ID | DOUBLE | N | Uniquely identifies the health plan related to this fact row. |
| RC_F_CLAIM_EVENT_ID | DOUBLE | N | Uniquely identifies data related to claims. |
| SHR_D_ADMIT_PRSNL_ID | DOUBLE | N | Uniquely identifies the admit person for this claim event. |
| SHR_D_LOCATION_ID | DOUBLE | N | Uniquely identifies the patient encounter location at the time the claim event. |
| SHR_D_PERSON_ID | DOUBLE | N | Uniquely identifies the person related to this claim event. |
| 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_CLAIM_EVENT
| Child Column in RC_F_CLAIM_EVENT(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | CLAIM_EVENT_DT_NBR | OMF_DATE | DT_NBR |
| RC_AF_PATIENT_AR_BALANCE_ID | RC_AF_PATIENT_AR_BALANCE | RC_AF_PATIENT_AR_BALANCE_ID | |
| RC_D_BILLING_ENTITY_ID | RC_D_BILLING_ENTITY | RC_D_BILLING_ENTITY_ID | |
| RC_D_BILL_TYPE_ID | RC_D_BILL_TYPE | RC_D_BILL_TYPE_ID | |
| RC_D_CLAIM_EVENT_TYPE_ID | RC_D_CLAIM_EVENT_TYPE | RC_D_CLAIM_EVENT_TYPE_ID | |
| RC_D_FINANCIAL_CLASS_ID | RC_D_FINANCIAL_CLASS | RC_D_FINANCIAL_CLASS_ID | |
| RC_D_HEALTH_PLAN_ID | RC_D_HEALTH_PLAN | RC_D_HEALTH_PLAN_ID | |
| SHR_D_LOCATION_ID | SHR_D_LOCATION | SHR_D_LOCATION_ID | |
| SHR_D_ADMIT_PRSNL_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_PERSON_ID | SHR_D_PERSON | SHR_D_PERSON_ID |
RC_F_CODING_ACTIVITY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Coding Activity |
| Definition: | This table is used to store activity related to the coding of clinical encounters. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_CODING_ACTIVITY
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVITY_DT_NBR | DOUBLE | N | The Cerner Julian number representing the date. |
| ADMIT_DT_NBR | DOUBLE | N | A number representing the admit date. References the key in the OMF_DATE table. |
| CODING_DT_NBR | DOUBLE | N | The Cerner Julian number representing the date the coding episode took place. |
| CODING_DT_TM | DATETIME | Y | The date and time the coding of episode took place. |
| COMPLETED_DT_NBR | DOUBLE | N | The Cerner Julian number representing the date for which the coding activity was completed. |
| COMPLETED_DT_TM | DATETIME | Y | The date and time for which the coding activity was completed. |
| DISCHARGE_DT_NBR | DOUBLE | N | A number representing the discharge date. References the key in the OMF_DATE table. |
| FE_BALANCE_AMT | DOUBLE | N | The financial encounter balance amount for the patient who had the coding activity. |
| FIN_NBR_IDENT | VARCHAR(50) | Y | The financial number alias related to the patient encounter. |
| 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. |
| LENGTH_OF_STAY | DOUBLE | N | The number of midnights the patient stays in the hospital, from admission to either discharge or coding activity date, which ever occurs first. |
| MILL_ENCOUNTER_ID | DOUBLE | N | The ENCOUNTER.ENCNTR_ID associated to the patient in Millennium. |
| MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the related logical domain record. |
| MRN_NBR_IDENT | VARCHAR(50) | Y | Identifier of a medical record number. |
| RC_D_ADMIT_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the admitting physician in a given location in the fact table. |
| RC_D_ATTEND_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the attending physician in a given location in the fact table. |
| 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 the medical service of the encounter associated to this coding activity. |
| RC_D_PRI_FIN_CLASS_ID | DOUBLE | N | Uniquely identifies the primary financial class related to this coding activity. |
| RC_D_PRI_HEALTH_PLAN_ID | DOUBLE | N | Uniquely identifies the primary health plan of the financial encounter. |
| RC_F_CODING_ACTIVITY_ID | DOUBLE | N | Uniquely identifies activity related to the coding of clinical encounters. |
| SHR_D_ADMITTING_PRSNL_ID | DOUBLE | N | Uniquely identifies the admitting personnel related to this coding activity. |
| SHR_D_ATTENDING_PRSNL_ID | DOUBLE | N | Uniquely identifies the attending personnel related to this coding activity. |
| 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 the location related to this coding activity. |
| SHR_D_PERSON_ID | DOUBLE | N | Uniquely identifies the person related to this coding activity. |
| TIME_ZONE_INDEX | DOUBLE | N | Stores the time zone from which the data was extracted. |
| 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_CODING_ACTIVITY
| Child Column in RC_F_CODING_ACTIVITY(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | 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 | |
| RC_D_ADMIT_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
| RC_D_ATTEND_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
| SHR_D_LOCATION_ID | SHR_D_LOCATION | SHR_D_LOCATION_ID | |
| SHR_D_ADMITTING_PRSNL_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_ATTENDING_PRSNL_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_CODING_PRSNL_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_PERSON_ID | SHR_D_PERSON | SHR_D_PERSON_ID |
RC_F_DAILY_BAL_AR_SMRY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Daily Balance AR Summary |
| Definition: | Summarization of RC_F_Balance_AR table. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_DAILY_BAL_AR_SMRY
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVITY_DT_NBR | DOUBLE | N | A number representing the activity date. References the key 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_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 related logical domain record. |
| RC_D_ACCOMMODATION_ID | DOUBLE | N | Uniquely identifies the accommodation related to this fact row. |
| RC_D_AGE_BY_DISCHARGE_ID | DOUBLE | N | Relates this fact row to a specific age category based on the discharge age. |
| RC_D_AGE_BY_FIRST_SERVICE_ID | DOUBLE | N | Uniquely identifies an age category that represents the difference between the activity date and the date the first charge was posted to the balance. |
| RC_D_AGE_BY_ORIG_BILL_ID | DOUBLE | N | Uniquely identifies an age category that represents the difference between the activity date and the first transmitted claim or submitted statement on a balance, regardless of whether or not the bill was cancelled. |
| RC_D_ATTEND_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the attending physician in a given location in the fact table. |
| RC_D_BALANCE_GROUP_ID | DOUBLE | N | Uniquely identifies the balance group related to this fact row. |
| RC_D_BALANCE_TYPE_ID | DOUBLE | N | Uniquely identifies the balance type related to this fact row |
| RC_D_BAL_HOLD_ID | DOUBLE | N | Uniquely identifies the balance hold related to this fact row |
| RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the billing entity related to this fact row. |
| RC_D_ENCNTR_HOLD_ID | DOUBLE | N | Uniquely identifies the encounter hold related to this fact row |
| RC_D_ENCNTR_TYPE_CLASS_ID | DOUBLE | N | Uniquely identifies the encounter class and encounter type related to this fact row. |
| RC_D_FIN_CLASS_ID | DOUBLE | N | Uniquely identifies the financial class related to this fact row. |
| RC_D_HEALTH_PLAN_ID | DOUBLE | N | Uniquely identifies the health plan related to this fact row |
| RC_D_MEDICAL_SERVICE_ID | DOUBLE | N | Uniquely identifies the medical service related to this fact row. |
| RC_D_PRI_FIN_CLASS_ID | DOUBLE | N | 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_D_RESP_FIN_CLASS_ID | DOUBLE | N | Uniquely identifies the responsible financial class related to this fact row |
| RC_D_RESP_HEALTH_PLAN_ID | DOUBLE | N | Uniquely identifies the responsible health plan related to this fact row |
| RC_F_DAILY_BAL_AR_SMRY_ID | DOUBLE | N | Unique generated number that identifies a single row on the RC_F_DAILY_BALANCE_AR_SMRY table. |
| SHR_D_ATTENDING_PHYSICIAN_ID | DOUBLE | N | Uniquely identifies the attending physician related to this fact row |
| SHR_D_LOCATION_ID | DOUBLE | N | Uniquely identifies the location related to this fact row |
| TOTAL_ADJUSTMENT_AMT | DOUBLE | N | The total adjustment amounts for the balances that make up the fact row. |
| TOTAL_BALANCE_AMT | DOUBLE | N | The total outstanding balance amount for the payer. |
| TOTAL_BALANCE_COUNT | DOUBLE | N | The number of balances rolled up into this fact row. |
| TOTAL_CHARGE_AMT | DOUBLE | N | The total charge amounts for the balances that make up the fact row. |
| TOTAL_PAYMENT_AMT | DOUBLE | N | The total payment amounts for the balances that make up the fact row. |
| 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_DAILY_BAL_AR_SMRY
| Child Column in RC_F_DAILY_BAL_AR_SMRY(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | RC_D_ACCOMMODATION_ID | RC_D_ACCOMMODATION | RC_D_ACCOMMODATION_ID |
| RC_D_AGE_BY_DISCHARGE_ID | RC_D_AGE_CATEGORY | RC_D_AGE_CATEGORY_ID | |
| RC_D_AGE_BY_FIRST_SERVICE_ID | RC_D_AGE_CATEGORY | RC_D_AGE_CATEGORY_ID | |
| RC_D_AGE_BY_ORIG_BILL_ID | RC_D_AGE_CATEGORY | RC_D_AGE_CATEGORY_ID | |
| RC_D_BALANCE_GROUP_ID | RC_D_BALANCE_GROUP | RC_D_BALANCE_GROUP_ID | |
| RC_D_BALANCE_TYPE_ID | RC_D_BALANCE_TYPE | RC_D_BALANCE_TYPE_ID | |
| RC_D_BILLING_ENTITY_ID | RC_D_BILLING_ENTITY | RC_D_BILLING_ENTITY_ID | |
| RC_D_ENCNTR_TYPE_CLASS_ID | RC_D_ENCNTR_TYPE_CLASS | RC_D_ENCNTR_TYPE_CLASS_ID | |
| RC_D_FIN_CLASS_ID | RC_D_FINANCIAL_CLASS | RC_D_FINANCIAL_CLASS_ID | |
| RC_D_PRI_FIN_CLASS_ID | RC_D_FINANCIAL_CLASS | RC_D_FINANCIAL_CLASS_ID | |
| RC_D_RESP_FIN_CLASS_ID | RC_D_FINANCIAL_CLASS | RC_D_FINANCIAL_CLASS_ID | |
| RC_D_HEALTH_PLAN_ID | RC_D_HEALTH_PLAN | RC_D_HEALTH_PLAN_ID | |
| RC_D_PRI_HEALTH_PLAN_ID | RC_D_HEALTH_PLAN | RC_D_HEALTH_PLAN_ID | |
| RC_D_RESP_HEALTH_PLAN_ID | RC_D_HEALTH_PLAN | RC_D_HEALTH_PLAN_ID | |
| RC_D_BAL_HOLD_ID | RC_D_HOLD | RC_D_HOLD_ID | |
| RC_D_ENCNTR_HOLD_ID | RC_D_HOLD | RC_D_HOLD_ID | |
| RC_D_MEDICAL_SERVICE_ID | RC_D_MEDICAL_SERVICE | RC_D_MEDICAL_SERVICE_ID | |
| RC_D_ATTEND_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
| SHR_D_LOCATION_ID | SHR_D_LOCATION | SHR_D_LOCATION_ID | |
| SHR_D_ATTENDING_PHYSICIAN_ID | SHR_D_PERSON | SHR_D_PERSON_ID |