Table Detail Report

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


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