Table Detail Report

LH_AMB_QUAL_ENCNTR



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_AMB_QUAL_ENCNTR
Definition: Table contains the qualifying encounters for Meaningful Use QM and PQRI solutions.
Table Type: ACTIVITY





Column Detail - LH_AMB_QUAL_ENCNTR


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.
BR_DATAM_VSET_ITEM_ID DOUBLE N This column will have br_datam_vset_item_id of an observation code, which will be used for QRDA XML files.
BR_DATAM_VSET_ITEM_NEG_ID DOUBLE N This column will have br_datam_vset_item_id of a Negation code, which will be used for QRDA XML files.
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
D_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the LH_D_PERSON table.
D_QUERY_ID DOUBLE N Identifies the query associated with the quality measure. Foreign key to the LH_D_QUERY table.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated.
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 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_AMB_QUAL_ENCNTR_ID DOUBLE N Unique generated number that identifies a single row on the LH_AMB_QUAL_ENCNTR 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.
NEGATION_IND DOUBLE N Indicates whether the given result code is a negation or not (QRDA)
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PARENT_ENTITY_ID DOUBLE N The ID of the event type from parent_entity_name.
PARENT_ENTITY_NAME VARCHAR(50) Y The table name of the parent_entity_id source.
PERSON_ID DOUBLE N Identifies the person against which the qualify measure is associated.
POP_EP_DT_TM DATETIME Y Activity date/time of an event qualifying in population.
PRIMARY_VSET_CD VARCHAR(100) Y Code corresponding to the encounter type (QRDA)
PRIMARY_VSET_CD_DISPLAY VARCHAR(500) Y Detailed information on the encounter type (QRDA)
PRIMARY_VSET_CD_SYS_NAME VARCHAR(100) Y Coding system name for the encounter type (QRDA)
PRIMARY_VSET_CD_SYS_OID VARCHAR(100) Y Coding system of the encounter type (QRDA)
PRIMARY_VSET_CD_SYS_SDTC VARCHAR(100) Y The OID of the encounter code system's value set (QRDA)
QUAL_REG_DT_TM DATETIME Y Stores the registration date time of the encounter that qualified this row.
REG_DT_TM DATETIME Y Registration date/time of encounter.
SECONDARY_VSET_CD VARCHAR(100) Y Code corresponding to the result type (QRDA)
SECONDARY_VSET_CD_DISPLAY VARCHAR(500) Y Detailed information on the result type (QRDA)
SECONDARY_VSET_CD_SYS_NAME VARCHAR(100) Y Coding system name for the result type (QRDA)
SECONDARY_VSET_CD_SYS_OID VARCHAR(100) Y Coding system of the result type (QRDA)
SECONDARY_VSET_CD_SYS_SDTC VARCHAR(100) Y The OID of the result code system's value set (QRDA)
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 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) 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. 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_AMB_QUAL_ENCNTR


Child Column in LH_AMB_QUAL_ENCNTR(FK) Parent Table Name Parent Column Name
Parents: D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID
D_QUERY_ID LH_D_QUERY D_QUERY_ID


LH_AMB_QUAL_ENCNTR_2016



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_AMB_QUAL_ENCNTR_2016
Definition: Table containing the qualifying encounters for Meaningful Use NQF Stage 2 2016
Table Type: ACTIVITY





Column Detail - LH_AMB_QUAL_ENCNTR_2016


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.
BR_DATAM_VSET_ITEM_ID DOUBLE N References the id in BR_DATAM_VSET_ITEM.
BR_DATAM_VSET_ITEM_NEG_ID DOUBLE N References the negation in BR_DATAM_VSET_ITEM.
CMS_PAYER_GROUP VARCHAR(100) Y The CMS payer grouping of the patient's payer.
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
D_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the LH_D_PERSON table.
D_QUERY_ID DOUBLE N Identifies the query associated with the quality measure. Foreign key to the LH_D_QUERY table.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated.
ETHNICITY_VSET_CD VARCHAR(100) Y The code value corresponding to the patient's ethnicity.
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 first date/time the row was updated by the NQF load script.
GENDER_VSET_CD VARCHAR(100) Y The code value corresponding to the patient's gender.
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.
HIC_NBR VARCHAR(50) Y The patient's HIC number.
LAST_PROCESS_DT_TM DATETIME Y The last date/time the row was updated by the NQF load script.
LH_AMB_QUAL_ENCNTR_2016_ID DOUBLE N Unique generated number that identifies a single row on the LH_AMB_QUAL_ENCNTR_2016 table.
LOC_NURSE_UNIT_CD DOUBLE Y The code value corresponding to the nursing unit of the encounter.
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.
NEGATION_IND DOUBLE N Indicates whether the given result code is a negation or not (QRDA)
ORGANIZATION_ID DOUBLE N References the id in ORGANIZATION.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PARENT_ENTITY_ID DOUBLE N The ID of the event type from parent_entity_name.
PARENT_ENTITY_NAME VARCHAR(50) Y The table name of the parent_entity_id source.
PAYER_VSET_CD VARCHAR(100) Y The code value corresponding to the patient's payer.
PERSON_ID DOUBLE N Identifies the person against which the qualify measure is associated.
POP_EP_DT_TM DATETIME Y Activity date/time of an event qualifying in population.
PQRS_IND DOUBLE Y Indicates whether the patient qualifies for PQRS.
PRIMARY_VSET_CD VARCHAR(100) Y Code corresponding to the encounter type (QRDA)
PRIMARY_VSET_CD_DISPLAY VARCHAR(500) Y Detailed information on the encounter type (QRDA)
PRIMARY_VSET_CD_SYS_NAME VARCHAR(100) Y Coding system name for the encounter type (QRDA)
PRIMARY_VSET_CD_SYS_OID VARCHAR(100) Y Coding system of the encounter type (QRDA)
PRIMARY_VSET_CD_SYS_SDTC VARCHAR(100) Y The OID of the encounter code system's value set (QRDA)
QUAL_REG_DT_TM DATETIME Y Indicates the date of a candidate for deletion.
RACE_VSET_CD VARCHAR(100) Y The code value corresponding to the patient's race.
REG_DT_TM DATETIME Y Registration date/time of encounter.
SECONDARY_VSET_CD VARCHAR(100) Y Code corresponding to the result type (QRDA)
SECONDARY_VSET_CD_DISPLAY VARCHAR(500) Y Detailed information on the result type (QRDA)
SECONDARY_VSET_CD_SYS_NAME VARCHAR(100) Y Coding system name for the result type (QRDA)
SECONDARY_VSET_CD_SYS_OID VARCHAR(100) Y Coding system of the result type (QRDA)
SECONDARY_VSET_CD_SYS_SDTC VARCHAR(100) Y The OID of the result code system's value set (QRDA)
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 Y 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.



Relationship Detail - LH_AMB_QUAL_ENCNTR_2016


Child Column in LH_AMB_QUAL_ENCNTR_2016(FK) Parent Table Name Parent Column Name
Parents: D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID
D_QUERY_ID LH_D_QUERY D_QUERY_ID


LH_AMB_QUAL_ENCNTR_2017



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_AMB_QUAL_ENCNTR_2017
Definition: Table containing the qualifying encounters for Meaningful Use NQF Stage 2 2017
Table Type: ACTIVITY





Column Detail - LH_AMB_QUAL_ENCNTR_2017


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.
BR_DATAM_VSET_ITEM_ID DOUBLE N References the id in BR_DATAM_VSET_ITEM.
BR_DATAM_VSET_ITEM_NEG_ID DOUBLE N References the negation in BR_DATAM_VSET_ITEM.
CMS_PAYER_GROUP VARCHAR(100) Y The CMS payer grouping of the patient's payer.
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
DISCH_DT_TM DATETIME Y The date/time of patient discharge
D_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the LH_D_PERSON table.
D_QUERY_ID DOUBLE N Identifies the query associated with the quality measure. Foreign key to the LH_D_QUERY table.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated.
ETHNICITY_VSET_CD VARCHAR(100) Y The code value corresponding to the patient's ethnicity.
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 that the first ETL process started that created this record.
GENDER_VSET_CD VARCHAR(100) Y The code value corresponding to the patient's gender.
HEALTH_PLAN_ID DOUBLE N The identifier for the patient¿s health plan
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.
HIC_NBR VARCHAR(50) Y The patient's HIC number.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_AMB_QUAL_ENCNTR_2017_ID DOUBLE N Unique generated number that identifies a single row on the LH_AMB_QUAL_ENCNTR_2017 table.
LOC_NURSE_UNIT_CD DOUBLE N The code value corresponding to the nursing unit of the encounter.
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.
NEGATION_IND DOUBLE Y Indicates whether the given result code is a negation or not (QRDA)
ORGANIZATION_ID DOUBLE N References the id in ORGANIZATION.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PARENT_ENTITY_ID DOUBLE N The ID of the event type from parent_entity_name.
PARENT_ENTITY_NAME VARCHAR(50) Y The table name of the parent_entity_id source.
PAYER_VSET_CD VARCHAR(100) Y The code value corresponding to the patient's payer.
PERSON_ETHNIC_CODE_DISPLAY VARCHAR(100) Y The textual representation of the patient's ethnicity
PERSON_ETHNIC_CODE_SYSTEM VARCHAR(100) Y The code system of the patient's ethnicity
PERSON_ETHNIC_CODE_SYSTEM_NAME VARCHAR(100) Y The name of the patient's ethnicity code system
PERSON_GENDER_CODE_DISPLAY VARCHAR(100) Y The textual representation of the patient's gender
PERSON_GENDER_CODE_SYSTEM VARCHAR(100) Y The code system of the patient's gender
PERSON_GENDER_CODE_SYSTEM_NAME VARCHAR(100) Y The name of the patient's gender code system
PERSON_ID DOUBLE N Identifies the person against which the qualify measure is associated.
PERSON_PAYER_CODE_DISPLAY VARCHAR(100) Y Text description of the policy type
PERSON_PAYER_CODE_SYSTEM VARCHAR(100) Y String representation of the code system that policy was derived from
PERSON_PAYER_CODE_SYSTEM_NAME VARCHAR(100) Y The name of the policy code system.
PERSON_RACE_CODE_DISPLAY VARCHAR(100) Y The textual representation of the patient's race
PERSON_RACE_CODE_SYSTEM VARCHAR(100) Y The code system of the patient's race
PERSON_RACE_CODE_SYSTEM_NAME VARCHAR(100) Y The name of the patient's race code system
POLICY_TYPE_DISPLAY VARCHAR(100) Y Text description of the policy type
POLICY_TYPE_SYSTEM_SDTC VARCHAR(100) Y OID of codeSystem string.
POP_EP_DT_TM DATETIME Y Activity date/time of an event qualifying in population.
PQRS_IND DOUBLE Y Indicates whether the patient qualifies for PQRS.
PRIMARY_VSET_CD VARCHAR(100) Y Code corresponding to the encounter type (QRDA)
PRIMARY_VSET_CD_DISPLAY VARCHAR(500) Y Detailed information on the encounter type (QRDA)
PRIMARY_VSET_CD_SYS_NAME VARCHAR(100) Y Coding system name for the encounter type (QRDA)
PRIMARY_VSET_CD_SYS_OID VARCHAR(100) Y Coding system of the encounter type (QRDA)
PRIMARY_VSET_CD_SYS_SDTC VARCHAR(100) Y The OID of the encounter code system's value set (QRDA)
QUAL_REG_DT_TM DATETIME Y Indicates the date of a candidate for deletion.
RACE_VSET_CD VARCHAR(100) Y The code value corresponding to the patient's race.
REG_DT_TM DATETIME Y Registration date/time of encounter.
SECONDARY_VSET_CD VARCHAR(100) Y Code corresponding to the result type (QRDA)
SECONDARY_VSET_CD_DISPLAY VARCHAR(500) Y Detailed information on the result type (QRDA)
SECONDARY_VSET_CD_SYS_NAME VARCHAR(100) Y Coding system name for the result type (QRDA)
SECONDARY_VSET_CD_SYS_OID VARCHAR(100) Y Coding system of the result type (QRDA)
SECONDARY_VSET_CD_SYS_SDTC VARCHAR(100) Y The OID of the result code system's value set (QRDA)
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.



Relationship Detail - LH_AMB_QUAL_ENCNTR_2017


Child Column in LH_AMB_QUAL_ENCNTR_2017(FK) Parent Table Name Parent Column Name
Parents: D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID
D_QUERY_ID LH_D_QUERY D_QUERY_ID


LH_AMB_QUAL_ENCNTR_2018



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_AMB_QUAL_ENCNTR_2018
Definition: Table containing the qualifying encounters for Meaningful Use NQF Stage 2 2018
Table Type: ACTIVITY





Column Detail - LH_AMB_QUAL_ENCNTR_2018


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.
BR_DATAM_VSET_ITEM_ID DOUBLE N References the id in BR_DATAM_VSET_ITEM.
BR_DATAM_VSET_ITEM_NEG_ID DOUBLE N References the negation in BR_DATAM_VSET_ITEM.
CMS_PAYER_GROUP VARCHAR(100) Y The CMS payer grouping of the patient's payer.
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
DISCH_DT_TM DATETIME Y The date/time of patient discharge
D_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the LH_D_PERSON table.
D_QUERY_ID DOUBLE N Identifies the query associated with the quality measure. Foreign key to the LH_D_QUERY table.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated.
ETHNICITY_VSET_CD VARCHAR(100) Y The code value corresponding to the patient's ethnicity.
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 that the first ETL process started that created this record.
GENDER_VSET_CD VARCHAR(100) Y The code value corresponding to the patient's gender.
HEALTH_PLAN_ID DOUBLE N The identifier for the patient¿s health plan
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.
HIC_NBR VARCHAR(50) Y The patient's HIC number.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_AMB_QUAL_ENCNTR_2018_ID DOUBLE N Unique generated number that identifies a single row on the LH_AMB_QUAL_ENCNTR_2018 table.
LOC_NURSE_UNIT_CD DOUBLE N The code value corresponding to the nursing unit of the encounter.
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.
NEGATION_IND DOUBLE Y Indicates whether the given result code is a negation or not (QRDA)
ORGANIZATION_ID DOUBLE N References the id in ORGANIZATION.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PARENT_ENTITY_ID DOUBLE N The ID of the event type from parent_entity_name.
PARENT_ENTITY_NAME VARCHAR(50) Y The table name of the parent_entity_id source.
PAYER_VSET_CD VARCHAR(100) Y The code value corresponding to the patient's payer.
PERSON_ETHNIC_CODE_DISPLAY VARCHAR(100) Y The textual representation of the patient's ethnicity
PERSON_ETHNIC_CODE_SYSTEM VARCHAR(100) Y The code system of the patient's ethnicity
PERSON_ETHNIC_CODE_SYSTEM_NAME VARCHAR(100) Y The name of the patient's ethnicity code system
PERSON_GENDER_CODE_DISPLAY VARCHAR(100) Y The textual representation of the patient's gender
PERSON_GENDER_CODE_SYSTEM VARCHAR(100) Y The code system of the patient's gender
PERSON_GENDER_CODE_SYSTEM_NAME VARCHAR(100) Y The name of the patient's gender code system
PERSON_ID DOUBLE N Identifies the person against which the qualify measure is associated.
PERSON_PAYER_CODE_DISPLAY VARCHAR(100) Y Text description of the policy type
PERSON_PAYER_CODE_SYSTEM VARCHAR(100) Y String representation of the code system that policy was derived from
PERSON_PAYER_CODE_SYSTEM_NAME VARCHAR(100) Y The name of the policy code system.
PERSON_RACE_CODE_DISPLAY VARCHAR(100) Y The textual representation of the patient's race
PERSON_RACE_CODE_SYSTEM VARCHAR(100) Y The code system of the patient's race
PERSON_RACE_CODE_SYSTEM_NAME VARCHAR(100) Y The name of the patient's race code system
POLICY_TYPE_DISPLAY VARCHAR(100) Y Text description of the policy type
POLICY_TYPE_SYSTEM_SDTC VARCHAR(100) Y OID of codeSystem string.
POP_EP_DT_TM DATETIME Y Activity date/time of an event qualifying in population.
PQRS_IND DOUBLE Y Indicates whether the patient qualifies for PQRS.
PRIMARY_VSET_CD VARCHAR(100) Y Code corresponding to the encounter type (QRDA)
PRIMARY_VSET_CD_DISPLAY VARCHAR(500) Y Detailed information on the encounter type (QRDA)
PRIMARY_VSET_CD_SYS_NAME VARCHAR(100) Y Coding system name for the encounter type (QRDA).
PRIMARY_VSET_CD_SYS_OID VARCHAR(100) Y Coding system of the encounter type (QRDA)
PRIMARY_VSET_CD_SYS_SDTC VARCHAR(100) Y The OID of the encounter code system's value set (QRDA)
QUAL_REG_DT_TM DATETIME Y Indicates the date of a candidate for deletion.
RACE_VSET_CD VARCHAR(100) Y The code value corresponding to the patient's race.
REG_DT_TM DATETIME Y Registration date/time of encounter.
SECONDARY_VSET_CD VARCHAR(100) Y Code corresponding to the result type (QRDA)
SECONDARY_VSET_CD_DISPLAY VARCHAR(500) Y Detailed information on the result type (QRDA)
SECONDARY_VSET_CD_SYS_NAME VARCHAR(100) Y Coding system name for the result type (QRDA)
SECONDARY_VSET_CD_SYS_OID VARCHAR(100) Y Coding system of the result type (QRDA)
SECONDARY_VSET_CD_SYS_SDTC VARCHAR(100) Y The OID of the result code system's value set (QRDA)
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.



Relationship Detail - LH_AMB_QUAL_ENCNTR_2018


Child Column in LH_AMB_QUAL_ENCNTR_2018(FK) Parent Table Name Parent Column Name
Parents: D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID
D_QUERY_ID LH_D_QUERY D_QUERY_ID


LH_AMB_QUAL_ENCNTR_2019



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_AMB_QUAL_ENCNTR_2019
Definition: Table containing the qualifying encounters for Meaningful Use NQF Stage 2 2019
Table Type: ACTIVITY





Column Detail - LH_AMB_QUAL_ENCNTR_2019


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.
BR_DATAM_VSET_ITEM_ID DOUBLE N References the id in BR_DATAM_VSET_ITEM.
BR_DATAM_VSET_ITEM_NEG_ID DOUBLE N References the negation in BR_DATAM_VSET_ITEM.
CMS_PAYER_GROUP VARCHAR(100) Y The CMS payer grouping of the patient's payer.
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
DISCH_DT_TM DATETIME Y The date/time of patient discharge
D_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the LH_D_PERSON table.
D_QUERY_ID DOUBLE N Identifies the query associated with the quality measure. Foreign key to the LH_D_QUERY table.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated.
ETHNICITY_VSET_CD VARCHAR(100) Y The code value corresponding to the patient's ethnicity.
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 that the first ETL process started that created this record.
GENDER_VSET_CD VARCHAR(100) Y The code value corresponding to the patient's gender.
HEALTH_PLAN_ID DOUBLE N The identifier for the patient¿s health plan
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.
HIC_NBR VARCHAR(50) Y The patient's HIC number.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_AMB_QUAL_ENCNTR_2019_ID DOUBLE N Unique generated number that identifies a single row on the LH_AMB_QUAL_ENCNTR_2019 table.
LOC_NURSE_UNIT_CD DOUBLE N The code value corresponding to the nursing unit of the encounter.
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.
NEGATION_IND DOUBLE Y Indicates whether the given result code is a negation or not (QRDA)
ORGANIZATION_ID DOUBLE N References the id in ORGANIZATION.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PARENT_ENTITY_ID DOUBLE N The ID of the event type from parent_entity_name.
PARENT_ENTITY_NAME VARCHAR(50) Y The table name of the parent_entity_id source.
PAYER_VSET_CD VARCHAR(100) Y The code value corresponding to the patient's payer.
PERSON_ETHNIC_CODE_DISPLAY VARCHAR(100) Y The textual representation of the patient's ethnicity
PERSON_ETHNIC_CODE_SYSTEM VARCHAR(100) Y The code system of the patient's ethnicity
PERSON_ETHNIC_CODE_SYSTEM_NAME VARCHAR(100) Y The name of the patient's ethnicity code system
PERSON_GENDER_CODE_DISPLAY VARCHAR(100) Y The textual representation of the patient's gender
PERSON_GENDER_CODE_SYSTEM VARCHAR(100) Y The code system of the patient's gender
PERSON_GENDER_CODE_SYSTEM_NAME VARCHAR(100) Y The name of the patient's gender code system
PERSON_ID DOUBLE N Identifies the person against which the qualify measure is associated.
PERSON_PAYER_CODE_DISPLAY VARCHAR(100) Y Text description of the policy type
PERSON_PAYER_CODE_SYSTEM VARCHAR(100) Y String representation of the code system that policy was derived from
PERSON_PAYER_CODE_SYSTEM_NAME VARCHAR(100) Y The name of the policy code system.
PERSON_RACE_CODE_DISPLAY VARCHAR(100) Y The textual representation of the patient's race
PERSON_RACE_CODE_SYSTEM VARCHAR(100) Y The code system of the patient's race
PERSON_RACE_CODE_SYSTEM_NAME VARCHAR(100) Y The name of the patient's race code system
POLICY_TYPE_DISPLAY VARCHAR(100) Y Text description of the policy type
POLICY_TYPE_SYSTEM_SDTC VARCHAR(100) Y OID of codeSystem string.
POP_EP_DT_TM DATETIME Y Activity date/time of an event qualifying in population.
PQRS_IND DOUBLE Y Indicates whether the patient qualifies for PQRS.
PRIMARY_VSET_CD VARCHAR(100) Y Code corresponding to the encounter type (QRDA)
PRIMARY_VSET_CD_DISPLAY VARCHAR(500) Y Detailed information on the encounter type (QRDA)
PRIMARY_VSET_CD_SYS_NAME VARCHAR(100) Y Coding system name for the encounter type (QRDA)
PRIMARY_VSET_CD_SYS_OID VARCHAR(100) Y Coding system of the encounter type (QRDA)
PRIMARY_VSET_CD_SYS_SDTC VARCHAR(100) Y The OID of the encounter code system's value set (QRDA)
QUAL_REG_DT_TM DATETIME Y Indicates the date of a candidate for deletion.
RACE_VSET_CD VARCHAR(100) Y The code value corresponding to the patient's race.
REG_DT_TM DATETIME Y Registration date/time of encounter.
SECONDARY_VSET_CD VARCHAR(100) Y Code corresponding to the result type (QRDA)
SECONDARY_VSET_CD_DISPLAY VARCHAR(500) Y Detailed information on the result type (QRDA)
SECONDARY_VSET_CD_SYS_NAME VARCHAR(100) Y Coding system name for the result type (QRDA)
SECONDARY_VSET_CD_SYS_OID VARCHAR(100) Y Coding system of the result type (QRDA)
SECONDARY_VSET_CD_SYS_SDTC VARCHAR(100) Y The OID of the result code system's value set (QRDA)
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.



Relationship Detail - LH_AMB_QUAL_ENCNTR_2019


Child Column in LH_AMB_QUAL_ENCNTR_2019(FK) Parent Table Name Parent Column Name
Parents: D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID
D_QUERY_ID LH_D_QUERY D_QUERY_ID