Table Detail Report

LH_MU_FX_2_EP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_MU_FX_2_EP_RELTN
Definition: Fact table to store the relationships betwen MU FX steage 2 ecnounter and BR Eligible
Table Type: ACTIVITY





Column Detail - LH_MU_FX_2_EP_RELTN


Column Name Type Null? Definition
BR_ELIGIBLE_PROVIDER_ID DOUBLE N Foreign key to BR_ELIGIBLE_PROVIDER table
D_EP_PRSNL_ID DOUBLE N Identifies the eligible provider with the quality measure. Foreign key to the LH_D_PERSONNAL table.
EC_IND DOUBLE Y Indicator used to show that an inpatient qualified for an EC.
ENCNTR_PRSNL_R_CD DOUBLE N Identifies the type of encounter personnel relationship
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_MU_FX_2_EP_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the LH_MU_FX_2_EP_RELTN table.
LH_MU_FX_2_METRICS_ID DOUBLE N Foreign key to LH_MU_FX_2_METRICS table
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.
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_SOURCE VARCHAR(50) N The source of the update
UPDT_TASK VARCHAR(50) 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 - LH_MU_FX_2_EP_RELTN


Child Column in LH_MU_FX_2_EP_RELTN(FK) Parent Table Name Parent Column Name
Parents: D_EP_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_MU_FX_2_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_MU_FX_2_METRICS_ID LH_MU_FX_2_METRICS LH_MU_FX_2_METRICS_ID


LH_MU_FX_2_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_MU_FX_2_METRICS
Definition: Fact table for Meaningful Use Functional Stage 2 Reporting
Table Type: ACTIVITY





Column Detail - LH_MU_FX_2_METRICS


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.
ADMIT_AGE DOUBLE N Patient's age on admission.
ADMIT_DT_TM DATETIME Y The date and time of the patient's visit.
ADMIT_POP_IND DOUBLE N Identify the encounter qualified EP/CCN population by admit date/time
ADMIT_UTC_DT_TM DATETIME Y The date and time of the patient's admittance converted to UTC.
ADV_DIR_DT_TM DATETIME Y The date/time of the first advanced directive documented for the patient.
ADV_DIR_UTC_DT_TM DATETIME Y The date/time of the first advanced directive documented for the patient; normalized to GMT.
APPOINTMENT_DT_TM DATETIME Y The date/time of appointment
APPOINTMENT_UTC_DT_TM DATETIME Y The date/time of an appointment;normalized to GMT.
APPT_TYPE_CD DOUBLE Y CODE SET:14230 The identifier for an appointment type. An example would be 'cardiac cath', 'echo stress', etc.
BR_CCN_ID DOUBLE N CMS Certification Number. Foreign key to BR_CCN.
CCN_POS_NBR DOUBLE Y Identify the ccn position number of the encounter
CLIN_SUMM_DT_TM DATETIME Y The date /time of Clinical Summary provided
CLIN_SUMM_FORMAT VARCHAR(100) Y The format of Clinical Summary
CLIN_SUMM_IND DOUBLE Y Indicates a Clinical Summary was given within 1 business days or was held for reason
CLIN_SUMM_PORTAL_IND DOUBLE Y Indicates using patient portal to provide clinical summary to patient.
CLIN_SUMM_UTC_DT_TM DATETIME Y The date /time of Clinical Summary provided; normalized to GMT.
DEMOG_CAUSE_DEATH VARCHAR(100) Y Patient's cause of death
DEMOG_DEATH_DT_TM DATETIME Y The date /time of patient death
DEMOG_DEATH_UTC_DT_TM DATETIME Y The date /time of patient death; normalized to GMT.
DEMOG_ETHNICITY VARCHAR(100) Y Patient's Ethnicity
DEMOG_LANGUAGE VARCHAR(100) Y Patient's prefer Language
DEMOG_RACE VARCHAR(100) Y Patient's race
DEMOG_SEX VARCHAR(100) Y Patient's sex
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged normalized to GMT.
DISC_DISP_EXP_IND DOUBLE Y Indicates the patient discharged in expired or deceased status.
D_DISCHARGE_BUILDING_ID DOUBLE N The building from which the patient was discharged
D_DISCHARGE_FACILITY_ID DOUBLE N The facility from which the patient was discharged
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type.
D_MED_SERVICE_ID DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others.
D_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the LH_D_PERSON table.
ED_RPT_METHOD_FLAG DOUBLE Y Indicates ED Method
ENCNTR_EXCL_IND DOUBLE N This indicator is to ensure that the encounter does not qualify in encounter based reports.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EP_IND DOUBLE N Identify the encounter qualified EP population
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
E_NOTE_DT_TM DATETIME Y The date/time of the electronic notes documented for the patient.
E_NOTE_IND DOUBLE Y Identify if the patient is qualified electronic notes numerator.
E_NOTE_NAME VARCHAR(500) Y The the name of electronic notes for this patient.
E_NOTE_UTC_DT_TM DATETIME Y The date/time of the electronic notes documented for the patient; normalized to GMT.
FAMILY_HISTORY_NUM_IND DOUBLE Y Identify if the patient is qualified family history numerator.
FHX_NOMEN_ID DOUBLE N Nomenclature_id from Nomenclature table, that qualified the patient for Family history
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the record was inserted into the table.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
LAST_PROCESS_DT_TM DATETIME Y The last date/time that the record was updated on the table.
LH_MU_FX_2_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_MU_FX_2_METRICS table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for the logical domain. This identifier allows the data to be grouped by logical domain.
MEDS_RECOND_DENOM_IND DOUBLE Y Indicates that medication reconciliation needed to be done. This is the Denominator for the Medication Reconciliation Report
MEDS_RECON_DENOM_EP_IND DOUBLE Y Indicates that medication reconciliation needed to be done for EP Patients. This is the Denominator for the EP Medication Reconciliation Report.
MEDS_RECON_IND DOUBLE Y Indicates that medication reconciliation was done. This is the Numerator for the Medication Reconciliation Report
MSG_SENT_DT_TM DATETIME Y The date /time of Secure Message sent.
MSG_SENT_UTC_DT_TM DATETIME Y The date /time of Secure Message sent. normalized to GMT.
ORG_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
PARENT_ENTITY_ID DOUBLE N The unique ID of the table that the row on this table is a child of
PARENT_ENTITY_NAME VARCHAR(50) N The name of the table that the row on this table is a child of
PARTITION_DT_TM DATETIME Y The date/time the encounter was admit from the facility
PAT_EDU_DT_TM DATETIME Y The date when the patient education material was given to the patient.
PAT_EDU_IND DOUBLE Y Indicates that the patient received proper education
PAT_EDU_MATERIAL VARCHAR(1000) Y The education material which patient received.
SECURE_MSG_IND DOUBLE Y Indicates a secure electronic message was sent
SECURE_MSG_TYPE VARCHAR(100) Y The type of secure message is sent for Secure Messaging Report
SMOKING_STATUS_DT_TM DATETIME Y The date/time of the first smoking status documented for the patient
SMOKING_STATUS_UTC_DT_TM DATETIME Y The date/time of the first smoking status documented for the patient, normalized to GMT.
SUMM_TRAN_DENOM_CCN_IND DOUBLE Y Indicates a CCN transfer order was created and a Summary of Care needed to be done for patients.
SUMM_TRAN_DENOM_EP_IND DOUBLE Y Indicates an EP Transfer order was created and a Summary of Care needed to be done for patients
SUMM_TRAN_DT_TM DATETIME Y The date /time of Transition Care or Referral.
SUMM_TRAN_INVALID_MASK DOUBLE Y Indicates the patient doesn't have problem list, allergy list or medication list populated in summary of care transition. This is the Numerator for the Summary of Care at Transition Report.
SUMM_TRAN_M1_IND DOUBLE Y Indicates a Summary of Care happened at transfer.
SUMM_TRAN_M2_IND DOUBLE Y Indicates a Summary of Care happened at transfer by electronically transmitted.
SUMM_TRAN_REV_PRSNL VARCHAR(100) Y Indicates patient's receiving provider of summary of care transition.This is the Numerator for the Summary of Care at Transition Report.
SUMM_TRAN_TOC_TYPE VARCHAR(50) Y Indicates the type of Transition Summary of Care .Such as print, email, fax¿
SUMM_TRAN_UTC_DT_TM DATETIME Y The date /time of Transition Care or Referral.normalized to GMT.
UNIQUE_EXCL_IND DOUBLE N This indicator is to ensure that the encounter does not qualify in unique patient measure reports.
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_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) N The registered (assigned) task number for the process that inserted or updated the row.
VDT_ACCESS_CCN_IND DOUBLE Y Indicates CCN patient clinical data accessed was provided timely.This will be the Numerator for the VDT (meausre 1)- Timely Access Report.
VDT_ACCESS_DT_TM DATETIME Y the date/time of accessing clinical data.
VDT_ACCESS_EP_IND DOUBLE Y Indicates CCN patient clinical data accessed was provided timely for Patients.This will be the Numerator for the VDT (meausre 1)- Timely Access Report.
VDT_ACCESS_UTC_DT_TM DATETIME Y The date/time of accessing clinical data.; normalized to GMT.
VDT_VIEW_DT_TM DATETIME Y the date/time of view , download or transmit of clinical data.
VDT_VIEW_IND DOUBLE Y Indicates the patient has viewed , downloaded , or transmitted the clinical data.;This will be the Numerator for the VDT (meausre 2)
VDT_VIEW_UTC_DT_TM DATETIME Y the date/time of view , download or transmit of clinical data.; normalized to GMT.
VITALS_DIASTOLIC_DOC_IND DOUBLE Y Identify if the patient has diastolic documentation for blood pressure.
VITALS_HEIGHT_DOC_IND DOUBLE Y Identify if the patient has the height documentation.
VITALS_SYSTOLIC_DOC_IND DOUBLE Y Identify if the patient has the systolic documentation for blood pressure.
VITALS_WEIGHT_DOC_IND DOUBLE Y Identify if the patient has the weight documentation.



Relationship Detail - LH_MU_FX_2_METRICS


Child Column in LH_MU_FX_2_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_MED_SERVICE_ID LH_D_MED_SERVICE D_MED_SERVICE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_MED_SERVICE HEALTH_SYSTEM_SOURCE_ID
D_DISCHARGE_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID




Parent Column in LH_MU_FX_2_METRICS (PK) Child Table Name Child Column Name
Children: HEALTH_SYSTEM_SOURCE_ID LH_MU_FX_2_DETAILS HEALTH_SYSTEM_SOURCE_ID
LH_MU_FX_2_METRICS_ID LH_MU_FX_2_DETAILS LH_MU_FX_2_METRICS_ID
HEALTH_SYSTEM_SOURCE_ID LH_MU_FX_2_EP_RELTN HEALTH_SYSTEM_SOURCE_ID
LH_MU_FX_2_METRICS_ID LH_MU_FX_2_EP_RELTN LH_MU_FX_2_METRICS_ID


LH_MU_FX_3_DETAILS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_MU_FX_3_DETAILS
Definition: This table holds the documented data for the encounter and person based measures
Table Type: ACTIVITY





Column Detail - LH_MU_FX_3_DETAILS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
BEDROCK_MASK_FLAG DOUBLE Y The value is a bit mask used to store indicators about bedrock Yes/No filters during the load.
BR_ELIGIBLE_PROVIDER_ID DOUBLE N Unique value for each eligible provider coming from br_eligible_provider table
CCD_SOURCE VARCHAR(50) Y This column contains source of the Continuity of Care Document (CCD)
CCD_SOURCE_IDENTIFIER_TEXT VARCHAR(125) Y This column contains the source document unique identifier of a CCD document.
CLIN_REC_ALLERGY_IND DOUBLE Y Indicates if an allergy profile was reconciled
CLIN_REC_CCDA_DT_TM DATETIME Y The time that the CCDA document was attributed
CLIN_REC_CCDA_IND DOUBLE Y Indicates if there was a CCDA document associated
CLIN_REC_MED_IND DOUBLE Y Indicates if a medication list was reconciled
CLIN_REC_PROB_IND DOUBLE Y Indicates if ta problem list was reconciled
DOC_ENCNTR_ID DOUBLE N This column mentions the encounter id on whom the documentation is done.
DOC_ENCNTR_ID_POS DOUBLE N This column mentiones the pos value of the encounter on whom the documentation is done. POS values will either be 0,21,22,23.
EP_CCN_FLAG DOUBLE Y This column will have the values of 1 ( to indicate this is a ccn patient ) 2 (to indicate this is an ep patient) and 3 ( to indicate this is an ep22 patient)
EVENT_DESCRIPTION VARCHAR(50) Y Detailed description of the event
EVENT_DT_TM DATETIME Y Date and time for the event ( clinical_event/ order_action_dt_tm etc)
EVENT_LOC_DT_TM DATETIME Y The local version of the EVENT_DT_TM column.
EXTRACT_DT_TM DATETIME Y Date and time when the row was extracted
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
HIE_ASK_NO_RECV_IND DOUBLE Y Indicates that summary of care was asked but not received for the encounter.
HIE_CCD_DOCUMENT_DT_TM DATETIME Y Date and time when the CCD Document was generated.
HIE_CCD_DOCUMENT_ID DOUBLE N CCD Document Id for HIE.
HIE_CCD_DOCUMENT_LOC_DT_TM DATETIME Y The local version of the HIE_CCD_DOCUMENT_DT_TM column.
HIE_DENOM_SOURCE VARCHAR(50) Y The name of the source that qualified the encounter to be part of the denominator.
HIE_DENOM_TEXT VARCHAR(200) Y The text value corresponding to the id or cd in denom_value.
HIE_DENOM_VALUE DOUBLE Y The value corresponding to the denom source, either an ID or a code value.
HIE_NO_DATA_IND DOUBLE Y Indicates if the encounter has a clinical event associated with the 'Queried an external HIE no Data found' Bedrock filter.
HIE_NO_HIE_IND DOUBLE Y Indicates if the 'No HIE available' Bedrock filter is set to 'YES'.
HIE_PAT_FLAG DOUBLE Y Describes the type of encounter where 1 is NEW, 2 is REF, and 3 is CCD.
HIE_SUM_VIEWED_IND DOUBLE Y Indicates if the encounter has a clinical event associated with the 'Summary of Care viewed' Bedrock filter.
HIE_XDOC_IND DOUBLE Y Indicates if encounter has a document in the SI_XDOC_METADATA table.
HIE_XDS_QUERIED_IND DOUBLE Y Indicates if encounter has a row on the SI_XDOC_QUERY_PERSON_RELTN table.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_MU_FX_3_DETAILS_ID DOUBLE N Unique generated number that identifies a single row on the LH_MU_FX_3_DETAILS table.
LH_MU_FX_3_POP_METRICS_ID DOUBLE N Foreign key column, coming from lh_mu_fx_3_pop_metrics table
METRIC_TYPE VARCHAR(50) Y Measure mean
MSG_POOL_NAME VARCHAR(100) Y The column stores the name of the pool, the message was sent from. The value stored is prsnl_group_name from prsnl_group table.
NUMERATOR_IND DOUBLE Y Indicates if the row qualifies for MET OUTCOME
OUTCOME_DETAIL VARCHAR(250) Y Reason for the outcome
PARENT_ENTITY_ID DOUBLE N Will contain the primary key of the tables for which the row qualified
PARENT_ENTITY_NAME VARCHAR(30) Y Contains the name of the table for which the row qualifies
PORTAL_ACCESS_IND DOUBLE N This column indicates if the person was offered portal access.
PORTAL_ACCOUNT_IND DOUBLE N This column indicates if the person has a portal account created.
QUERY_MEAN VARCHAR(50) Y Name of the query
SEC_MSG_EP_TYPE_FLAG DOUBLE Y Status whether the provider on the br_eligible_provider_d column was listed on the TOC or CC field of the message. This will have 3 values ( 1,2,3)1 if the provider is in the cc section of the message2 if the provider is in the to section of the message3 if the provider_id corresponds to the eligible/responsible provider
SEC_MSG_NOTE_TYPE_TEXT VARCHAR(50) Y The type of message
SEC_MSG_SENDER_ID DOUBLE N The provider ID of provider who sent the message
SUB_METRIC_TYPE VARCHAR(50) Y More information for the respective metric type
TOC_ALLERGY_IND DOUBLE Y Indicates the allergy documented for TOC
TOC_MED_IND DOUBLE Y Indicates the medication documented for TOC
TOC_PROB_IND DOUBLE Y Indicates the problems documented for TOC
TOC_PROB_SNOMED_IND DOUBLE Y Indicates if the documented problem id SNOMED or not for TOC
TOC_RECIPIENT_TYPE VARCHAR(50) Y Different ways in which CCD Document will be sent ( EMAIL, PUBLISH, PRINT, FAX).
TOC_REF_PROV_FREETEXT VARCHAR(255) Y Provider names entered in the freetext field while referring the referral order to a Provider. Value coming from Order detail table where field meaning is REFERREDTOFREETXTPROVIDER.
TOC_REF_TO_PROV VARCHAR(255) Y Provider who the referral order is referred to while placing a referral order . Value coming from Order detail table where field meaning is REFERREDTOPROVIDER.
UPDT_CNT DOUBLE Y 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 Y 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_SOURCE VARCHAR(50) Y Source which updated the row
UPDT_TASK VARCHAR(50) Y 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 - LH_MU_FX_3_DETAILS


Child Column in LH_MU_FX_3_DETAILS(FK) Parent Table Name Parent Column Name
Parents: HEALTH_SYSTEM_SOURCE_ID LH_MU_FX_3_POP_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_MU_FX_3_POP_METRICS_ID LH_MU_FX_3_POP_METRICS LH_MU_FX_3_POP_METRICS_ID


LH_MU_FX_3_EP_CCN_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_MU_FX_3_EP_CCN_RELTN
Definition: This table holds data for identifying ep or ccn patients
Table Type: ACTIVITY





Column Detail - LH_MU_FX_3_EP_CCN_RELTN


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ATTRIBUTION_OPTION DOUBLE Y Ep Option set in the dm_info table ( MUSE_EP_POPULATION)
BILL_EP_IND DOUBLE Y Will signify if the Billing Logic is used
CCN_POS_NBR DOUBLE Y pos value coming from bedrock configuration settings ( 21/22/23)
CHARGE_RELTN_CD DOUBLE N charge reltn cd coming from charge table
CHARGE_RELTN_TEXT VARCHAR(50) Y display for the charge_reltn_cd column coming from code_value table
ED_RPT_METHOD_FLAG DOUBLE Y The value will indicate if the patient is an observation services patient. Value will be set to 1 if this is true. Default value = 0.
ENCNTR_PRSNL_R_CD DOUBLE N Encounter Prsnl Reltn code
ENCNTR_PRSNL_R_TEXT VARCHAR(50) Y Display for the encntr_prsnl_reltn_cd column coming from code_value table
EXTRACT_DT_TM DATETIME Y Date and time when the row was last extracted
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_MU_FX_3_EP_CCN_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the LH_MU_FX_3_EP_CCN_RELTN table.
LH_MU_FX_3_ORD_METRICS_ID DOUBLE N Foreign key column coming from lh_mu_fx_3_ord_metrics
LH_MU_FX_3_POP_METRICS_ID DOUBLE N Foreign key column coming from lh_mu_fx_3_pop_metrics
PARENT_ENTITY_ID DOUBLE N will hold br_cnn_id/br_eligible_provider_id
PARENT_ENTITY_NAME VARCHAR(30) Y Will hold BR_CCN / BR_ELIGIBLE_PROVIDER values to signify ccn or ep patient
UPDT_CNT DOUBLE Y 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 Y The date and time the row was last inserted or updated.
UPDT_SOURCE VARCHAR(50) Y Source which updated the row
UPDT_TASK VARCHAR(50) Y The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - LH_MU_FX_3_EP_CCN_RELTN


Child Column in LH_MU_FX_3_EP_CCN_RELTN(FK) Parent Table Name Parent Column Name
Parents: HEALTH_SYSTEM_SOURCE_ID LH_MU_FX_3_ORD_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_MU_FX_3_ORD_METRICS_ID LH_MU_FX_3_ORD_METRICS LH_MU_FX_3_ORD_METRICS_ID
HEALTH_SYSTEM_SOURCE_ID LH_MU_FX_3_POP_METRICS HEALTH_SYSTEM_SOURCE_ID
LH_MU_FX_3_POP_METRICS_ID LH_MU_FX_3_POP_METRICS LH_MU_FX_3_POP_METRICS_ID


LH_MU_FX_3_ORD_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_MU_FX_3_ORD_METRICS
Definition: This table will contain the populated persons for the order based measures
Table Type: ACTIVITY





Column Detail - LH_MU_FX_3_ORD_METRICS


Column Name Type Null? Definition
ACTION_PERSONNEL_ID DOUBLE N Person who performs the action of placing the order ( could be anyone)
ACTIVE_IND DOUBLE Y 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.
ADMIT_DT_TM DATETIME Y Registration date and time for the encounter
ADMIT_LOC_DT_TM DATETIME Y The local version of the ADMIT_DT_TM column.
APPT_TYPE_CD DOUBLE N Scheduling appointment type for encounter
APPT_TYPE_TEXT VARCHAR(50) Y The display for the appt_type_cd coming from code value table
BIRTH_DT_TM DATETIME Y Birth date and time for the person
BIRTH_LOC_DT_TM DATETIME Y The local version of the BIRTH_DT_TM column
CCN_IND DOUBLE Y will signify an inpatient encounter or an observation encounter
COMMUNICATION_TYPE_CD DOUBLE N The code represting the method of communication for the order action
COMMUNICATION_TYPE_TEXT VARCHAR(50) Y The string representing the method of communication for the order action
DISCH_DT_TM DATETIME Y Discharge date and time for the encounter
DISCH_LOC_DT_TM DATETIME Y The local version of the DISCH_DT_TM column.
DISPENSE_IND DOUBLE Y Order is dispensed in retail pharmet. 1= Yes 0 = No
D_DISCHARGE_BUILDING_ID DOUBLE N Value comes from lh_d_building
D_DISCHARGE_FACILITY_ID DOUBLE N Value comes from lh_d_facility
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N Value comes from lh_d_nurse_unit
D_ENCNTR_TYPE_ID DOUBLE N Value comes from lh_d_encntr_type
D_MED_SERVICE_ID DOUBLE N Value comes from lh_d_med_service
D_PERSON_ID DOUBLE N Contains d_person_id for each person coming form lh_d_person table
EC_IND DOUBLE N Indicator used to show that an inpatient qualified for an EC.
ENCNTR_ID DOUBLE N Encntr_id of the person
EP_IND DOUBLE Y Will signify an outpatient encounter or an observation encounter
EVENT_DESCRIPTION VARCHAR(100) Y The description of the event.
EVENT_DT_TM DATETIME Y The date and time of the event (utc).
EVENT_LOC_DT_TM DATETIME Y The date and time of the event (local).
EXTRACT_DT_TM DATETIME Y Date and time the row was extracted into the table
FINANCIAL_NBR_TXT VARCHAR(50) Y Fin number for the encounter
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
FORMULARY_ENABLED_IND DOUBLE Y Indicates if the formulary benefit was on/off
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
IS_PRESCRIBED_IND DOUBLE Y Indicates if the order was electronically prescribed
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_MU_FX_3_ORD_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_MU_FX_3_ORD_METRICS table.
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.
METRIC_TYPE VARCHAR(50) Y The measure mean for which the row qualified
NUMERATOR_IND DOUBLE Y Indicates if the row qualifies for MET outcome
ORDERING_PROVIDER_ID DOUBLE N Provider who places the order
ORDER_DETAIL_LINE VARCHAR(255) Y Detailed description for the order
ORDER_ID DOUBLE N Unique value for each order coming from orders table
ORG_MRN_TXT VARCHAR(50) Y MRN for the person
OUTCOME_DETAIL VARCHAR(100) Y Reason for the outcome
PERSON_ID DOUBLE N Person id for the person
POP_DESCRIPTION VARCHAR(100) Y Detailed description for the qualification of the row
POP_QUAL_DT_TM DATETIME Y will hold admit_dt_tm/order_action_dt_tm/clinical_event_dt_tm/appointment_dt_tm depending on which query the row qualifies for. The value should be in accordance with the parent_entity_name and parent_entity_id columns.
POP_QUAL_LOC_DT_TM DATETIME Y The local version of the POP_QUAL_DT_TM column.
POSITION_CD DOUBLE N The position of the person placing the order ( e.g. dba no dta)
POSITION_TEXT VARCHAR(50) Y The string representing the position of the person placing the order coming from code_value table
QUERY_MEAN VARCHAR(50) Y The name of the query for which the row qualified
SOURCE_CD DOUBLE N Source of the order coming from orders table
SOURCE_TEXT VARCHAR(50) Y The String representing the source of the order coming from code_value table
START_DT_TM DATETIME Y Date and time when the order started
START_LOC_DT_TM DATETIME Y The local version of the START_DT_TM column.
SUB_METRIC_TYPE VARCHAR(50) Y More detailed information for which the row qualified
UPDT_CNT DOUBLE Y 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 Y 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_SOURCE VARCHAR(50) Y The source which update/inserted the row
UPDT_TASK VARCHAR(50) Y 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 - LH_MU_FX_3_ORD_METRICS


Child Column in LH_MU_FX_3_ORD_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_MED_SERVICE_ID LH_D_MED_SERVICE D_MED_SERVICE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_MED_SERVICE HEALTH_SYSTEM_SOURCE_ID
D_DISCHARGE_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID




Parent Column in LH_MU_FX_3_ORD_METRICS (PK) Child Table Name Child Column Name
Children: HEALTH_SYSTEM_SOURCE_ID LH_MU_FX_3_EP_CCN_RELTN HEALTH_SYSTEM_SOURCE_ID
LH_MU_FX_3_ORD_METRICS_ID LH_MU_FX_3_EP_CCN_RELTN LH_MU_FX_3_ORD_METRICS_ID