LH_MU_AGGREGATION



Column Section Top of Page


Table-level Detail

Description: LH_MU_AGGREGATION
Definition: Contains Lighthouse Meaningful Use metrics that have been aggregated by 7-days, 30-days, 90-days, 12 weeks, and 12 months
Table Type: ACTIVITY





Column Detail - LH_MU_AGGREGATION


Column Name Type Null? Definition
ACI_EC_GROUP_FLAG DOUBLE Y This column mentions whether the data is loaded for EP/CCN - Eligible Provide/CMS Certification Nbr(0) or ACI Group - Advanced Care Information Group (1) or ACI EC - Advanced Care Information Eligible Clinician (2) or EP - Eligible Provider(3) or CCN - CMS Certification Nbr(4).
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.
BR_ELIGIBLE_PROVIDER_ID DOUBLE N Foreign key referencing BR_ELIGIBLE_PROVIDER table
CALENDAR_YEAR DOUBLE Y Represents calendar year (2013, 2014, 2015, etc.)
CCN_NBR_TXT VARCHAR(150) Y The CMS Certification Number (CCN) used to uniquely identify a Facility
DATE_RANGE_END DATETIME Y Identifies the date range the metric is aggregated to
DATE_RANGE_START DATETIME Y Identifies the date range the metric is aggregated to
DENOMINATOR_CNT DOUBLE Y The number of qualifying patients or visits which appears for a Meaningful Use EP measure
D_BR_CCN_ID DOUBLE N Foreign key referencing LH_D_BR_CCN table
ED_RPT_METHOD_FLG DOUBLE Y Identifies which ED definition the records falls in and how it should be processed when the Report is ran. 0 - N/A 1 - All ED Visits 2 - Observation Services
EP_NAME VARCHAR(100) Y Represents the name of the eligible provider
EXCEPTION_CNT DOUBLE Y The number of exceptions.
EXCLUSION_CNT DOUBLE Y The number of qualifying patients or visits which are excluded from Meaningful Use EP measure
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.
GPRO_NAME VARCHAR(255) Y Group practice name of the TIN if the ACI_EC_GROUP_FLAG is 1 or 2 (ACI Group or ACI EC).
GPRO_TAX_ID_NBR_TXT VARCHAR(50) Y Group practice tax identification number in text format.
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.
IPP_CNT DOUBLE N Initial patient population count.
LAST_MU_LOAD_DT_TM DATETIME Y Max extract_dt_tm of LH_AMB_QUAL_ENCNTR for the period number
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_MU_AGGREGATION_ID DOUBLE N Unique generated number that identifies a single row on the LH_MU_AGGREGATION 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_NAME VARCHAR(500) Y Name that uniquely identifies that Metric being aggregated. This could be one of the 18 Functional measures or any of the Stroke, ED Throughput, or VTE measures
METRIC_VALUE DOUBLE Y Calculated value that represents the average of the metric by the date range specified
MSR_POP_CNT DOUBLE N Measure population count.
MU_VERSION DOUBLE Y Numeric representation of Meaningful Use version (e.g. "1" stands for stage I and "2" for stage II)
NPI_NBR_TXT VARCHAR(200) Y The National Provider Identification used to uniquely identify a Eligible Provider
NUMERATOR_CNT DOUBLE Y The number of qualifying patients or visits which meet the criteria (MET/DONE) for Meaningful Use EP measure
PERIOD_NBR DOUBLE N Number to denote the script specific date range for this record.
SCRIPT_VERSION VARCHAR(50) Y The name of script which populated this row (e.g. "lh_nqf_aggregation.prg", "lh_nqf2_aggregation.prg", etc.)
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 script name responsible for updating the record.
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.


LH_MU_EP_METRICS_RELTN



Column Section Top of Page


Table-level Detail

Description: LH_MU_EP_METRICS_RELTN
Definition: Fact table for Meaningful Use Lighthouse Report.
Table Type: ACTIVITY





Column Detail - LH_MU_EP_METRICS_RELTN


Column Name Type Null? Definition
BILL_EP_IND DOUBLE Y Identifies the encounter and EP relationship is base on billing system.
BR_ELIGIBLE_PROVIDER_ID DOUBLE N The ID of the row on the BR_ELIGIBLE_PROVIDER table that is related to the MU FX Metric.
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_EP_METRICS_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the LH_MU_EP_METRICS_RELTN table.
LH_MU_FX_METRICS_ID DOUBLE N The ID of the row on the LH_MU_FX_METRICS table that is related to the BR_ELIGIBLE_PROVIDER 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) Y The source of the update.
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.


LH_MU_EP_ORG_RELTN



Column Section Top of Page


Table-level Detail

Description: LH_MU_EP_ORG_RELTN
Definition: Identifies which Organizations an Eligible provider belongs to so they can be reported properly in the Lighthouse Meaningful Use reports
Table Type: REFERENCE





Column Detail - LH_MU_EP_ORG_RELTN


Column Name Type Null? Definition
EP_NAME VARCHAR(100) Y The Full Name of the Eligible Provider
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_EP_ORG_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the LH_MU_EP_ORG_RELTN table.
NPI_NBR_TXT VARCHAR(200) Y The National Provider Identification used to uniquely identify a Eligible Provider
ORGANIZATION_ID DOUBLE N Unique Identifier for the Organization
ORG_NAME VARCHAR(100) Y The name of the Organization the Eligible Provider is associated to
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 script name responsible for updating the record.
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.


LH_MU_EP_VISIT_RELTN



Column Section Top of Page


Table-level Detail

Description: LH_MU_EP_VISIT_RELTN
Definition: Fact table for Meaningful Use Functional Reporting
Table Type: ACTIVITY





Column Detail - LH_MU_EP_VISIT_RELTN


Column Name Type Null? Definition
BR_ELIGIBLE_PROVIDER_ID DOUBLE N Foreign key to BR_ELIGIBLE_PROVIDER table
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 the record was first loaded 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 date/time the record was last loaded into the table.
LH_MU_EP_VISIT_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the LH_MU_EP_VISIT_RELTN table.
LH_MU_FX_VISIT_METRICS_ID DOUBLE N Foreign key to LH_MU_FX_VISIT_METRICS table
UPDT_CNT DOUBLE Y The number of times the row has been updated
UPDT_DT_TM DATETIME Y The last time the row was updated
UPDT_SOURCE VARCHAR(50) Y The source of the update
UPDT_TASK VARCHAR(50) Y The task of the update


LH_MU_FX_2_DETAILS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_MU_FX_2_DETAILS
Definition: Fact table is to store metric details for Meaningful Use Functional Stage 2 Reporting
Table Type: ACTIVITY





Column Detail - LH_MU_FX_2_DETAILS


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.
EVENT_DESCRIPTION VARCHAR(1000) Y The description of the event
EVENT_DT_TM DATETIME Y The date and time of the event
EVENT_UTC_DT_TM DATETIME Y The date and time of the event
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_DETAILS_ID DOUBLE N Unique generated number that identifies a single row on the LH_MU_FX_2_DETAILS table.
LH_MU_FX_2_METRICS_ID DOUBLE N Foreign key to LH_MU_FX_VISIT_METRICS table
METRIC_TYPE VARCHAR(50) Y Identifies the type of metric for the row
MSG_SENDER_ID DOUBLE N Indicates the person_id of who sent the secure message to the patient.
NUMERATOR_IND DOUBLE N Identifies whether or not the row belongs in the numerator
ORDER_PROVIDER_ID DOUBLE Y This column will provide the name of the ordering provider who placed the order on 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
SUB_METRIC_TYPE VARCHAR(50) Y Identifies the type of metric for the row
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_DETAILS


Child Column in LH_MU_FX_2_DETAILS(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