Table Detail Report
RC_F_DAILY_ENCNTR_VISIT_SMRY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Daily Encounter Visit Summary |
| Definition: | This table contains summarized encounter visit data by day. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_DAILY_ENCNTR_VISIT_SMRY
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVITY_DT_NBR | DOUBLE | N | A number representing the activity date. References the key in the OMF_DATE table. |
| BEG_CENSUS_COUNT | DOUBLE | N | The total amount of encounters associated to a particular location at the beginning of the day. |
| DAILY_ENCNTR_VISIT_SMRY_ID | DOUBLE | N | Uniquely identifies summarized encounter visit data by 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. |
| RC_D_ENCNTR_TYPE_CLASS_ID | DOUBLE | N | Uniquely identifies encounter type class information related to this fact row. |
| SHR_D_LOCATION_ID | DOUBLE | N | Uniquely identifies the patient encounter location at the time of the claim event. |
| TOTAL_ADMITTED_ENCNTRS | DOUBLE | N | Total number of encounters that have been admitted on a given day. |
| TOTAL_ADMITTED_VRFD_ENCNTRS | DOUBLE | N | The total number of encounters that have their insurance verified prior to their admission on a given day. |
| TOTAL_DISCHARGED_ENCNTRS | DOUBLE | N | The total number of encounters that have been discharged on a given day. |
| TOTAL_DSCHRG_LENGTH_OF_STAY | DOUBLE | N | Sum of the number of days from the admission date to the patient's discharge date on a given day. |
| 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 day. |
| TOTAL_PRE_REG_ENCNTRS | DOUBLE | N | Total number of encounters that have been pre-registered on a given day. |
| TOTAL_PRE_REG_VRFD_ENCNTRS | DOUBLE | N | Total number of encounters that have their insurance verified prior to their pre-registration on a given day. |
| 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_DAILY_ENCNTR_VISIT_SMRY
| Child Column in RC_F_DAILY_ENCNTR_VISIT_SMRY(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ACTIVITY_DT_NBR | OMF_DATE | DT_NBR |
| 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 |
RC_F_DAILY_TRANS_SMRY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Daily Transaction Summary |
| Definition: | Contains payment, adjustment and charges aggregated at a daily level. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_DAILY_TRANS_SMRY
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVITY_DT_NBR | DOUBLE | N | A number representing the activity date. References the key in the OMF_DATE table. |
| 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 the row on the rc_d_account_type table related to this fact. |
| RC_D_ADMIT_PHYS_SPECIALTY_ID | DOUBLE | N | This is a foreign key that identifies the specialty assigned to the admitting physician in a given location in the fact table. |
| RC_D_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 the Insurance AR balance or Self-Pay balance that the payment or adjustment was to. |
| 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_DAILY_TRANS_SMRY_ID | DOUBLE | N | Uniquely identifies payments, adjustments and charges aggregated on a daily 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_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_TRANSACTION_AMT | DOUBLE | N | Represents the total transaction amount of all the transactions 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_DAILY_TRANS_SMRY
| Child Column in RC_F_DAILY_TRANS_SMRY(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ACTIVITY_DT_NBR | OMF_DATE | DT_NBR |
| 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_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_DAYS_IN_AR_SMRY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Days in AR Summary |
| Definition: | This table contains summarized days in AR data. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_DAYS_IN_AR_SMRY
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVITY_DT_NBR | DOUBLE | N | A number representing the activity date. References the key in the OMF_DATE table. |
| FIRST_PROCESS_DT_TM | DATETIME | N | The date/time that the first ETL process started that created this record. |
| 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_DISCHARGE_AGE_ID | DOUBLE | N | Uniquely identifies the age category to which this fact row is related based on the discharge age. |
| RC_D_HOLD_ID | DOUBLE | N | Uniquely identifies the hold related to this fact row. |
| RC_F_DAYS_IN_AR_SMRY_ID | DOUBLE | N | Uniquely identifies summarized days in AR data. |
| TOTAL_DAYS_IN_AR | DOUBLE | N | Represents the average number of days spent recovering AR. |
| TOT_CREDIT_BALANCE_DAYS_IN_AR | DOUBLE | N | Represents the average number of days spent recovering credit AR. |
| 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_DAYS_IN_AR_SMRY
| Child Column in RC_F_DAYS_IN_AR_SMRY(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ACTIVITY_DT_NBR | OMF_DATE | DT_NBR |
| RC_D_DISCHARGE_AGE_ID | RC_D_AGE_CATEGORY | RC_D_AGE_CATEGORY_ID | |
| RC_D_BILLING_ENTITY_ID | RC_D_BILLING_ENTITY | RC_D_BILLING_ENTITY_ID | |
| RC_D_HOLD_ID | RC_D_HOLD | RC_D_HOLD_ID |
RC_F_DENIAL
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Denial |
| Definition: | This table contains data related to denials (remark codes) applied to transactions. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_DENIAL
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ADJUSTMENT_AMT | DOUBLE | N | Contains the total adjustment amount made to claim associated to the denial. |
| ADMIT_DT_NBR | DOUBLE | N | A number representing the admit date. References the key in the OMF_DATE table. |
| BILL_NUMBER_IDENT | VARCHAR(40) | N | Contains the display value associated to a bill number. |
| CLAIM_BILLED_AMT | DOUBLE | N | Contains the total amount of the claim billed to payor for the claim associated to the denial. |
| DENIAL_BILLED_AMT | DOUBLE | N | Contains the dollar amount denied. |
| DENIAL_DT_NBR | DOUBLE | N | A number representing the denial date. References the key in the OMF_DATE table. |
| DISCHARGE_DT_NBR | DOUBLE | N | A number representing the discharge 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. |
| LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
| MILL_CORSP_ID | DOUBLE | N | Uniquely identifies the millennium database claim to which the denial fact information is related. |
| MILL_DENIAL_ID | DOUBLE | N | Uniquely identifies a row on the Denial table in the Millennium from which this data is derived. |
| MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the logical domain to which the row data belongs. |
| PATIENT_LIABILITY_AMT | DOUBLE | N | Contains the dollar amount tied to a patient liability remark. |
| PAYMENT_AMT | DOUBLE | N | Contains the total payment amount made to the claim associated to the denial. |
| RC_AF_PATIENT_AR_BALANCE_ID | DOUBLE | N | Uniquely identifies data related to the RC_F_Denial table. |
| RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the billing entity associated to the encounter associated to this denial. |
| RC_D_BILL_TYPE_ID | DOUBLE | N | Uniquely identifies the bill type related to this fact row. |
| RC_D_DENIAL_ALIAS_ID | DOUBLE | N | Uniquely identifies the denial alias dimension row that is related to this fact row. |
| RC_D_DRG_ID | DOUBLE | N | Uniquely identifies the DRG associated tot the encounter for which the denial is posted. |
| 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 related to this fact row. |
| RC_D_MEDICAL_SERVICE_ID | DOUBLE | N | Uniquely identifies the medical service of the encounter associated to this denial. |
| RC_D_TRANSACTION_BATCH_ID | DOUBLE | N | Uniquely identifies the remittance batch from which this denial was posted. |
| RC_F_DENIAL_ID | DOUBLE | N | Uniquely identifies data related to denials applied to transactions. |
| SHR_D_ATTENDING_PHYSICIAN_ID | DOUBLE | N | Uniquely identifies the attending physician associated with this denial. |
| SHR_D_LOCATION_ID | DOUBLE | N | Uniquely identifies the patient encounter location at the time the denial was posted. |
| SHR_D_PERSON_ID | DOUBLE | N | Uniquely identifies the patient associated with this denial. |
| SHR_D_POSTED_PERSON_ID | DOUBLE | N | Uniquely identifies the person who posted this denial. |
| 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_DENIAL
| Child Column in RC_F_DENIAL(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ADMIT_DT_NBR | OMF_DATE | DT_NBR |
| DENIAL_DT_NBR | OMF_DATE | DT_NBR | |
| DISCHARGE_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_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_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_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_TRANSACTION_BATCH_ID | RC_D_TRANSACTION_BATCH | RC_D_TRANSACTION_BATCH_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_PERSON_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_POSTED_PERSON_ID | SHR_D_PERSON | SHR_D_PERSON_ID |
RC_F_DLY_CHRG_ASSOC_SMRY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Daily Charge Association Summary |
| Definition: | This table contains summarized payment and adjustment amounts related to a charge for each physician. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_DLY_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 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_ENCNTR_TYPE_CLASS_ID | DOUBLE | N | Uniquely identifies encounter type class information related to this fact row. |
| RC_D_FINANCIAL_CLASS_ID | DOUBLE | N | Uniquely identifies the financial class related to this fact row. |
| RC_D_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 this fact row. |
| RC_F_DLY_CHRG_ASSOC_SMRY_ID | DOUBLE | N | Uniquely identifies summarized payment and adjustment amounts related to a charge for each physician. |
| SERVICE_DT_NBR | DOUBLE | N | A number representing the service date. References the key in the OMF_DATE table. |
| 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_SUPERV_PHYSICIAN_ID | DOUBLE | N | Uniquely identifies supervising physician information related to this fact row. |
| TOTAL_ADJUSTMENT_AMT | DOUBLE | N | Sum of all adjustments from the ADJUSTMENT fact table that are related to charges for the physician for the same date. |
| TOTAL_ADJUSTMENT_COUNT | DOUBLE | N | TOTAL_ADJUSTMENT_COUNT is the sum of all adjustments from the RC_F_ADJUSTMENT table that are related to charges for the physician for the same date. |
| TOTAL_CHARGE_AMT | DOUBLE | N | Total amount for charges for each physician. |
| TOTAL_CHARGE_COUNT | DOUBLE | N | Total number of charges per physician on a service date. |
| TOTAL_PAYMENT_AMT | DOUBLE | N | Sum of all payments from the CASH fact table that are related to charges for the physician for the same date |
| TOTAL_PAYMENT_COUNT | DOUBLE | N | Total count of all payments from the CASH fact table that are related to charges for the physician for the same date |
| 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_DLY_CHRG_ASSOC_SMRY
| Child Column in RC_F_DLY_CHRG_ASSOC_SMRY(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | SERVICE_DT_NBR | OMF_DATE | DT_NBR |
| 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_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 |