Table Detail Report
LH_CQM_MEAS
| Column Section | Top of Page |
Table-level Detail
| Description: | Lighthouse Clinical Quality Measures Measure |
| Definition: | Contains the defined measures for the program. |
| Table Type: | REFERENCE |
Column Detail - LH_CQM_MEAS
| Column Name | Type | Null? | Definition |
|---|
LH_CQM_MEAS_SVC_ENTITY_R
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Lighthouse Clinical Quality Measures Service Entity Relation |
| Definition: | Relates the measure to the entity that the measure applies to, i.e. a hospital or eligible provider. |
| Table Type: | REFERENCE |
Column Detail - LH_CQM_MEAS_SVC_ENTITY_R
| 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. |
| BEG_EFFECTIVE_DT_TM | DATETIME | N | 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. |
| END_EFFECTIVE_DT_TM | DATETIME | N | 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. |
| LH_CQM_MEAS_ID | DOUBLE | N | The measure that is being related to this service entity. |
| LH_CQM_MEAS_SVC_ENTITY_R_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_CQM_MEAS_SVC_ENTITY_R table. |
| LH_CQM_REPORT_TYPE_TFLG | VARCHAR(5) | Y | Determines the reporting type as MIPs or MVPs. |
| ORIG_LH_CQM_MEAS_SVCENT_R_ID | DOUBLE | N | Used for versioning. Contains the value of the PK for a particular set of rows in LH_CQM_MEAS_SVC_ENTITY_R. |
| PARENT_ENTITY_ID | DOUBLE | N | Identifies the Eligible Provider or Hospital that is being related to this measure. |
| PARENT_ENTITY_NAME | VARCHAR(32) | N | A pointer to the table that holds the service entity being related to this measure. |
| UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. 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_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 | N | 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_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. 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 | DOUBLE | 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_CQM_MEAS_SVC_ENTITY_R
| Child Column in LH_CQM_MEAS_SVC_ENTITY_R(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ORIG_LH_CQM_MEAS_SVCENT_R_ID | LH_CQM_MEAS_SVC_ENTITY_R | LH_CQM_MEAS_SVC_ENTITY_R_ID |
| Parent Column in LH_CQM_MEAS_SVC_ENTITY_R (PK) | Child Table Name | Child Column Name | |
|---|---|---|---|
| Children: | LH_CQM_MEAS_SVC_ENTITY_R_ID | LH_CQM_MEAS_SVC_ENTITY_R | ORIG_LH_CQM_MEAS_SVCENT_R_ID |
LH_D_QUERY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | LH_D_QUERY |
| Definition: | Dimension table contain query and measure information for Meaningful Use QM and PQRI solutions. |
| Table Type: | REFERENCE |
Column Detail - LH_D_QUERY
| 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. |
| D_QUERY_ID | DOUBLE | N | Unique generated number that identifies a single row on LH_D_QUERY table. |
| 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. |
| EXECUTION_MODE_FLAG | DOUBLE | N | The Oracle optimizer execution mode. 0 = default, 1=RBO, 2=CBO |
| EXTRACT_DT_TM | DATETIME | Y | The date/time that the program running the extracts was started. This field should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time. |
| 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. |
| HINT_NAME | VARCHAR(200) | Y | Contains the name of the hint that is to be used for the query. |
| 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. |
| POPULATION_GROUP | VARCHAR(50) | Y | Name of the measure. |
| PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
| QUERY_NAME | VARCHAR(100) | N | Name of the individual queries associated with a measure. |
| REPORT_SECTION_GRAIN | VARCHAR(100) | Y | This column will be used to store grain of the report_writer_section for all queries. This will allow us to dynamically change the grain of a query. |
| 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_D_QUERY
| Parent Column in LH_D_QUERY (PK) | Child Table Name | Child Column Name | |
|---|---|---|---|
| Children: | D_QUERY_ID | LH_AMB_EVENT_DATA | D_QUERY_ID |
| LH_AMB_EVENT_DATA_2016 | D_QUERY_ID | ||
| LH_AMB_EVENT_DATA_2017 | D_QUERY_ID | ||
| LH_AMB_EVENT_DATA_2018 | D_QUERY_ID | ||
| LH_AMB_EVENT_DATA_2019 | D_QUERY_ID | ||
| LH_AMB_EVENT_DATA_2020 | D_QUERY_ID | ||
| LH_AMB_EVENT_DATA_2021 | D_QUERY_ID | ||
| LH_AMB_EVENT_DATA_2022 | D_QUERY_ID | ||
| LH_AMB_EVENT_DATA_2023 | D_QUERY_ID | ||
| LH_AMB_EVENT_DATA_2024 | D_QUERY_ID | ||
| LH_AMB_EVENT_DATA_2025 | D_QUERY_ID | ||
| LH_AMB_QUAL_ENCNTR | D_QUERY_ID | ||
| LH_AMB_QUAL_ENCNTR_2016 | D_QUERY_ID | ||
| LH_AMB_QUAL_ENCNTR_2017 | D_QUERY_ID | ||
| LH_AMB_QUAL_ENCNTR_2018 | D_QUERY_ID | ||
| LH_AMB_QUAL_ENCNTR_2019 | D_QUERY_ID | ||
| LH_AMB_QUAL_ENCNTR_2020 | D_QUERY_ID | ||
| LH_AMB_QUAL_ENCNTR_2021 | D_QUERY_ID | ||
| LH_AMB_QUAL_ENCNTR_2022 | D_QUERY_ID | ||
| LH_AMB_QUAL_ENCNTR_2023 | D_QUERY_ID | ||
| LH_AMB_QUAL_ENCNTR_2024 | D_QUERY_ID | ||
| LH_AMB_QUAL_ENCNTR_2025 | D_QUERY_ID |
LH_E_AKI_2025_METRICS
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Lighthouse eMeasures Hospital-Harm Acute Kidney Injury 2025 Metrics |
| Definition: | Stores data gathered by the LH_E_AKI_2025 script. |
| Table Type: | ACTIVITY |
Column Detail - LH_E_AKI_2025_METRICS
| 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. |
| BODY_TEMPERATURE_RESULT_TXT | VARCHAR(60) | Y | The result text for the first body temperature result. |
| CREATININE_48H_CNT | DOUBLE | Y | The count of creatinine results collected during the first 48 hours of the visit. |
| CREAT_AFTER_48H_RESULT_DT_TM | DATETIME | Y | Date/time for the first Creatinine that has been collected 48 hours or more after the visit start. |
| CREAT_AFTER_48H_RESULT_TXT | VARCHAR(60) | Y | Result text for the first Creatinine that has been collected 48 hours or more after the visit start. |
| DIAG_WITH_POA_NOMEN | VARCHAR(1000) | Y | A list of diagnoses for the visit that have present on admission separated by semicolons. |
| DIALYSIS_AFTER_48_PROC_DT_TM | DATETIME | Y | The Date/time code for the last dialysis procedure document after the first 48 hours of the encounter. |
| DIALYSIS_AFTER_48_PROC_NOMEN | VARCHAR(50) | Y | The nomenclature code for the last dialysis procedure document after the first 48 hours of the encounter. |
| DIALYSIS_FIRST_48_PROC_DT_TM | DATETIME | Y | The date/time for the first dialysis procedure document during the first 48 hours of the encounter. |
| DIALYSIS_FIRST_48_PROC_NOMEN | VARCHAR(50) | Y | The nomenclature code for the first dialysis procedure document during the first 48 hours of the encounter. |
| DISCHARGE_DT_TM | DATETIME | Y | The end of the qualifying encounter. |
| D_ADMIT_BUILDING_ID | DOUBLE | N | Dimension ID for admit building. |
| D_ADMIT_FACILITY_ID | DOUBLE | N | Dimension ID for admit facility. |
| D_ADMIT_NURSE_UNIT_ID | DOUBLE | N | Dimension ID for admit nurse unit. |
| D_ADMIT_SRC_ID | DOUBLE | N | Dimension ID for admit source. |
| D_ADMIT_TYPE_ID | DOUBLE | N | Dimension ID for admit type. |
| D_ATTEND_PRSNL_ID | DOUBLE | N | Dimension ID for attending physician. |
| D_BR_CCN_ID | DOUBLE | N | Dimension ID for CCN. |
| D_BR_HCO_ID | DOUBLE | N | Dimension ID for HCO. |
| D_DISCHARGE_BUILDING_ID | DOUBLE | N | Dimension ID for discharge building. |
| D_DISCHARGE_FACILITY_ID | DOUBLE | N | Dimension ID for discharge facility. |
| D_DISCHARGE_NURSE_UNIT_ID | DOUBLE | N | Dimension ID for discharge nurse unit. |
| D_DISCH_DISP_ID | DOUBLE | N | Dimension ID for discharge disposition. |
| D_ENCNTR_TYPE_ID | DOUBLE | N | Dimension ID for encounter type. |
| D_METRIC_0_ID | DOUBLE | N | Dimension ID for GMCS metric. |
| D_PERSON_ID | DOUBLE | N | Dimension ID for person data. |
| ED_ARRIVAL_DT_TM | DATETIME | Y | The start of the qualifying emergency encounter. |
| ED_DEPART_DT_TM | DATETIME | Y | The end of the qualifying emergency encounter. |
| ED_ENCNTR_ID | DOUBLE | N | The ID of the qualifying Emergency encounter associated to the record. |
| EGFR_NBR | DOUBLE | Y | The Estimated Glomerular Filtration Rate calculated from the index result |
| ENCNTR_ID | DOUBLE | N | The ID of the qualifying encounter associated to the record. |
| EXCLUDE_IND | DOUBLE | Y | Indicates that the person qualifies for exclusion outcome. |
| EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
| FINANCIAL_NBR_TXT | VARCHAR(50) | Y | Financial Number of the record. |
| FIRST_CREAT_48H_RESULT_DT_TM | DATETIME | Y | If 24 hour result is not found, the date/time for the first creatinine result in the first 48 hours of the visit, otherwise null. Used as the index result. |
| FIRST_CREAT_48H_RESULT_TXT | VARCHAR(60) | Y | If 24 hour result is not found, the result text for the first creatinine result in the first 48 hours of the visit, otherwise blank. Used as the index result. |
| 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. |
| HEART_RATE_RESULT_TXT | VARCHAR(60) | Y | The result text for the first heart rate result. |
| HIC_MBI_TXT | VARCHAR(50) | Y | Displays the qualifying HIC or MBI Number if there is a Medicare payer on the encounter. |
| HIGH_CREAT_RESULT_DT_TM | DATETIME | Y | The date/time for the highest creatinine result during the visit |
| HIGH_CREAT_RESULT_TXT | VARCHAR(60) | Y | The result text for the highest creatinine result during the visit |
| HIGH_RISK_AKI_DIAG_NOMEN | VARCHAR(50) | Y | Nomenclature for a diagnosis with high risk for acute kidney injury. Must have present on admission ""Yes"" or ""Clinically undetermined"" |
| HIGH_RISK_AKI_PROC_DT_TM | DATETIME | Y | Date/time for a procedure with high risk for acute kidney injury. |
| HIGH_RISK_AKI_PROC_NOMEN | VARCHAR(50) | Y | Nomenclature for a procedure with high risk for acute kidney injury. |
| IPP_IND | DOUBLE | Y | Indicates that the person qualifies for population. |
| IP_ADMIT_DT_TM | DATETIME | Y | The start of the inpatient encounter. |
| LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
| LH_E_AKI_2025_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_E_AKI_2025_METRICS 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. |
| LOW_CREAT_24H_RESULT_DT_TM | DATETIME | Y | Date/time for the lowest creatinine result in the first 24 hours of the visit. Used as the index result. |
| LOW_CREAT_24H_RESULT_TXT | VARCHAR(60) | Y | Result text for the lowest creatinine result in the first 24 hours of the visit. Used as the index result. |
| LOW_CREAT_RESULT_DT_TM | DATETIME | Y | The date/time for the lowest creatinine result during the visit |
| LOW_CREAT_RESULT_TXT | VARCHAR(60) | Y | The result text for the lowest creatinine result during the visit |
| NUM_IND | DOUBLE | Y | Indicates that the person qualifies for numerator outcome. |
| OBS_DX_NOMEN_TXT | VARCHAR(60) | Y | Nomenclature for obstetrical or pregnancy related conditions diagnosis. |
| OBS_SERV_ARRIVAL_DT_TM | DATETIME | Y | The start of the qualifying observation encounter. |
| OBS_SERV_DEPART_DT_TM | DATETIME | Y | The end of the qualifying observation encounter. |
| OBS_SERV_ENCNTR_ID | DOUBLE | N | The ID of the qualifying Observation encounter associated to the record. |
| ORG_MRN_TXT | VARCHAR(50) | Y | Medical Record Number of the record. |
| PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility. |
| PATIENT_IDENT | VARCHAR(50) | Y | Identifies the earliest documented medical record number of the patient. |
| PERSON_ETHNIC_CODE_DISPLAY | VARCHAR(300) | Y | String to store ethnicity display. |
| PERSON_GENDER_CODE_DISPLAY | VARCHAR(300) | Y | String to store gender display. |
| PERSON_ID | DOUBLE | N | The ID of the person associated to the record. |
| PERSON_PAYER_CODE_DISPLAY | VARCHAR(300) | Y | String to store payer display. |
| PERSON_RACE_DESC | VARCHAR(300) | Y | String to store multiple races. |
| RESPIRATORY_RATE_RESULT_TXT | VARCHAR(60) | Y | The result text for the first respiratory rate result. |
| SCRIPT_VERSION | DOUBLE | Y | The version number of the script that populated the row |
| SRC_UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated to be preserved during extracts. |
| SRC_UPDT_SOURCE | VARCHAR(50) | Y | The script name responsible for updating the record to be preserved during extracts. |
| SUBSEQ_CREAT_RESULT_DT_TM | DATETIME | Y | The date/time for the highest creatinine result after the index result. Must be at least .3 higher. |
| SUBSEQ_CREAT_RESULT_TXT | VARCHAR(60) | Y | The result text for the highest creatinine result after the index result. Must be at least .3 higher. |
| SYSTOLIC_BLOOD_PRESSURE_TXT | VARCHAR(60) | Y | The result text for the first systolic blood pressure result. |
| TIME_ZONE_TXT | VARCHAR(100) | Y | The timezone of the record in ""America/Chicago"" format. |
| 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_E_AKI_2025_METRICS
| Child Column in LH_E_AKI_2025_METRICS(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | D_ADMIT_SRC_ID | LH_D_ADMIT_SRC | D_ADMIT_SRC_ID |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_SRC | HEALTH_SYSTEM_SOURCE_ID | |
| D_ADMIT_TYPE_ID | LH_D_ADMIT_TYPE | D_ADMIT_TYPE_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
| D_BR_CCN_ID | LH_D_BR_CCN | D_BR_CCN_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_CCN | HEALTH_SYSTEM_SOURCE_ID | |
| D_BR_HCO_ID | LH_D_BR_HCO | D_BR_HCO_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_HCO | HEALTH_SYSTEM_SOURCE_ID | |
| D_ADMIT_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
| D_DISCHARGE_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
| D_DISCH_DISP_ID | LH_D_DISCH_DISP | D_DISCH_DISP_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_DISCH_DISP | HEALTH_SYSTEM_SOURCE_ID | |
| D_ENCNTR_TYPE_ID | LH_D_ENCNTR_TYPE | D_ENCNTR_TYPE_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_ENCNTR_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
| D_ADMIT_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
| D_DISCHARGE_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
| D_METRIC_0_ID | LH_D_METRIC | D_METRIC_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
| D_ADMIT_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
| D_DISCHARGE_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
| D_PERSON_ID | LH_D_PERSON | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSON | HEALTH_SYSTEM_SOURCE_ID | |
| D_ATTEND_PRSNL_ID | LH_D_PERSONNEL | D_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSONNEL | HEALTH_SYSTEM_SOURCE_ID |
LH_E_AKI_2026_METRICS
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Lighthouse eMeasures Hospital-Harm Acute Kidney Injury 2026 Metrics |
| Definition: | Stores data gathered by the LH_E_AKI_2026 script. |
| Table Type: | ACTIVITY |
Column Detail - LH_E_AKI_2026_METRICS
| 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. |
| BODY_TEMPERATURE_RESULT_TXT | VARCHAR(60) | Y | The result text for the first body temperature result. |
| CREATININE_48H_CNT | DOUBLE | Y | The count of creatinine results collected during the first 48 hours of the visit. |
| CREAT_AFTER_48H_RESULT_DT_TM | DATETIME | Y | Date/time for the first Creatinine that has been collected 48 hours or more after the visit start. |
| CREAT_AFTER_48H_RESULT_TXT | VARCHAR(60) | Y | Result text for the first Creatinine that has been collected 48 hours or more after the visit start. |
| DIAG_WITH_POA_NOMEN | VARCHAR(1000) | Y | A list of diagnoses for the visit that have present on admission separated by semicolons. |
| DIALYSIS_AFTER_48_PROC_DT_TM | DATETIME | Y | The Date/time code for the last dialysis procedure document after the first 48 hours of the encounter. |
| DIALYSIS_AFTER_48_PROC_NOMEN | VARCHAR(50) | Y | The nomenclature code for the last dialysis procedure document after the first 48 hours of the encounter. |
| DIALYSIS_FIRST_48_PROC_DT_TM | DATETIME | Y | The date/time for the first dialysis procedure document during the first 48 hours of the encounter. |
| DIALYSIS_FIRST_48_PROC_NOMEN | VARCHAR(50) | Y | The nomenclature code for the first dialysis procedure document during the first 48 hours of the encounter. |
| DISCHARGE_DT_TM | DATETIME | Y | The end of the qualifying encounter. |
| D_ADMIT_BUILDING_ID | DOUBLE | N | Dimension ID for admit building. |
| D_ADMIT_FACILITY_ID | DOUBLE | N | Dimension ID for admit facility. |
| D_ADMIT_NURSE_UNIT_ID | DOUBLE | N | Dimension ID for admit nurse unit. |
| D_ADMIT_SRC_ID | DOUBLE | N | Dimension ID for admit source. |
| D_ADMIT_TYPE_ID | DOUBLE | N | Dimension ID for admit type. |
| D_ATTEND_PRSNL_ID | DOUBLE | N | Dimension ID for attending physician. |
| D_BR_CCN_ID | DOUBLE | N | Dimension ID for CCN. |
| D_BR_HCO_ID | DOUBLE | N | Dimension ID for HCO. |
| D_DISCHARGE_BUILDING_ID | DOUBLE | N | Dimension ID for discharge building. |
| D_DISCHARGE_FACILITY_ID | DOUBLE | N | Dimension ID for discharge facility. |
| D_DISCHARGE_NURSE_UNIT_ID | DOUBLE | N | Dimension ID for discharge nurse unit. |
| D_DISCH_DISP_ID | DOUBLE | N | Dimension ID for discharge disposition. |
| D_ENCNTR_TYPE_ID | DOUBLE | N | Dimension ID for encounter type. |
| D_METRIC_0_ID | DOUBLE | N | Dimension ID for GMCS metric. |
| D_PERSON_ID | DOUBLE | N | Dimension ID for person data. |
| ED_ARRIVAL_DT_TM | DATETIME | Y | The start of the qualifying emergency encounter. |
| ED_DEPART_DT_TM | DATETIME | Y | The end of the qualifying emergency encounter. |
| ED_ENCNTR_ID | DOUBLE | N | The ID of the qualifying Emergency encounter associated to the record. |
| EGFR_NBR | DOUBLE | Y | The Estimated Glomerular Filtration Rate calculated from the index result |
| ENCNTR_ID | DOUBLE | N | The ID of the qualifying encounter associated to the record. |
| EXCLUDE_IND | DOUBLE | Y | Indicates that the person qualifies for exclusion outcome. |
| EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
| FINANCIAL_NBR_TXT | VARCHAR(50) | Y | Financial Number of the record. |
| FIRST_CREAT_48H_RESULT_DT_TM | DATETIME | Y | If 24 hour result is not found, the date/time for the first creatinine result in the first 48 hours of the visit, otherwise null. Used as the index result. |
| FIRST_CREAT_48H_RESULT_TXT | VARCHAR(60) | Y | If 24 hour result is not found, the result text for the first creatinine result in the first 48 hours of the visit, otherwise blank. Used as the index result. |
| 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. |
| HEART_RATE_RESULT_TXT | VARCHAR(60) | Y | The result text for the first heart rate result. |
| HIC_MBI_TXT | VARCHAR(50) | Y | Displays the qualifying HIC or MBI Number if there is a Medicare payer on the encounter. |
| HIGH_CREAT_RESULT_DT_TM | DATETIME | Y | The date/time for the highest creatinine result during the visit |
| HIGH_CREAT_RESULT_TXT | VARCHAR(60) | Y | The result text for the highest creatinine result during the visit |
| HIGH_RISK_AKI_DIAG_NOMEN | VARCHAR(50) | Y | Nomenclature for a diagnosis with high risk for acute kidney injury. Must have present on admission ""Yes"" or ""Clinically undetermined"" |
| HIGH_RISK_AKI_PROC_DT_TM | DATETIME | Y | Date/time for a procedure with high risk for acute kidney injury. |
| HIGH_RISK_AKI_PROC_NOMEN | VARCHAR(50) | Y | Nomenclature for a procedure with high risk for acute kidney injury. |
| IPP_IND | DOUBLE | Y | Indicates that the person qualifies for population. |
| IP_ADMIT_DT_TM | DATETIME | Y | The start of the inpatient encounter. |
| LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
| LH_E_AKI_2026_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_E_AKI_2026_METRICS 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. |
| LOW_CREAT_24H_RESULT_DT_TM | DATETIME | Y | Date/time for the lowest creatinine result in the first 24 hours of the visit. Used as the index result. |
| LOW_CREAT_24H_RESULT_TXT | VARCHAR(60) | Y | Result text for the lowest creatinine result in the first 24 hours of the visit. Used as the index result. |
| LOW_CREAT_RESULT_DT_TM | DATETIME | Y | The date/time for the lowest creatinine result during the visit |
| LOW_CREAT_RESULT_TXT | VARCHAR(60) | Y | The result text for the lowest creatinine result during the visit |
| NUM_IND | DOUBLE | Y | Indicates that the person qualifies for numerator outcome. |
| OBS_DX_NOMEN_TXT | VARCHAR(60) | Y | Nomenclature for obstetrical or pregnancy related conditions diagnosis. |
| OBS_SERV_ARRIVAL_DT_TM | DATETIME | Y | The start of the qualifying observation encounter. |
| OBS_SERV_DEPART_DT_TM | DATETIME | Y | The end of the qualifying observation encounter. |
| OBS_SERV_ENCNTR_ID | DOUBLE | N | The ID of the qualifying Observation encounter associated to the record. |
| ORG_MRN_TXT | VARCHAR(50) | Y | Medical Record Number of the record. |
| PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility. |
| PATIENT_IDENT | VARCHAR(50) | Y | Identifies the earliest documented medical record number of the patient. |
| PERSON_ETHNIC_CODE_DISPLAY | VARCHAR(300) | Y | String to store ethnicity display. |
| PERSON_GENDER_CODE_DISPLAY | VARCHAR(300) | Y | String to store gender display. |
| PERSON_ID | DOUBLE | N | The ID of the person associated to the record. |
| PERSON_PAYER_CODE_DISPLAY | VARCHAR(300) | Y | String to store payer display. |
| PERSON_RACE_DESC | VARCHAR(300) | Y | String to store multiple races. |
| RESPIRATORY_RATE_RESULT_TXT | VARCHAR(60) | Y | The result text for the first respiratory rate result. |
| SCRIPT_VERSION | DOUBLE | Y | The version number of the script that populated the row |
| SRC_UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated to be preserved during extracts. |
| SRC_UPDT_SOURCE | VARCHAR(50) | Y | The script name responsible for updating the record to be preserved during extracts. |
| SUBSEQ_CREAT_RESULT_DT_TM | DATETIME | Y | The date/time for the highest creatinine result after the index result. Must be at least .3 higher. |
| SUBSEQ_CREAT_RESULT_TXT | VARCHAR(60) | Y | The result text for the highest creatinine result after the index result. Must be at least .3 higher. |
| SYSTOLIC_BLOOD_PRESSURE_TXT | VARCHAR(60) | Y | The result text for the first systolic blood pressure result. |
| TIME_ZONE_TXT | VARCHAR(100) | Y | The timezone of the record in ""America/Chicago"" format. |
| 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_E_AKI_2026_METRICS
| Child Column in LH_E_AKI_2026_METRICS(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | D_ADMIT_SRC_ID | LH_D_ADMIT_SRC | D_ADMIT_SRC_ID |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_SRC | HEALTH_SYSTEM_SOURCE_ID | |
| D_ADMIT_TYPE_ID | LH_D_ADMIT_TYPE | D_ADMIT_TYPE_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
| D_BR_CCN_ID | LH_D_BR_CCN | D_BR_CCN_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_CCN | HEALTH_SYSTEM_SOURCE_ID | |
| D_BR_HCO_ID | LH_D_BR_HCO | D_BR_HCO_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_HCO | HEALTH_SYSTEM_SOURCE_ID | |
| D_ADMIT_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
| D_DISCHARGE_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
| D_DISCH_DISP_ID | LH_D_DISCH_DISP | D_DISCH_DISP_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_DISCH_DISP | HEALTH_SYSTEM_SOURCE_ID | |
| D_ENCNTR_TYPE_ID | LH_D_ENCNTR_TYPE | D_ENCNTR_TYPE_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_ENCNTR_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
| D_ADMIT_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
| D_DISCHARGE_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
| D_METRIC_0_ID | LH_D_METRIC | D_METRIC_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
| D_ADMIT_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
| D_DISCHARGE_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
| D_PERSON_ID | LH_D_PERSON | D_PERSON_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSON | HEALTH_SYSTEM_SOURCE_ID | |
| D_ATTEND_PRSNL_ID | LH_D_PERSONNEL | D_PRSNL_ID | |
| HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSONNEL | HEALTH_SYSTEM_SOURCE_ID |