LH_ABS_ADMIN



Column Section Top of Page


Table-level Detail

Description: LH_ABS_ADMIN
Definition: This table is used to store eQuality Check Admin settings
Table Type: REFERENCE





Column Detail - LH_ABS_ADMIN


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 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.
CATEGORY_MEAN VARCHAR(30) N The category meaning.
CONFIG_NAME VARCHAR(50) N The name used to identify the configuration setting.
CONFIG_VALUE VARCHAR(250) N The value of the configuration setting.
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.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_ABS_ADMIN_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_ADMIN table.
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 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) 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.


LH_ABS_AMI_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - LH_ABS_AMI_METRICS


Column Name Type Null? Definition
ACEIRXDCHG_FLAG DOUBLE Y Identifies if the patient was prescribed an ACEI at discharge
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.
ARBRXDIS_FLAG DOUBLE Y Identifies if the patient was prescribed an ARB at discharge
ARRIVAL_DATE_TXT VARCHAR(10) Y The earliest documented date the patient arrived at the hospital. User Entered (MM-DD-YYYY) Includes dashes
ARRIVAL_DT_TM DATETIME Y The date/time on which the patient arrived at the facility.
ARRIVAL_TIME_TXT VARCHAR(10) Y The earliest documented date the patient arrived at the hospital. User Entered (Military format with or without colon, HH:MM)
ARRIVAL_UTC_DT_TM DATETIME Y The date/time on which the patient arrived at the facility normalized to GMT.
ASPRN24RS_FLAG DOUBLE Y Identifies the patient received aspirin within 24 hours before or after hospital arrival.
ASPRNRXDIS_FLAG DOUBLE Y Identifies the patient was aspirin prescribed at discharge.
BBLKRRXDIS_FLAG DOUBLE Y Identifies if the patient was prescribed a beta blocker at discharge.
CLINICAL_TRIAL_FLAG DOUBLE Y During this hospital stay, the patient enrolled in a clinical trial in which patients with the same condition as the measure set were being studied
CMO_FLAG DOUBLE Y The earliest physician/APN/PA documentation of comfort measures only
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 if a patient has a documented reason for not prescribing BOTH ACEI and ARB at discharge.
CTRASPRNAR_FLAG DOUBLE Y Identifies if the patient has a documentation of a reason for not administering aspirin on arrival.
CTRASPRNDS_FLAG DOUBLE Y Identifies if the patient has a documentation of a reason for not prescribing aspirin at discharge.
CTRBBLKRDS_FLAG DOUBLE Y Identifies if a patient has a documented reason for not prescribing a beta-blocker at discharge.
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 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_DISCH_DISP_ID DOUBLE N The conditions under which the patient left the facility at the time of discharge.
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_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 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_10_IND DOUBLE Y Identifies patients excluded from AMI-10
EXCLUDE_1_IND DOUBLE Y Identifies patients excluded from AMI-1
EXCLUDE_2_IND DOUBLE Y Identifies patients excluded from AMI-2
EXCLUDE_3_IND DOUBLE Y Identifies patients excluded from AMI-3
EXCLUDE_5_IND DOUBLE Y Identifies patients excluded from AMI-5
EXCLUDE_7_IND DOUBLE Y Identifies patients excluded from AMI-7/7a
EXCLUDE_8_IND DOUBLE Y Identifies patients excluded from AMI-8/8a
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FIBADMINDT_TXT VARCHAR(10) Y Date the primary fibrinolytic therapy initiated. User Entered (MM-DD-YYYY) Includes dashes
FIBADMINTM_TXT VARCHAR(10) Y Time the primary fibrinolytic therapy initiated. User Entered (HH-MM) Includes dashes
FIBADMIN_DT_TM DATETIME Y The administration date/time of fibrinolytic therapy.
FIBADMIN_FLAG DOUBLE Y Identifies the patient received primary fibrinolytic therapy during this hospital stay.
FIBADMIN_UTC_DT_TM DATETIME Y The administration date/time of fibrinolytic therapy 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 a patient has a documentation of ST-segment elevation or LBBB on the ECG performed closest to hospital arrival.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LDLCLESSTHAN_FLAG DOUBLE Y Identifies if the patient had an LDL less than 100 within 24 hours of arrival or within 30 days prior to hospital arrival.
LH_ABS_AMI_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_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.
LVSD_FLAG DOUBLE Y Identifies patients with an LVEF of moderate to severe.
NONPRIPCI_FLAG DOUBLE Y Identifies if the first PCI is non-primary.
NUMERATOR_10_IND DOUBLE Y Identifies patients that qualify for AMI-10
NUMERATOR_1_IND DOUBLE Y Identifies patients that qualify for AMI-1
NUMERATOR_2_IND DOUBLE Y Identifies patients that qualify for AMI-2
NUMERATOR_3_IND DOUBLE Y Identifies patients that qualify for AMI-3
NUMERATOR_5_IND DOUBLE Y Identifies patients that qualify for AMI-5
NUMERATOR_7A_IND DOUBLE Y Identifies patients that qualify for AMI-7a
NUMERATOR_8A_IND DOUBLE Y Identifies patients that qualify for AMI-8a
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
PCIDT_TXT VARCHAR(10) Y Date of FIRST PCI .User Entered (MM-DD-YYYY) Includes dashes
PCITM_TXT VARCHAR(10) Y Time of FIRST PCI .User Entered (HH-MM) Includes dashes
PCI_DT_TM DATETIME Y The date/time of the first PCI.
PCI_PROC_IND DOUBLE Y Identifies patients with an ICD9 procedure of PCI.
PCI_UTC_DT_TM DATETIME Y The date/time of the first PCI normalized to GMT.
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
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 fibrinolytic therapy.
REASONDELPCI_FLAG DOUBLE Y Identifies the patient has a documented reason for a delay in the first PCI.
REJECT_10_IND DOUBLE Y Identifies patients reject for AMI-10
REJECT_1_IND DOUBLE Y Identifies patients reject for AMI-1
REJECT_2_IND DOUBLE Y Identifies patients reject for AMI-2
REJECT_3_IND DOUBLE Y Identifies patients reject for AMI-3
REJECT_5_IND DOUBLE Y Identifies patients reject for AMI-5
REJECT_7_IND DOUBLE Y Identifies patients reject for AMI-7/7a
REJECT_8_IND DOUBLE Y Identifies patients reject for AMI-8/8a
RSNNORXSTATIN_FLAG DOUBLE Y Identifies the patient has a documented reason for not prescribing a statin medication at discharge.
SAMPLE_IND DOUBLE Y This case represent part of a sample
STATINRXDS_FLAG DOUBLE Y Identifies if the patient was prescribed a a statin medication at discharge.
TRANSFERED_FLAG DOUBLE Y Identifies if a patient was transferred from another hospital or ASC.
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_AMI_METRICS


Child Column in LH_ABS_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_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_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_ANSWER



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_ABS_ANSWER
Definition: Answers that a user can select to questions of the Lighthouse Abstractor (eQuality Check)
Table Type: REFERENCE





Column Detail - LH_ABS_ANSWER


Column Name Type Null? Definition
ANSWER_CODE VARCHAR(50) Y The codified value of the answer. This will be that will be applied to submission files.
ANSWER_SEQ DOUBLE Y Defines the order that this Answer will presented to the user if multiple Answers are available for the Question
ANSWER_SUB_SEQ DOUBLE Y A Sub Answer sequence when ANSWER_SEQ is the same for QUESTION_KEY
ANSWER_VALUE VARCHAR(1000) Y Full text of the Answer
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.
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.
GWTG_ANSWER_CODE VARCHAR(50) Y Get With The Guidelines answer code
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_ANSWER_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_ANSWER table.
LH_ABS_QUESTION_ID DOUBLE N Identifies the Question that this response can be applied to. Foreign Key to LH_ABS_QUESTION
TJC_ANSWER_CODE VARCHAR(50) Y The Joint Commission answer code
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.



Relationship Detail - LH_ABS_ANSWER


Child Column in LH_ABS_ANSWER(FK) Parent Table Name Parent Column Name
Parents: HEALTH_SYSTEM_SOURCE_ID LH_ABS_QUESTION HEALTH_SYSTEM_SOURCE_ID
LH_ABS_QUESTION_ID LH_ABS_QUESTION LH_ABS_QUESTION_ID


LH_ABS_ATT_NOTES



Column Section Top of Page


Table-level Detail

Description: LH ABS ATT NOTES
Definition: Contains measure attribution notes made on eQC abstractions.
Table Type: ACTIVITY





Column Detail - LH_ABS_ATT_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 Identifies the category (i.e. Stroke, VTE, or ED Throughput). Foreign Key to BR_DATAMART_CATEGORY
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 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_ATT_NOTES_ID DOUBLE N PRIMARY KEY
METRIC_TXT VARCHAR(20) Y Identifies specific metric for category
NOTE_TXT VARCHAR(250) Y Text of attribution note
PRSNL2_ID DOUBLE N Holds the prsnl_id of the second abstractor attached to the attribution, if any.
PRSNL_ID DOUBLE N Holds the prsnl_id of the first abstractor attached to the attribution.
REASON_TXT VARCHAR(200) Y The Metric's category reason
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.
USER_ID DOUBLE N Identifies the user who created the note


LH_ABS_CAC_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_ABS_CAC_METRICS
Definition: This table is used to store metrics for the Abstractor Children's Asthma measure.
Table Type: ACTIVITY





Column Detail - LH_ABS_CAC_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 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 the patient is excluded from the measure due to participation in a clinical trial.
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
CTRREL_FLAG DOUBLE Y Identifies if there is a documented reason for not administering relievers
CTRSYSCST_FLAG DOUBLE Y Identifies if there is a documented reason for not administering corticosteroids
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 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 BR_CCN.
D_BR_HCO_ID DOUBLE N Healthcare organization Number. Foreign key to BR_HCO
D_DISCHARGE_BUILDING_ID DOUBLE N The building to which the patient was admitted.
D_DISCHARGE_FACILITY_ID DOUBLE N The facility to which the patient was admitted.
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted.
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 CAC1 metric.
D_METRIC_2_ID DOUBLE N Identifies the patient population associated with the CAC2 metric.
D_METRIC_3_ID DOUBLE N Identifies the patient population associated with the CAC3 metric.
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 CAC-1
EXCLUDE_2_IND DOUBLE Y Identifies patients excluded from CAC-2
EXCLUDE_3_IND DOUBLE Y Identifies patients excluded from CAC-3
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 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.
HMPADCTRLRS_FLAG DOUBLE Y Identifies if the HMP addresses use of controllers.
HMPADENVTRG_FLAG DOUBLE Y Identifies if the HMP addresses environmental control and control of other triggers.
HMPADFU_FLAG DOUBLE Y Identifies if the HMP addresses arrangements for follow-care.
HMPADREL_FLAG DOUBLE Y Identifies if the HMP addresses use of relievers.
HMPADRSCU_FLAG DOUBLE Y Identifies if the HMP addresses method and timing of rescue actions.
HMPDOCGVNPT_FLAG DOUBLE Y Identifies if the HMP was given to the patient.
HMPDOCPRES_FLAG DOUBLE Y Identifies if the HMP document is present.
LAST_PROCESS_DT_TM DATETIME Y The date/time the record was last loaded into the table.
LH_ABS_CAC_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_CAC_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_1_IND DOUBLE Y Identifies patients that qualify for CAC-1
NUMERATOR_2_IND DOUBLE Y Identifies patients that qualify for CAC-2
NUMERATOR_3_IND DOUBLE Y Identifies patients that qualify for CAC-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 Identifies the patient s source of payment.
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 CAC-1 due to missing data.
REJECT_2_IND DOUBLE Y Identifies patients rejected from CAC-2 due to missing data.
REJECT_3_IND DOUBLE Y Identifies patients rejected from CAC-3 due to missing data.
RELADMIN_FLAG DOUBLE Y Identifies if the patient had relievers administered
SAMPLE_IND DOUBLE Y Identifies if the patient is part of a sample.
STRATUM_TITLE VARCHAR(50) Y The stratum title of the condition.
SYSCSTADMIN_FLAG DOUBLE Y Identifies if corticosteroids were administered.
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_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) Y The date/time that the record was extracted from the source system.
UPDT_TASK VARCHAR(50) Y The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - LH_ABS_CAC_METRICS


Child Column in LH_ABS_CAC_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