Table Detail Report

RC_F_MTH_CHRG_ASSOC_SMRY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Fact Monthly Charge Association Summary
Definition: A table that has monthly summarized payment and adjustment amoujnts related to a charge for each physician.
Table Type: ACTIVITY





Column Detail - RC_F_MTH_CHRG_ASSOC_SMRY


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_LOGICAL_DOMAIN_ID DOUBLE N Represents the transaction's logical domain.
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_BILLING_ENTITY_ID DOUBLE N Uniquely identifies the billing entity related to this fact row.
RC_D_BILL_ITEM_ID DOUBLE N Uniquely identifies Bill Item information such as activity type and charge description.
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 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_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_F_MTH_CHRG_ASSOC_SMRY_ID DOUBLE N Unique generated number that identifies a single row on the RC_F_MTH_CHRG_ASSOC_SMRY table.
SERVICE_YEAR DOUBLE N The year of service
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 location of the patient.
SHR_D_PERFORM_PHYSICIAN_ID DOUBLE N Represents the person who was the performing physician for 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_SERVICE_MONTH_ID DOUBLE N Contains the month of service.
SHR_D_SUPERV_PHYSICIAN_ID DOUBLE N Uniquely identifies supervising physician information related to this fact row.
TOTAL_ADJUSTMENT_AMT DOUBLE N Contains the total of the adjustments.
TOTAL_ADJUSTMENT_COUNT DOUBLE N The total count of the adjustments.
TOTAL_CHARGE_AMT DOUBLE N The total of the charges.
TOTAL_CHARGE_COUNT DOUBLE N The total count of the charges.
TOTAL_PAYMENT_AMT DOUBLE N Contains the total amount of the payments.
TOTAL_PAYMENT_COUNT DOUBLE N The total amount of the payments
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_MTH_CHRG_ASSOC_SMRY


Child Column in RC_F_MTH_CHRG_ASSOC_SMRY(FK) Parent Table Name Parent Column Name
Parents: MILL_LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_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_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_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
SHR_D_PATIENT_LOCATION_ID SHR_D_LOCATION SHR_D_LOCATION_ID
SHR_D_SERVICE_MONTH_ID SHR_D_MONTH SHR_D_MONTH_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_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_MTH_CODING_ACT_SMRY



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Revenue Cycle Warehouse
Definition: This table will store monthly summarization of coding activity by coding personnel.
Table Type: ACTIVITY





Column Detail - RC_F_MTH_CODING_ACT_SMRY


Column Name Type Null? Definition
ACTIVITY_YEAR DOUBLE N Contains the year in which the activity took place.
FIRST_PROCESS_DT_TM DATETIME N The date/time the record was first loaded into the table.
LAST_PROCESS_DT_TM DATETIME N The date/time the record was last loaded into the table.
MILL_LOGICAL_DOMAIN_ID DOUBLE N Represents the transaction's logical domain.
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
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 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_F_MTH_CODING_ACT_SMRY_ID DOUBLE N Unique generated number that identifies a single row on the RC_F_MTH_CODING_ACT_SMRY table.
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 location information related to this fact row.
SHR_D_MONTH_ID DOUBLE N Uniquely identifies the month related to this fact row.
TOTAL_ACTIONS_COUNT DOUBLE N The total actions count per coding personnel.
TOTAL_ENCOUNTER_COUNT DOUBLE N The total number of encounters associated to this coding activity.
TOTAL_FE_BALANCE_AMT DOUBLE N The total of the financial encounter balance amount for the patient who had the coding activity.
TOTAL_LENGTH_OF_STAY DOUBLE N The total number of midnights the patient stays in the hospital, from admission to either discharge or coding activity date, which ever occurs first.
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_MTH_CODING_ACT_SMRY


Child Column in RC_F_MTH_CODING_ACT_SMRY(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
SHR_D_LOCATION_ID SHR_D_LOCATION SHR_D_LOCATION_ID
SHR_D_CODING_PRSNL_ID SHR_D_PERSON SHR_D_PERSON_ID


RC_F_NON_AR_BALANCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Fact Non AR Balance
Definition: This table contains data related to Non General AR account balances.
Table Type: ACTIVITY





Column Detail - RC_F_NON_AR_BALANCE


Column Name Type Null? Definition
BEGIN_BALANCE_AMT DOUBLE N The beginning balance amount of the non AR account.
BEGIN_DT_NBR DOUBLE N A number representing the begin date of this fact row. References the related row in the OMF_DATE table.
DAILY_ADJUSTMENT_AMT DOUBLE N Contains the adjustment amount per day.
DAILY_PAYMENT_AMT DOUBLE N Contains the payment amount per day.
END_BALANCE_AMT DOUBLE N The ending balance of the Non AR acount.
END_DT_NBR DOUBLE N A number representing the end date of this balance fact row. 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_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_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_LOGICAL_DOMAIN_ID DOUBLE N Represents the related logical domain.
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 the related billing entity record.
RC_F_NON_AR_BALANCE_ID DOUBLE N This is a uniquely generated number that idenfifies a single row onthe RC_F_NON_AR_BALANCE table.
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_NON_AR_BALANCE


Child Column in RC_F_NON_AR_BALANCE(FK) Parent Table Name Parent Column Name
Parents: BEGIN_DT_NBR OMF_DATE DT_NBR
END_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_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