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 |