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 |