Table Detail Report
RC_F_INVOICE_AR_BAL_SMRY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Invoice Accounts Receivable Balance |
| Definition: | This table contains summarized client AR balance data at the account level. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_INVOICE_AR_BAL_SMRY
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| BEGIN_BALANCE_AMT | DOUBLE | Y | The beginning balance amount. |
| BEGIN_DT_NBR | DOUBLE | N | The beginning date. References the OMF_DATE table. |
| DAILY_ADJUSTMENT_AMT | DOUBLE | Y | The Daily Adjustment amount associated to the encounter. |
| DAILY_CHARGE_AMT | DOUBLE | Y | The Daily Charge amount associated to the encounter. |
| DAILY_PAYMENT_AMT | DOUBLE | Y | The daily payment amount associate to the encounter. |
| END_BALANCE_AMT | DOUBLE | Y | The ending balance amount |
| END_DT_NBR | DOUBLE | N | The ending date number. References the OMF_DATE table. |
| FIRST_PROCESS_DT_TM | DATETIME | N | The date/time that the first ETL process started that created this record. |
| LAST_INVOICE_ADJUSTMENT_DT_NBR | DOUBLE | N | The date of the last time an adjustment was made against the invoice. |
| LAST_INVOICE_AMT | DOUBLE | N | The total charge amount against the invoice. |
| LAST_INVOICE_DT_NBR | DOUBLE | N | The date the last invoice was generated. References the OMF Date table. |
| LAST_INVOICE_PAYMENT_DT_NBR | DOUBLE | N | Date of the last time a payment was made against the invoice. |
| LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
| MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the related logical domain record. |
| 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_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the billing entity related to this fact row. |
| RC_F_INVOICE_AR_BAL_SMRY_ID | DOUBLE | N | Unique generated number that identifies a single row on the RC_F_INVOICE_AR_BAL_SMRY table. |
| TIME_ZONE_INDEX | DOUBLE | N | Stores the time zone from which the data was extracted. |
| UNBILLED_CHARGE_AMT | DOUBLE | Y | The total charges that have not been billed yet. |
| 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_INVOICE_AR_BAL_SMRY
| Child Column in RC_F_INVOICE_AR_BAL_SMRY(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | BEGIN_DT_NBR | OMF_DATE | DT_NBR |
| END_DT_NBR | OMF_DATE | DT_NBR | |
| LAST_INVOICE_ADJUSTMENT_DT_NBR | OMF_DATE | DT_NBR | |
| LAST_INVOICE_DT_NBR | OMF_DATE | DT_NBR | |
| LAST_INVOICE_PAYMENT_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_MONTHLY_CDM_SMRY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Monthly CDM Summary |
| Definition: | Contains charges aggregated by CDM at a Monthly level. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_MONTHLY_CDM_SMRY
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVITY_YEAR | DOUBLE | N | Contains the year in which the activity took place. |
| 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. |
| 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 unites associated to a charge. |
| 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_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the logical domain to which the row data belongs. |
| RC_D_ACCOUNT_TYPE_ID | DOUBLE | N | Uniquely identifies the related account type. |
| 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 associated to the encounter associated to this CDM summary record. |
| 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 the encounter type class of the encounter associated to this fact row. |
| RC_D_FINANCIAL_CLASS_ID | DOUBLE | N | Uniquely identifies the financial class of the health plan associated to this fact row. |
| RC_D_GL_ALIAS_ID | DOUBLE | N | Uniquely identifies the GL Alias information associated 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 associated to this fact row. |
| RC_D_MEDICAL_SERVICE_ID | DOUBLE | N | Uniquely identifies the medical service of the encounter associated 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 this fact row. |
| RC_F_MONTHLY_CDM_SMRY_ID | DOUBLE | N | Uniquely identifies charges by CDM aggregated at a Monthly level. |
| RELATIVE_VALUE_UNITS_QTY | DOUBLE | N | Workload units associated to a charge. |
| 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 related to this fact row. |
| 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. |
| TOTAL_CHARGE_AMT | DOUBLE | N | Represents the total transaction amount of all the transactions aggregated into the summary row. |
| TOTAL_SERVICE_UNITS | DOUBLE | N | The total amount of units associated to an individual charge. |
| TOTAL_TRANSACTIONS | DOUBLE | N | The total number of transactions represented in this summary row. |
| UNIT_PRICE_AMT | DOUBLE | N | The price per unit 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_MONTHLY_CDM_SMRY
| Child Column in RC_F_MONTHLY_CDM_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_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_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 | |
| SHR_D_LOCATION_ID | SHR_D_LOCATION | SHR_D_LOCATION_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_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_MONTHLY_CENSUS_SMRY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Monthly Census Summary |
| Definition: | This table contains aggregated totals for a month for each census event, patient day, discharged days, and encounter count that is aggregated by Financial Class, Location, Encounter Type Class, and Census Event. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_MONTHLY_CENSUS_SMRY
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVITY_YEAR | DOUBLE | N | Contains the year in which the activity took place. |
| CENSUS_EVENT_COUNT | DOUBLE | N | The number of census events that make up the aggregate data for the fact row. |
| 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. |
| MILL_ORGANIZATION_ID | DOUBLE | N | Uniquely identifies a related Millennium organization at which this census event occurred. |
| RC_D_ADMIT_SOURCE_ID | DOUBLE | N | Uniquely identifies related admit source information |
| RC_D_ADMIT_TYPE_ID | DOUBLE | N | Uniquely identifies admit type information related to this fact row. |
| 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_CENSUS_EVENT_ID | DOUBLE | N | Uniquely identifies the census event related to this fact row. |
| RC_D_DISCHARGE_DISPOSITION_ID | DOUBLE | N | Uniquely identifies discharge disposition information related to this fact row. |
| RC_D_ENCNTR_TYPE_CLASS_ID | DOUBLE | N | Uniquely identifies the encounter type class related to this fact row. |
| RC_D_ETHNICITY_COMPOSITE_ID | DOUBLE | N | Unique generated number that identifies a single row on the RC_D_ETHNICITY_COMPOSITE table. |
| RC_D_MEDICAL_SERVICE_ID | DOUBLE | N | Uniquely identifies medical service information related to this fact row. |
| RC_D_NEWBORN_STATUS_ID | DOUBLE | N | Uniquely identifies the newborn status related to this record. |
| RC_D_PATIENT_AGE_ID | DOUBLE | N | Uniquely identifies the patient age related to this fact row. |
| RC_D_PRI_FIN_CLASS_ID | DOUBLE | N | Uniquely identifies the primary financial class related to this fact row. |
| RC_D_RACE_COMPOSITE_ID | DOUBLE | N | Unique generated number that identifies a single row on the RC_D_RACE_COMPOSITE table. |
| RC_D_RACE_COMPOSITE_VALUE | DOUBLE | N | Contains a value that will identify a single or combination of race values. |
| RC_D_SEX_ID | DOUBLE | N | Uniquely identifies the gender related to this fact row. |
| RC_F_MONTHLY_CENSUS_SMRY_ID | DOUBLE | N | Uniquely identifies aggregated totals for a month for each census event, patient day, discharged days, and encounter count that is aggregated by Financial Class, Location, encounter type class, and census event. |
| SHR_D_ATTENDING_PHYSICIAN_ID | DOUBLE | N | Uniquely identifies the attending physician related to this fact row |
| SHR_D_LOCATION_ID | DOUBLE | N | Uniquely identifies the hospital location related to this fact row. |
| SHR_D_MONTH_ID | DOUBLE | N | Uniquely identifies the month related to this fact. |
| TOTAL_LENGTH_OF_STAY | DOUBLE | N | The aggregated total of Length of Stay. LOS: The cumulative number of days that an encounter has been in a bed at midnight since admission. |
| TOTAL_PATIENT_DAYS | DOUBLE | N | The aggregated total of Patient Day. Patient Day: The unit of measure denoting lodging provided and services rendered to one inpatient between the midnight on two successive days. |
| 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_CENSUS_SMRY
| Child Column in RC_F_MONTHLY_CENSUS_SMRY(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | RC_D_ADMIT_SOURCE_ID | RC_D_ADMIT_SOURCE | RC_D_ADMIT_SOURCE_ID |
| RC_D_ADMIT_TYPE_ID | RC_D_ADMIT_TYPE | RC_D_ADMIT_TYPE_ID | |
| RC_D_CENSUS_EVENT_ID | RC_D_CENSUS_EVENT | RC_D_CENSUS_EVENT_ID | |
| RC_D_DISCHARGE_DISPOSITION_ID | RC_D_DISCHARGE_DISPOSITION | RC_D_DISCHARGE_DISPOSITION_ID | |
| RC_D_ENCNTR_TYPE_CLASS_ID | RC_D_ENCNTR_TYPE_CLASS | RC_D_ENCNTR_TYPE_CLASS_ID | |
| RC_D_ETHNICITY_COMPOSITE_ID | RC_D_ETHNICITY_COMPOSITE | RC_D_ETHNICITY_COMPOSITE_ID | |
| RC_D_PRI_FIN_CLASS_ID | RC_D_FINANCIAL_CLASS | RC_D_FINANCIAL_CLASS_ID | |
| RC_D_MEDICAL_SERVICE_ID | RC_D_MEDICAL_SERVICE | RC_D_MEDICAL_SERVICE_ID | |
| RC_D_NEWBORN_STATUS_ID | RC_D_NEWBORN_STATUS | RC_D_NEWBORN_STATUS_ID | |
| RC_D_PATIENT_AGE_ID | RC_D_PATIENT_AGE | RC_D_PATIENT_AGE_ID | |
| RC_D_ATTEND_PHYS_SPECIALTY_ID | RC_D_PHYSICIAN_SPECIALTY | RC_D_PHYSICIAN_SPECIALTY_ID | |
| RC_D_RACE_COMPOSITE_ID | RC_D_RACE_COMPOSITE | RC_D_RACE_COMPOSITE_ID | |
| RC_D_SEX_ID | RC_D_SEX | RC_D_SEX_ID | |
| SHR_D_LOCATION_ID | SHR_D_LOCATION | SHR_D_LOCATION_ID | |
| SHR_D_ATTENDING_PHYSICIAN_ID | SHR_D_PERSON | SHR_D_PERSON_ID |
RC_F_MONTHLY_CLAIM_EVENT_SMRY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Monthly Claim Event Summary |
| Definition: | This table contains aggregated claim data by the given dimensions for a given activity date. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_MONTHLY_CLAIM_EVENT_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 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. |
| MONTHLY_CLAIM_EVENT_SMRY_ID | DOUBLE | N | Uniquely identifies aggregated claim data by the given dimensions for a given activity date. |
| PRIORITY_SEQUENCE | DOUBLE | N | Identifies who is responsible for the claim. (i.e. 1 = Primary, 2 = Secondary, 3 = Tertiary) |
| RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the billing entity associated to this fact row. |
| RC_D_BILL_TYPE_ID | DOUBLE | N | Uniquely identifies the bill type related to this fact row. |
| RC_D_CLAIM_EVENT_TYPE_ID | DOUBLE | N | Uniquely identifies a claim event type dimension row related to this fact row. |
| 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 for which the claim was generated. |
| SHR_D_LOCATION_ID | DOUBLE | N | Uniquely identifies the patient encounter location at the time of the claim event. |
| SHR_D_MONTH_ID | DOUBLE | N | Uniquely identifies the month related to this fact row. |
| TOTAL_BILLED_AMT | DOUBLE | N | Represents the total amount billed of all the claims aggregated into a given row for a given month. |
| TOTAL_DAYS_SINCE_DISCHARGE | DOUBLE | N | Represents the total number of days between discharge and the claim event (submission for example) for all of the claims summarized for a given month. |
| TOTAL_DAYS_SINCE_GENERATION | DOUBLE | N | Represents the total number of days between generation and the claim event (submission for example) for all of the claims summarized for a given month. |
| TOTAL_DAYS_SINCE_SUBMISSION | DOUBLE | N | Represents the total number of days between submission and the claim event (transmission for example) for all of the claims summarized for a given month. |
| TOTAL_NUMBER_OF_CLAIMS | DOUBLE | N | Represents the number of claims that have been aggregated into this row for a given month. |
| 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_CLAIM_EVENT_SMRY
| Child Column in RC_F_MONTHLY_CLAIM_EVENT_SMRY(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | RC_D_BILLING_ENTITY_ID | RC_D_BILLING_ENTITY | RC_D_BILLING_ENTITY_ID |
| RC_D_BILL_TYPE_ID | RC_D_BILL_TYPE | RC_D_BILL_TYPE_ID | |
| RC_D_CLAIM_EVENT_TYPE_ID | RC_D_CLAIM_EVENT_TYPE | RC_D_CLAIM_EVENT_TYPE_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 | |
| 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_DENIAL_SMRY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Monthly Denial Summary |
| Definition: | This table contains summarizzed denial data by month. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_MONTHLY_DENIAL_SMRY
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVITY_YEAR | DOUBLE | N | Contains the year in which the activity took place. |
| DENIAL_BILLED_AMT | DOUBLE | N | The dollar amount associated with the denied bill. |
| 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_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the billing entity related to this fact row. |
| RC_D_BILL_TYPE_ID | DOUBLE | N | Uniquely identifies the bill type related to this fact row. |
| RC_D_DENIAL_ALIAS_ID | DOUBLE | N | The number that uniquely identifies a denial. |
| RC_D_ENCNTR_TYPE_CLASS_ID | DOUBLE | N | Uniquely identifies the encounter type class of the encounter associated to this denial. |
| RC_D_FINANCIAL_CLASS_ID | DOUBLE | N | Uniquely identifies the financial class of the health plan associated to the claim for which this denial was posted. |
| RC_D_HEALTH_PLAN_ID | DOUBLE | N | Uniquely identifies the health plan associated to the claim for which this denial was posted. |
| RC_F_MONTHLY_DENIAL_SMRY_ID | DOUBLE | N | Uniquely identifies summarized denial data by month. |
| SHR_D_MONTH_ID | DOUBLE | N | Uniquely identifies the month related to this fact row. |
| 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_DENIAL_SMRY
| Child Column in RC_F_MONTHLY_DENIAL_SMRY(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | RC_D_BILLING_ENTITY_ID | RC_D_BILLING_ENTITY | RC_D_BILLING_ENTITY_ID |
| RC_D_BILL_TYPE_ID | RC_D_BILL_TYPE | RC_D_BILL_TYPE_ID | |
| RC_D_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 | |
| SHR_D_MONTH_ID | SHR_D_MONTH | SHR_D_MONTH_ID |