Table Detail Report
RC_F_NON_AR_BALANCE_TRANS
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Non Accounts Receivable Balance Transaction |
| Definition: | This table contains data related to Non AR account transaction balance |
| Table Type: | ACTIVITY |
Column Detail - RC_F_NON_AR_BALANCE_TRANS
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVITY_DT_NBR | DOUBLE | N | A number representing the activity date. References the key in the OMF_DATE table. |
| 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_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the related logical domain record. |
| 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 the related account record. |
| 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_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies billing entity information related to this fact row. |
| RC_D_GL_ALIAS_ID | DOUBLE | N | Uniquely identifies the GL Alias information associated to this fact row. |
| RC_D_OTHER_GL_ALIAS_ID | DOUBLE | N | Uniquely identifies GL alias information such as company name and account name for alias other than NON AR GL Alias |
| 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_TYPE_ID | DOUBLE | N | Uniquely identifies a Transaction Type Dimension row realted to this fact row |
| RC_F_NON_AR_BALANCE_TRANS_ID | DOUBLE | N | Unique generated number that identifies a single row on the RC_F_NON_AR_BALANCE_TRANS table. |
| 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 |
| 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 the 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_NON_AR_BALANCE_TRANS
| Child Column in RC_F_NON_AR_BALANCE_TRANS(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ACTIVITY_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_GL_ALIAS_ID | RC_D_GL_ALIAS | RC_D_GL_ALIAS_ID | |
| RC_D_OTHER_GL_ALIAS_ID | RC_D_GL_ALIAS | RC_D_GL_ALIAS_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_TYPE_ID | RC_D_TRANSACTION_TYPE | RC_D_TRANSACTION_TYPE_ID | |
| SHR_D_POSTING_PRSNL_ID | SHR_D_PERSON | SHR_D_PERSON_ID |
RC_F_PATIENT_AR_BALANCE
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Patient AR Balance |
| Definition: | This table contains data related to Patient AR Account Balances. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_PATIENT_AR_BALANCE
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVITY_DT_NBR | DOUBLE | N | A number representing the activity date. References the key in the OMF_DATE table. |
| ACTUAL_BALANCE_AMT | DOUBLE | N | Original Balance Amount without offset consideration. |
| ACTUAL_DLY_ADJ_AMT | DOUBLE | N | Original daily adjustment amount without offset consideration. |
| ACTUAL_DLY_CHG_AMT | DOUBLE | N | Original daily charge amount without offset consideration. |
| ACTUAL_DLY_PAY_AMT | DOUBLE | N | Original daily payment amount without offset consideration |
| ACTUAL_TOT_ADJ_AMT | DOUBLE | N | Original total adjustment amount without offset consideration |
| ACTUAL_TOT_CHG_AMT | DOUBLE | N | Original total charge amount without offset consideration |
| ACTUAL_TOT_PAY_AMT | DOUBLE | N | Original total payment amount without offset consideration |
| ADMIT_DT_NBR | DOUBLE | N | A number representing the admit date. References the key in the OMF_DATE table. |
| BALANCE_AMT | DOUBLE | N | The balance amount of the Patient AR Account. |
| BILL_AGE | DOUBLE | N | Contains the number of days that result from the difference between the current activity date and the transmission date of the bill. |
| DAILY_ADJUSTMENT_AMT | DOUBLE | N | Contains the adjustment amount per day. |
| DAILY_CHARGE_AMT | DOUBLE | N | Contains the daily charge amount per day. |
| DAILY_PAYMENT_AMT | DOUBLE | N | Contains the payment amount per day. |
| 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. |
| FINAL_CODED_DT_NBR | DOUBLE | N | A number representing the final coded 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. |
| HARD_CLOSE_EVAL_DT_TM | DATETIME | Y | This field stores the datetime of when the particular encounter was evaluated for hard close. |
| INSURANCE_BALANCE_AMT | DOUBLE | Y | The total balance amount for insurance. |
| 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_ENCOUNTER_ID | DOUBLE | N | Uniquely identifies the Millennium Encounter record that relates to this fact row. |
| MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the logical domain to which the row data belongs. |
| RC_AF_PATIENT_AR_BALANCE_ID | DOUBLE | N | Uniquely identifies data related to the RC_F_Patient_AR_Balance table. |
| RC_D_ACCOMMODATION_ID | DOUBLE | N | Uniquely identifies accommodation information 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_LAST_PAYMENT_ID | DOUBLE | N | Relates the age by last payment to a specific age category. |
| RC_D_ATTEND_PHYS_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_BALANCE_TYPE_ID | DOUBLE | N | Uniquely identifies the dunning level related to this fact row. |
| RC_D_BAL_AMT_CATEGORY_ID | DOUBLE | N | Uniquely identifies the amount range category to which the balance applies. |
| RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the billing entity related to this fact row. |
| RC_D_DNFB_STATUS_ID | DOUBLE | N | Uniquely identifies the current status and reason if the encounter is DNFB. |
| RC_D_DUNNING_LEVEL_ID | DOUBLE | N | Uniquely identifies the dunning level related to this fact row. |
| RC_D_ENCNTR_TYPE_CLASS_ID | DOUBLE | N | Uniquely identifies encounter type class information 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_DRG_ID | DOUBLE | Y | Uniquely identifies the primary DRG related to this record. |
| RC_D_PRI_FIN_CLASS_ID | DOUBLE | N | Number that uniquely identifies the primary financial class related to this fact row. |
| RC_D_PRI_HEALTH_PLAN_ID | DOUBLE | N | Uniquely identifies information about the primary health plan related to this fact row. |
| RC_D_PRI_HOLD_ID | DOUBLE | N | Number that uniquely identifies the primary hold for 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 | Number that uniquely identifies the responsible health plan related to this fact row. |
| RC_D_UNBILLED_BAL_AMT_CAT_ID | DOUBLE | N | Uniquely identifies the amount range category to which the unbilled balance applies. |
| RC_F_PATIENT_AR_BALANCE_ID | DOUBLE | N | Uniquely identifies data related to Patient AR Account balances. |
| RESP_PRIORITY_SEQ_NBR | DOUBLE | N | Sequence that defines a hierarchy for Insurance, Self Pay responsibility. |
| SHR_D_ATTENDING_PHYSICIAN_ID | DOUBLE | N | Uniquely identifies the attending physician for this patient AR balance. |
| SHR_D_CODING_PERSON_ID | DOUBLE | N | Uniquely identifies the person who coded the clinical encounter. |
| SHR_D_LOCATION_ID | DOUBLE | N | Uniquely identifies location information related to this fact row. |
| SHR_D_PERSON_ID | DOUBLE | N | Uniquely identifies the person related to this fact row. |
| SHR_D_QUEUE_PERSON_ID | DOUBLE | N | Uniquely identifies the person to whom the responsible financial encounter balance is assigned to in a workflow. |
| SP_BALANCE_AMT | DOUBLE | N | The total balance amount for Selfpay. |
| 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 | The total of the charges. |
| TOTAL_PAYMENT_AMT | DOUBLE | N | Contains the total of the payments. |
| UNBILLED_BALANCE_AMT | DOUBLE | N | Contains the balance amount that has not been billed on any claims. |
| 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. |
| ZERO_BAL_DT_NBR | DOUBLE | N | A number representing the zero balance date. References the key in the OMF_DATE table. |
Relationship Detail - RC_F_PATIENT_AR_BALANCE
| Child Column in RC_F_PATIENT_AR_BALANCE(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 | |
| FINAL_CODED_DT_NBR | OMF_DATE | DT_NBR | |
| LAST_PAYMENT_DT_NBR | OMF_DATE | DT_NBR | |
| ZERO_BAL_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_LAST_PAYMENT_ID | RC_D_AGE_CATEGORY | RC_D_AGE_CATEGORY_ID | |
| RC_D_BAL_AMT_CATEGORY_ID | RC_D_AMOUNT_CATEGORY | RC_D_AMOUNT_CATEGORY_ID | |
| RC_D_UNBILLED_BAL_AMT_CAT_ID | RC_D_AMOUNT_CATEGORY | RC_D_AMOUNT_CATEGORY_ID | |
| RC_D_BILLING_ENTITY_ID | RC_D_BILLING_ENTITY | RC_D_BILLING_ENTITY_ID | |
| RC_D_DNFB_STATUS_ID | RC_D_DNFB_STATUS | RC_D_DNFB_STATUS_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_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_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_PRI_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_CODING_PERSON_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_PERSON_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_QUEUE_PERSON_ID | SHR_D_PERSON | SHR_D_PERSON_ID |
RC_F_PATIENT_AR_BAL_SMRY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Patient AR Balance Summary |
| Definition: | This table contains summarized patient AR balance data. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_PATIENT_AR_BAL_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. |
| INSURANCE_BALANCE_AMT | DOUBLE | Y | The total balance amount for insurance. |
| 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 logical domain to which the row data belongs. |
| RC_D_AGE_BY_LAST_PAYMENT_ID | DOUBLE | N | Uniquely identifies an age category that represents the difference between the activity date and the last payment made to the encounter balance. |
| RC_D_BALANCE_TYPE_ID | DOUBLE | N | Uniquely identifies the balance type related to this fact row. |
| RC_D_BAL_AMT_CATEGORY_ID | DOUBLE | N | Uniquely identifies the amount range category to which the total balance applies. |
| RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the billing entity related to this fact row. |
| RC_D_BILL_AGE_ID | DOUBLE | N | Uniquely identifies an age category that represents the difference between the activity date and the first bill date for the encounter balance. |
| RC_D_DISCHARGE_AGE_ID | DOUBLE | N | Uniquely identifies the age category to which this fact row is related based on the discharge age. |
| RC_D_DNFB_STATUS_ID | DOUBLE | N | Uniquely identifies the current status and reason of the DNFB |
| RC_D_DUNNING_LEVEL_ID | DOUBLE | N | Uniquely identifies the dunning level related to this fact row. |
| RC_D_ENCNTR_TYPE_CLASS_ID | DOUBLE | N | Uniquely identifies the encounter type class of the encounter. |
| RC_D_FINANCIAL_CLASS_ID | DOUBLE | N | Uniquely identifies the financial class 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_HEALTH_PLAN_ID | DOUBLE | N | Uniquely identifies the primary health plan of the financial encounter. |
| 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 of the financial encounter. |
| RC_D_UNBILLED_BAL_AMT_CAT_ID | DOUBLE | N | Uniquely identifies the amount range category to which the total unbilled balance applies. |
| RC_F_PATIENT_AR_BAL_SMRY_ID | DOUBLE | N | Uniquely identifies summarized patient AR balance data. |
| SHR_D_LOCATION_ID | DOUBLE | N | Uniquely identifies the location related to this fact row. |
| SP_BALANCE_AMT | DOUBLE | N | The total balance amount for Selfpay. |
| TOTAL_BALANCE_AMT | DOUBLE | N | The total balance for the patient AR accounts. |
| TOTAL_ENCOUNTER_COUNT | DOUBLE | N | The number of encounters rolled up into this fact row. |
| TOTAL_ENCOUNTER_FINAL_CODED | DOUBLE | N | The total number of encounters that have been final coded within an end day established as a preference. |
| TOTAL_UNBILLED_BALANCE_AMT | DOUBLE | N | Total balance amount that has not been billed on any claims. |
| TOTAL_ZERO_BALANCE_CNT | DOUBLE | N | The total number of encounters resolved to a zero dollar balance for the given activity date. |
| TOT_DSCHRG_FINAL_CODE_DAYS | DOUBLE | N | The total of days between the discharge date and the final coded date. |
| TOT_ENCNTR_FINAL_CODE_BY_END | DOUBLE | N | The total number of encounters that have been final coded within an end day established as a preference. |
| 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_PATIENT_AR_BAL_SMRY
| Child Column in RC_F_PATIENT_AR_BAL_SMRY(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ACTIVITY_DT_NBR | OMF_DATE | DT_NBR |
| RC_D_AGE_BY_LAST_PAYMENT_ID | RC_D_AGE_CATEGORY | RC_D_AGE_CATEGORY_ID | |
| RC_D_BILL_AGE_ID | RC_D_AGE_CATEGORY | RC_D_AGE_CATEGORY_ID | |
| RC_D_DISCHARGE_AGE_ID | RC_D_AGE_CATEGORY | RC_D_AGE_CATEGORY_ID | |
| RC_D_BAL_AMT_CATEGORY_ID | RC_D_AMOUNT_CATEGORY | RC_D_AMOUNT_CATEGORY_ID | |
| RC_D_UNBILLED_BAL_AMT_CAT_ID | RC_D_AMOUNT_CATEGORY | RC_D_AMOUNT_CATEGORY_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_DNFB_STATUS_ID | RC_D_DNFB_STATUS | RC_D_DNFB_STATUS_ID | |
| RC_D_DUNNING_LEVEL_ID | RC_D_DUNNING_LEVEL | RC_D_DUNNING_LEVEL_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_RESP_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_RESP_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 | |
| SHR_D_LOCATION_ID | SHR_D_LOCATION | SHR_D_LOCATION_ID |
RC_F_REVENUE
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Revenue |
| Definition: | This table contains data related to revenue. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_REVENUE
| 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. |
| CDM_FULL_IMPL_FAC_RVU_NBR | DOUBLE | Y | This field contains the CDM fully implemented facility relative value units associated to a charge. |
| CDM_FULL_IMPL_NON_FAC_RVU_NBR | DOUBLE | Y | This field contains the CDM fully implemented non-facility relative value units associated to a charge. |
| CDM_MALPRACTICE_RVU_NBR | DOUBLE | Y | This field contains the CDM malpractice relative value units associated to a charge. |
| CDM_RVU_NBR | DOUBLE | Y | This field contains the CDM relative value units associated to a charge. |
| 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. |
| FIRST_PROCESS_DT_TM | DATETIME | N | The date/time that the first ETL process started that created this record. |
| FULL_IMPL_FAC_RVU_NBR | DOUBLE | Y | This field contains the fully implemented facility relative value units associated to a charge. |
| FULL_IMPL_NONFAC_RVU_NBR | DOUBLE | Y | This field contains the fully implemented non-facility relative value units associated to a charge. |
| 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. |
| GL_INTERFACE_DT_NBR | DOUBLE | N | A number representing the GL Interface Date. References the key in the OMF_DATE table. |
| HCPCS_FULL_IMPL_FAC_RVU_NBR | DOUBLE | Y | This field containes the HCPCS fully implemented facility relative value units associated to a charge. |
| HCPCS_FULL_IMPL_NONFAC_RVU_NBR | DOUBLE | Y | This field contains the HCPCS fully implemented non-facility relative value units associated to a charge. |
| HCPCS_MALPRACTICE_RVU_NBR | DOUBLE | Y | This field contains the HCPCS malpractice relative value units associated to a charge. |
| HCPCS_RVU_NBR | DOUBLE | Y | This field contains the HCPCS work relative value units associated to a charge. |
| LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
| MALPRACTICE_RVU_NBR | DOUBLE | Y | This field contains the malpractice relative value units associated to a charge. |
| MILL_GL_TRANS_LOG_ID | DOUBLE | N | Uniquely identifies the row on the GL_TRANS_LOG on which this ID originated. |
| 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. |
| PLACE_OF_SERVICE_DESC | VARCHAR(100) | Y | Description of the place of service. |
| RC_AF_PATIENT_AR_BALANCE_ID | DOUBLE | N | Uniquely identifies data related to the RC_F_Revenue table. |
| RC_D_ACCOMMODATION_ID | DOUBLE | N | Uniquely identifies accommodation information related to this fact row. |
| 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_ITEM_ID | DOUBLE | N | Uniquely identifies the bill item 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_CPT_MODIFIER_ID | DOUBLE | N | Uniquely identifies the related CPT Modifier |
| RC_D_ENCNTR_TYPE_CLASS_ID | DOUBLE | N | Uniquely identifies encounter type class information related to this fact row. |
| 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_HCPCS_MODIFIER_ID | DOUBLE | N | Uniquely identifies the related HCPCS Modifier. |
| 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 related to this fact row. |
| 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_TIER_GROUP_ID | DOUBLE | N | Uniquely identifies the tier group related to the charge. |
| RC_D_TRANSACTION_ALIAS_ID | DOUBLE | N | Uniquely identifies the transaction alias 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_REVENUE_ID | DOUBLE | N | Uniquely identifies data related to revenue. |
| RELATIVE_VALUE_UNITS_QTY | DOUBLE | N | Contains the workload units associated to a charge. |
| SERVICE_DT_NBR | DOUBLE | N | A number representing the service date. References the key in the OMF_DATE table. |
| SERVICE_FACILITY_NAME | VARCHAR(100) | Y | Contains the name of the service facility |
| 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 | Uniquely identifies attending physician information related to this fact row. |
| SHR_D_CONSULT_PHYSICIAN_ID | DOUBLE | N | Represents the person who was the consulting physician for the related fact row. |
| SHR_D_CREATED_PRSNL_ID | DOUBLE | N | Uniquely identifier the person related to this fact row who created this information. |
| SHR_D_ORDER_PHYSICIAN_ID | DOUBLE | N | Uniquely identifies ordering physician information related to this fact row. |
| SHR_D_PATIENT_LOCATION_ID | DOUBLE | N | Uniquely identifies the location of the patient. |
| SHR_D_PERFORMING_LOCATION_ID | DOUBLE | N | Contains a number to identify the performing location. |
| SHR_D_PERFORM_PHYSICIAN_ID | DOUBLE | N | Uniquely identifies performing physician information related to this fact row. |
| SHR_D_PERSON_ID | DOUBLE | N | Uniquely identifies person information related to this fact row. |
| SHR_D_REFER_PHYSICIAN_ID | DOUBLE | N | Uniquely identifies referring physician information related to this 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. |
| TOTAL_CHARGE_AMT | DOUBLE | N | The total of the charges. |
| TOTAL_QTY | DOUBLE | N | The total quantity. |
| UNIT_PRICE_AMT | DOUBLE | N | Unit price for the charge. |
| 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_REVENUE
| Child Column in RC_F_REVENUE(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 | |
| GL_ACTIVITY_DT_NBR | OMF_DATE | DT_NBR | |
| GL_CREATED_DT_NBR | OMF_DATE | DT_NBR | |
| GL_IMPACT_DT_NBR | OMF_DATE | DT_NBR | |
| GL_INTERFACE_DT_NBR | OMF_DATE | DT_NBR | |
| SERVICE_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_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_ITEM_ID | RC_D_BILL_ITEM | RC_D_BILL_ITEM_ID | |
| RC_D_CPT_MODIFIER_ID | RC_D_BILL_ITEM_MODIFIER | RC_D_BILL_ITEM_MODIFIER_ID | |
| RC_D_HCPCS_MODIFIER_ID | RC_D_BILL_ITEM_MODIFIER | RC_D_BILL_ITEM_MODIFIER_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_TIER_GROUP_ID | RC_D_TIER_GROUP | RC_D_TIER_GROUP_ID | |
| RC_D_TRANSACTION_ALIAS_ID | RC_D_TRANSACTION_ALIAS | RC_D_TRANSACTION_ALIAS_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_PERFORMING_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_CREATED_PRSNL_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_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_VARIANCE
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Variance |
| Definition: | Contains the detail data associated to variance for reporting purposes. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_VARIANCE
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVITY_DT_NBR | DOUBLE | N | A number representing the activity date. References the key in the OMF_DATE table. |
| ACTIVITY_DT_TM | DATETIME | N | Date and time of the charge. |
| ACTUAL_REIMBURSEMENT_AMT | DOUBLE | N | The actual amount of the reimbursement. |
| ADJUSTED_VARIANCE_AMT | DOUBLE | N | Contains the adjusted original variance dollar amount that has been identified for this fact row. |
| ADJUSTED_VARIANCE_DT_NBR | DOUBLE | N | A number representing the adjusted original variance identified date for this fact row. 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. |
| APPEAL_IND | DOUBLE | N | An indicator that will be set to true only for the queue item ids that represent an appeal. |
| BILLED_AMT | DOUBLE | N | The amount billed |
| CLAIM_NBR_IDENT | VARCHAR(50) | Y | The claim number related to this fact row. |
| CLAIM_SERVICE_ITEM_IDENT | VARCHAR(50) | Y | The claim service item related to this fact row. |
| CLAIM_TRANSMIT_DT_NBR | DOUBLE | N | A number representing the claim transmission date. References the key in the OMF_DATE table. |
| CPT | VARCHAR(200) | Y | This will store the CPT information. |
| CURRENT_VARIANCE_AMT | DOUBLE | N | Contains the current variance dollar amount that has been identified for this fact row. |
| DISCHARGE_DT_NBR | DOUBLE | N | A number representing the discharge date. References the key in the OMF_DATE table. |
| EST_CONTRACTUAL_AMT | DOUBLE | N | Contains the estimated contractual dollar amount on the claim. |
| EST_REIMBURSEMENT_AMT | DOUBLE | N | Contains the estimated reimbursement dollar amount on the claim. |
| FIN_NBR_IDENT | VARCHAR(50) | Y | identifier of a financial number. |
| LAST_PAYMENT_AMT | DOUBLE | N | The last payment amount on the ProFit 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_VAR_ACTIVITY_DT_NBR | DOUBLE | N | Stores the equivalent date number for the last date/time that the variance activity occurred. |
| LAST_VAR_ACTIVITY_DT_TM | DATETIME | N | Stores the data and time of the last variance activity. |
| 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_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the related logical domain record. |
| MILL_PFT_QUEUE_ITEM_ID | DOUBLE | N | Identifies the millennium related queue item for which the history data on the ID was derived. |
| MILL_PFT_QUEUE_ITEM_WF_HIST_ID | DOUBLE | N | Identifies the millennium related workflow history for which the history data on the ID was derived. |
| MRN_NBR_IDENT | VARCHAR(50) | Y | Identifier of a medical record number. |
| ORIGINAL_VARIANCE_AMT | DOUBLE | N | Contains the first variance dollar amount that has been identified for this fact row. |
| ORIG_VARIANCE_DT_NBR | DOUBLE | N | A number representing the first variance identified date for this fact row. References the key in the omf_date table. |
| PATIENT_RESPONSIBILITY_AMT | DOUBLE | N | Contains the patient responsibility dollar amount on the claim. |
| RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the billing entity related to this fact row. |
| RC_D_BILL_PROPERTY_ID | DOUBLE | N | Uniquely identifies data associated to claim attributes for reporting purposes. |
| RC_D_BILL_TYPE_ID | DOUBLE | N | Uniquely identifies the bill type related to this fact row. |
| RC_D_DENIAL_ALIAS_ID | DOUBLE | N | Uniquely identifies the related RC_D_DENIAL_ALIAS row. |
| RC_D_ENCNTR_TYPE_CLASS_ID | DOUBLE | N | Uniquely identifies data related to the clinical encounter type and class. |
| 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_D_VARIANCE_ACTION_ID | DOUBLE | N | Uniquely identifies data associated to variance attributes for Reporting purposes. |
| RC_D_VARIANCE_ORIGIN_ID | DOUBLE | N | Uniquely identifies the related RC_D_VARIANCE_ORIGIN row. |
| RC_D_VARIANCE_PROPERTY_ID | DOUBLE | N | Uniquely identifies data associated to variance attributes for reporting purposes. |
| RC_F_VARIANCE_ID | DOUBLE | N | Uniquely identifies data associated to a variance for reporting purposes. |
| RECOVERY_AMT | DOUBLE | N | Contains the recovery dollar amount on the claim. |
| SELF_PAY_BALANCE_AMT | DOUBLE | N | Contains the last self pay balance dollar amount for this fact row. |
| SELF_PAY_PAYMENT_AMT | DOUBLE | N | Contains the selfpay payment dollar amount on the claim. |
| SHR_D_ACTION_PERSON_ID | DOUBLE | N | Uniquely identifies the person related to this fact row. |
| SHR_D_PATIENT_ID | DOUBLE | N | Uniquely identifies the patient related to this fact row. |
| SHR_D_PATIENT_LOCATION_ID | DOUBLE | N | Uniquely identifies the location of the patient. |
| SHR_D_QUEUE_PERSON_ID | DOUBLE | N | Uniquely identifies the person to whom the responsible financial encounter balance is assigned in a workflow. |
| SHR_D_REND_PHYSICIAN_ID | DOUBLE | N | This will store the related rendering physician ID from the shr_d_person table. Will be used to obtain the rendering physician name. |
| 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_PAYMENT_AMT | DOUBLE | N | Contains the total payment dollar amount for this claim. |
| 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. |
| VARIANCE_SEQUENCE | DOUBLE | N | A sequence number that uniquely identifies the sequence on actions on a particular variance. |
Relationship Detail - RC_F_VARIANCE
| Child Column in RC_F_VARIANCE(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ACTIVITY_DT_NBR | OMF_DATE | DT_NBR |
| ADJUSTED_VARIANCE_DT_NBR | OMF_DATE | DT_NBR | |
| ADMIT_DT_NBR | OMF_DATE | DT_NBR | |
| CLAIM_TRANSMIT_DT_NBR | OMF_DATE | DT_NBR | |
| DISCHARGE_DT_NBR | OMF_DATE | DT_NBR | |
| LAST_PAYMENT_DT_NBR | OMF_DATE | DT_NBR | |
| LAST_VAR_ACTIVITY_DT_NBR | OMF_DATE | DT_NBR | |
| ORIG_VARIANCE_DT_NBR | OMF_DATE | DT_NBR | |
| 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_BILL_TYPE_ID | RC_D_BILL_TYPE | RC_D_BILL_TYPE_ID | |
| RC_D_DENIAL_ALIAS_ID | RC_D_DENIAL_ALIAS | RC_D_DENIAL_ALIAS_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_HEALTH_PLAN_ID | RC_D_HEALTH_PLAN | RC_D_HEALTH_PLAN_ID | |
| RC_D_VARIANCE_ACTION_ID | RC_D_VARIANCE_ACTION | RC_D_VARIANCE_ACTION_ID | |
| RC_D_VARIANCE_ORIGIN_ID | RC_D_VARIANCE_ORIGIN | RC_D_VARIANCE_ORIGIN_ID | |
| RC_D_VARIANCE_PROPERTY_ID | RC_D_VARIANCE_PROPERTY | RC_D_VARIANCE_PROPERTY_ID | |
| SHR_D_PATIENT_LOCATION_ID | SHR_D_LOCATION | SHR_D_LOCATION_ID | |
| SHR_D_ACTION_PERSON_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_PATIENT_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_QUEUE_PERSON_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_REND_PHYSICIAN_ID | SHR_D_PERSON | SHR_D_PERSON_ID |