Table Detail Report

LH_ABS_HBIPS_PATIENTS_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_ABS_HBIPS_PATIENTS_INFO
Definition: Contains additional information about cases present in the lh_abs_hbips_patients table
Table Type: ACTIVITY





Column Detail - LH_ABS_HBIPS_PATIENTS_INFO


Column Name Type Null? Definition
ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted.
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
D_BUILDING_ID DOUBLE N The building from which the patient was discharged.
D_FACILITY_ID DOUBLE N The facility from which the patient was discharged.
D_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged.
ENCNTR_ID DOUBLE N Identifies the encounter against which the psych days are associated. Foreign key to the ENCOUNTER table.
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_HBIPS_PATIENTS_INFO_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_HBIPS_PATIENTS_INFO table.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
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 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_HBIPS_PATIENTS_INFO


Child Column in LH_ABS_HBIPS_PATIENTS_INFO(FK) Parent Table Name Parent Column Name
Parents: D_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID


LH_ABS_HELP



Column Section Top of Page


Table-level Detail

Description: LH_ABS_HELP
Definition: Structure to define the help documentation for Lighthouse Abstractor (eQuality Check)
Table Type: REFERENCE





Column Detail - LH_ABS_HELP


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 Identifies the Category (i.e. Stroke, VTE, or ED Throughput). Foreign Key to BR_DATAMART_CATEGORY
DISPLAY VARCHAR(50) Y Help file's display text. This will only be present for top level help.
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 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.
HELP_FILENAME VARCHAR(100) Y Help file's file name
HELP_PATH VARCHAR(100) Y Relative directory text where the help file is residing
HELP_SEQ DOUBLE Y Assigns display order for the top level help files
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_ABS_HELP_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_HELP table.
LH_ABS_QUESTION_ID DOUBLE N The question which the help file is for. This has the potential to be null for top level help. Foreign Key to LH_ABS_QUESTION but can be null/0
LINK_TEXT VARCHAR(50) Y Help file's text to be used as a link.
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.


LH_ABS_HF_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_ABS_HF_METRICS
Definition: This table is used to store metrics for the NHIQM heart failure metrics. This table is at the encounter grain based upon the heart failure population definition.
Table Type: ACTIVITY





Column Detail - LH_ABS_HF_METRICS


Column Name Type Null? Definition
ACEIRXDCHG_FLAG DOUBLE Y Identifies if the patient was prescribed an ARB at discharge.
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.
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.
ARBRXDIS_FLAG DOUBLE Y Identifies if there is a valid reason documented for not prescribing an ACEI/ARB at discharge.
ARRIVAL_DT_TM DATETIME Y The date/time on which the patient arrived at the facility.
ARRIVAL_UTC_DT_TM DATETIME Y The date/time on which the patient arrived at the facility normalized to GMT.
CLINICAL_TRIAL_FLAG DOUBLE Y Identifies if a patient was excluded due to an order for comfort measures.
CMO_FLAG DOUBLE Y Identifies the discharge instructions provided to the patient to address activity.
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
CTRACEI_FLAG DOUBLE Y Identifies the patient's source of payment.
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 if the patient is excluded from the measure due to participation in a clinical trial.
DSINSTADAC_FLAG DOUBLE Y Identifies the discharge instructions provided to the patient to address diet.
DSINSTADDI_FLAG DOUBLE Y Identifies the discharge instructions provided to the patient to address follow up.
DSINSTADFU_FLAG DOUBLE Y Identifies the discharge instructions provided to the patient to address medications.
DSINSTADMD_FLAG DOUBLE Y Identifies the discharge instructions provided to the patient to address symptoms worsening.
DSINSTADSW_FLAG DOUBLE Y Identifies the discharge instructions provided to the patient to address weight monitoring.
DSINSTADWT_FLAG DOUBLE Y Identifies if the patient had an LVS function evaluation.
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.
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.
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_1_ID DOUBLE N Identifies the patient population associated with the HF2 metric.
D_METRIC_2_ID DOUBLE N Identifies the patient population associated with the HF3 metric.
D_METRIC_3_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.
D_PERSON_ID DOUBLE N The person that qualified for the quality metric.
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 HF-1
EXCLUDE_2_IND DOUBLE Y Identifies patients excluded from HF-2
EXCLUDE_3_IND DOUBLE Y Identifies patients excluded from HF-3
EXTRACT_DT_TM DATETIME 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.
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
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_HF_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_HF_METRICS table.
LOGICAL_DOMAIN_ID DOUBLE N Identifies the discharge disposition of the patient.
LVEFEVAL_FLAG DOUBLE Y Identifies if the patient was prescribed an ACEI at discharge.
LVSD_FLAG DOUBLE Y Identifies patients with an LVEF of moderate to severe.
NUMERATOR_1_IND DOUBLE Y Identifies patients that qualify for HF-1
NUMERATOR_2_IND DOUBLE Y Identifies patients that qualify for HF-2
NUMERATOR_3_IND DOUBLE Y Identifies patients that qualify for HF-3
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
OTH_DIAGNOSIS_LIST VARCHAR(400) Y The list of other non-principle diagnoses.
OTH_PROCEDURE_DATES_LIST VARCHAR(400) Y The list of dates for when the other non-principle procedures were performed.
OTH_PROCEDURE_LIST VARCHAR(400) Y The list of other non-principle procedures.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PAYMENT_SOURCE_FLAG DOUBLE Y The principle diagnosis.
PHYSICIAN_1_TXT VARCHAR(50) Y First physician identifier.
PHYSICIAN_2_TXT VARCHAR(50) Y Second physician identifier.
PRIN_DIAGNOSIS VARCHAR(10) Y The principle diagnosis.
PRIN_PROCEDURE VARCHAR(10) Y The principle procedure.
PRIN_PROCEDURE_DATE_TXT VARCHAR(10) Y The date/time 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_1_IND DOUBLE Y Identifies patients rejected from HF-1 due to missing data.
REJECT_2_IND DOUBLE Y Identifies patients rejected from HF-2 due to missing data.
REJECT_3_IND DOUBLE Y Identifies patients rejected from HF-3 due to missing data.
SAMPLE_IND DOUBLE Y Identifies if the patient is part of a sample.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_SOURCE VARCHAR(50) N The date/time that the record was extracted from the source system.
UPDT_TASK VARCHAR(50) N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - LH_ABS_HF_METRICS


Child Column in LH_ABS_HF_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_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_HOQR_AMI_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - LH_ABS_HOQR_AMI_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_DT_TM DATETIME Y The earliest documented date/time on which the patient arrived at the hospital.
ARRIVAL_TIME_TXT VARCHAR(10) Y The earliest documented time the patient arrived at the hospital. 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 hospital normalized to GMT.
ASPIRINRCVD_FLAG DOUBLE Y Identifies if the patient received Aspirin.
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
CTRASPRN_FLAG DOUBLE Y Identifies the patient has a documented reason for no Aspirin on arrival.
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_TXT VARCHAR(10) Y The patient's discharge disposition on the day of discharge.
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.
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.
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_1_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_PERSON_ID DOUBLE N The person that qualified for the quality metric.
ECGDONE_FLAG DOUBLE Y Identifies if the patient has an ECG performed.
ECGDT_TXT VARCHAR(10) Y Date of the initial ECG. User Entered (MM-DD-YYYY) Includes dashes
ECGTM_TXT VARCHAR(10) Y Time of the initial ECG. User Entered (Military format with or without colon, HH:MM)
ECG_DT_TM DATETIME Y The date/time of the initial ECG
ECG_UTC_DT_TM DATETIME Y The date/time of the ECG; normalized to GMT.
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(10) 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.
EMCODE VARCHAR(10) Y Identifies the patient E/M code documented
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXCLUDE_16_IND DOUBLE Y Identifies patients excluded from OP-16
EXCLUDE_1_IND DOUBLE Y Identifies patients excluded from OP-1, OP-2
EXCLUDE_3_IND DOUBLE Y Identifies patients excluded from OP-3
EXCLUDE_4_IND DOUBLE Y Identifies patients excluded from OP-4
EXCLUDE_5_IND DOUBLE Y Identifies patients excluded from OP-5
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FIBADMINDT_TXT VARCHAR(10) Y Date of the Fibrinolytic Administration. User Entered (MM-DD-YYYY) Includes dashes
FIBADMINTM_TXT VARCHAR(10) Y Time of the Fibrinolytic Administration. User Entered (Military format with or without colon, HH:MM)
FIBADMIN_DT_TM DATETIME Y The date/time of the Fibrinolytic Administration
FIBADMIN_FLAG DOUBLE Y Identifies if the patient has fibrinolytic administration.
FIBADMIN_UTC_DT_TM DATETIME Y The date/time of the Fibrinolytic Administration; normalized to GMT.
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.
INITECGINT_FLAG DOUBLE Y Identifies if the patient had an elevated ST or LBBB.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_ABS_HOQR_AMI_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_HOQR_AMI_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.
NUMERATOR_16_IND DOUBLE Y Identifies patients that qualify for OP-16
NUMERATOR_2_IND DOUBLE Y Identifies patients that qualify for OP-2
NUMERATOR_3A_IND DOUBLE Y Identifies patients that qualify for OP-3 overall rate
NUMERATOR_3B_IND DOUBLE Y Identifies patients that qualify for OP-3 Reporting Rate
NUMERATOR_3C_IND DOUBLE Y Identifies patients that qualify for OP-3 Quality Improvement Rate
NUMERATOR_4_IND DOUBLE Y Identifies patients that qualify for OP-4
OP1_MEASUREMENT_VALUE DOUBLE Y Identifies the time of fibrinolyisis (minutes)
OP2_REASON_TXT VARCHAR(250) Y Stores the category reason for OP-2 obtained during the completion of abstraction.
OP3_MEASUREMENT_VALUE DOUBLE Y Identifies the time in ED (minutes)
OP3_REASON_TXT VARCHAR(250) Y Stores the category reason for OP-3 obtained during the completion of abstraction.
OP5_MEASUREMENT_VALUE DOUBLE Y Identifies the time of ECG (minutes)
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.
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.
PRS_TXT VARCHAR(10) Y Identifies the Patient Reliability Score (PRS).
REASONDELFIB_FLAG DOUBLE Y Identifies the patient has a documented reason for a delay in initiating fibrinolytic therapy.
REASONNOFIBADMIN_FLAG DOUBLE Y Identifies the patient has a documented reason for not administering fibrinolytic therapy.
REJECT_16_IND DOUBLE Y Identifies patients reject for OP-16
REJECT_1_IND DOUBLE Y Identifies patients reject for OP-1, OP-2
REJECT_3_IND DOUBLE Y Identifies patients reject for OP-3
REJECT_4_IND DOUBLE Y Identifies patients reject for OP-4
REJECT_5_IND DOUBLE Y Identifies patients reject for OP-5
SAMPLE_IND DOUBLE Y This case represent part of a sample
TRANSFERCORINT_FLAG DOUBLE Y Identifies if the patient was transferred for acute coronary intervention is documented.
TROPORD_FLAG DOUBLE Y Identifies if the patient has troponin orders
TROPRESDT_TXT VARCHAR(10) Y Date of troponin order. User Entered (MM-DD-YYYY) Includes dashes
TROPRESTM_TXT VARCHAR(10) Y Time of troponin order. User Entered (Military format with or without colon, HH:MM)
TROPRES_DT_TM DATETIME Y The date/time of troponin order
TROPRES_UTC_DT_TM DATETIME Y The date/time of troponin order; normalized to GMT.
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_HOQR_AMI_METRICS


Child Column in LH_ABS_HOQR_AMI_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_1_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
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_HOQR_CATA_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: SCR_LH_ABS_HOQR_CATA_METRICS
Definition: Contains information based on HOQR OP-31: Appropriate Follow-up Interval for Normal Colonoscopy in Average Risk Patients condition for an encounters
Table Type: ACTIVITY





Column Detail - LH_ABS_HOQR_CATA_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 the abstracted case was completed
CPTCODE VARCHAR(10) Y Identify the CPT code is selected for the patient
CPTCODEDT_TXT VARCHAR(10) Y The date for CPT code performed. User Entered (MM-DD-YYYY) Includes dashes
CPTCODE_DESC_TXT VARCHAR(255) Y Textual description of the CPTCODE documented for the case
CPTCODE_DT_TM DATETIME Y The date/time on which CPT code performed.
CPTCODE_UTC_DT_TM DATETIME Y The The date/time on which CPT code performed. 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.
D_BR_CCN_ID DOUBLE N CMS Certification Number. Foreign key to the LH_D_BR_CCN
D_BR_HCO_ID DOUBLE N Healthcare organization Number. Foreign key to the LH_D_BR_HCO
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.
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_1_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_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the LH_D_PERSON
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
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_HOQR_CATA_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the SCR_LH_ABS_HOQR_CATA_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.
NUMERATOR_31_IND DOUBLE Y Identifies if this case meets the criteria to be 'met' or 'not met'
OP31_REASON_TXT VARCHAR(250) Y Stores the category reason obtained during the completion of abstraction.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PHYSICIAN_1_TXT VARCHAR(50) Y First physician identifier
PHYSICIAN_2_TXT VARCHAR(50) Y Second physician identifier
PRS_TXT VARCHAR(10) Y Identifies the Patient Reliability Score (PRS).
SAMPLE_IND DOUBLE Y Indicates if the case was sampled
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_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.
VSLFNCTNSRVY_FLAG DOUBLE Y Identifies if a pre and post operative visual function instrument was completed
VSLIMPRVMNT_FLAG DOUBLE Y Identifies if there was improvement in patients visual function within 90 days post cataract surgery



Relationship Detail - LH_ABS_HOQR_CATA_METRICS


Child Column in LH_ABS_HOQR_CATA_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_1_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
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