Table Detail Report
RC_F_MONTHLY_ENCNTR_VISIT_SMRY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Monthly Encounter Visit Summary |
| Definition: | This table contains cummarized encounter visit data by month. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_MONTHLY_ENCNTR_VISIT_SMRY
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVITY_YEAR | DOUBLE | N | Contains the year in which the activity took place. |
| BEG_CENSUS_COUNT | DOUBLE | N | The total amount of encounters associated to a particular location at the beginning of the day. |
| END_CENSUS_COUNT | DOUBLE | N | The total amount of encounters associated to a particular location at the end of a day. |
| 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. |
| MONTHLY_ENCNTR_VISIT_SMRY_ID | DOUBLE | N | Uniquely identifies summarized encounter visit data by month. |
| RC_D_ENCNTR_TYPE_CLASS_ID | DOUBLE | N | Uniquely identifies data related to the clinical encounter type and class. |
| SHR_D_LOCATION_ID | DOUBLE | N | Uniquely identifies the patient encounter location for the activity date. |
| SHR_D_MONTH_ID | DOUBLE | N | Uniquely identifies the month related to this fact row. |
| TOTAL_ADMITTED_ENCNTRS | DOUBLE | N | The total number of encounters that have been admitted on a given month. |
| TOTAL_ADMITTED_VRFD_ENCNTRS | DOUBLE | N | The total number of encounters that have their insurance verified prior to their admission on a given month. |
| TOTAL_DISCHARGED_ENCNTRS | DOUBLE | N | The total number of encounters that have been pre-registered on a given month. |
| TOTAL_DSCHRG_LENGTH_OF_STAY | DOUBLE | N | The total number of days from the admission date to the patient's discharge date in a given month. |
| TOTAL_ENCNTRS | DOUBLE | N | The total number of encounters aggregated into a given summary row. |
| TOTAL_PATIENT_DAYS | DOUBLE | N | The total amount of patients that were at the facility on a given month. |
| TOTAL_PRE_REG_ENCNTRS | DOUBLE | N | Total number of encounters that have been pre-registered for a given month. |
| TOTAL_PRE_REG_VRFD_ENCNTRS | DOUBLE | N | Total number of encounters that have their insurance verified prior to their pre-registration for a given month. |
| TOTAL_TRANSFER_IN_COUNT | DOUBLE | N | Total number of encounters who are newly associated to a location. |
| TOTAL_TRANSFER_OUT_COUNT | DOUBLE | N | Total number of encounters who have transferred out of a location since the previous day. |
| 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_MONTHLY_ENCNTR_VISIT_SMRY
| Child Column in RC_F_MONTHLY_ENCNTR_VISIT_SMRY(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | RC_D_ENCNTR_TYPE_CLASS_ID | RC_D_ENCNTR_TYPE_CLASS | RC_D_ENCNTR_TYPE_CLASS_ID |
| SHR_D_LOCATION_ID | SHR_D_LOCATION | SHR_D_LOCATION_ID | |
| SHR_D_MONTH_ID | SHR_D_MONTH | SHR_D_MONTH_ID |
RC_F_MONTHLY_TRANS_SMRY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Monthly Trasaction Summary |
| Definition: | This table contains payment, adjustment, and charges aggregated at a monthly level. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_MONTHLY_TRANS_SMRY
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVITY_YEAR | DOUBLE | N | Contains the year in which the activity took place. |
| DISCHARGE_MONTH_ID | DOUBLE | N | The month the patient who made the transaction was discharged. |
| DISCHARGE_YEAR | DOUBLE | N | The year the patient who made the transaction was discharged. |
| FIRST_PROCESS_DT_TM | DATETIME | N | The date/time that the first ETL process started that created this record. |
| LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
| MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the logical domain to which the row data belongs. |
| RC_D_ACCOUNT_TYPE_ID | DOUBLE | N | Unique genereated number that identifies a single row on the rc_d_account_type table. |
| 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_CONSULT_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the consulting physician in a given location in the fact table. |
| RC_D_ENCNTR_TYPE_CLASS_ID | DOUBLE | N | Uniquely identifies the encounter type class of the encounter. |
| 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 information associated to the transaction. |
| RC_D_HEALTH_PLAN_ID | DOUBLE | N | Uniquely identifies the health plan associated to the insurance AR balance or Self-Pay balance to which the payment or adjustment was made. |
| RC_D_MEDICAL_SERVICE_ID | DOUBLE | N | Uniquely identifies the medical service of the encounter associated to the transaction. |
| RC_D_ORDER_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the ordering physician in a given location in the fact table. |
| RC_D_PAYMENT_METHOD_ID | DOUBLE | N | Uniquely identifies a Payment Method Dimension Row related to this fact row. |
| RC_D_PERFORM_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the performing physician in a given location in the fact table. |
| RC_D_REFER_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the refering physician in a given location in the fact table. |
| RC_D_REND_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the rendering physician in a given location in the fact table. |
| RC_D_SUPERV_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the supervising physician in a given location in the fact table. |
| RC_D_TIER_GROUP_ID | DOUBLE | N | Uniquely identifies the tier group to which a charge has been posted. |
| RC_D_TRANSACTION_ALIAS_ID | DOUBLE | N | Uniquely identifies the transaction alias related to this fact row. |
| RC_D_TRANSACTION_LOCATION_ID | DOUBLE | N | Uniquely identifies the transaction location information related to this fact row. |
| RC_D_TRANSACTION_TYPE_ID | DOUBLE | N | Uniquely identifies a Transaction Type Dimension row realted to this fact row |
| RC_F_MONTHLY_TRANS_SMRY_ID | DOUBLE | N | Uniquely identifies payments, adjustments, and charges, that are aggregated at a monthly level. |
| 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_LOCATION_ID | DOUBLE | N | Uniquely identifies the patient encounter location at the time the transaction was posted. |
| SHR_D_MONTH_ID | DOUBLE | N | Uniquely identifies the month related to this fact row. |
| SHR_D_ORDER_PHYSICIAN_ID | DOUBLE | N | Represents the person who was the ordering physician for the related fact rows. |
| 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_SUPERV_PHYSICIAN_ID | DOUBLE | N | Uniquely identifies supervising physician information related to this fact row. |
| TOS_PAYMENT_AMOUNT | DOUBLE | N | The total payment amount made on the day the patient is registered to the hospital. |
| TOTAL_SERVICE_UNITS | DOUBLE | N | Contains the total amount of units associated to an individual charge. |
| TOTAL_TRANSACTIONS | DOUBLE | N | Contains the total number of transactions represented in this summary row. |
| TOTAL_TRANS_AMT | DOUBLE | N | Represents the total transaction amount of all the transaction aggregated into the summary row. |
| UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
| UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - RC_F_MONTHLY_TRANS_SMRY
| Child Column in RC_F_MONTHLY_TRANS_SMRY(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | 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_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_GL_ALIAS_ID | RC_D_GL_ALIAS | RC_D_GL_ALIAS_ID | |
| RC_D_HEALTH_PLAN_ID | RC_D_HEALTH_PLAN | RC_D_HEALTH_PLAN_ID | |
| RC_D_MEDICAL_SERVICE_ID | RC_D_MEDICAL_SERVICE | RC_D_MEDICAL_SERVICE_ID | |
| RC_D_PAYMENT_METHOD_ID | RC_D_PAYMENT_METHOD | RC_D_PAYMENT_METHOD_ID | |
| RC_D_ADMIT_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
| RC_D_ATTEND_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
| RC_D_CONSULT_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
| RC_D_ORDER_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
| RC_D_PERFORM_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
| RC_D_REFER_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
| RC_D_REND_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
| RC_D_SUPERV_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
| RC_D_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_LOCATION_ID | RC_D_TRANSACTION_LOCATION | RC_D_TRANSACTION_LOCATION_ID | |
| RC_D_TRANSACTION_TYPE_ID | RC_D_TRANSACTION_TYPE | RC_D_TRANSACTION_TYPE_ID | |
| SHR_D_LOCATION_ID | SHR_D_LOCATION | SHR_D_LOCATION_ID | |
| DISCHARGE_MONTH_ID | SHR_D_MONTH | SHR_D_MONTH_ID | |
| SHR_D_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_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_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 |