Table Detail Report
LH_AMB_EVENT_DATA_2016
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_AMB_EVENT_DATA_2016 |
Definition: | Table containing event information for meaningful use NQF stage 2 2016 |
Table Type: | ACTIVITY |
Column Detail - LH_AMB_EVENT_DATA_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. |
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. |
EP_DT_TM | DATETIME | Y | Activity date/time of an event. |
EXTRACT_DT_TM | DATETIME | Y | The time in which the nqf load script that updated this record was run |
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_EVENT_DATA_2016_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_AMB_EVENT_DATA_2016 table. |
NEGATION_IND | DOUBLE | N | Indicates whether the given result code is a negation or not (QRDA) |
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 associated with the quality measure. |
POP_REG_DT_TM | DATETIME | Y | The date of the qualifying encounter that corresponds to this record. |
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. |
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_EVENT_DATA_2016
Child Column in LH_AMB_EVENT_DATA_2016(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_QUERY_ID | LH_D_QUERY | D_QUERY_ID |
LH_AMB_EVENT_DATA_2017
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_AMB_EVENT_DATA_2017 |
Definition: | Table containing event information for meaningful use NQF stage 2 2017 |
Table Type: | ACTIVITY |
Column Detail - LH_AMB_EVENT_DATA_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. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
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. |
CE_RESULT_UNIT | VARCHAR(50) | Y | This field is to specify the UAR_GET_CODE_DISPLAY of the unit code of the result value of the clinical event. It comes from the Millenium table CLINICAL_EVENT and attribute 'result_units_cd'. It stores the UAR_GET_CODE_DISPLAY(result_units_cd) of the value into the new attribute. |
CE_RESULT_VAL | VARCHAR(255) | Y | The value of the result |
DIAG_ACTIVE_IND | DOUBLE | Y | Table row is active or inactive |
DIAG_PRIORITY | DOUBLE | Y | Priority of diagnoses as determined by application |
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. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
EP_DT_TM | DATETIME | Y | Activity date/time of an event. |
EP_END_DT_TM | DATETIME | Y | This field is to specify the end date time of either Diagnosis or Problem |
EXTRACT_DT_TM | DATETIME | Y | The time in which the nqf load script that updated this record was run |
FAMILY_MBR_CODE | VARCHAR(255) | Y | Family member associated with the patient for family history diagnosis |
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_EVENT_DATA_2017_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_AMB_EVENT_DATA_2017 table. |
NEGATION_IND | DOUBLE | Y | Indicates whether the given result code is a negation or not (QRDA) |
ONSET_DT_TM | DATETIME | Y | The date and time the problem began |
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 associated with the quality measure. |
POP_REG_DT_TM | DATETIME | Y | The date of the qualifying encounter that corresponds to this record. |
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) |
PROB_LIFE_CYCLE_STATUS_CD | DOUBLE | N | The current status of the problem. (From Problem Table) |
QUAL_REG_DT_TM | DATETIME | Y | Indicates the date of a candidate for deletion. |
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_EVENT_DATA_2017
Child Column in LH_AMB_EVENT_DATA_2017(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_QUERY_ID | LH_D_QUERY | D_QUERY_ID |
LH_AMB_EVENT_DATA_2018
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_AMB_EVENT_DATA_2018 |
Definition: | Table containing event information for meaningful use NQF stage 2 2018 |
Table Type: | ACTIVITY |
Column Detail - LH_AMB_EVENT_DATA_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. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
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. |
CE_RESULT_UNIT | VARCHAR(50) | Y | The unit of the result value. |
CE_RESULT_VAL | VARCHAR(255) | Y | The value of the result |
DIAG_ACTIVE_IND | DOUBLE | Y | Table row is active or inactive |
DIAG_PRIORITY | DOUBLE | Y | Priority of diagnoses as determined by application |
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. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
EP_DT_TM | DATETIME | Y | Activity date/time of an event. |
EP_END_DT_TM | DATETIME | Y | The date and time the Diagnosis/Problem/Prcedure/order end. |
EXTRACT_DT_TM | DATETIME | Y | The time in which the nqf load script that updated this record was run |
FAMILY_MBR_CODE | VARCHAR(255) | Y | Family member associated with the patient for family history diagnosis |
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. |
LAST_UPDATED_PROVIDER_ID | DOUBLE | N | The id representing the provider on the last action of the order where it was present. |
LH_AMB_EVENT_DATA_2018_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_AMB_EVENT_DATA_2018 table. |
NEGATION_IND | DOUBLE | Y | Indicates whether the given result code is a negation or not (QRDA) |
ONSET_DT_TM | DATETIME | Y | The date and time the problem began |
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 associated with the quality measure. |
POP_REG_DT_TM | DATETIME | Y | The date of the qualifying encounter that corresponds to this record. |
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) |
PROB_LIFE_CYCLE_STATUS_CD | DOUBLE | N | The current status of the problem. (From Problem Table) |
QUAL_REG_DT_TM | DATETIME | Y | Indicates the date of a candidate for deletion. |
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_EVENT_DATA_2018
Child Column in LH_AMB_EVENT_DATA_2018(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_QUERY_ID | LH_D_QUERY | D_QUERY_ID |
LH_AMB_EVENT_DATA_2019
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_AMB_EVENT_DATA_2019 |
Definition: | Table containing event information for meaningful use NQF stage 2 2019 |
Table Type: | ACTIVITY |
Column Detail - LH_AMB_EVENT_DATA_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. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
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. |
CE_RESULT_UNIT | VARCHAR(50) | Y | The unit of the result value. |
CE_RESULT_VAL | VARCHAR(255) | Y | The value of the result |
DIAG_ACTIVE_IND | DOUBLE | Y | Table row is active or inactive |
DIAG_PRIORITY | DOUBLE | Y | Priority of diagnoses as determined by application |
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. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
EP_DT_TM | DATETIME | Y | Activity date/time of an event. |
EP_END_DT_TM | DATETIME | Y | The date and time the Diagnosis/Problem/Prcedure/order end. |
EXTRACT_DT_TM | DATETIME | Y | The time in which the nqf load script that updated this record was run |
FAMILY_MBR_CODE | VARCHAR(255) | Y | Family member associated with the patient for family history diagnosis |
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. |
LAST_UPDATED_PROVIDER_ID | DOUBLE | N | This gives the ID of the provider whoever has updated the row last |
LH_AMB_EVENT_DATA_2019_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_AMB_EVENT_DATA_2019 table. |
NEGATION_IND | DOUBLE | Y | Indicates whether the given result code is a negation or not (QRDA) |
ONSET_DT_TM | DATETIME | Y | The date and time the problem began |
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 associated with the quality measure. |
POP_REG_DT_TM | DATETIME | Y | The date of the qualifying encounter that corresponds to this record. |
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) |
PROB_LIFE_CYCLE_STATUS_CD | DOUBLE | N | The current status of the problem. (From Problem Table) |
QUAL_REG_DT_TM | DATETIME | Y | Indicates the date of a candidate for deletion. |
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_EVENT_DATA_2019
Child Column in LH_AMB_EVENT_DATA_2019(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_QUERY_ID | LH_D_QUERY | D_QUERY_ID |
LH_AMB_EVENT_DATA_2020
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_AMB_EVENT_DATA_2020 |
Definition: | Table containing event information for meaningful use NQF stage 2 2020 |
Table Type: | ACTIVITY |
Column Detail - LH_AMB_EVENT_DATA_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. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
BR_DATAM_VSET_ITEM_ID | DOUBLE | N | References the id in BR_DATAM_VAL_SET_ITEM. |
BR_DATAM_VSET_ITEM_NEG_ID | DOUBLE | N | References the negation in BR_DATAM_VAL_SET_ITEM. |
CE_RESULT_UNIT | VARCHAR(50) | Y | The unit of the result value. |
CE_RESULT_VAL | VARCHAR(255) | Y | The value of the result |
DIAG_ACTIVE_IND | DOUBLE | Y | Table row is active or inactive |
DIAG_PRIORITY | DOUBLE | Y | Priority of diagnoses as determined by application |
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. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
EP_DT_TM | DATETIME | Y | Activity date/time of an event. |
EP_END_DT_TM | DATETIME | Y | The date and time the Diagnosis/Problem/Prcedure/order end. |
EXTRACT_DT_TM | DATETIME | Y | The time in which the nqf load script that updated this record was run |
FAMILY_MBR_CODE | VARCHAR(255) | Y | Family member associated with the patient for family history diagnosis |
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. |
LAST_UPDATED_PROVIDER_ID | DOUBLE | N | This gives the ID of the provider whoever has updated the row last |
LH_AMB_EVENT_DATA_2020_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_AMB_EVENT_DATA_2020 table. |
NEGATION_IND | DOUBLE | Y | Indicates whether the given result code is a negation or not (QRDA) |
ONSET_DT_TM | DATETIME | Y | The date and time the problem began |
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 associated with the quality measure. |
POP_REG_DT_TM | DATETIME | Y | The date of the qualifying encounter that corresponds to this record. |
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) |
PROB_LIFE_CYCLE_STATUS_CD | DOUBLE | N | The current status of the problem. (From Problem Table) |
QUAL_REG_DT_TM | DATETIME | Y | Indicates the date of a candidate for deletion. |
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_EVENT_DATA_2020
Child Column in LH_AMB_EVENT_DATA_2020(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_QUERY_ID | LH_D_QUERY | D_QUERY_ID |