Table Detail Report

RC_F_DAILY_CENSUS_SMRY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Fact Daily Census Summary
Definition: This table contains aggregated totals for an activity date 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_DAILY_CENSUS_SMRY


Column Name Type Null? Definition
ACTIVITY_DT_NBR DOUBLE N The Cerner Julian number representing the date for which the census data applies.
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_DAILY_CENSUS_SMRY_ID DOUBLE N Uniquely identifies aggregated totals for an activity date for a given 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.
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_DAILY_CENSUS_SMRY


Child Column in RC_F_DAILY_CENSUS_SMRY(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_DT_NBR OMF_DATE DT_NBR
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_DAILY_CLAIM_EVENT_SMRY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Daily Claim Event Summary
Definition: Contains aggregated claim data by the given dimensions for a given activity date.
Table Type: ACTIVITY





Column Detail - RC_F_DAILY_CLAIM_EVENT_SMRY


Column Name Type Null? Definition
ACTIVITY_DT_NBR DOUBLE N Represents the date that the claim event data is being aggregated.
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.
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 this claim was generated.
RC_F_DAILY_CLAIM_EVENT_SMRY_ID DOUBLE N Uniquely identifies aggregated claim data for a given activity date.
SHR_D_LOCATION_ID DOUBLE N Uniquely identifies the patient encounter location at the time of the claim event.
TOTAL_BILLED_AMT DOUBLE N Represents the total amount billed of all the claims aggregated into a given row for a given activity date.
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 activity date.
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 activity date.
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 activity date.
TOTAL_NUMBER_OF_CLAIMS DOUBLE N Represents the number of claims that have been aggregated into this row for the given activity date.
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_CLAIM_EVENT_SMRY


Child Column in RC_F_DAILY_CLAIM_EVENT_SMRY(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_DT_NBR OMF_DATE DT_NBR
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


RC_F_DAILY_DENIAL_SMRY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Fact Daily Denial Summary
Definition: This table contains summarized denial data by day.
Table Type: ACTIVITY





Column Detail - RC_F_DAILY_DENIAL_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.
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_DAILY_DENIAL_SMRY_ID DOUBLE N Uniquely identifies summarized denial data by 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_DENIAL_SMRY


Child Column in RC_F_DAILY_DENIAL_SMRY(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_DT_NBR OMF_DATE DT_NBR
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


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