Table Detail Report

LH_AMB_QUAL_ENCNTR_2020



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - LH_AMB_QUAL_ENCNTR_2020


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_VAL_SET_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_2020_ID DOUBLE N Unique generated number that identifies a single row on the LH_AMB_QUAL_ENCNTR_2020 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_2020


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




Parent Column in LH_AMB_QUAL_ENCNTR_2020 (PK) Child Table Name Child Column Name
Children: HEALTH_SYSTEM_SOURCE_ID LH_AMB_EP_RELTN_2020 HEALTH_SYSTEM_SOURCE_ID
LH_AMB_QUAL_ENCNTR_2020_ID LH_AMB_EP_RELTN_2020 LH_AMB_QUAL_ENCNTR_2020_ID


LH_AMB_QUAL_ENCNTR_2021



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - LH_AMB_QUAL_ENCNTR_2021


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_2021_ID DOUBLE N Unique generated number that identifies a single row on the LH_AMB_QUAL_ENCNTR_2021 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_2021


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




Parent Column in LH_AMB_QUAL_ENCNTR_2021 (PK) Child Table Name Child Column Name
Children: HEALTH_SYSTEM_SOURCE_ID LH_AMB_EP_RELTN_2021 HEALTH_SYSTEM_SOURCE_ID
LH_AMB_QUAL_ENCNTR_2021_ID LH_AMB_EP_RELTN_2021 LH_AMB_QUAL_ENCNTR_2021_ID


LH_AMB_QUAL_ENCNTR_2022



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_AMB_QUAL_ENCNTR_2022
Definition: Table containing the qualifying encounters for Meaningful Use NQF Stage 2 2022.
Table Type: ACTIVITY





Column Detail - LH_AMB_QUAL_ENCNTR_2022


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 Y References the id in BR_DATAM_VSET_ITEM.
BR_DATAM_VSET_ITEM_NEG_ID DOUBLE Y 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 Y Identifies the person associated with the quality measure. Foreign key to the LH_D_PERSON table.
D_QUERY_ID DOUBLE Y Identifies the query associated with the quality measure. Foreign key to the LH_D_QUERY table.
ENCNTR_ID DOUBLE Y 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 Y The identifier for the patient¿s health plan
HEALTH_SYSTEM_ID DOUBLE Y 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_2022_ID DOUBLE N Unique generated number that identifies a single row on the LH_AMB_QUAL_ENCNTR_2022 table.
LOC_NURSE_UNIT_CD DOUBLE Y The code value corresponding to the nursing unit of the encounter.
LOGICAL_DOMAIN_ID DOUBLE Y 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 Y References the id in ORGANIZATION.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PARENT_ENTITY_ID DOUBLE Y 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 Y 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(500) 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_2022


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




Parent Column in LH_AMB_QUAL_ENCNTR_2022 (PK) Child Table Name Child Column Name
Children: HEALTH_SYSTEM_SOURCE_ID LH_AMB_EP_RELTN_2022 HEALTH_SYSTEM_SOURCE_ID
LH_AMB_QUAL_ENCNTR_2022_ID LH_AMB_EP_RELTN_2022 LH_AMB_QUAL_ENCNTR_2022_ID


LH_AMB_QUAL_ENCNTR_2023



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - LH_AMB_QUAL_ENCNTR_2023


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.
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 Y 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_2023_ID DOUBLE N Unique generated number that identifies a single row on the LH_AMB_QUAL_ENCNTR_2023 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 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_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(500) 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 N 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. 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_2023


Child Column in LH_AMB_QUAL_ENCNTR_2023(FK) Parent Table Name Parent Column Name
Parents: D_QUERY_ID LH_D_QUERY D_QUERY_ID




Parent Column in LH_AMB_QUAL_ENCNTR_2023 (PK) Child Table Name Child Column Name
Children: HEALTH_SYSTEM_SOURCE_ID LH_AMB_EP_RELTN_2023 HEALTH_SYSTEM_SOURCE_ID
LH_AMB_QUAL_ENCNTR_2023_ID LH_AMB_EP_RELTN_2023 LH_AMB_QUAL_ENCNTR_2023_ID


LH_AMB_QUAL_ENCNTR_2024



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_AMB_QUAL_ENCNTR_2024
Definition: Table containing the qualifying encounters for Meaningful Use NQF Stage 2 2024.
Table Type: ACTIVITY





Column Detail - LH_AMB_QUAL_ENCNTR_2024


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.
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 Y 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_2024_ID DOUBLE N Unique generated number that identifies a single row on the LH_AMB_QUAL_ENCNTR_2024 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 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_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(500) 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 N 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. 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_2024


Child Column in LH_AMB_QUAL_ENCNTR_2024(FK) Parent Table Name Parent Column Name
Parents: D_QUERY_ID LH_D_QUERY D_QUERY_ID




Parent Column in LH_AMB_QUAL_ENCNTR_2024 (PK) Child Table Name Child Column Name
Children: HEALTH_SYSTEM_SOURCE_ID LH_AMB_EP_RELTN_2024 HEALTH_SYSTEM_SOURCE_ID
LH_AMB_QUAL_ENCNTR_2024_ID LH_AMB_EP_RELTN_2024 LH_AMB_QUAL_ENCNTR_2024_ID