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 |