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.