Table Detail Report

LH_ABS_CASE_NOTES



Column Section Top of Page


Table-level Detail

Description: LH_ABS_CASE_NOTES
Definition: Case Notes for records being abstracted in the Lighthouse Abstractor (eQuality Check)
Table Type: ACTIVITY





Column Detail - LH_ABS_CASE_NOTES


Column Name Type Null? Definition
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_DATAMART_CATEGORY_ID DOUBLE N Holds the br_datamart_category_id of the condition and version that the case note was added for. Possibly zero in the case of condition spanning older styled case notes.
CREATE_DT_TM DATETIME Y Date time the case note was created
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER 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.
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FIRST_PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
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 the record was last loaded into the table.
LH_ABS_CASE_NOTES_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_CASE_NOTES table.
NOTES_TXT VARCHAR(3200) Y Case Notes related to this visit
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.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated.
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.
USER_ID DOUBLE N The person_id of the user that answered the question.


LH_ABS_COMP_TIME



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse ABS Completion Time
Definition: This table stores information about the total time spent by abstrcator to complete abstraction for each case within eQualityCheck solution.
Table Type: ACTIVITY





Column Detail - LH_ABS_COMP_TIME


Column Name Type Null? Definition
ABS_TIME_SECS DOUBLE N The total time taken by abstractor to complete abstraction on the case in seconds.
BR_DATAMART_CATEGORY_ID DOUBLE N The primary key of the bedrock category on BR_DATAMART_CATEGORY table.
COMPLETE_IND DOUBLE Y Indicates the abstrcation status of the case.
D_FACILITY_ID DOUBLE N The primary key of the facility domension of the encounter. Based on the condition, this column holds either the admit facility or discharge facility or event facility.
ENCNTR_ID DOUBLE N SEQUENCE NAME:ENCOUNTER_ONLY_SEQ; Unique identifier for the ENCOUNTER table.
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_ABS_COMP_TIME_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_COMP_TIME table.
LH_ABS_HBIPS_EVENTS_ID DOUBLE N The primary key of the associated row from the LH_ABS_HBIPS_EVENTS 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.
PRSNL_ID DOUBLE N " SEQUENCE NAME:PERSON_ONLY_SEQ; The person from the personnel (PRSNL) table that completed abstraction on this case."
QUALIFIER_DT_TM DATETIME Y Based on the condition, this column holds either the admit date/time or discharge date/time or event date/time.
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. 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.



Relationship Detail - LH_ABS_COMP_TIME


Child Column in LH_ABS_COMP_TIME(FK) Parent Table Name Parent Column Name
Parents: HEALTH_SYSTEM_SOURCE_ID LH_ABS_HBIPS_EVENTS HEALTH_SYSTEM_SOURCE_ID
LH_ABS_HBIPS_EVENTS_ID LH_ABS_HBIPS_EVENTS LH_ABS_HBIPS_EVENTS_ID
D_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID


LH_ABS_CSTK02_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_ABS_CSTK02_METRICS
Definition: Stores information about CSTK-02 Modified Rankin Score encounters.
Table Type: ACTIVITY





Column Detail - LH_ABS_CSTK02_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.
ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted.
ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted normalized to GMT.
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
COMPLETED_DT_TM DATETIME Y The Date and Time at which the abstracted case was completed.
CSTK02_CATEGORY_REASON_TXT VARCHAR(250) Y Identifies the category reason for the measure outcome
CSTK10A_IND DOUBLE Y This field indicates if the encounter is in stratum A for CSTK-10 measure.
CSTK10B_IND DOUBLE Y This field indicates if the encounter is in stratum B for CSTK-10 measure.
CSTK10C_IND DOUBLE Y This field indicates if the encounter is in stratum C for CSTK-10 measure.
CSTK10D_IND DOUBLE Y This field indicates if the encounter is in stratum D for CSTK-10 measure.
CSTK10_CATEGORY_REASON_TXT VARCHAR(250) Y Identifies the category reason for the CSTK-10 measure outcome.
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged normalized to GMT.
DISC_DISP_FLAG DOUBLE Y Identifies the discharge disposition of the patient.
D_ADMIT_BUILDING_ID DOUBLE Y The building to which the patient was admitted.
D_ADMIT_FACILITY_ID DOUBLE Y The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE Y The nurse unit to which the patient was admitted.
D_ADMIT_SRC_ID DOUBLE Y Identifies the place from which the patient came before being admitted.
D_ADMIT_TYPE_ID DOUBLE Y Indicates the circumstances under which the patient was admitted.
D_ATTEND_PRSNL_ID DOUBLE Y Identifies the final attending physician associated to the encounter.
D_BR_CCN_ID DOUBLE Y CMS Certification Number. Foreign key to LH_D_BR_CCN.
D_BR_HCO_ID DOUBLE Y Healthcare organization Number. Foreign key to LH_D_BR_HCO.
D_DISCHARGE_BUILDING_ID DOUBLE Y The building from which the patient was discharged.
D_DISCHARGE_FACILITY_ID DOUBLE Y The facility from which the patient was discharged.
D_DISCHARGE_NURSE_UNIT_ID DOUBLE Y The nurse unit from which the patient was discharged.
D_DISCH_DISP_ID DOUBLE Y The conditions under which the patient left the facility at the time of discharge. Foreign key to LH_D_DISCH_DISP.
D_ENCNTR_TYPE_ID DOUBLE Y Categorizes the encounter into a logical group or type.
D_MED_SERVICE_ID DOUBLE Y The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others.
D_METRIC_1_ID DOUBLE Y Identifies the metric identifier for the Lighthouse metric.
D_PERSON_ID DOUBLE Y Identifies the person associated with the quality measure. Foreign key to the LH_D_PERSON.
ELECTIVE_CAROTID_IND DOUBLE Y this admission was for the sole purpose of performance of an elective carotid intervention
ENCNTR_ID DOUBLE Y Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXCLUDE_CSTK02_IND DOUBLE Y Represents if the person is excluded for CTK02.
EXCLUDE_CSTK10_IND DOUBLE Y This field indicates if the encounter is excluded for CSTK-10 measure.
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.
HEALTH_SYSTEM_ID DOUBLE Y Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE Y Identifies the unique source within the delivery network responsible for supplying the data.
IV_THROM_INIT_FLAG DOUBLE Y This field stores the value of response for IVTHROMINIT question. 1-Yes, 2-No, 999-Missing Response.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_ABS_CSTK02_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_CSTK02_METRICS table.
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.
MOD_RAN_SC_DT_TM DATETIME Y The date/time on which the Modified Rankin Score was determined
MOD_RAN_SC_FLAG DOUBLE Y A flag indicating Modified rankin score
MOD_RAN_SC_UTC_DT_TM DATETIME Y The date/time on which the Modified Rankin Score was determined normalized to GMT
MRS_IND DOUBLE Y Indicates if the MRS indicator is set for the patient.
NUMERATOR_CSTK02_IND DOUBLE Y Represents if the person is in the numerator for CTK02.
NUMERATOR_CSTK10_IND DOUBLE Y This field indicates if the encounter is in numerator for CSTK-10 measure.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
OTH_DIAGNOSIS_LIST VARCHAR(400) Y A comma separated list of other diagnoses associated with the encounter.
OTH_PROCEDURE_DATES_LIST VARCHAR(400) Y A comma separated list of dates the other procedures associated with the encounter were performed.
OTH_PROCEDURE_LIST VARCHAR(400) Y A comma separated list of other procedures associated with the encounter.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility.
PAYMENT_SOURCE_FLAG DOUBLE Y Identifies the source of payment for the encounter. 1 - Medicare, 2 - Non-Medicare, 999 - Missing.
PHYSICIAN_1_TXT VARCHAR(50) Y First physician identifier.
PHYSICIAN_2_TXT VARCHAR(50) Y Second physician identifier.
PRE_MOD_RAN_SC_FLAG DOUBLE Y This field stores the value of response for PREMODRANSC question.
PRIN_DIAGNOSIS VARCHAR(10) Y Identifies the principle diagnosis associated with the encounter.
PRIN_PROCEDURE VARCHAR(10) Y Identifies the principle procedure associated with the encounter.
PRIN_PROCEDURE_DATE_TXT VARCHAR(10) Y The date on which the principle procedure was performed.
PRIN_PROCEDURE_DT_TM DATETIME Y The date/time on which the principle procedure was performed.
PRIN_PROCEDURE_UTC_DT_TM DATETIME Y The date/time on which the principle procedure was performed; normalized to GMT.
PRS_TXT VARCHAR(10) Y Identifies the Patient Reliability Score (PRS).
REJECT_CSTK02_IND DOUBLE Y Represents if the person is rejected for CTK02.
REJECT_CSTK10_IND DOUBLE Y This field indicates if the encounter is rejected for CSTK-10 measure.
SAMPLE_IND DOUBLE Y Indicates if the case is sampled.
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 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 Y 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_SOURCE VARCHAR(50) Y The script name responsible for updating the reecord.
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_ABS_CSTK02_METRICS


Child Column in LH_ABS_CSTK02_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_MED_SERVICE_ID LH_D_MED_SERVICE D_MED_SERVICE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_MED_SERVICE HEALTH_SYSTEM_SOURCE_ID
D_METRIC_1_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_ABS_ED_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_ABS_ED_METRICS
Definition: This table is used to store ED metrics from the Lighthouse Abstractor (eQuality Check). This table is at the encounter grain.
Table Type: ACTIVITY





Column Detail - LH_ABS_ED_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.
ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted.
ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted; normalized to GMT.
ARRIVAL_DATE_TXT VARCHAR(10) Y The earliest documented date the patient arrived at the facility. User Entered (MM-DD-YYYY) Includes dashes
ARRIVAL_DT_TM DATETIME Y The earliest documented date/time on which the patient arrived at the facility.
ARRIVAL_TIME_TXT VARCHAR(5) Y The earliest documented date the patient arrived at the facility. User Entered (Military format with or without colon, HH:MM)
ARRIVAL_UTC_DT_TM DATETIME Y The earliest documented date/time on which the patient arrived at the facility normalized to GMT.
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
COMPLETED_DT_TM DATETIME Y The Date and Time the abstracted case was completed
DECISION_ADMIT_DATE_TXT VARCHAR(10) Y The earliest documented month, day, and year of the decision to admit. User Entered (MM-DD-YYYY) Includes dashes
DECISION_ADMIT_DT_TM DATETIME Y The earliest documented month, day, and year of the decision to admit.
DECISION_ADMIT_TIME_TXT VARCHAR(5) Y The earliest documented time of the decision to admit. User Entered (Military format with or without colon, HH:MM)
DECISION_ADMIT_UTC_DT_TM DATETIME Y The earliest documented month, day, and year of the decision to admit normalized to GMT.
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged; normalized to GMT.
D_ADMIT_BUILDING_ID DOUBLE N The building to which the patient was admitted.
D_ADMIT_FACILITY_ID DOUBLE N The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted.
D_ADMIT_SRC_ID DOUBLE N Identifies the place from which the patient came before being admitted.
D_ADMIT_TYPE_ID DOUBLE N Indicates the circumstances under which the patient was admitted.
D_ATTEND_PRSNL_ID DOUBLE N Identifies the final attending physician associated to the encounter during the visit.
D_BR_CCN_ID DOUBLE N CMS Certification Number.
D_BR_HCO_ID DOUBLE N Healthcare organization Number.
D_DISCHARGE_BUILDING_ID DOUBLE N The building from which the patient was discharged
D_DISCHARGE_FACILITY_ID DOUBLE N The facility from which the patient was discharged
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type. Foreign key to the CODE_VALUE table.
D_MED_SERVICE_ID DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type, surgery, general resources, or others.
D_METRIC_10_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_11_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_12_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_13_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_14_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_15_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_16_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_17_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_18_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_19_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_1_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_20_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_2_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_3_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_4_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_5_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_6_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_7_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_8_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_METRIC_9_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the PERSON table.
ED1A_IND DOUBLE Y Identifies if the patient qualifies for ED-1 Overall Measure
ED1B_IND DOUBLE Y Identifies if the patient qualifies for ED-1 Reporting Measure
ED1C_IND DOUBLE Y Identifies if the patient qualifies for ED-1 Observation Measure
ED1D_IND DOUBLE Y Identifies if the patient qualifies for ED-1 Psych/Mental Measure
ED1_MEASUREMENT_VALUE DOUBLE Y Identifies the ED Length of Stay (days)
ED2A_IND DOUBLE Y Identifies if the patient qualifies for ED-2 Overall Measure
ED2B_IND DOUBLE Y Identifies if the patient qualifies for ED-2 Reporting Measure
ED2C_IND DOUBLE Y Identifies if the patient qualifies for ED-2 Psych/Mental Measure
ED2_MEASUREMENT_VALUE DOUBLE Y The amount of days between the decision to admit was placed and the ED Departure time
ED_1_REASON_TXT VARCHAR(250) Y Stores the category reason for ED-1 obtained during the completion of abstraction.
ED_2_REASON_TXT VARCHAR(250) Y Stores the category reason for ED-2 obtained during the completion of abstraction.
ED_DEPART_DATE_TXT VARCHAR(10) Y Date the patient departed from the emergency department. User Entered (MM-DD-YYYY) Includes dashes
ED_DEPART_DT_TM DATETIME Y Time the patient departed from the emergency department.
ED_DEPART_TIME_TXT VARCHAR(5) Y Time the patient departed from the emergency department. User Entered (Military format with or without colon, HH:MM)
ED_DEPART_UTC_DT_TM DATETIME Y Time the patient departed from the emergency department normalized to GMT.
ED_OBSERVATION_IND DOUBLE Y Documentation the patient was placed in observation services during the encounter or hospitalization
ED_PATIENT_IND DOUBLE Y The patient an ED patient at the facility
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXCLUDE_1_IND DOUBLE Y Identifies patients excluded from ED-1
EXCLUDE_2_IND DOUBLE Y Identifies patients excluded from ED-2
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.
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_ABS_ED_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_ED_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.
MENTAL_DISORDER_IND DOUBLE Y Identifies patients with a mental disorder listed as their principle diagnosis.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
OTH_DIAGNOSIS_LIST VARCHAR(250) Y A comma separated list of other diagnoses associated with the encounter.
OTH_PROCEDURE_DATES_LIST VARCHAR(275) Y A comma separated list of dates the other procedures associated with the encounter were performed.
OTH_PROCEDURE_LIST VARCHAR(250) Y A comma separated list of other procedures associated with the encounter.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PAYMENT_SOURCE_FLAG DOUBLE Y Identifies the source of payment for the encounter
PHYSICIAN_1_TXT VARCHAR(50) Y First physician identifier
PHYSICIAN_2_TXT VARCHAR(50) Y Second physician identifier
PRIN_DIAGNOSIS VARCHAR(10) Y Identifies the principle diagnosis associated with the encounter.
PRIN_PROCEDURE VARCHAR(10) Y Identifies the principle procedure associated with the encounter.
PRIN_PROCEDURE_DATE_TXT VARCHAR(10) Y The date on which the principle procedure was performed.
PRIN_PROCEDURE_DT_TM DATETIME Y The date/time on which the principle procedure was performed.
PRIN_PROCEDURE_UTC_DT_TM DATETIME Y The date/time on which the principle procedure was performed; normalized to GMT
REJECT_1_IND DOUBLE Y Identifies patients reject for ED-1
REJECT_2_IND DOUBLE Y Identifies patients reject for ED-2
SAMPLE_IND DOUBLE Y This case represent part of a sample
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_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_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_ABS_ED_METRICS


Child Column in LH_ABS_ED_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_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_MED_SERVICE_ID LH_D_MED_SERVICE D_MED_SERVICE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_MED_SERVICE HEALTH_SYSTEM_SOURCE_ID
D_METRIC_10_ID LH_D_METRIC D_METRIC_ID
D_METRIC_11_ID LH_D_METRIC D_METRIC_ID
D_METRIC_12_ID LH_D_METRIC D_METRIC_ID
D_METRIC_13_ID LH_D_METRIC D_METRIC_ID
D_METRIC_14_ID LH_D_METRIC D_METRIC_ID
D_METRIC_15_ID LH_D_METRIC D_METRIC_ID
D_METRIC_16_ID LH_D_METRIC D_METRIC_ID
D_METRIC_17_ID LH_D_METRIC D_METRIC_ID
D_METRIC_18_ID LH_D_METRIC D_METRIC_ID
D_METRIC_19_ID LH_D_METRIC D_METRIC_ID
D_METRIC_1_ID LH_D_METRIC D_METRIC_ID
D_METRIC_20_ID LH_D_METRIC D_METRIC_ID
D_METRIC_2_ID LH_D_METRIC D_METRIC_ID
D_METRIC_3_ID LH_D_METRIC D_METRIC_ID
D_METRIC_4_ID LH_D_METRIC D_METRIC_ID
D_METRIC_5_ID LH_D_METRIC D_METRIC_ID
D_METRIC_6_ID LH_D_METRIC D_METRIC_ID
D_METRIC_7_ID LH_D_METRIC D_METRIC_ID
D_METRIC_8_ID LH_D_METRIC D_METRIC_ID
D_METRIC_9_ID LH_D_METRIC D_METRIC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_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_ABS_GLOBAL_POP



Column Section Top of Page


Table-level Detail

Description: lh_abs_global_pop
Definition: Holds sampling information for global NHIQM conditions.
Table Type: ACTIVITY





Column Detail - LH_ABS_GLOBAL_POP


Column Name Type Null? Definition
DISCHARGE_DT_TM DATETIME Y dischg_dt_tm of the encounter
ENCNTR_ID DOUBLE N Encounter id of the encounter
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
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_ABS_GLOBAL_POP_ID DOUBLE N Unique generated number that identifies a single row on the lh_abs_global_pop table.
SAMPLE_IND DOUBLE Y Indicator representing whither the encounter is sampled
SAMPLE_MISMATCH_IND DOUBLE N This column indicates if the patient is Sampled for some Global Conditions but not all effective Global Conditions.
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.