Table Detail Report

LH_F_VTE_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_VTE_METRICS
Definition: This table is used to store metrics for the Lighthouse VTE quality measure.
Table Type: ACTIVITY





Column Detail - LH_F_VTE_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.
ACT_ORDER_IND DOUBLE Y Indicator is set if ambulatory activity order is ordered.
ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted.
ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted; normalized to GMT.
ADVISOR_RECOM_IND DOUBLE Y Identifies patient has advisor recommendation documented.
AMB_ORDER_IND DOUBLE Y Identifies patients that have had an order for ambulation.
APPROP_TREAT_ORD_IND DOUBLE Y Identifies patient has appropriate treatment order within time frame of advisor recommendation documented.
ARRIVAL_DT_TM DATETIME Y The date/time on which the patient arrived at the facility.
ARRIVAL_UTC_DT_TM DATETIME Y The date/time on which the patient arrived at the facility; normalized to GMT.
ASSESS_24H_ADMIT_IND DOUBLE Y Identifies patients that have been assessed for VTE risk within 24 hours of admission.
ASSESS_24H_CHG_PROC_IND DOUBLE Y Identifies patients that have been assessed within 24 hours of all completed procedure orders
ASSESS_24H_CHG_STAT_IND DOUBLE Y Identifies patients that have been assessed within 24 hours of all transfers to a nurse unit with a higher/lower acuity level.
ASSESS_24H_CHG_SURG_IND DOUBLE Y Identifies patients that have been assessed within 24 hours of all competed surgery procedures.
ASSESS_24H_CHG_SVC_IND DOUBLE Y Identifies patients that have been assessed within 24 hours of all primary service changes.
ASSESS_24H_CHG_TRAN_IND DOUBLE Y Identifies patients that have been assessed within 24 hours of all completed transfer orders.
AT_RISK_EDUCATION_IND DOUBLE Y Identifies patients that have had VTE prevention education documented.
CHANGE_PROC_ORD_IND DOUBLE Y Identifies patients that have completed Procedure Orders
CHANGE_SERVICE_IND DOUBLE Y Identifies patients that have had a change in medical service during the visit.
CHANGE_STATUS_IND DOUBLE Y Identifies patients that have moved to a nurse unit with a higher or lower acuity level than the previous nurse unit.
CHANGE_SURG_PROC_IND DOUBLE Y Identifies patients that have completed surgery procedure.
CHANGE_TRAN_ORD_IND DOUBLE Y Identifies patients that have completed transfer order
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
DISAG_RECOM_IND DOUBLE Y Identifies if there was a disagreement with the recommendations documented.
DISCHARGED_LAST_30_DAYS_IND DOUBLE Y Identifies if the patient has been discharged previously within the last 30 days
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.
D_ADMIT_BUILDING_ID DOUBLE N The building to which the patient was admitted.
D_ADMIT_FACILITY_ID DOUBLE N The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted.
D_ADMIT_SRC_ID DOUBLE N Identifies the place from which the patient came before being admitted.
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. Foreign key to the CODE_VALUE table.
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_METRIC_01_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_02_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_03_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_04_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_05_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_06_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_07_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_08_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_09_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_10_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_11_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_12_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_13_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_14_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_15_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_16_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_17_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_18_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_19_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_20_ID DOUBLE N Identifies a metric associated with falls. Foreign key to the lh_d_metric table.
D_METRIC_21_ID DOUBLE N Identifier of a falls metric. Foreign key to the lh_d_metric table.
D_METRIC_22_ID DOUBLE N Identifier of a falls metric. Foreign key to the lh_d_metric table.
D_METRIC_23_ID DOUBLE N Identifier of a falls metric. Foreign key to the lh_d_metric table.
D_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the PERSON table.
D_VTE_ADV_PRSNL_ID DOUBLE N The identifier of the provider that completed the advisor.
EDUCATION_IND DOUBLE Y Identifies patients that have had VTE education documented
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
ENOXAPARIN_ORDER_IND DOUBLE Y Identifies patients that had an order for Enoxaparin and a creatinine clearance result of less than 30 ml/min
ENOXAPARIN_RENAL_IND DOUBLE Y Identifies patients with an Enoxaparin renal dose.
EXCLUDE_SERVICE_IND DOUBLE Y Excludes services set in exclusion bedrock filter.
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
FIRST_PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
FIRST_RISK_ASS_LEVEL_DT_TM DATETIME Y The date/time on the first VTE risk assessment level.
FIRST_RISK_ASS_LEVEL_FLAG DOUBLE Y Identifies patients' the first VTE risk assessment level, very lower, lower, moderate or high.
FIRST_RISK_ASS_LEVEL_UTC_DT_TM DATETIME Y The date/time on the first VTE risk assessment level normalized to GMT.
F_VTE_METRICS_ID DOUBLE N Unique identifier for the lighthouse VTE metrics.
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.
HEPARIN_ORDER_IND DOUBLE Y Identifies patients that have had heparin anticoagulation therapy
HIT_DX_IND DOUBLE Y Identifies patients with hit diagnosis
INR_WIN_24H_WARFARIN_IND DOUBLE Y Identifies patients that had an INR result within 24 hours before or after the administration of warfarin
LAST_PROCESS_DT_TM DATETIME Y The date/time the record was last loaded into the table.
LMWH_UFH_IND DOUBLE Y Identifies patient received LMWH or UFH
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.
LOW_MECH_ORDER_IND DOUBLE Y Identifies patients have a risk assessment of low and an order for compression stockings and/or a mechanical device during the period which the patient is considered low risk.
LOW_PHARM_ORDER_IND DOUBLE Y Identifies patients have a risk assessment of low and an active order for pharmacological anticoagulants during the period which the patient is considered low risk.
MECH_CONTRA_IND DOUBLE Y Identifies patient has Mech Contraindication
MECH_PHARM_ORD_DT_TM DATETIME Y Order dt/tm of mechanical or pharmacological order..
MECH_PHARM_ORD_IND DOUBLE Y Identifies patient has a mech or pharm order.
MOD_PHARM_ORDER_IND DOUBLE Y Identifies patients that have a risk assessment of moderate and an active order for pharmacological anticoagulants during the period which the patient is considered moderate risk.
NOTIFY_PRV_ORD_COMP_IND DOUBLE Y Identifies patients against which an order to notify the physician was completed.
NOTIFY_PRV_ORD_IND DOUBLE Y Identifies patients against which an order to notify the physician was placed.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PATIENT_TYPE_FLAG DOUBLE Y Identifies the first patient type
PHARM_CONTRA_IND DOUBLE Y Identifies patient has Pharm Contraindication
PLAN_INITIATED_IND DOUBLE Y Identifies patients that have had the VTE prevention plan initiated.
PLATELET_PRIOR_HEPARIN_IND DOUBLE Y Identifies patients that have had a baseline platelet count prior to heparin anticoagulation therapy.
POPULATION_IND DOUBLE Y Identifies patients that have qualified for the VTE prevention population.
PREV_INCDNT_DT_TM DATETIME Y Identifies the date/time of the last VTE incident.
PREV_INCDNT_UTC_DT_TM DATETIME Y Identifies the date/time of the last VTE incident normalized to GMT.
PREV_PROPH_ORD_IND DOUBLE Y Identifies patient that vte prophylaxis received visit with 30 days of current visit.
PRIN_PROCEDURE_DT_TM DATETIME Y The date/time on which the principle procedure was performed.
PRIN_PROCEDURE_UTC_DT_TM DATETIME Y The date/time on which the principle procedure was performed; normalized to GMT
PROPHYLAXIS_REGIMEN_IND DOUBLE Y Identifies patients that are following the appropriate prophylaxis regimen for visits within 30 days of the current visit.
RISK_ASSESS_IND DOUBLE Y Identifies patient that have been assessed for VTE risk.
RISK_ASSESS_LOW_IND DOUBLE Y Identifies patients that have a VTE risk assessment equal to ""low"".
RISK_ASSESS_MOD_IND DOUBLE Y Identifies patients that have a VTE risk assessment greater than or equal to ""moderate"".
SUGGESTED_PLAN_IND DOUBLE Y Identifies patients that had the suggested VTE prevention PowerPlan
TREAT_NONE_IND DOUBLE Y Identifies if there was documentation where the VTE Treatment chosen was "None".
TREAT_PHARM_AND_MECH_IND DOUBLE Y Identifies patients with a pharmacological and mechanical treatment plan.
TREAT_PHARM_IND DOUBLE Y Identifies patients with a pharmacological treatment plan.
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.
VTE_DEFER_24H_ADMIT_IND DOUBLE Y Identifies patients that have been assessed for VTE risk within 24 hours of admission.
VTE_DEFER_IND DOUBLE Y Identifies patient has vte deferral document
VTE_IND DOUBLE Y Identifies patients with a VTE (DVT or PE diagnosis/problems)
VTE_POA_IND DOUBLE Y Identifies patients with a VTE present on admission (DVT or PE diagnosis/problems)
VTE_PREV_ADM_IND DOUBLE Y Identifies if the patient had a VTE dx on the previous admission within 30 days
VTE_PROB_DX_DT_TM DATETIME Y Date time when vte problem/ diagnosis is is diagnosed.
VTE_PROPH_DAYS_IND DOUBLE Y Indicator is set if the number of vte prophylaxis days is less than 30.
VTE_RISK_IND DOUBLE Y Identifies patients that are at risk for VTE.
WARFARIN_ORDER_IND DOUBLE Y Identifies patients that have had an order for warfarin administered.



Relationship Detail - LH_F_VTE_METRICS


Child Column in LH_F_VTE_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_ADMIT_SRC_ID LH_D_ADMIT_SRC D_ADMIT_SRC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_SRC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_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_ADMIT_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_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_METRIC_01_ID LH_D_METRIC D_METRIC_ID
D_METRIC_02_ID LH_D_METRIC D_METRIC_ID
D_METRIC_03_ID LH_D_METRIC D_METRIC_ID
D_METRIC_04_ID LH_D_METRIC D_METRIC_ID
D_METRIC_05_ID LH_D_METRIC D_METRIC_ID
D_METRIC_06_ID LH_D_METRIC D_METRIC_ID
D_METRIC_07_ID LH_D_METRIC D_METRIC_ID
D_METRIC_08_ID LH_D_METRIC D_METRIC_ID
D_METRIC_09_ID LH_D_METRIC D_METRIC_ID
D_METRIC_10_ID LH_D_METRIC D_METRIC_ID
D_METRIC_11_ID LH_D_METRIC D_METRIC_ID
D_METRIC_12_ID LH_D_METRIC D_METRIC_ID
D_METRIC_13_ID LH_D_METRIC D_METRIC_ID
D_METRIC_14_ID LH_D_METRIC D_METRIC_ID
D_METRIC_15_ID LH_D_METRIC D_METRIC_ID
D_METRIC_16_ID LH_D_METRIC D_METRIC_ID
D_METRIC_17_ID LH_D_METRIC D_METRIC_ID
D_METRIC_18_ID LH_D_METRIC D_METRIC_ID
D_METRIC_19_ID LH_D_METRIC D_METRIC_ID
D_METRIC_20_ID LH_D_METRIC D_METRIC_ID
D_METRIC_21_ID LH_D_METRIC D_METRIC_ID
D_METRIC_22_ID LH_D_METRIC D_METRIC_ID
D_METRIC_23_ID LH_D_METRIC D_METRIC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_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
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
D_VTE_ADV_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID


LH_LIGHTSON_METRICS



Column Section Top of Page


Table-level Detail

Description: LH_LIGHTSON_METRICS
Definition: This table is used to store Lighthouse metrics for LightsOn Aggregation. This table is aggregated to the nurse_unit per month per year and stores multiple Condition/Metrics.
Table Type: REFERENCE





Column Detail - LH_LIGHTSON_METRICS


Column Name Type Null? Definition
BUILDING VARCHAR(40) Y The building from which the patient was discharged.
CLIENT_TARGET DOUBLE Y Client target value for the metric.
CONDITION VARCHAR(50) Y Lighthouse Condition title.
CONDITION_MEANING VARCHAR(50) N Unique string for a Condition.
DENOMINATOR DOUBLE Y The denominator for the Metric. This will represent the records that qualify for the metric.
DISCHARGE_MONTH DOUBLE Y The Month the records were discharged.
DISCHARGE_YEAR DOUBLE Y The Year the records were discharged.
FACILITY VARCHAR(40) Y The facility from which the patient was discharged.
LH_LIGHTSON_AGGR_ID DOUBLE N Unique identifier for the Lighthouse Condition/Metric
LIGHTHOUSE_GOAL DOUBLE Y Lighthouse goal value for the metric.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for the logical domain. This identifier allows the data to be grouped by logical domain.
METRIC_NAME VARCHAR(100) Y A measurement within a Condition.
METRIC_NAME_MEANING VARCHAR(100) N Unique string for each Metric within a Condition.
NUMERATOR DOUBLE Y The numerator for the Metric. This will represent the records that meet the metric.
NURSE_UNIT VARCHAR(40) Y The nurse unit from which the patient was discharged.
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 VARCHAR(50) N The registered (assigned) task number for the process that inserted or updated the row.
VERSION DOUBLE Y The Version of the script loading this table.


LH_PROVIDER_TYPE



Column Section Top of Page


Table-level Detail

Description: Lighthouse Provider Type
Definition: Holds NPI (National Provider Identifier) and provider type data for 2017 EP filter project
Table Type: REFERENCE





Column Detail - LH_PROVIDER_TYPE


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.
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_PROVIDER_TYPE_ID DOUBLE N Unique generated number that identifies a single row on the LH_PROVIDER_TYPE table.
NPI VARCHAR(50) Y Identifies the national provider identification number for the doctor/provider.
PROVIDER_TYPE VARCHAR(100) Y Identifies the type of the provider.
TAXONOMY_CODE VARCHAR(50) Y Identifies the taxonomy code for the provider.
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_VIEWS



Column Section Top of Page


Table-level Detail

Description: LH VIEWS
Definition: This table is used to gather patient's view dates to be used for Meaningful Use Functional Reporting's VDT measure
Table Type: ACTIVITY





Column Detail - LH_VIEWS


Column Name Type Null? Definition
D_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the LH_D_PERSON table
EXTRACT_DT_TM DATETIME Y The date and time that the record was extracted from the source system
LH_VIEWS_ID DOUBLE N PRIMARY KEY
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.
PERSON_ID DOUBLE N Indicates the person_id of the patient with a view
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 that updated the row of data
VDT_VIEW_DT_TM DATETIME Y The date/time the patient viewed data
VDT_VIEW_LOC_DT_TM DATETIME Y The date/time the patient viewed data; Normalized to GMT
VDT_VIEW_TYPE VARCHAR(50) Y Indicates the type of view by the patient