Table Detail Report
RC_D_VARIANCE_ORIGIN
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Dimension Variance Origin |
| Definition: | Contains the data associated to variance attributes for reporting purposes. |
| Table Type: | REFERENCE |
Column Detail - RC_D_VARIANCE_ORIGIN
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| 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_WORKITEM_ORIGIN_CD | DOUBLE | N | Stores the code value for the origin of the work item created. |
| RC_D_VARIANCE_ORIGIN_ID | DOUBLE | N | Unique generated nuymber that identifies a single row on the RC_D_VARIANCE_ORIGIN 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. |
| WORKITEM_ORIGIN_DESC | VARCHAR(50) | N | Stores the description of origin for the Wrok Item created. |
Relationship Detail - RC_D_VARIANCE_ORIGIN
| Parent Column in RC_D_VARIANCE_ORIGIN (PK) | Child Table Name | Child Column Name | |
|---|---|---|---|
| Children: | RC_D_VARIANCE_ORIGIN_ID | RC_F_VARIANCE | RC_D_VARIANCE_ORIGIN_ID |
| RC_F_VAR_CLAIM_SMRY | RC_D_VARIANCE_ORIGIN_ID | ||
| RC_F_VAR_LINE_ITEM_SMRY | RC_D_VARIANCE_ORIGIN_ID |
RC_D_VARIANCE_PROPERTY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Dimension Variance Property |
| Definition: | Contains the data associated to variance attributes for Reporting purposes |
| Table Type: | REFERENCE |
Column Detail - RC_D_VARIANCE_PROPERTY
| 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. |
| 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_PFT_ENTITY_STATUS_CD | DOUBLE | N | Contains all the current state for the work Items. |
| RC_D_VARIANCE_PROPERTY_ID | DOUBLE | N | Uniquely identifies data associated to variance attributes for reporting purposes. |
| 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. |
| VARIANCE_STATUS | VARCHAR(40) | Y | Contains all the statuses associated to a variance work item based on the MILL_PFT_ENTITY_STATUS_CD |
| WORK_ITEM_ACTION | VARCHAR(40) | Y | Contains supported performed actions on this queue item |
Relationship Detail - RC_D_VARIANCE_PROPERTY
| Parent Column in RC_D_VARIANCE_PROPERTY (PK) | Child Table Name | Child Column Name | |
|---|---|---|---|
| Children: | RC_D_VARIANCE_PROPERTY_ID | RC_F_VARIANCE | RC_D_VARIANCE_PROPERTY_ID |
| RC_F_VAR_CLAIM_SMRY | RC_D_VARIANCE_PROPERTY_ID | ||
| RC_F_VAR_LINE_ITEM_SMRY | RC_D_VARIANCE_PROPERTY_ID |
RC_F_ADJUSTMENT
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Adjustment |
| Definition: | This table contains data related to adjustments. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_ADJUSTMENT
| 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 | A number representing the discharge date. References the key in the OMF_DATE table. |
| FEDERAL_TAX_ID_NBR | VARCHAR(100) | Y | An identifying federal tax number. |
| 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 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 | Uniquely identifies a row in the PFT_TRANS_RELTN table on the Millennium data base from which this data was derived. |
| MILL_CORSP_ID | DOUBLE | N | Uniquely identifies a row in the BILL_REC table on the Millennium data base from which this data 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 |
| PLACE_OF_SERVICE_DESC | VARCHAR(100) | Y | 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 gl alias information such as company name and account name for the records with an account type of AR. |
| 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 related to this fact row. |
| RC_D_BILL_TYPE_ID | DOUBLE | N | Uniquely identifies the bill type 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 financial class related to this fact row. |
| RC_D_GL_ALIAS_ID | DOUBLE | N | Uniquely identifies the GL Alias 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 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_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 the transaction alias related to this fact row. |
| RC_D_TRANSACTION_BATCH_ID | DOUBLE | N | Uniquely identifies the transaction batch 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_ADJUSTMENT_ID | DOUBLE | N | Uniquely identifies data related to adjustments. |
| 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 person information related to this fact row. |
| SHR_D_POSTING_PRSNL_ID | DOUBLE | N | Uniquely identifies information about the person who posted the information related to this 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 | Represents the person who was the supervising physician for the related fact table. |
| 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 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_ADJUSTMENT
| Child Column in RC_F_ADJUSTMENT(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 | |
| 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_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_ALL_AR_SMRY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact All Accounts Receivable Summary |
| Definition: | This table contains data related to All AR account summary - Client AR, General AR, Patient AR, Non AR |
| Table Type: | ACTIVITY |
Column Detail - RC_F_ALL_AR_SMRY
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVITY_DT_NBR | DOUBLE | N | Represents the activity date. References the key on the OMF_DATE table.. |
| ADJUSTMENT_AMT | DOUBLE | N | Contains the adjustment amount for each AR account. |
| BEGIN_BALANCE_AMT | DOUBLE | N | Contains the Begin Balance for each AR account. |
| CHARGE_AMT | DOUBLE | N | This will store the Total Charge Amount for Patient AR, Balance AR and Client AR |
| END_BALANCE_AMT | DOUBLE | N | Contains the End Balance for each AR account. |
| 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. |
| PAYMENT_AMT | DOUBLE | N | Contains the payment amount for each AR account. |
| RC_D_ACCOUNT_TYPE_ID | DOUBLE | N | Uniquely identifies the account type information related to this fact row. |
| RC_D_BALANCE_TYPE_ID | DOUBLE | Y | Uniquely identifies the related fow on the RC_D_BALANCE_TYPE table. |
| RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies billing entity information related to this fact row. |
| RC_F_ALL_AR_SMRY_ID | DOUBLE | N | Unique generated number that identifies a single row on the RC_F_ALL_AR_SMRY. |
| TIME_ZONE_INDEX | DOUBLE | N | Stores the time zone in which the GSR job is running. |
| 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_ALL_AR_SMRY
| Child Column in RC_F_ALL_AR_SMRY(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ACTIVITY_DT_NBR | OMF_DATE | DT_NBR |
| RC_D_ACCOUNT_TYPE_ID | RC_D_ACCOUNT_TYPE | RC_D_ACCOUNT_TYPE_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_F_BALANCE_AR
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Balance AR |
| Definition: | This table contains data related to balance level AR. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_BALANCE_AR
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVITY_DT_NBR | DOUBLE | N | The Cerner Julian number representing the date for which the census data applies. |
| ADMIT_DT_NBR | DOUBLE | N | A number representing the admit date. References the key in the OMF_DATE table. |
| BALANCE_AMT | DOUBLE | N | Contains the Balance of the AR account. |
| BILL_AGE | DOUBLE | N | Contains the number of days that result from the difference between the current activity data and the transmission date of the bill. |
| BILL_NUMBER | VARCHAR(40) | N | Bill number of this balance fact row. |
| BILL_STATUS | VARCHAR(20) | N | The status of the bill of this balance fact row. |
| DISCHARGE_AGE | DOUBLE | N | Contains the number of days that result from the difference between the current activity date and the discharge date. |
| DISCHARGE_DT_NBR | DOUBLE | N | A number representing the discharge date. References the key in the OMF_DATE table. |
| ENCNTR_BALANCE_AMT | DOUBLE | N | The balance amount of the Patient AR Account. |
| FIRST_PROCESS_DT_TM | DATETIME | N | The date/time that the first ETL process started that created this record. |
| FIRST_SERVICE_AGE | DOUBLE | N | Contains the number of days that result from the difference between the activity date and the date the first charge was posted to the balance. |
| FIRST_SERVICE_DT_NBR | DOUBLE | N | A number representing the first service date. References the key in the OMF_DATE table. |
| LAST_ADJUSTMENT_DT_NBR | DOUBLE | N | A number representing the most recent adjustment date of this balance fact row. References the key in the OMF_DATE table. |
| LAST_BILL_SUBMISSION_DT_NBR | DOUBLE | N | A number representing the first submitted bill date for this balance row. References the key in the OMF_DATE table. |
| LAST_BILL_TRANSMISSION_DT_NBR | DOUBLE | N | A number representing the first transmitted bill date for this balance row. References the key in the OMF_DATE table. |
| LAST_CHARGE_DT_NBR | DOUBLE | N | A number representing the most recent posted charge date for this balance fact row. References the key in the OMF_DATE table. |
| LAST_PAYMENT_AGE | DOUBLE | N | Days since the last payment has been made to the Financial Encounter. |
| LAST_PAYMENT_DT_NBR | DOUBLE | N | Date of the last time a payment was made to the financial encounter. Related to the OMF_DATE table. |
| LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
| MILL_BENEFIT_ORDER_ID | DOUBLE | N | Uniquely identifies the related benefit order. |
| MILL_BO_HP_RELTN_ID | DOUBLE | N | Uniquely identifies the related BO_HP_RELTN record. |
| MILL_FIN_ENCNTR_ID | DOUBLE | N | Uniquely identifies the related financial encounter record. |
| MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the related logical domain record. |
| ORIG_BILL_AGE | DOUBLE | N | Contains the number of days that result from 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. |
| ORIG_BILL_SUBMISSION_DT_NBR | DOUBLE | N | A number representing the first submitted bill date for this balance row. References the key in the OMF_DATE table. |
| ORIG_BILL_TRANSMISSION_DT_NBR | DOUBLE | N | A number representing the first transmitted bill date for this balance row. References the key in the OMF_DATE table |
| PRIORITY_SEQ | DOUBLE | N | A sequence that defines a hierarchy for Insurance, Self Pay responsibility. |
| RC_AF_PATIENT_AR_BALANCE_ID | DOUBLE | N | Uniquely identifies data related to the RC_AF_PATIENT_AR_BALANCE table. |
| RC_D_ACCOMMODATION_ID | DOUBLE | N | Uniquely identifies the accommodation related to this fact row. |
| RC_D_AGE_BY_BILL_ID | DOUBLE | N | Relates this fact row to a specific age category. |
| 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 | A number representing the first service date. References the key in the OMF_DATE table. |
| RC_D_AGE_BY_LAST_PAYMENT_ID | DOUBLE | N | Relates the age by last payment to a specific age category. |
| 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 a balance group. |
| RC_D_BALANCE_TYPE_ID | DOUBLE | N | Uniquely identifies the different balance types to which an account can be associated. |
| RC_D_BAL_HOLD_ID | DOUBLE | N | Uniquely identifies the primary balance level hold for this fact row. |
| RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the billing entity associated to the encounter associated to this denial. |
| RC_D_BILL_PROPERTY_ID | DOUBLE | N | Uniquely identifies data associated to claim attributes for reporting purposes. |
| RC_D_ENCNTR_HOLD_ID | DOUBLE | N | Uniquely identifies the primary encounter level hold for this fact row. |
| RC_D_ENCNTR_TYPE_CLASS_ID | DOUBLE | N | Uniquely identifies the encounter type class of the encounter associated to this row. |
| RC_D_FIN_CLASS_ID | DOUBLE | N | Uniquely identifies the current financial class related to this fact row. |
| RC_D_HEALTH_PLAN_ID | DOUBLE | N | Uniquely identifies the current health plan related to this fact row. |
| RC_D_MEDICAL_SERVICE_ID | DOUBLE | N | Uniquely identifies medical service information 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_BALANCE_AR_ID | DOUBLE | N | Unique generated number that identifies a single row on the RC_F_BALANCE_AR table, which contains data related to balance level AR. |
| REG_DT_NBR | DOUBLE | N | A number representing the registration date. References the key in the OMF_DATE table. |
| SHR_D_ATTENDING_PHYSICIAN_ID | DOUBLE | N | Uniquely identifies the attending physician for this fact row. |
| SHR_D_LOCATION_ID | DOUBLE | N | Uniquely identifies the location information related to this fact row. |
| SHR_D_PERSON_ID | DOUBLE | N | Uniquely identifies the person 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 of this balance fact row. |
| TOTAL_CHARGE_AMT | DOUBLE | N | Contains the total of the charges of this balance fact row. |
| TOTAL_PAYMENT_AMT | DOUBLE | N | Contains the total of the payments of this balance 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_BALANCE_AR
| Child Column in RC_F_BALANCE_AR(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ACTIVITY_DT_NBR | OMF_DATE | DT_NBR |
| ADMIT_DT_NBR | OMF_DATE | DT_NBR | |
| DISCHARGE_DT_NBR | OMF_DATE | DT_NBR | |
| LAST_ADJUSTMENT_DT_NBR | OMF_DATE | DT_NBR | |
| LAST_BILL_SUBMISSION_DT_NBR | OMF_DATE | DT_NBR | |
| LAST_BILL_TRANSMISSION_DT_NBR | OMF_DATE | DT_NBR | |
| LAST_CHARGE_DT_NBR | OMF_DATE | DT_NBR | |
| LAST_PAYMENT_DT_NBR | OMF_DATE | DT_NBR | |
| REG_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_ACCOMMODATION_ID | RC_D_ACCOMMODATION | RC_D_ACCOMMODATION_ID | |
| RC_D_AGE_BY_BILL_ID | RC_D_AGE_CATEGORY | RC_D_AGE_CATEGORY_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_LAST_PAYMENT_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_BILL_PROPERTY_ID | RC_D_BILL_PROPERTY | RC_D_BILL_PROPERTY_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 | |
| SHR_D_PERSON_ID | SHR_D_PERSON | SHR_D_PERSON_ID |