Table Detail Report

RC_GSR_DIMENSION_TMP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Gold Standard Reporting Dimension Temporary
Definition: This table is used by the GSR dimension load process to identify the distinct set of rows in each of the dimension tables which must be inserted or updated during the current job execution. This table does not need a unique PK value or associated index.
Table Type: ACTIVITY





Column Detail - RC_GSR_DIMENSION_TMP


Column Name Type Null? Definition
BATCH_ID DOUBLE N A sequential batch identifier assigned to a group of rows inserted into this table by the GSR dimension load process for the logical_domain_id in which the process is being executed.
DIM_INDEX DOUBLE N This field is an index into the recDWItems structure that is used by the GSR dimension load process to access the parameters needed to process the loading of data for each dimension table
INSERT_IND DOUBLE N This field will be set to 0 if the dimension row related to this row already exists and must be updated, or 1 if a new row will need to be inserted.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
LONG_TEXT_MD5_HASH_TXT VARCHAR(32) N This field is a unique identifier based on the value of the long_text string that is linked to the referenced rc_cln_area row. While rc_cln_area may include large numbers of rows that reference the same dimension row, only one row will be inserted into this table for each distinct dimension row based on the value of this column.
RCR_GSR_CONTEXT_ID DOUBLE N Unique generated number that identifies a single row on the RCR_GSR_CONTEXT table.
RC_CLN_AREA_ID DOUBLE N This is the primary key of a row on the rc_cln_area staging table.
RC_DIMENSION_ID DOUBLE N This field is a numeric identifier that is associated with each GSR dimension table. The specific values assigned to each dimension table are defined in the pft_load_dw.inc include file.



Relationship Detail - RC_GSR_DIMENSION_TMP


Child Column in RC_GSR_DIMENSION_TMP(FK) Parent Table Name Parent Column Name
Parents: RCR_GSR_CONTEXT_ID RCR_GSR_CONTEXT RCR_GSR_CONTEXT_ID


RC_GSR_SUM_AGG_TMP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Gold Standard Reporting Summary Aggregate Temporary
Definition: This tables is used in the GSR summarization process to control the distributed summarization of data based on all possible values of an extract-specific dimension.
Table Type: ACTIVITY





Column Detail - RC_GSR_SUM_AGG_TMP


Column Name Type Null? Definition
ACTIVITY_DATE DOUBLE N The date for which activity data is to be summarized.
AGGREGATE_INFO VARCHAR(250) N This is a delimited string that defines the names of the source activity table, the column in that table containing the dimension id found in the attribute_value and the name of the dimension table for which this value represents the primary key.
ATTRIBUTE_VALUE DOUBLE N The value of a specific dimension id by which activity data is to be summarized. This value may be 0.0 to allow summarization to occur for activity data for which there is no related dimension row. See the aggregate_info column for information defining which dimension table is referenced, what it's primary key column name is, and what the name of the activity table being summarized is.
LOAD_SCRIPT_NAME VARCHAR(32) N The name of the load script that is responsible for summarizing the data associated with this row.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
RCR_GSR_CONTEXT_ID DOUBLE N Uniquely identifies the related GSR Context Identifier
TEMP_ID DOUBLE N A sequential identifier for the rows that are inserted by the GSR summary load process for the logical_domain_id in which the process is being executed.



Relationship Detail - RC_GSR_SUM_AGG_TMP


Child Column in RC_GSR_SUM_AGG_TMP(FK) Parent Table Name Parent Column Name
Parents: RCR_GSR_CONTEXT_ID RCR_GSR_CONTEXT RCR_GSR_CONTEXT_ID


SHR_D_LOCATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Shared Dimension Location
Definition: This table contains location information such as facility and building name.
Table Type: REFERENCE





Column Detail - SHR_D_LOCATION


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.
BED VARCHAR(40) N The bed associate with a location.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
BUILDING VARCHAR(40) N The building associated with a location.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FACILITY VARCHAR(40) N The facility associated with a location.
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.
LOCATION_DESC VARCHAR(40) N The current permanent location of the patient (The location of a patient will be valued with the lowest level location type in the hierarchy of facility, building, room, bed).
LOCATION_MD5_HASH_TXT VARCHAR(32) N This column contains an MD5 hash code based upon the combined values of the LOCATION_DESC, FACILITY, BUILDING, ROOM, BED, MILL_LOGICAL_DOMAIN_ID and ACTIVE_IND columns.
MILL_LOGICAL_DOMAIN_ID DOUBLE N Uniquely identifies the logical domain to which the row data belongs.
ROOM VARCHAR(40) N The room associated with a location.
SHR_D_LOCATION_ID DOUBLE N Uniquely identifies location information such as facility and building name.
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 - SHR_D_LOCATION




Parent Column in SHR_D_LOCATION (PK) Child Table Name Child Column Name
Children: SHR_D_LOCATION_ID RC_F_ADJUSTMENT SHR_D_PATIENT_LOCATION_ID
RC_F_BALANCE_AR SHR_D_LOCATION_ID
RC_F_CASE_MIX SHR_D_LOCATION_ID
RC_F_CASH SHR_D_PATIENT_LOCATION_ID
RC_F_CLAIM_EVENT SHR_D_LOCATION_ID
RC_F_CODING_ACTIVITY SHR_D_LOCATION_ID
RC_F_DAILY_BAL_AR_SMRY SHR_D_LOCATION_ID
RC_F_DAILY_CDM_SMRY SHR_D_LOCATION_ID
RC_F_DAILY_CENSUS SHR_D_LOCATION_ID
RC_F_DAILY_CENSUS_SMRY SHR_D_LOCATION_ID
RC_F_DAILY_CLAIM_EVENT_SMRY SHR_D_LOCATION_ID
RC_F_DAILY_ENCNTR_VISIT_SMRY SHR_D_LOCATION_ID
RC_F_DAILY_TRANS_SMRY SHR_D_LOCATION_ID
RC_F_DENIAL SHR_D_LOCATION_ID
RC_F_DLY_CHRG_ASSOC_SMRY SHR_D_PATIENT_LOCATION_ID
RC_F_DLY_CODING_ACT_SMRY SHR_D_LOCATION_ID
RC_F_INVOICE_AR_BALANCE SHR_D_LOCATION_ID
RC_F_MONTHLY_CDM_SMRY SHR_D_LOCATION_ID
RC_F_MONTHLY_CENSUS_SMRY SHR_D_LOCATION_ID
RC_F_MONTHLY_CLAIM_EVENT_SMRY SHR_D_LOCATION_ID
RC_F_MONTHLY_ENCNTR_VISIT_SMRY SHR_D_LOCATION_ID
RC_F_MONTHLY_TRANS_SMRY SHR_D_LOCATION_ID
RC_F_MTH_CHRG_ASSOC_SMRY SHR_D_PATIENT_LOCATION_ID
RC_F_MTH_CODING_ACT_SMRY SHR_D_LOCATION_ID
RC_F_PATIENT_AR_BALANCE SHR_D_LOCATION_ID
RC_F_PATIENT_AR_BAL_SMRY SHR_D_LOCATION_ID
RC_F_REVENUE SHR_D_PATIENT_LOCATION_ID
RC_F_REVENUE SHR_D_PERFORMING_LOCATION_ID
RC_F_VARIANCE SHR_D_PATIENT_LOCATION_ID
RC_F_VAR_CLAIM_SMRY SHR_D_PATIENT_LOCATION_ID
RC_F_VAR_LINE_ITEM_SMRY SHR_D_PATIENT_LOCATION_ID
SHR_F_ENCOUNTER_VISIT SHR_D_LOCATION_ID


SHR_D_MONTH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Shared Dimension Month
Definition: Contains data related to the months of the year.
Table Type: REFERENCE





Column Detail - SHR_D_MONTH


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.
MONTH_ABBREVIATION VARCHAR(5) N Contains the first three letters of the name of the month.
MONTH_NAME VARCHAR(10) N Contains the name of the month.
SHR_D_MONTH_ID DOUBLE N Uniquely identifies a row for each month of the year.
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 - SHR_D_MONTH




Parent Column in SHR_D_MONTH (PK) Child Table Name Child Column Name
Children: SHR_D_MONTH_ID RC_F_DAILY_TRANS_SMRY DISCHARGE_MONTH_ID
RC_F_MONTHLY_CDM_SMRY SHR_D_MONTH_ID
RC_F_MONTHLY_CLAIM_EVENT_SMRY SHR_D_MONTH_ID
RC_F_MONTHLY_DENIAL_SMRY SHR_D_MONTH_ID
RC_F_MONTHLY_ENCNTR_VISIT_SMRY SHR_D_MONTH_ID
RC_F_MONTHLY_TRANS_SMRY DISCHARGE_MONTH_ID
RC_F_MONTHLY_TRANS_SMRY SHR_D_MONTH_ID
RC_F_MTH_CHRG_ASSOC_SMRY SHR_D_SERVICE_MONTH_ID


SHR_D_PERSON



Column Section Relationship Section Top of Page


Table-level Detail

Description: Shared Dimension Person
Definition: This table contains person information such as a person's and a supervisor's name.
Table Type: ACTIVITY





Column Detail - SHR_D_PERSON


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
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_PERSON_ID DOUBLE N Uniquely identifies the person id from the Millennium database person table related to this dimension row.
PERSON_FIRST_NAME VARCHAR(100) N The first name of a person.
PERSON_FULL_NAME VARCHAR(100) N The full name of the person.
PERSON_LAST_NAME VARCHAR(100) N The last name of the person.
PERSON_MIDDLE_NAME VARCHAR(100) N The middle name of the person.
SHR_D_PERSON_ID DOUBLE N Uniquely identifies person information.
SUPERVISOR_FULL_NAME VARCHAR(100) N The full name of the supervisor.
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 - SHR_D_PERSON




Parent Column in SHR_D_PERSON (PK) Child Table Name Child Column Name
Children: SHR_D_PERSON_ID RC_D_RACE_BRIDGE SHR_D_PERSON_ID
RC_F_ADJUSTMENT SHR_D_ADMIT_PHYSICIAN_ID
RC_F_ADJUSTMENT SHR_D_ATTEND_PHYSICIAN_ID
RC_F_ADJUSTMENT SHR_D_CONSULT_PHYSICIAN_ID
RC_F_ADJUSTMENT SHR_D_ORDER_PHYSICIAN_ID
RC_F_ADJUSTMENT SHR_D_PERFORM_PHYSICIAN_ID
RC_F_ADJUSTMENT SHR_D_PERSON_ID
RC_F_ADJUSTMENT SHR_D_POSTING_PRSNL_ID
RC_F_ADJUSTMENT SHR_D_REFER_PHYSICIAN_ID
RC_F_ADJUSTMENT SHR_D_REND_PHYSICIAN_ID
RC_F_ADJUSTMENT SHR_D_SUPERV_PHYSICIAN_ID
RC_F_BALANCE_AR SHR_D_ATTENDING_PHYSICIAN_ID
RC_F_BALANCE_AR SHR_D_PERSON_ID
RC_F_CASE_MIX SHR_D_ATTENDING_PRSNL_ID
RC_F_CASE_MIX SHR_D_CODING_PRSNL_ID
RC_F_CASE_MIX SHR_D_PERSON_ID
RC_F_CASH SHR_D_ADMIT_PHYSICIAN_ID
RC_F_CASH SHR_D_ATTEND_PHYSICIAN_ID
RC_F_CASH SHR_D_CONSULT_PHYSICIAN_ID
RC_F_CASH SHR_D_ORDER_PHYSICIAN_ID
RC_F_CASH SHR_D_PERFORM_PHYSICIAN_ID
RC_F_CASH SHR_D_PERSON_ID
RC_F_CASH SHR_D_POSTING_PRSNL_ID
RC_F_CASH SHR_D_REFER_PHYSICIAN_ID
RC_F_CASH SHR_D_REND_PHYSICIAN_ID
RC_F_CASH SHR_D_SUPERV_PHYSICIAN_ID
RC_F_CLAIM_EVENT SHR_D_ADMIT_PRSNL_ID
RC_F_CLAIM_EVENT SHR_D_PERSON_ID
RC_F_CODING_ACTIVITY SHR_D_ADMITTING_PRSNL_ID
RC_F_CODING_ACTIVITY SHR_D_ATTENDING_PRSNL_ID
RC_F_CODING_ACTIVITY SHR_D_CODING_PRSNL_ID
RC_F_CODING_ACTIVITY SHR_D_PERSON_ID
RC_F_DAILY_BAL_AR_SMRY SHR_D_ATTENDING_PHYSICIAN_ID
RC_F_DAILY_CDM_SMRY SHR_D_ADMIT_PHYSICIAN_ID
RC_F_DAILY_CDM_SMRY SHR_D_ATTEND_PHYSICIAN_ID
RC_F_DAILY_CDM_SMRY SHR_D_CONSULT_PHYSICIAN_ID
RC_F_DAILY_CDM_SMRY SHR_D_ORDER_PHYSICIAN_ID
RC_F_DAILY_CDM_SMRY SHR_D_PERFORM_PHYSICIAN_ID
RC_F_DAILY_CDM_SMRY SHR_D_REFER_PHYSICIAN_ID
RC_F_DAILY_CDM_SMRY SHR_D_REND_PHYSICIAN_ID
RC_F_DAILY_CDM_SMRY SHR_D_SUPERV_PHYSICIAN_ID
RC_F_DAILY_CENSUS SHR_D_ATTENDING_PHYSICIAN_ID
RC_F_DAILY_CENSUS SHR_D_PERSON_ID
RC_F_DAILY_CENSUS_SMRY SHR_D_ATTENDING_PHYSICIAN_ID
RC_F_DAILY_TRANS_SMRY SHR_D_ADMIT_PHYSICIAN_ID
RC_F_DAILY_TRANS_SMRY SHR_D_ATTEND_PHYSICIAN_ID
RC_F_DAILY_TRANS_SMRY SHR_D_CONSULT_PHYSICIAN_ID
RC_F_DAILY_TRANS_SMRY SHR_D_ORDER_PHYSICIAN_ID
RC_F_DAILY_TRANS_SMRY SHR_D_PERFORM_PHYSICIAN_ID
RC_F_DAILY_TRANS_SMRY SHR_D_REFER_PHYSICIAN_ID
RC_F_DAILY_TRANS_SMRY SHR_D_REND_PHYSICIAN_ID
RC_F_DAILY_TRANS_SMRY SHR_D_SUPERV_PHYSICIAN_ID
RC_F_DENIAL SHR_D_ATTENDING_PHYSICIAN_ID
RC_F_DENIAL SHR_D_PERSON_ID
RC_F_DENIAL SHR_D_POSTED_PERSON_ID
RC_F_DLY_CHRG_ASSOC_SMRY SHR_D_ADMIT_PHYSICIAN_ID
RC_F_DLY_CHRG_ASSOC_SMRY SHR_D_ATTEND_PHYSICIAN_ID
RC_F_DLY_CHRG_ASSOC_SMRY SHR_D_CONSULT_PHYSICIAN_ID
RC_F_DLY_CHRG_ASSOC_SMRY SHR_D_ORDER_PHYSICIAN_ID
RC_F_DLY_CHRG_ASSOC_SMRY SHR_D_PERFORM_PHYSICIAN_ID
RC_F_DLY_CHRG_ASSOC_SMRY SHR_D_REFER_PHYSICIAN_ID
RC_F_DLY_CHRG_ASSOC_SMRY SHR_D_REND_PHYSICIAN_ID
RC_F_DLY_CHRG_ASSOC_SMRY SHR_D_SUPERV_PHYSICIAN_ID
RC_F_DLY_CODING_ACT_SMRY SHR_D_CODING_PRSNL_ID
RC_F_GENERAL_AR_BAL_TRANS SHR_D_POSTING_PRSNL_ID
RC_F_INVOICE_AR_BALANCE SHR_D_PERSON_ID
RC_F_MONTHLY_CDM_SMRY SHR_D_ADMIT_PHYSICIAN_ID
RC_F_MONTHLY_CDM_SMRY SHR_D_ATTEND_PHYSICIAN_ID
RC_F_MONTHLY_CDM_SMRY SHR_D_CONSULT_PHYSICIAN_ID
RC_F_MONTHLY_CDM_SMRY SHR_D_ORDER_PHYSICIAN_ID
RC_F_MONTHLY_CDM_SMRY SHR_D_PERFORM_PHYSICIAN_ID
RC_F_MONTHLY_CDM_SMRY SHR_D_REFER_PHYSICIAN_ID
RC_F_MONTHLY_CDM_SMRY SHR_D_REND_PHYSICIAN_ID
RC_F_MONTHLY_CDM_SMRY SHR_D_SUPERV_PHYSICIAN_ID
RC_F_MONTHLY_CENSUS_SMRY SHR_D_ATTENDING_PHYSICIAN_ID
RC_F_MONTHLY_TRANS_SMRY SHR_D_ADMIT_PHYSICIAN_ID
RC_F_MONTHLY_TRANS_SMRY SHR_D_ATTEND_PHYSICIAN_ID
RC_F_MONTHLY_TRANS_SMRY SHR_D_ORDER_PHYSICIAN_ID
RC_F_MONTHLY_TRANS_SMRY SHR_D_PERFORM_PHYSICIAN_ID
RC_F_MONTHLY_TRANS_SMRY SHR_D_REFER_PHYSICIAN_ID
RC_F_MONTHLY_TRANS_SMRY SHR_D_REND_PHYSICIAN_ID
RC_F_MONTHLY_TRANS_SMRY SHR_D_SUPERV_PHYSICIAN_ID
RC_F_MTH_CHRG_ASSOC_SMRY SHR_D_ADMIT_PHYSICIAN_ID
RC_F_MTH_CHRG_ASSOC_SMRY SHR_D_ATTEND_PHYSICIAN_ID
RC_F_MTH_CHRG_ASSOC_SMRY SHR_D_CONSULT_PHYSICIAN_ID
RC_F_MTH_CHRG_ASSOC_SMRY SHR_D_ORDER_PHYSICIAN_ID
RC_F_MTH_CHRG_ASSOC_SMRY SHR_D_PERFORM_PHYSICIAN_ID
RC_F_MTH_CHRG_ASSOC_SMRY SHR_D_REFER_PHYSICIAN_ID
RC_F_MTH_CHRG_ASSOC_SMRY SHR_D_REND_PHYSICIAN_ID
RC_F_MTH_CHRG_ASSOC_SMRY SHR_D_SUPERV_PHYSICIAN_ID
RC_F_MTH_CODING_ACT_SMRY SHR_D_CODING_PRSNL_ID
RC_F_NON_AR_BALANCE_TRANS SHR_D_POSTING_PRSNL_ID
RC_F_PATIENT_AR_BALANCE SHR_D_ATTENDING_PHYSICIAN_ID
RC_F_PATIENT_AR_BALANCE SHR_D_CODING_PERSON_ID
RC_F_PATIENT_AR_BALANCE SHR_D_PERSON_ID
RC_F_PATIENT_AR_BALANCE SHR_D_QUEUE_PERSON_ID
RC_F_REVENUE SHR_D_ADMIT_PHYSICIAN_ID
RC_F_REVENUE SHR_D_ATTEND_PHYSICIAN_ID
RC_F_REVENUE SHR_D_CONSULT_PHYSICIAN_ID
RC_F_REVENUE SHR_D_CREATED_PRSNL_ID
RC_F_REVENUE SHR_D_ORDER_PHYSICIAN_ID
RC_F_REVENUE SHR_D_PERFORM_PHYSICIAN_ID
RC_F_REVENUE SHR_D_PERSON_ID
RC_F_REVENUE SHR_D_REFER_PHYSICIAN_ID
RC_F_REVENUE SHR_D_REND_PHYSICIAN_ID
RC_F_REVENUE SHR_D_SUPERV_PHYSICIAN_ID
RC_F_VARIANCE SHR_D_ACTION_PERSON_ID
RC_F_VARIANCE SHR_D_PATIENT_ID
RC_F_VARIANCE SHR_D_QUEUE_PERSON_ID
RC_F_VARIANCE SHR_D_REND_PHYSICIAN_ID
RC_F_VAR_CLAIM_SMRY SHR_D_ACTION_PERSON_ID
RC_F_VAR_CLAIM_SMRY SHR_D_PATIENT_ID
RC_F_VAR_CLAIM_SMRY SHR_D_QUEUE_PERSON_ID
RC_F_VAR_LINE_ITEM_SMRY SHR_D_ACTION_PERSON_ID
RC_F_VAR_LINE_ITEM_SMRY SHR_D_PATIENT_ID
RC_F_VAR_LINE_ITEM_SMRY SHR_D_QUEUE_PERSON_ID
SHR_F_ENCOUNTER_VISIT SHR_D_ATTENDING_PHYSICIAN_ID
SHR_F_ENCOUNTER_VISIT SHR_D_PERSON_ID
SHR_F_ENCOUNTER_VISIT SHR_D_VERIFY_PRSNL_ID