Table Detail Report

RC_F_ADJUSTMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Fact Adjustment
Definition: This table contains data related to adjustments.
Table Type: ACTIVITY





Column Detail - RC_F_ADJUSTMENT


Column Name Type Null? Definition
ACTIVITY_DT_NBR DOUBLE N A number representing the activity date. References the key in the OMF_DATE table.
ADMIT_DT_NBR DOUBLE N A number representing the admit date. References the key in the OMF_DATE table.
BATCH_CREATED_DT_NBR DOUBLE N A number representing the date the batch was created. References the key in the OMF_DATE table.
BILL_NUMBER_IDENT VARCHAR(40) N Contains the display value associated to a bill number.
DISCHARGE_DT_NBR DOUBLE N A number representing the discharge date. References the key in the OMF_DATE table.
FEDERAL_TAX_ID_NBR VARCHAR(100) Y An identifying federal tax number.
FIN_NBR_IDENT VARCHAR(50) Y Identifier of Financial Number
FIRST_PROCESS_DT_TM DATETIME N The date/time that the first ETL process started that created this record.
GL_ACTIVITY_DT_NBR DOUBLE N Contains the GL_ACTIVITY_DT_TM value from GL_TRANS_LOG table.
GL_CREATED_DT_NBR DOUBLE N Contains the GL_CREATED_DT_TM number from the GL_TRANS_LOG table.
GL_IMPACT_DT_NBR DOUBLE N Contains the GL_IMPACT_DT_TM value from GL_TRANS_LOG table.
INTERFACE_DT_NBR DOUBLE N A number representing the interface date. References the key in the OMF_DATE table.
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
MILL_ACTIVITY_ID DOUBLE N Uniquely identifies a row in the PFT_TRANS_RELTN table on the Millennium data base from which this data was derived.
MILL_CORSP_ID DOUBLE N Uniquely identifies a row in the BILL_REC table on the Millennium data base from which this data was derived.
MILL_GL_TRANS_LOG_ID DOUBLE N Uniquely identifies the related record on the GL_TRANS_LOG table.
MILL_LOGICAL_DOMAIN_ID DOUBLE N Uniquely identifies the logical domain to which the row data belongs.
MILL_PFT_CHARGE_ID DOUBLE N Identifies the Millennium record from which the data on this row was derived.
MRN_NBR_IDENT VARCHAR(50) Y Identifier of Medical Record Number
PLACE_OF_SERVICE_DESC VARCHAR(100) Y Description of the place of service.
POST_DT_NBR DOUBLE N A number representing the post date. References the key in the OMF_DATE table.
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_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_AR_GL_ALIAS_ID DOUBLE N Uniquely identifies gl alias information such as company name and account name for the records with an account type of AR.
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_TYPE_ID DOUBLE N Uniquely identifies the bill type 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 associated to the payment.
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 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 such as type or category, that the patient is receiving in relation to their encounter.
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_TRANSACTION_ALIAS_ID DOUBLE N Uniquely identifies the transaction alias related to this fact row.
RC_D_TRANSACTION_BATCH_ID DOUBLE N Uniquely identifies the transaction batch 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_ADJUSTMENT_ID DOUBLE N Uniquely identifies data related to adjustments.
SERVICE_FACILITY_NAME VARCHAR(100) Y The name of the facility where service was performed.
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 related patient location
SHR_D_PERFORM_PHYSICIAN_ID DOUBLE N Represents the person who was the performing physician for the related fact row.
SHR_D_PERSON_ID DOUBLE N Uniquely identifies person information related to this fact row.
SHR_D_POSTING_PRSNL_ID DOUBLE N Uniquely identifies information about the person who posted the information related to this 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 Represents the person who was the supervising physician for the related fact table.
TIME_ZONE_INDEX DOUBLE N Stores the time zone from which the data was extracted.
TRANSACTION_AMT DOUBLE N Contains the dollar amount associated to a transaction.
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_ADJUSTMENT


Child Column in RC_F_ADJUSTMENT(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_DT_NBR OMF_DATE DT_NBR
ADMIT_DT_NBR OMF_DATE DT_NBR
GL_ACTIVITY_DT_NBR OMF_DATE DT_NBR
GL_CREATED_DT_NBR OMF_DATE DT_NBR
GL_IMPACT_DT_NBR OMF_DATE DT_NBR
INTERFACE_DT_NBR OMF_DATE DT_NBR
POST_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_D_BILL_TYPE_ID RC_D_BILL_TYPE RC_D_BILL_TYPE_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_AR_GL_ALIAS_ID RC_D_GL_ALIAS RC_D_GL_ALIAS_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_TRANSACTION_ALIAS_ID RC_D_TRANSACTION_ALIAS RC_D_TRANSACTION_ALIAS_ID
RC_D_TRANSACTION_BATCH_ID RC_D_TRANSACTION_BATCH RC_D_TRANSACTION_BATCH_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_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_PERSON_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_POSTING_PRSNL_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_ALL_AR_SMRY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Fact All Accounts Receivable Summary
Definition: This table contains data related to All AR account summary - Client AR, General AR, Patient AR, Non AR
Table Type: ACTIVITY





Column Detail - RC_F_ALL_AR_SMRY


Column Name Type Null? Definition
ACTIVITY_DT_NBR DOUBLE N Represents the activity date. References the key on the OMF_DATE table..
ADJUSTMENT_AMT DOUBLE N Contains the adjustment amount for each AR account.
BEGIN_BALANCE_AMT DOUBLE N Contains the Begin Balance for each AR account.
CHARGE_AMT DOUBLE N This will store the Total Charge Amount for Patient AR, Balance AR and Client AR
END_BALANCE_AMT DOUBLE N Contains the End Balance for each AR account.
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 related logical domain record.
PAYMENT_AMT DOUBLE N Contains the payment amount for each AR account.
RC_D_ACCOUNT_TYPE_ID DOUBLE N Uniquely identifies the account type information related to this fact row.
RC_D_BALANCE_TYPE_ID DOUBLE Y Uniquely identifies the related fow on the RC_D_BALANCE_TYPE table.
RC_D_BILLING_ENTITY_ID DOUBLE N Uniquely identifies billing entity information related to this fact row.
RC_F_ALL_AR_SMRY_ID DOUBLE N Unique generated number that identifies a single row on the RC_F_ALL_AR_SMRY.
TIME_ZONE_INDEX DOUBLE N Stores the time zone in which the GSR job is running.
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_ALL_AR_SMRY


Child Column in RC_F_ALL_AR_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_BALANCE_TYPE_ID RC_D_BALANCE_TYPE RC_D_BALANCE_TYPE_ID
RC_D_BILLING_ENTITY_ID RC_D_BILLING_ENTITY RC_D_BILLING_ENTITY_ID


RC_F_BALANCE_AR



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Fact Balance AR
Definition: This table contains data related to balance level AR.
Table Type: ACTIVITY





Column Detail - RC_F_BALANCE_AR


Column Name Type Null? Definition
ACTIVITY_DT_NBR DOUBLE N The Cerner Julian number representing the date for which the census data applies.
ADMIT_DT_NBR DOUBLE N A number representing the admit date. References the key in the OMF_DATE table.
BALANCE_AMT DOUBLE N Contains the Balance of the AR account.
BILL_AGE DOUBLE N Contains the number of days that result from the difference between the current activity data and the transmission date of the bill.
BILL_NUMBER VARCHAR(40) N Bill number of this balance fact row.
BILL_STATUS VARCHAR(20) N The status of the bill of this balance fact row.
DISCHARGE_AGE DOUBLE N Contains the number of days that result from the difference between the current activity date and the discharge date.
DISCHARGE_DT_NBR DOUBLE N A number representing the discharge date. References the key in the OMF_DATE table.
ENCNTR_BALANCE_AMT DOUBLE N The balance amount of the Patient AR Account.
FIRST_PROCESS_DT_TM DATETIME N The date/time that the first ETL process started that created this record.
FIRST_SERVICE_AGE DOUBLE N Contains the number of days that result from the difference between the activity date and the date the first charge was posted to the balance.
FIRST_SERVICE_DT_NBR DOUBLE N A number representing the first service date. References the key in the OMF_DATE table.
LAST_ADJUSTMENT_DT_NBR DOUBLE N A number representing the most recent adjustment date of this balance fact row. References the key in the OMF_DATE table.
LAST_BILL_SUBMISSION_DT_NBR DOUBLE N A number representing the first submitted bill date for this balance row. References the key in the OMF_DATE table.
LAST_BILL_TRANSMISSION_DT_NBR DOUBLE N A number representing the first transmitted bill date for this balance row. References the key in the OMF_DATE table.
LAST_CHARGE_DT_NBR DOUBLE N A number representing the most recent posted charge date for this balance fact row. References the key in the OMF_DATE table.
LAST_PAYMENT_AGE DOUBLE N Days since the last payment has been made to the Financial Encounter.
LAST_PAYMENT_DT_NBR DOUBLE N Date of the last time a payment was made to the financial encounter. Related to the OMF_DATE table.
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
MILL_BENEFIT_ORDER_ID DOUBLE N Uniquely identifies the related benefit order.
MILL_BO_HP_RELTN_ID DOUBLE N Uniquely identifies the related BO_HP_RELTN record.
MILL_FIN_ENCNTR_ID DOUBLE N Uniquely identifies the related financial encounter record.
MILL_LOGICAL_DOMAIN_ID DOUBLE N Uniquely identifies the related logical domain record.
ORIG_BILL_AGE DOUBLE N Contains the number of days that result from the difference between the activity date and the first transmitted claim or submitted statement on a balance, regardless of whether or not the bill was cancelled.
ORIG_BILL_SUBMISSION_DT_NBR DOUBLE N A number representing the first submitted bill date for this balance row. References the key in the OMF_DATE table.
ORIG_BILL_TRANSMISSION_DT_NBR DOUBLE N A number representing the first transmitted bill date for this balance row. References the key in the OMF_DATE table
PRIORITY_SEQ DOUBLE N A sequence that defines a hierarchy for Insurance, Self Pay responsibility.
RC_AF_PATIENT_AR_BALANCE_ID DOUBLE N Uniquely identifies data related to the RC_AF_PATIENT_AR_BALANCE table.
RC_D_ACCOMMODATION_ID DOUBLE N Uniquely identifies the accommodation related to this fact row.
RC_D_AGE_BY_BILL_ID DOUBLE N Relates this fact row to a specific age category.
RC_D_AGE_BY_DISCHARGE_ID DOUBLE N Relates this fact row to a specific age category based on the discharge age.
RC_D_AGE_BY_FIRST_SERVICE_ID DOUBLE N A number representing the first service date. References the key in the OMF_DATE table.
RC_D_AGE_BY_LAST_PAYMENT_ID DOUBLE N Relates the age by last payment to a specific age category.
RC_D_AGE_BY_ORIG_BILL_ID DOUBLE N Uniquely identifies an age category that represents the difference between the activity date and the first transmitted claim or submitted statement on a balance, regardless of whether or not the bill was cancelled.
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_BALANCE_GROUP_ID DOUBLE N Uniquely identifies a balance group.
RC_D_BALANCE_TYPE_ID DOUBLE N Uniquely identifies the different balance types to which an account can be associated.
RC_D_BAL_HOLD_ID DOUBLE N Uniquely identifies the primary balance level hold for this fact row.
RC_D_BILLING_ENTITY_ID DOUBLE N Uniquely identifies the billing entity associated to the encounter associated to this denial.
RC_D_BILL_PROPERTY_ID DOUBLE N Uniquely identifies data associated to claim attributes for reporting purposes.
RC_D_ENCNTR_HOLD_ID DOUBLE N Uniquely identifies the primary encounter level hold for this fact row.
RC_D_ENCNTR_TYPE_CLASS_ID DOUBLE N Uniquely identifies the encounter type class of the encounter associated to this row.
RC_D_FIN_CLASS_ID DOUBLE N Uniquely identifies the current financial class related to this fact row.
RC_D_HEALTH_PLAN_ID DOUBLE N Uniquely identifies the current 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_PRI_FIN_CLASS_ID DOUBLE N Uniquely identifies the primary financial class related to this fact row.
RC_D_PRI_HEALTH_PLAN_ID DOUBLE N Uniquely identifies the primary health plan related to this fact row.
RC_D_RESP_FIN_CLASS_ID DOUBLE N Uniquely identifies the responsible financial class related to this fact row.
RC_D_RESP_HEALTH_PLAN_ID DOUBLE N Uniquely identifies the responsible health plan related to this fact row.
RC_F_BALANCE_AR_ID DOUBLE N Unique generated number that identifies a single row on the RC_F_BALANCE_AR table, which contains data related to balance level AR.
REG_DT_NBR DOUBLE N A number representing the registration date. References the key in the OMF_DATE table.
SHR_D_ATTENDING_PHYSICIAN_ID DOUBLE N Uniquely identifies the attending physician for this fact row.
SHR_D_LOCATION_ID DOUBLE N Uniquely identifies the location information related to this fact row.
SHR_D_PERSON_ID DOUBLE N Uniquely identifies the person related to this fact row
TIME_ZONE_INDEX DOUBLE N Stores the time zone from which the data was extracted.
TOTAL_ADJUSTMENT_AMT DOUBLE N Contains the total of the adjustments of this balance fact row.
TOTAL_CHARGE_AMT DOUBLE N Contains the total of the charges of this balance fact row.
TOTAL_PAYMENT_AMT DOUBLE N Contains the total of the payments of this balance fact 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_BALANCE_AR


Child Column in RC_F_BALANCE_AR(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_DT_NBR OMF_DATE DT_NBR
ADMIT_DT_NBR OMF_DATE DT_NBR
DISCHARGE_DT_NBR OMF_DATE DT_NBR
LAST_ADJUSTMENT_DT_NBR OMF_DATE DT_NBR
LAST_BILL_SUBMISSION_DT_NBR OMF_DATE DT_NBR
LAST_BILL_TRANSMISSION_DT_NBR OMF_DATE DT_NBR
LAST_CHARGE_DT_NBR OMF_DATE DT_NBR
LAST_PAYMENT_DT_NBR OMF_DATE DT_NBR
REG_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_ACCOMMODATION_ID RC_D_ACCOMMODATION RC_D_ACCOMMODATION_ID
RC_D_AGE_BY_BILL_ID RC_D_AGE_CATEGORY RC_D_AGE_CATEGORY_ID
RC_D_AGE_BY_DISCHARGE_ID RC_D_AGE_CATEGORY RC_D_AGE_CATEGORY_ID
RC_D_AGE_BY_FIRST_SERVICE_ID RC_D_AGE_CATEGORY RC_D_AGE_CATEGORY_ID
RC_D_AGE_BY_LAST_PAYMENT_ID RC_D_AGE_CATEGORY RC_D_AGE_CATEGORY_ID
RC_D_AGE_BY_ORIG_BILL_ID RC_D_AGE_CATEGORY RC_D_AGE_CATEGORY_ID
RC_D_BALANCE_GROUP_ID RC_D_BALANCE_GROUP RC_D_BALANCE_GROUP_ID
RC_D_BALANCE_TYPE_ID RC_D_BALANCE_TYPE RC_D_BALANCE_TYPE_ID
RC_D_BILLING_ENTITY_ID RC_D_BILLING_ENTITY RC_D_BILLING_ENTITY_ID
RC_D_BILL_PROPERTY_ID RC_D_BILL_PROPERTY RC_D_BILL_PROPERTY_ID
RC_D_ENCNTR_TYPE_CLASS_ID RC_D_ENCNTR_TYPE_CLASS RC_D_ENCNTR_TYPE_CLASS_ID
RC_D_FIN_CLASS_ID RC_D_FINANCIAL_CLASS RC_D_FINANCIAL_CLASS_ID
RC_D_PRI_FIN_CLASS_ID RC_D_FINANCIAL_CLASS RC_D_FINANCIAL_CLASS_ID
RC_D_RESP_FIN_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_PRI_HEALTH_PLAN_ID RC_D_HEALTH_PLAN RC_D_HEALTH_PLAN_ID
RC_D_RESP_HEALTH_PLAN_ID RC_D_HEALTH_PLAN RC_D_HEALTH_PLAN_ID
RC_D_BAL_HOLD_ID RC_D_HOLD RC_D_HOLD_ID
RC_D_ENCNTR_HOLD_ID RC_D_HOLD RC_D_HOLD_ID
RC_D_MEDICAL_SERVICE_ID RC_D_MEDICAL_SERVICE RC_D_MEDICAL_SERVICE_ID
RC_D_ATTEND_PHYS_SPECIALTY_ID RC_D_PHYSICIAN_SPECIALTY RC_D_PHYSICIAN_SPECIALTY_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


RC_F_CASE_MIX



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Fact Case Mix
Definition: This table represents the case mix value for encounters that have been coded.
Table Type: ACTIVITY





Column Detail - RC_F_CASE_MIX


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ADMISSION_DT_NBR DOUBLE N The Cerner Julian number representing the date the patient was admitted to the hospital. In the case of Observation patients, this is the date the patient was registered to the hospital.
ATTENDING_PHYSICIAN_START_TIME DATETIME Y Identifies the date and time the attending physician was assigned
BALANCE_AMOUNT DOUBLE N Uniquely identifies the balance amount for the encounter
BEGIN_CODING_DT_NBR DOUBLE N The Cerner Julian number representing the date for which the first coding activity occurred.
BILL_DATE_NBR DOUBLE N Date when the first bill was sent to the payor.
CODED_DATE_NBR DOUBLE N Date when the coding for the of episode took place..
DISCHARGE_DT_NBR DOUBLE N The Cerner Julian number representing the date the patient was discharged from the hospital.
END_CODING_DT_NBR DOUBLE N The Cerner Julian number representing the date for which the most recent coding activity occurred
FIN_NBR_IDENT VARCHAR(50) Y The FIN of the patient whose encounter had the coding activity.
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.
LENGTH_OF_STAY DOUBLE N The cumulative number of days an encounter has been in a bed at midnight since admission. Additionally, if the patient is admitted and discharged on the same day, the Length of Stay is 1 day.
MILL_ENCOUNTER_ID DOUBLE N The Encounter ID from Millennium that is related to this record.
MILL_LOGICAL_DOMAIN_ID DOUBLE N The Logical Domain Identifier from Millennium
MRN_NBR_IDENT VARCHAR(50) Y Identifier of a medical record number.
MS_DRG_ID DOUBLE N Uniquely identifies the diagnostic related group related to this fact row.
RC_D_ATTEND_PRSNL_SPECIALTY_ID DOUBLE N This is a foreign key that identifies the specialty assigned to the attending Personnel in a given location in the fact table.
RC_D_CODING_STATUS_ID DOUBLE N Uniquely identifies the coding status related to this fact row.
RC_D_ENCNTR_TYPE_CLASS_ID DOUBLE N Uniquely identifies the encounter type class related to this record.
RC_D_MEDICAL_SERVICE_ID DOUBLE N Uniquely identifies the medical service related to this record.
RC_D_NEWBORN_STATUS_ID DOUBLE N Uniquely identifies the newborn status related to this record.
RC_D_PRI_DRG_ID DOUBLE N Uniquely identifies the primary DRG related to this record.
RC_D_PRI_FINANCIAL_CLASS_ID DOUBLE N Uniquely identifies the Primary Financial Class related to this record.
RC_D_PRI_HEALTH_PLAN_ID DOUBLE N Uniquely identifies the Primary Health Plan related to this record.
RC_F_CASE_MIX_ID DOUBLE N Uniquely represents a case mix value for encounters that have been coded.
SHR_D_ATTENDING_PRSNL_ID DOUBLE N Uniquely identifies the attending personnel related to this coding activity.
SHR_D_CODING_PRSNL_ID DOUBLE N Uniquely identifies the coding personnel related to this coding activity.
SHR_D_LOCATION_ID DOUBLE N Uniquely identifies the patient encounter location for the activity date.
SHR_D_PERSON_ID DOUBLE N Uniquely identifies person information related to this fact row.
TIME_ZONE_INDEX DOUBLE N Stores the time zone from which the data was extracted.
TOTAL_ADJUSTMENT_AMT DOUBLE N Contains the total of the adjustments.
TOTAL_CHARGE_AMT DOUBLE N Represents the total charges for the encounter
TOTAL_PAYMENT_AMT DOUBLE N Represents the total payments for the encounter
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_CASE_MIX


Child Column in RC_F_CASE_MIX(FK) Parent Table Name Parent Column Name
Parents: MILL_LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
MS_DRG_ID RC_D_DRG RC_D_DRG_ID
RC_D_PRI_DRG_ID RC_D_DRG RC_D_DRG_ID
RC_D_ENCNTR_TYPE_CLASS_ID RC_D_ENCNTR_TYPE_CLASS RC_D_ENCNTR_TYPE_CLASS_ID
RC_D_PRI_FINANCIAL_CLASS_ID RC_D_FINANCIAL_CLASS RC_D_FINANCIAL_CLASS_ID
RC_D_PRI_HEALTH_PLAN_ID RC_D_HEALTH_PLAN RC_D_HEALTH_PLAN_ID
RC_D_MEDICAL_SERVICE_ID RC_D_MEDICAL_SERVICE RC_D_MEDICAL_SERVICE_ID
RC_D_NEWBORN_STATUS_ID RC_D_NEWBORN_STATUS RC_D_NEWBORN_STATUS_ID
RC_D_ATTEND_PRSNL_SPECIALTY_ID RC_D_PHYSICIAN_SPECIALTY RC_D_PHYSICIAN_SPECIALTY_ID
SHR_D_LOCATION_ID SHR_D_LOCATION SHR_D_LOCATION_ID
SHR_D_ATTENDING_PRSNL_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_CODING_PRSNL_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_PERSON_ID SHR_D_PERSON SHR_D_PERSON_ID


RC_F_CASH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Fact Cash
Definition: This fact table contains data related to payments.
Table Type: ACTIVITY





Column Detail - RC_F_CASH


Column Name Type Null? Definition
ACTIVITY_DT_NBR DOUBLE N A number representing the activity date. References the key in the OMF_DATE table.
ADMIT_DT_NBR DOUBLE N A number representing the admit date. References the key in the OMF_DATE table.
BATCH_CREATED_DT_NBR DOUBLE N A number representing the date the batch was created. References the key in the OMF_DATE table.
BILL_NUMBER_IDENT VARCHAR(40) N Contains the display value associated to a bill number.
DISCHARGE_DT_NBR DOUBLE N The number representing the date the patient who made the transaction was discharged.
FEDERAL_TAX_ID_NBR VARCHAR(100) Y Contains the tax identification number assigned by the federal government.
FIN_NBR_IDENT VARCHAR(50) Y Identifier of Financial Number
FIRST_PROCESS_DT_TM DATETIME N The date/time that the first ETL process started that created this record.
GL_ACTIVITY_DT_NBR DOUBLE N Contains the GL_ACTIVITY_DT_TM value from GL_TRANS_LOG table.
GL_CREATED_DT_NBR DOUBLE N Contains the GL_CREATED_DT_TM number from the GL_TRANS_LOG table.
GL_IMPACT_DT_NBR DOUBLE N Contains the GL_IMPACT_DT_TM value from GL_TRANS_LOG table.
INTERFACE_DT_NBR DOUBLE N A number representing the date the interface date. References the key in the OMF_DATE table.
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
MILL_ACTIVITY_ID DOUBLE N Number that identifies the row in the pft_trans_reltn Millennium database table from which this row was derived.
MILL_CORSP_ID DOUBLE N Number that identifies the row in the Bill_Rec Millennium database table from which this row was derived.
MILL_GL_TRANS_LOG_ID DOUBLE N Uniquely identifies the related record on the GL_TRANS_LOG table.
MILL_LOGICAL_DOMAIN_ID DOUBLE N Uniquely identifies the logical domain to which the row data belongs.
MILL_PFT_CHARGE_ID DOUBLE N Identifies the Millennium record from which the data on this row was derived.
MRN_NBR_IDENT VARCHAR(50) Y Identifier of medical record number.
PAYMENT_INFO VARCHAR(40) Y Contains payment information such as credit card confirmation or check number.
PAYMENT_METHOD_DT_NBR DOUBLE N A number representing the Payment Method Date. References the key in the OMF_DATE table.
PAYMENT_METHOD_NBR DOUBLE N Contains the related check or credit card number.
PLACE_OF_SERVICE_DESC VARCHAR(100) Y Contains a description of the place of service.
POST_DT_NBR DOUBLE N A number representing the post date. References the key in the OMF_DATE table.
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_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_AR_GL_ALIAS_ID DOUBLE N Uniquely identifies the AR GL record related to this 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_BILLING_ENTITY_ID DOUBLE N Uniquely identifies the Billing Entity Dimension Row related to this Fact row.
RC_D_BILL_TYPE_ID DOUBLE N Uniquely identifies the Bill Type Dimension row 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 associated to the payment.
RC_D_FINANCIAL_CLASS_ID DOUBLE N Uniquely identifies the row on the Financial Class Dimension that relates to this fact row.
RC_D_GL_ALIAS_ID DOUBLE N Uniquely identifies a GL Alias Dimension row related to this fact row.
RC_D_HEALTH_PLAN_ID DOUBLE N Uniquely identifies a Health Plan Dimension Row related to this fact row.
RC_D_MEDICAL_SERVICE_ID DOUBLE N Uniquely identifies medical service information such as type or category, that the patient is receiving in relation to their encounter .
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_TRANSACTION_ALIAS_ID DOUBLE N Uniquely identifies a Transaction Alias Dimension Row related to this fact row.
RC_D_TRANSACTION_BATCH_ID DOUBLE N Uniquely identifies a Transaction Batch Dimension Row 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_CASH_ID DOUBLE N Uniquely identifies data related to payments.
REGISTRATION_DT_NBR DOUBLE N The number representing the date the patient who made the transaction was registered to the hospital.
SERVICE_FACILITY_NAME VARCHAR(100) Y The name of the facility where service was performed.
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 related patient location
SHR_D_PERFORM_PHYSICIAN_ID DOUBLE N Represents the person who was the performing physician for the related fact row.
SHR_D_PERSON_ID DOUBLE N Uniquely identifies a Person Dimension Row related to this fact row.
SHR_D_POSTING_PRSNL_ID DOUBLE N Uniquely identifies a row on the Shared Person Dimension table that represents the person who posted the information about 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.
TIME_ZONE_INDEX DOUBLE N Stores the time zone from which the data was extracted.
TRANSACTION_AMT DOUBLE N Contains the dollar amount associated to a given transaction.
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_CASH


Child Column in RC_F_CASH(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_DT_NBR OMF_DATE DT_NBR
ADMIT_DT_NBR OMF_DATE DT_NBR
GL_ACTIVITY_DT_NBR OMF_DATE DT_NBR
GL_CREATED_DT_NBR OMF_DATE DT_NBR
GL_IMPACT_DT_NBR OMF_DATE DT_NBR
INTERFACE_DT_NBR OMF_DATE DT_NBR
PAYMENT_METHOD_DT_NBR OMF_DATE DT_NBR
POST_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_D_BILL_TYPE_ID RC_D_BILL_TYPE RC_D_BILL_TYPE_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_AR_GL_ALIAS_ID RC_D_GL_ALIAS RC_D_GL_ALIAS_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_TRANSACTION_ALIAS_ID RC_D_TRANSACTION_ALIAS RC_D_TRANSACTION_ALIAS_ID
RC_D_TRANSACTION_BATCH_ID RC_D_TRANSACTION_BATCH RC_D_TRANSACTION_BATCH_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_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_PERSON_ID SHR_D_PERSON SHR_D_PERSON_ID
SHR_D_POSTING_PRSNL_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