Table Detail Report
LH_ABS_QUESTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_ABS_QUESTION |
Definition: | Questions that can be used for the Lighthouse Abstractor (eQuality Check) |
Table Type: | REFERENCE |
Column Detail - LH_ABS_QUESTION
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. |
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_QUESTION_KEY | VARCHAR(50) | Y | Get With The Guidelines question key |
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_QUESTION_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_ABS_QUESTION table. |
NHIQM_QUESTION_KEY | VARCHAR(50) | Y | NHIQM question_key |
QUESTION_KEY | VARCHAR(50) | Y | An identifier that uniquely identifies the question. |
QUESTION_TITLE | VARCHAR(200) | Y | Short description of the question. |
QUESTION_TXT | VARCHAR(4000) | Y | Full text of the Question |
RESPONSE_DATATYPE_FLAG | DOUBLE | Y | Identifies the expected datatype of the user's response to the question.1 = alphanumeric2 = date3 = time4 = numeric |
RESPONSE_OCCURRENCES | DOUBLE | Y | Specifies the maximum number of responses that can be given for the question. |
TIME_SENSITIVE_IND | DOUBLE | N | Identifies questions that are checked for time sensitive warnings. |
TJC_QUESTION_KEY | VARCHAR(50) | Y | The Joint Commission question key |
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. |
VERSION_TXT | VARCHAR(25) | Y | Specifies version of this question key |
Relationship Detail - LH_ABS_QUESTION
Parent Column in LH_ABS_QUESTION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | HEALTH_SYSTEM_SOURCE_ID | LH_ABS_ANSWER | HEALTH_SYSTEM_SOURCE_ID |
LH_ABS_QUESTION_ID | LH_ABS_ANSWER | LH_ABS_QUESTION_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_LAYOUT | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_QUESTION_ID | LH_ABS_LAYOUT | LH_ABS_QUESTION_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_RESPONSE | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_QUESTION_ID | LH_ABS_RESPONSE | LH_ABS_QUESTION_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_SPECIAL_SKIP_LOGIC | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_QUESTION_ID | LH_ABS_SPECIAL_SKIP_LOGIC | LH_ABS_QUESTION_ID |
LH_ABS_RESPONSE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_ABS_RESPONSE |
Definition: | Responses to abstraction question answered in the Lighthouse Abstractor (eQuality Check) |
Table Type: | ACTIVITY |
Column Detail - LH_ABS_RESPONSE
Column Name | Type | Null? | Definition |
---|---|---|---|
ANSWERED_DT_TM | DATETIME | Y | The date and time the question was answered |
ANSWER_CODE | VARCHAR(500) | Y | The user's response the question |
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. |
GROUP_VALUE | DOUBLE | N | A value used to group/link rows together. This value will be generated by our JavaScript (front-end) code. The rows which are not linked to any other row will get a GROUP_VALUE of 0. |
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_EVENTS_ID | DOUBLE | N | If the response is an hbips event, this column will tell us which event the response belongs to. |
LH_ABS_QUESTION_ID | DOUBLE | N | Identifies the Question that is being answered. Foreign key to LH_ABS_QUESTION. |
LH_ABS_RESPONSE_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_ABS_RESPONSE table. |
PERSON_ID | DOUBLE | N | Identifies the person that will be abstracted. Foreign key to the PERSON table. |
QUESTION_STATE_FLAG | DOUBLE | Y | A flag indicating status of a question. 0 - Blank, 1 - Populated but unmarked as done, 2 - Marked as completed (note this table can have multiple rows for a question. These should match within that group) |
SKIP_IND | DOUBLE | N | Identifies skipped questions in the abstractor. |
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 | The person_id of the user that answered the question. |
Relationship Detail - LH_ABS_RESPONSE
Child Column in LH_ABS_RESPONSE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | HEALTH_SYSTEM_SOURCE_ID | LH_ABS_HBIPS_EVENTS | HEALTH_SYSTEM_SOURCE_ID |
LH_ABS_HBIPS_EVENTS_ID | LH_ABS_HBIPS_EVENTS | LH_ABS_HBIPS_EVENTS_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_ABS_QUESTION | HEALTH_SYSTEM_SOURCE_ID | |
LH_ABS_QUESTION_ID | LH_ABS_QUESTION | LH_ABS_QUESTION_ID |
LH_ABS_SAMP_INFO
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_ABS_SAMP_INFO |
Definition: | Hold information about eqc/abstractor sampling. Total population size, CCN measure sampling, sample numbers |
Table Type: | ACTIVITY |
Column Detail - LH_ABS_SAMP_INFO
Column Name | Type | Null? | Definition |
---|---|---|---|
CATEGORY_MEAN | VARCHAR(100) | Y | The category_mean of the condition being documented |
D_BR_CCN_ID | DOUBLE | N | CMS Certification Number. |
D_BR_HCO_ID | DOUBLE | N | Healthcare organization Number. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was last loaded into the table. |
LH_ABS_SAMP_INFO_ID | DOUBLE | N | Primary key of this table |
MEDICARE_SAMP_CNT | DOUBLE | N | Sampled population for the CCN/Measure combination that is Medicare |
MEDICARE_TOTAL_CNT | DOUBLE | N | Total population for the CCN/Measure combination that is Medicare |
MONTH_DT_TM | DATETIME | Y | Month this sample was over |
NON_MEDICARE_SAMP_CNT | DOUBLE | N | Sampled population for the CCN/Measure combination that is non-Medicare |
NON_MEDICARE_TOTAL_CNT | DOUBLE | N | Total population for the CCN/Measure combination that is non-Medicare |
STRATUM_TXT | VARCHAR(50) | Y | If the documented data was tied to a condition's stratum, this holds that stratum |
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_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
UPDT_TASK_TXT | VARCHAR(50) | Y | The registered (assigned) task number for the process that inserted or updated the row. (TEXT FORMAT) |
Relationship Detail - LH_ABS_SAMP_INFO
Child Column in LH_ABS_SAMP_INFO(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | 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 |
LH_ABS_SCIP_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_ABS_SCIP_METRICS |
Definition: | This table is used to store SCIP metrics from the Lighthouse Abstractor (eQuality Check). This table is at the encounter grain. |
Table Type: | ACTIVITY |
Column Detail - LH_ABS_SCIP_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. |
ANESTENDDATE_TXT | VARCHAR(100) | Y | Date the Anesthesia EndUser Entered (MM-DD-YYYY) Includes dashes |
ANESTEND_DT_TM | DATETIME | Y | The earliest documented date/time on the anesthesia for the principal procedure end |
ANESTEND_UTC_DT_TM | DATETIME | Y | The earliest documented date/time on the anesthesia for the principal procedure end; normalized to GMT. |
ANESTHENDTIME_TXT | VARCHAR(100) | Y | Time the Anesthesia EndUser Entered (Military format with or without colon, HH:MM) |
ANESTSTARTDT_TXT | VARCHAR(100) | Y | Date the Anesthesia StartUser Entered (MM-DD-YYYY) Includes dashes |
ANESTSTARTTM_TXT | VARCHAR(100) | Y | Time the Anesthesia StartUser Entered (Military format with or without colon, HH:MM) |
ANESTSTART_DT_TM | DATETIME | Y | The earliest documented date/time on the anesthesia for the procedure start |
ANESTSTART_UTC_DT_TM | DATETIME | Y | The earliest documented date/time on the anesthesia for the procedure start; normalized to GMT. |
ANESTTYPE_FLAG | DOUBLE | Y | Identifies the patient has a documentation that the procedure was performed using general or neuraxial anesthesia. 1 - general anesthesia, 2 - neuraxial anesthesia, 3 - neuraxial and general anesthesia, 4 - either general or neuraxial anesthesia or unable to determine, 999 - Missing. |
ANTIALLERGY_FLAG | DOUBLE | Y | Identifies patients that have allergies, sensitivities or intolerance to beta-lactam/penicillin antibiotic or cephalosporin medications. 0 - No, 1 - Yes, 999 - Missing. |
ANTIBIRCVD_FLAG | DOUBLE | Y | Identifies the patient receive antibiotics within 24 hours of arrival or the day prior to arrival and/or during this hospital stay. 1 - Antibiotic received only within 24 hours of arrival or the day prior to arrival and not during hospital stay, 2 - Antibiotic received within 24 hours of arrival or the day prior to arrival and during hospital stay (arrival through 24 hours for PN and arrival through 48 hours postop [72 hours postop for CABG or Other Cardiac Surgery] for SCIP-Inf), 3 - Antibiotic |
BBLKRCURRENT_FLAG | DOUBLE | Y | Identifies the patient has a documentation of a daily beta-blocker therapy prior to arrival. 0 - No, 1 - Yes, 999 - Missing. |
BBLKRPERIOP_MASK | DOUBLE | Y | Identifies the patient received a beta blocker perioperatively. |
BBLKRPREG_FLAG | DOUBLE | Y | Identifies the patient is taking the beta-blocker prior to arrival pregnant. 0 - No, 1 - Yes, 999 - Missing. |
CATHREMOVE_FLAG | DOUBLE | Y | Identifies if the patient had the urinary catheter removed. 1 - There is documentation that the urinary catheter was removed on POD 0 through POD 2, 2 - There is no documentation that the urinary catheter was removed on POD 0 through POD 2, 3 - Unable to determine (UTD) from medical record documentation whether the urinary catheter was removed on POD 0 through POD 2, 999 - Missing. |
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. 0 - N0, 1 - Yes, 999 - Missing. |
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 |
CONTRAVTEPRO2_FLAG | DOUBLE | Y | Reason for Not Administering VTE Prophylaxis question flag |
CONTRAVTEPRO_FLAG | DOUBLE | Y | Identifies the patient has a reason documented for not administering pharmacological and/or mechanical VTE prophylaxis. 1 - There is physician/APN/PA or pharmacist documentation of a reason for not administering mechanical VTE prophylaxis, 2 - There is physician/APN/PA or pharmacist documentation of a reason for not administering pharmacological VTE prophylaxis, 3 - There is physician/APN/PA or pharmacist documentation of a reason for not administering both mechanical and pharmacological VTE pro |
CTRBBLKPERIOP_MASK | DOUBLE | Y | Reason(s) for Not Administering Beta-Blocker - Perioperative |
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. |
DTABX_LIST | VARCHAR(1000) | Y | A comma separated list of the date of antibiotic administered after hospital arrival and within the specified timeframe. User Entered (MM-DD-YYYY) Includes dashes |
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 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. |
D_PROC_GROUP_ID | DOUBLE | N | Identifies the surgical procedure group for which the visit qualifies. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EXCLUDE_CARD_2_IND | DOUBLE | Y | Identifies patients excluded from SCIP-CARD-2 |
EXCLUDE_INF_10_IND | DOUBLE | Y | Identifies patients excluded from SCIP-INF-10 |
EXCLUDE_INF_1_IND | DOUBLE | Y | Identifies patients excluded from SCIP-INF-1 |
EXCLUDE_INF_2_IND | DOUBLE | Y | Identifies patients excluded from SCIP-INF-2 |
EXCLUDE_INF_3_IND | DOUBLE | Y | Identifies patients excluded from SCIP-INF-3 |
EXCLUDE_INF_4_IND | DOUBLE | Y | Identifies patients excluded from SCIP-INF-4 |
EXCLUDE_INF_6_IND | DOUBLE | Y | Identifies patients excluded from SCIP-INF-6 |
EXCLUDE_INF_9_IND | DOUBLE | Y | Identifies patients excluded from SCIP-INF-9 |
EXCLUDE_VTE_1_IND | DOUBLE | Y | Identifies patients excluded from SCIP-VTE-1 |
EXCLUDE_VTE_2_IND | DOUBLE | Y | Identifies patients excluded from SCIP-VTE-2 |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | The financial number alias associated to the encounter. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
GLUCOSE_FLAG | DOUBLE | Y | Glucose question flag |
GLUPOD1_FLAG | DOUBLE | Y | Identifies patients with a controlled post-operative blood glucose level day 1. 0 - No, 1 - Yes, 999 - Missing. |
GLUPOD1_TXT | VARCHAR(100) | Y | Blood Glucose level on postoperative day one (POD 1) closest to 6:00 A.M. |
GLUPOD2_FLAG | DOUBLE | Y | Identifies patients with a controlled post-operative blood glucose level day 2. 0 - No, 1 - Yes, 999 - Missing. |
GLUPOD2_TXT | VARCHAR(10) | Y | Blood Glucose level on postoperative day one (POD 2) closest to 6:00 A.M. |
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. |
INFECPTA_FLAG | DOUBLE | Y | Identifies patients that had an infection during this hospitalization prior to the principal procedure. 0 - No, 1 - Yes, 999 - Missing. |
INTENTHYPO_FLAG | DOUBLE | Y | Identifies patients that had intentional hypothermia documented . 0 - No, 1 - Yes, 999 - Missing. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was last loaded into the table. |
LH_ABS_SCIP_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_ABS_SCIP_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. |
NAMEABX_LIST | VARCHAR(2000) | Y | A comma separated list of the names of the antibiotic dose(s) administered after hospital arrival and within the specified timeframe. 0 - No, 1 - Yes, 999 - Missing. |
NUMERATOR_CARD_2_IND | DOUBLE | Y | Identifies patients that qualify for SCIP-CARD-2 |
NUMERATOR_INF_10_IND | DOUBLE | Y | Identifies patients that qualify for SCIP-INF-10 |
NUMERATOR_INF_1_IND | DOUBLE | Y | Identifies patients that qualify for SCIP-INF-1 |
NUMERATOR_INF_2_IND | DOUBLE | Y | Identifies patients that qualify for SCIP-INF-2 |
NUMERATOR_INF_3_IND | DOUBLE | Y | Identifies patients that qualify for SCIP-INF-3 |
NUMERATOR_INF_4_IND | DOUBLE | Y | Identifies patients that qualify for SCIP-INF-4 |
NUMERATOR_INF_6_IND | DOUBLE | Y | Identifies patients that qualify for SCIP-INF-6 |
NUMERATOR_INF_9_IND | DOUBLE | Y | Identifies patients that qualify for SCIP-INF-9 |
NUMERATOR_VTE_1_IND | DOUBLE | Y | Identifies patients that qualify for SCIP-VTE-1 |
NUMERATOR_VTE_2_IND | DOUBLE | Y | Identifies patients that qualify for SCIP-VTE-2 |
ORALANTIBIOTIC_FLAG | DOUBLE | Y | Identifies color surgery patients that received oral antibiotics. 0 - No, 1 - Yes, 999 - Missing. |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
OTHERSURG_FLAG | DOUBLE | Y | Identifies patients that had other surgical procedures performed within days of the current procedure. 0 - No, 1 - Yes, 999 - Missing. |
OTH_DIAGNOSIS_LIST | VARCHAR(500) | Y | A comma separated list of other diagnoses associated with the encounter. |
OTH_PROCEDURE_DATES_LIST | VARCHAR(500) | Y | A comma separated list of dates the other procedures associated with the encounter were performed. |
OTH_PROCEDURE_LIST | VARCHAR(500) | Y | A comma separated list of other procedures associated with the encounter. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility |
PAYMENT_SOURCE_FLAG | DOUBLE | Y | Identifies the source of payment for the encounter. 1 -Source of payment is Medicare, 2 - Source of payment is Non-Medicare, 999 - Missing. |
PERIOPDEATH_FLAG | DOUBLE | Y | Identifies patients that suffered a perioperative death. 0 - No, 1 - Yes, 999 - Missing. |
PHYSICIAN_1_TXT | VARCHAR(50) | Y | First physician identifier. |
PHYSICIAN_2_TXT | VARCHAR(50) | Y | Second physician identifier. |
PREANTICOAG_FLAG | DOUBLE | Y | Identifies patients that had a document on continuous oral anticoagulation therapy prior to admission. 0 - No, 1 - Yes, 999 - Missing. |
PREOPHRREM_MASK | DOUBLE | Y | Method(s) of Preoperative Hair Removal |
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). |
REASONCNTCATH_MASK | DOUBLE | Y | Reason(s) for Continuing Urinary Catheterization |
REJECT_CARD_2_IND | DOUBLE | Y | Identifies patients reject for SCIP-CARD-2 |
REJECT_INF_10_IND | DOUBLE | Y | Identifies patients reject for SCIP-INF-10 |
REJECT_INF_1_IND | DOUBLE | Y | Identifies patients reject for SCIP-INF-1 |
REJECT_INF_2_IND | DOUBLE | Y | Identifies patients reject for SCIP-INF-2 |
REJECT_INF_3_IND | DOUBLE | Y | Identifies patients reject for SCIP-INF-3 |
REJECT_INF_4_IND | DOUBLE | Y | Identifies patients reject for SCIP-INF-4 |
REJECT_INF_6_IND | DOUBLE | Y | Identifies patients reject for SCIP-INF-6 |
REJECT_INF_9_IND | DOUBLE | Y | Identifies patients reject for SCIP-INF-9 |
REJECT_VTE_1_IND | DOUBLE | Y | Identifies patients reject for SCIP-VTE-1 |
REJECT_VTE_2_IND | DOUBLE | Y | Identifies patients reject for SCIP-VTE-2 |
ROUTEABX_LIST | VARCHAR(500) | Y | A comma separated list of the routes of the antibiotic dose(s) administered after hospital arrival and within the specified timeframe |
RSNEXTABX_MASK | DOUBLE | Y | Reason(s) to Extend Antibiotics |
SAMPLE_IND | DOUBLE | Y | This case represent part of a sample |
STRATUM_TITLE | VARCHAR(50) | Y | The stratum title of the condition. |
SURGINCISDT_TXT | VARCHAR(10) | Y | Date the Surgical IncisionUser Entered (MM-DD-YYYY) Includes dashes |
SURGINCISTM_TXT | VARCHAR(10) | Y | Time the Surgical IncisionUser Entered (HH-MM) Includes dashes |
SURGINCIS_DT_TM | DATETIME | Y | The incision date/time for the principal procedure made |
SURGINCIS_UTC_DT_TM | DATETIME | Y | The incision date/time for the principal procedure made ; normalized to GMT. |
TEMPERATURE_FLAG | DOUBLE | Y | Identifies how the temperature was controlled during surgery. 1 - Active warming was performed intraoperatively, 2 - There is documentation of at least one body temperature greater than or equal to 96.8 degrees Fahrenheit/36 degrees Celsius within the 30 minutes immediately prior to or the 15 minutes immediately after Anesthesia End Time, 3 - There is no documentation of Allowable Values 1 AND 2, 4 - Unable to determine from the medical record documentation, 999 - Missing. |
TMABX_LIST | VARCHAR(1000) | Y | A comma separated list of the time of antibiotic administered after hospital arrival and within the specified timeframe. User Entered (HH-MM) Includes dashes |
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 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. |
URINECATH_FLAG | DOUBLE | Y | Identifies the patient had a urinary catheter placed in the perioperative timeframe and that it was still in place at the time of discharge from the recovery/post-anesthesia care area. 0 - No, 1 - Yes, 999 - Missing. |
VANCO_MASK | DOUBLE | Y | Type(s) of using Vancomycin documented. |
VTETIMELY_MASK | DOUBLE | Y | Type(s) of VTE prophylaxis received within 24 hours prior to Anesthesia Start Time to 24 hours after Anesthesia End Time |
VTE_PROPHYLAXIS_MASK | DOUBLE | Y | Type(s) of VTE prophylaxis documented in the medical record |
Relationship Detail - LH_ABS_SCIP_METRICS
Child Column in LH_ABS_SCIP_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_PROC_GROUP_ID | LH_D_GROUP | D_GROUP_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_GROUP | 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_SCRATCHPAD
Column Section | Top of Page |
Table-level Detail
Description: | LH_ABS_SCRATCHPAD |
Definition: | Scratchpad entries for records being abstracted in the Lighthouse Abstractor (eQuality Check) |
Table Type: | ACTIVITY |
Column Detail - LH_ABS_SCRATCHPAD
Column Name | Type | Null? | Definition |
---|---|---|---|
ABS_DT_TM | DATETIME | Y | When the result was documented |
ABS_NAME | VARCHAR(75) | Y | Name of the result being entered |
ABS_NOTE | VARCHAR(255) | Y | Free text entry for note taking use |
ABS_VALUE | VARCHAR(250) | Y | What the value of the result was |
ADDED_DT_TM | DATETIME | Y | When this item was added by the system or front end user |
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 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_QUESTION_ID | DOUBLE | N | Identifies the Question that is being answered. Foreign key to LH_ABS_QUESTION. |
LH_ABS_SCRATCHPAD_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_ABS_SCRATCHPAD table. |
PARENT_ENTITY_ID | DOUBLE | N | The ID of the Order, Document, Result, etc¿ if not user-defined |
PARENT_ENTITY_NAME | VARCHAR(50) | Y | The table the entry came from if not user-defined |
SOURCE | VARCHAR(75) | Y | The general name of where this entry came from I.E. "Orders", "Documents". |
UPDT_CNT | DOUBLE | Y | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. |
UPDT_SOURCE | VARCHAR(50) | Y | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | Y | The registered (assigned) task number for the process that inserted or updated the row. |
USER_ID | DOUBLE | N | The person_id of the user that answered the question. |