Table Detail Report

LH_AMB_EVENT_DATA_2021



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_AMB_EVENT_DATA_2021
Definition: Table containing event information for meaningful use NQF stage 2 2021
Table Type: ACTIVITY





Column Detail - LH_AMB_EVENT_DATA_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.
ASSOCIATED_ENTITY_ID DOUBLE N The ID of the associated event from the table listed in associated_entity_name.
ASSOCIATED_ENTITY_NAME VARCHAR(30) Y The name of the table the associated event in the associated_entity_id column is coming from.
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_2021_ID DOUBLE N Unique generated number that identifies a single row on the LH_AMB_EVENT_DATA_2021 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_2021


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


LH_AMB_EVENT_DATA_2022



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_AMB_EVENT_DATA_2022
Definition: Table containing event information for meaningful use NQF stage 2 2022.
Table Type: ACTIVITY





Column Detail - LH_AMB_EVENT_DATA_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.
ASSOCIATED_ENTITY_ID DOUBLE Y The ID of the associated event from the table listed in associated_entity_name.
ASSOCIATED_ENTITY_NAME VARCHAR(30) Y The name of the table the associated event in the associated_entity_id column is coming from.
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 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.
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 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.
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 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.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LAST_UPDATED_PROVIDER_ID DOUBLE Y This gives the ID of the provider whoever has updated the row last
LH_AMB_EVENT_DATA_2022_ID DOUBLE N Unique generated number that identifies a single row on the LH_AMB_EVENT_DATA_2022 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 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.
PERSON_ID DOUBLE Y 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 Y 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_2022


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


LH_AMB_EVENT_DATA_2023



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_AMB_EVENT_DATA_2023
Definition: Table containing event information for meaningful use NQF stage 2 2023
Table Type: ACTIVITY





Column Detail - LH_AMB_EVENT_DATA_2023


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.
ASSOCIATED_ENTITY_ID DOUBLE Y The ID of the associated event from the table listed in associated_entity_name.
ASSOCIATED_ENTITY_NAME VARCHAR(30) Y The name of the table the associated event in the associated_entity_id column is coming from.
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 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.
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 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.
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 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.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LAST_UPDATED_PROVIDER_ID DOUBLE Y This gives the ID of the provider whoever has updated the row last
LH_AMB_EVENT_DATA_2023_ID DOUBLE N Unique generated number that identifies a single row on the LH_AMB_EVENT_DATA_2023 table.
MEDS_DISPENSE_QTY DOUBLE Y This field contains the dispense quantity of the medication.
MEDS_DISPENSE_QTY_UNIT VARCHAR(100) Y This field contains the unit of the dispense quantity of medication.
MEDS_DURATION DOUBLE Y This field contains the duration for medication.
MEDS_DURATION_UNIT VARCHAR(100) Y This field contains the unit for duration of the medication.
MEDS_FREQUENCY DOUBLE Y This field contains the frequency of the medication.
MEDS_REFILL_CNT DOUBLE Y This field contains the refill count of the medication.
MEDS_STRENGTH_DOSE DOUBLE Y This field contains medication dose's strength.
MEDS_STRENGTH_DOSE_UNIT VARCHAR(100) Y This field contains the unit of the medication dose's strength.
MEDS_VOLUME_DOSE DOUBLE Y This field contains medication dose's volume.
MEDS_VOLUME_DOSE_UNIT VARCHAR(100) Y This field contains the unit of the medication dose's volume.
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 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.
PERSON_ID DOUBLE Y 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 Y 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.
VACCINE_DOSE_FLAG DOUBLE Y This field contains the details of vaccine dose. 0 - Row is not related to a vaccine dose, 2 - This value will denote a 2-dose vaccine, 3 - This value will denote a 3-dose vaccine, 4 - This value will denote a 4-dose vaccine.



Relationship Detail - LH_AMB_EVENT_DATA_2023


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


LH_AMB_EVENT_DATA_2024



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_AMB_EVENT_DATA_2024
Definition: Table containing event information for meaningful use NQF stage 2 2024.
Table Type: ACTIVITY





Column Detail - LH_AMB_EVENT_DATA_2024


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.
ASSOCIATED_ENTITY_ID DOUBLE Y The ID of the associated event from the table listed in associated_entity_name.
ASSOCIATED_ENTITY_NAME VARCHAR(30) Y The name of the table the associated event in the associated_entity_id column is coming from.
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 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.
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 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.
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 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.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LAST_UPDATED_PROVIDER_ID DOUBLE Y This gives the ID of the provider whoever has updated the row last
LH_AMB_EVENT_DATA_2024_ID DOUBLE N Unique generated number that identifies a single row on the LH_AMB_EVENT_DATA_2024 table.
MEDS_DISPENSE_QTY DOUBLE Y This field contains the dispense quantity of the medication.
MEDS_DISPENSE_QTY_UNIT VARCHAR(100) Y This field contains the unit of the dispense quantity of medication.
MEDS_DURATION DOUBLE Y This field contains the duration for medication.
MEDS_DURATION_UNIT VARCHAR(100) Y This field contains the unit for duration of the medication.
MEDS_FREQUENCY DOUBLE Y This field contains the frequency of the medication.
MEDS_REFILL_CNT DOUBLE Y This field contains the refill count of the medication.
MEDS_STRENGTH_DOSE DOUBLE Y This field contains medication dose's strength.
MEDS_STRENGTH_DOSE_UNIT VARCHAR(100) Y This field contains the unit of the medication dose's strength.
MEDS_VOLUME_DOSE DOUBLE Y This field contains medication dose's volume.
MEDS_VOLUME_DOSE_UNIT VARCHAR(100) Y This field contains the unit of the medication dose's volume.
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 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.
PERSON_ID DOUBLE Y 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 Y 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.
VACCINE_DOSE_FLAG DOUBLE Y This field contains the details of vaccine dose. 0 - Row is not related to a vaccine dose, 2 - This value will denote a 2-dose vaccine, 3 - This value will denote a 3-dose vaccine, 4 - This value will denote a 4-dose vaccine.



Relationship Detail - LH_AMB_EVENT_DATA_2024


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


LH_AMB_FILTER_PARAMS



Column Section Top of Page


Table-level Detail

Description: LH_AMB_FILTER_PARAMS
Definition: This table holds parameters for the LH_AMB_FILTER program.
Table Type: ACTIVITY





Column Detail - LH_AMB_FILTER_PARAMS


Column Name Type Null? Definition
BEG_EXTRACT_DT_TM DATETIME Y The start of the extract period.
BIRTHDATE_HIGH_DT_TM DATETIME Y The highest value for Patient Birth Date Time.
BIRTHDATE_LOW_DT_TM DATETIME Y The lowest value for Patient Birth Date Time.
END_EXTRACT_DT_TM DATETIME Y The end of the extract period.
ETHNICITY_CD DOUBLE Y CODE_VALUE for Patient Ethnicity Filter.
FILE_TEXT VARCHAR(50) Y The text to associate with records .
GENDER_ITEM_ID DOUBLE N BR_DATAM_VAL_SET_ITEM_ID for Patient Gender Filter.
INSURANCE_ITEM_ID DOUBLE N BR_DATAM_VAL_SET_ITEM_ID for Patient Insurance Filter.
LH_AMB_FILTER_PARAMS_ID DOUBLE N Unique generated number that identifies a single row on the LH_AMB_FILTER_PARAMS table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
PARENT_ENTITY_ID DOUBLE N The id to associate with Parent Entity Name.
PARENT_ENTITY_NAME VARCHAR(30) Y The table to associate with Parent Entity ID.
PRINT_OPTION VARCHAR(10) Y The format in which to print results.
PROBLEM_VSET_ID DOUBLE N BR_DATAM_VAL_SET_ID for Patient Problem Filter.
RACE_CD DOUBLE Y CODE_VALUE for Patient Race Filter.
REPORT_BY VARCHAR(20) Y The Reporting Option.
REPORT_MODE VARCHAR(20) Y The mode for which to run LH_AMB_FILTER.
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_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.