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 |