Table Detail Report

LH_MU_METRIC_DETAILS



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - LH_MU_METRIC_DETAILS


Column Name Type Null? Definition
BR_ELIGIBLE_PROVIDER_ID DOUBLE N BR ELIGIBLE PROVIDER
EVENT_DESCRIPTION VARCHAR(1000) Y The description of the event.
EVENT_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 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_FX_METRICS_ID DOUBLE N Foreign key to lh_mu_fx_metrics table.
LH_MU_METRIC_DETAILS_ID DOUBLE N Unique generated number that identifies a single row on the LH_MU_METRIC_DETAILS table.
METRIC_TYPE VARCHAR(50) Y Identifies the type of metric for the row.
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 name 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 This field is used to identify 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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.



Relationship Detail - LH_MU_METRIC_DETAILS


Child Column in LH_MU_METRIC_DETAILS(FK) Parent Table Name Parent Column Name
Parents: BR_ELIGIBLE_PROVIDER_ID BR_ELIGIBLE_PROVIDER BR_ELIGIBLE_PROVIDER_ID


LH_MU_VISIT_METRIC_DETAILS



Column Section Top of Page


Table-level Detail

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





Column Detail - LH_MU_VISIT_METRIC_DETAILS


Column Name Type Null? Definition
BR_ELIGIBLE_PROVIDER_ID DOUBLE N Foreign key to BR_ELIGIBLE_PROVIDER table
EVENT_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 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_FX_VISIT_METRICS_ID DOUBLE N Foreign key to LH_MU_FX_VISIT_METRICS table
LH_MU_VISIT_METRIC_DETAILS_ID DOUBLE N Unique generated number that identifies a single row on the LH_MU_VISIT_METRIC_DETAILS table.
METRIC_TYPE VARCHAR(50) Y Identifies the type of metric for the row
NUMERATOR_IND DOUBLE Y Identifies whether or not the row belongs in the numerator
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) Y The name of the table that the row on this table is a child of
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_PURGE_HIST



Column Section Top of Page


Table-level Detail

Description: LH PURGE HISTORY
Definition: Stores purge history for lighthouse reporting data - audit purpose
Table Type: ACTIVITY





Column Detail - LH_PURGE_HIST


Column Name Type Null? Definition
LH_PURGE_HIST_ID DOUBLE N PRIMARY KEY
PROCESSED_DT_TM DATETIME Y The date when the purge script was run by the user
PURGED_TILL_DT_TM DATETIME Y Contains the date till which the rows are removed. ; We will remove rows that have admit_dt_tm < purged_till_dt_tm
PURGED_USER_NAME VARCHAR(50) Y The user Identifier of the person who ran the script
ROWS_PURGED_COUNT DOUBLE Y Contains the number of rows deleted from the table
TABLE_NAME VARCHAR(50) Y Contains the name of the table that is being purged
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_TASK VARCHAR(50) Y Contains the team name and what task has been done (eg : "PIFX stage 1 purge")