Table Detail Report

LH_ABS_SECTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_ABS_SECTION
Definition: Defined groupings of Questions/Answers displayed in the Lighthouse Abstractor (eQuality Check)
Table Type: REFERENCE





Column Detail - LH_ABS_SECTION


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.
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_SECTION_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_SECTION table.
SECTION_DISPLAY VARCHAR(250) Y The description of the section that will be displayed in Abstractor
SECTION_MEANING VARCHAR(50) Y An identifier that uniquely identifies the section
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_SECTION




Parent Column in LH_ABS_SECTION (PK) Child Table Name Child Column Name
Children: HEALTH_SYSTEM_SOURCE_ID LH_ABS_LAYOUT HEALTH_SYSTEM_SOURCE_ID
LH_ABS_SECTION_ID LH_ABS_LAYOUT LH_ABS_SECTION_ID


LH_ABS_SEPSIS_METRICS



Column Section Top of Page


Table-level Detail

Description: LH_ABS_SEPSIS_METRICS
Definition: Contains information based on the Sepsis condition
Table Type: ACTIVITY





Column Detail - LH_ABS_SEPSIS_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.
ADMCONTRASHOCK_FLAG DOUBLE Y Identifies if there was administrative contraindication to care for septic shock. 1 - Yes - Documentation of refusal, 2 - Yes - Witnessed refusal, 3 - No - No documentation or witnessed refusal, 999 - Missing
ADMCONTRA_FLAG DOUBLE Y Identifies if there is documentation for administrative contraindication to care. 1 - Yes - Documentation of refusal, 2 - Yes - Witnessed refusal, 3 - No - No Documentation or Witnessed refusal, 999 - Missing
ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted.
ADMIT_DT_TXT VARCHAR(10) Y The date response on which the patient was admitted.
ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted; normalized to GMT.
ASSESS_FLD_MIN DOUBLE Y Crystalloid Fluid Assessment Timing
ASSESS_MIN DOUBLE Y Septic Shock Presentation Assessment Timing
BCCOLLECTDELAY_FLAG DOUBLE Y Identifies if there was an acceptable delay in collecting a blood culture. 1 - Yes, 2 - No or UTD, 999 - Missing
BCCOLLECTDT_TXT VARCHAR(10) Y The date response when blood culture collection was done
BCCOLLECTTM_TXT VARCHAR(10) Y The time response when blood culture collection was done
BCCOLLECT_DT_TM DATETIME Y The date/time blood culture collection was done
BCCOLLECT_FLAG DOUBLE Y Identifies if blood culture collection was done. 1 - Yes, 2 - No, 999 - Missing
BCCOLLECT_UTC_DT_TM DATETIME Y The date/time blood culture collection was done; normalized to GMT.
BED_ULTRA_FLD_MIN DOUBLE Y Bedside Ultrasound Fluid Time (in minutes)
BED_ULTRA_MIN DOUBLE Y Bedside Ultrasound Time (in minutes)
BLD_CULT_ABX_MIN DOUBLE Y Blood Culture Antibiotic Time (in minutes)
BLD_CULT_MIN DOUBLE Y Blood Culture Time (in minutes)
BRDABXADM_FLAG DOUBLE Y Identifies broad spectrum or other antibiotic administration was done, 1 - Yes, 2 - No, 999 - Missing
BRDABXDT_TXT VARCHAR(10) Y The date response when broad spectrum or other antibiotic administration was done
BRDABXSELECT_FLAG DOUBLE Y Identifies broad spectrum or other antibiotic administration selection. 1 - Yes, 2 - No, 999 - Missing
BRDABXTM_TXT VARCHAR(10) Y The time response when broad spectrum or other antibiotic administration was done
BRDABX_DT_TM DATETIME Y The date/time broad spectrum or other antibiotic administration was done was done
BRDABX_UTC_DT_TM DATETIME Y The date/time broad spectrum or other antibiotic administration was done was done; normalized to GMT.
BROAD_SPEC_ABX_MIN DOUBLE Y Broad Spectrum Antibiotic Time (in minutes)
BSCARDUSDT_TXT VARCHAR(10) Y The date response bedside cardiovascular ultrasound performed
BSCARDUSPER_FLAG DOUBLE Y Identifies bedside cardiovascular ultrasound performed. 1 - Yes, 2 - No, 999 - Missing
BSCARDUSTM_TXT VARCHAR(10) Y The time response bedside cardiovascular ultrasound performed
BSCARDUS_DT_TM DATETIME Y The date/time bedside cardiovascular ultrasound performed
BSCARDUS_UTC_DT_TM DATETIME Y The date/time bedside cardiovascular ultrasound performed; normalized to GMT.
CAP_REFILL_FLD_MIN DOUBLE Y Capillary Refill Fluid Time (in minutes)
CAP_REFILL_MIN DOUBLE Y Capillary Refill Time (in minutes)
CARDEVALDT_TXT VARCHAR(10) Y The date response cardiopulmonary evaluation performed
CARDEVALPERF_FLAG DOUBLE Y Initial cardiopulmonary evaluation performed. 1 - Yes, 2 - No, 999 - Missing
CARDEVALTM_TXT VARCHAR(10) Y The time response cardiopulmonary evaluation performed
CARDEVAL_DT_TM DATETIME Y The date/time cardiopulmonary evaluation performed
CARDEVAL_UTC_DT_TM DATETIME Y The date/time cardiopulmonary evaluation performed; normalized to GMT.
CARDIO_EVAL_FLD_MIN DOUBLE Y Cardiopulmonary Evaluation Fluid Time (in minutes)
CARDIO_EVAL_MIN DOUBLE Y Cardiopulmonary Evaluation Time (in minutes)
CEN_VEN_OXY_FLD_MIN DOUBLE Y Central Venous Oxygen Fluid Time (in minutes)
CEN_VEN_OXY_MIN DOUBLE Y Central Venous Oxygen Time (in minutes)
CEN_VEN_PRES_FLD_MIN DOUBLE Y Central Venous Pressure Fluid Time (in minutes)
CEN_VEN_PRES_MIN DOUBLE Y Central Venous Pressure Time (in minutes)
CFADMINDT_TXT VARCHAR(10) Y The date response crystalloid fluid administration was initiated
CFADMINTM_TXT VARCHAR(10) Y The time response crystalloid fluid administration was initiated
CFADMIN_DT_TM DATETIME Y The date/time when crystalloid fluid administration was initiated
CFADMIN_FLAG DOUBLE Y Identifies crystalloid fluid administration. 1 - Yes - Volume order was 30 mL/kg, 2 - Yes - Volume order less than 30 mL/kg OR UTD, 3 - No - Not Administered or UTD, 999 - Missing
CFADMIN_UTC_DT_TM DATETIME Y The date/time when crystalloid fluid administration was initiated; normalized to GMT.
CLINICAL_TRIAL_IND DOUBLE Y During this hospital stay, was the patient enrolled in a clinical trial in which patients with the same condition as the measure set were being studied. 0 - No, 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
CREXAMDT_TXT VARCHAR(10) Y The date response capillary refill examination performed
CREXAMPERF_FLAG DOUBLE Y Identifies capillary refill examination performed. 1 - Yes, 2 - No, 999 - Missing
CREXAMTM_TXT VARCHAR(10) Y The time response capillary refill examination performed
CREXAM_DT_TM DATETIME Y The date/time capillary refill examination performed
CREXAM_UTC_DT_TM DATETIME Y The date/time capillary refill examination performed; normalized to GMT
CRYSTAL_FLD_ADMIN_MIN DOUBLE Y Crystalloid Fluid Admin Time (in minutes)
CVOXYDT_TXT VARCHAR(10) Y The date response central venous oxygen measurement
CVOXYTM_TXT VARCHAR(10) Y The time response central venous oxygen measurement
CVOXY_DT_TM DATETIME Y The date/time central venous oxygen measurement
CVOXY_FLAG DOUBLE Y Identifies central venous oxygen measurement. 1 - Yes, 2 - No, 999 - Missing
CVOXY_UTC_DT_TM DATETIME Y The date/time central venous oxygen measurement; normalized to GMT.
CVPDT_TXT VARCHAR(10) Y The date response central venous pressure measurement
CVPTM_TXT VARCHAR(10) Y The time response central venous pressure measurement
CVP_DT_TM DATETIME Y The date/time central venous pressure measurement
CVP_FLAG DOUBLE Y Identifies central venous pressure measurement
CVP_UTC_DT_TM DATETIME Y The date/time central venous pressure measurement; normalized to GMT.
DIRCCSEPSIS_FLAG DOUBLE Y Identifies if directive for comfort care for severe sepsis was given. 1 - Yes, 2 - No, 999 - Missing
DIRCCSHOCK_FLAG DOUBLE Y Identifies if directive for comfort care for septic shock was given. 1 - Yes, 2 - No, 999 - Missing
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_DT_TXT VARCHAR(10) Y The date response on which the patient was discharged
DISCHARGE_TM_TXT VARCHAR(10) Y The time response 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 discharge disposition on the day of discharge.1 - Home, 2 - Hospice - Home, 3 - Hospice - Health Care Facility, 4 - Acute Care Facility, 5 - Other Health Care Facility, 6 - Expired, 7 - Left Against Medical Advice/AMA, 8 - Not Documented or UTD, 999 - Missing
DOCSEPSHOCK_FLAG DOUBLE Y Indicates if septic shock was documented. 1 - Yes, 2 - No, 999 - Missing
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 LH_D_BR_CCN
D_BR_HCO_ID DOUBLE N Healthcare organization Number. Foreign key to LH_D_BR_HCO
D_DISCHARGE_BUILDING_ID DOUBLE N The building from which the patient was discharged
D_DISCHARGE_FACILITY_ID DOUBLE N The facility from which the patient was discharged
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged
D_DISCH_DISP_ID DOUBLE N The conditions under which the patient left the facility at the time of discharge. Foreign key to LH_D_DISCH_DISP
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type.
D_MED_SERVICE_ID DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others.
D_METRIC_1_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the LH_D_PERSON
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
ETHNICITY_FLAG DOUBLE Y Identifies the patient has an ethnicity documented. 1 - Yes, 2 - No, 999 - Missing
EXCLUDE_1_IND DOUBLE Y Identifies if a patient was excluded from SEP-1
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
FLCHALDT_TXT VARCHAR(10) Y The date response fluid challenge performed
FLCHALPERF_FLAG DOUBLE Y Identifies fluid challenge performed.1 - Yes, 2 - No, 999 - Missing
FLCHALTM_TXT VARCHAR(10) Y The time response fluid challenge performed
FLCHAL_DT_TM DATETIME Y The date/time fluid challenge performed
FLCHAL_UTC_DT_TM DATETIME Y The date/time fluid challenge performed; normalized to GMT.
FLD_CHALL_FLD_MIN DOUBLE Y Fluid Challenge Fluid Time (in minutes)
FLD_SHOCK_MIN DOUBLE Y Fluid Shock Time (in minutes)
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.
HICNUMBER VARCHAR(20) Y Identifies the patient has a HIC number documented
HYPOTENSION_FLAG DOUBLE Y Identifies persistent hypotension.1 - Yes, 2 - No - Not Present, 3 - No - Not Assessed or Unable to Determine, 4 - Not Applicable, 999 - Missing
INHYPODT_TXT VARCHAR(10) Y Initial Hypotension Date Response
INHYPOTM_TXT VARCHAR(10) Y Initial Hypotension Time Response
INHYPO_DT_TM DATETIME Y Standard Time conversion of Initial Hypotension Date/Time
INHYPO_FLD_MIN DOUBLE Y Initial Hypotension Fluid Timing
INHYPO_UTC_DT_TM DATETIME Y UTC Time conversion of Initial Hypotension Date/Time
INITHYPOTENSION_FLAG DOUBLE Y Indicates if initial hypotension was present. 1 - Yes, 2 - No, 999 - Missing
INITLLCOLL_FLAG DOUBLE Y Identifies if initial lactate level collection was done. 1 - Yes, 2 - No, 999 - Missing
INITLLDT_TXT VARCHAR(10) Y The date response of initial lactate level collection
INITLLRES_FLAG DOUBLE Y Identifies initial lactate level result. 1 - <= 2.0, 2 - >2.0 and < 4.0, 3 - >= 4.0, 999 - Missing
INITLLTM_TXT VARCHAR(10) Y The time response of initial lactate level collection
INITLL_DT_TM DATETIME Y The date/time initial lactate level collection happened
INITLL_UTC_DT_TM DATETIME Y The date/time initial lactate level collection happened; normalized to GMT.
INIT_LACTATE_MIN DOUBLE Y Initial Lactate Time (in minutes)
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_ABS_SEPSIS_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_SEPSIS_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 if a patient qualifies to be met/not met for SEP-1
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
OTH_DIAGNOSIS_LIST VARCHAR(400) Y A comma separated list of other diagnoses associated with the encounter.
OTH_PROCEDURE_DATES_LIST VARCHAR(400) Y A comma separated list of dates the other procedures associated with the encounter were performed
OTH_PROCEDURE_LIST VARCHAR(400) 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
PASSLEGDT_TXT VARCHAR(10) Y The date response passive leg raise exam performed
PASSLEGPERF_FLAG DOUBLE Y Identifies passive leg raise exam performed. 1 - Yes, 2 - No, 999 - Missing
PASSLEGTM_TXT VARCHAR(10) Y The time response passive leg raise exam performed
PASSLEG_DT_TM DATETIME Y The date/time passive leg raise exam performed
PASSLEG_UTC_DT_TM DATETIME Y The date/time passive leg raise exam performed; normalized to GMT.
PASS_LEG_RAISE_FLD_MIN DOUBLE Y Passive Leg Raise Fluid Time (in minutes)
PASS_LEG_RAISE_MIN DOUBLE Y Passive Leg Raise Time (in minutes)
PAYMENT_SOURCE_FLAG DOUBLE Y Identifies the patient has a payment source documented. 1 - Medicare, 2 - Non-Medicare, 999 - Missing
PERIP_PULSE_FLD_MIN DOUBLE Y Peripheral Pulse Fluid Time (in minutes)
PERIP_PULSE_MIN DOUBLE Y Peripheral Pulse Time (in minutes)
PHYSICIAN_1_TXT VARCHAR(50) Y First physician identifier
PHYSICIAN_2_TXT VARCHAR(50) Y Second physician identifier
POSTAL_CODE VARCHAR(20) Y Identifies the patient has a postal code documented
PPEVALDT_TXT VARCHAR(10) Y The date response peripheral pulse evaluation performed
PPEVALPERF_FLAG DOUBLE Y Identifies peripheral pulse evaluation performed. 1 - Yes, 2 - No, 999 - Missing
PPEVALTM_TXT VARCHAR(10) Y The time response peripheral pulse evaluation performed
PPEVAL_DT_TM DATETIME Y The date/time peripheral pulse evaluation performed
PPEVAL_UTC_DT_TM DATETIME Y The date/time peripheral pulse evaluation performed; normalized to GMT.
PREGNANT_FLAG DOUBLE Y Designates if user has noted that patient is pregnant or not. 1 - Pregnant, 2 - Not Pregnant, 999 - User has not given any response. A NULL value will be on rows that existed before this question was available to the user.
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 Identifies the principle procedure response
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)
RACE_FLAG DOUBLE Y Identifies the patient has a race documented. 1 - White, 2 - Black or African American, 3 - American Indian or Alaska Native, 4 - Asian, 5 - Native Hawaiian or Pacific Islander, 6 - RETIRED VALUE, 7 - UTD (Unable to determine), 999 - Missing
REJECT_1_IND DOUBLE Y Identifies if a patient was rejected for SEP-1
REPEATLLCOLL_FLAG DOUBLE Y Identifies initial lactate Level collection.1 - Yes, 2 - No, 999 - Missing
REPEATLLDT_TXT VARCHAR(10) Y The date response when initial lactate level was drawn
REPEATLLTM_TXT VARCHAR(10) Y The time response when initial lactate level was drawn
REPEATLL_DT_TM DATETIME Y The date/time when initial lactate level was drawn
REPEATLL_UTC_DT_TM DATETIME Y The date/time when initial lactate level was drawn; normalized to GMT.
REPEATVSDT_TXT VARCHAR(10) Y Repeat Volume and Tissue Perfusion Assessment Performed Date Response
REPEATVSTM_TXT VARCHAR(10) Y Repeat Volume and Tissue Perfusion Assessment Performed Time Response
REPEATVS_DT_TM DATETIME Y Standard Time conversion of Repeat Volume and Tissue Perfusion Assessment
REPEATVS_FLAG DOUBLE Y Repeat Volume and Tissue Perfusion Assessment Performed Answer.0 - No, 1 - Yes, 999 - Unanswered
REPEATVS_UTC_DT_TM DATETIME Y UTC Time conversion of Repeat Volume and Tissue Perfusion Assessment
RPT_LACTATE_MIN DOUBLE Y Repeat Lactate Time (in minutes)
SAMPLE_IND DOUBLE Y Indicates if the case was sampled
SEP1_REASON_TXT VARCHAR(250) Y Stores the category reason obtained during the completion of abstraction.
SEPSISPRESDT_TXT VARCHAR(10) Y The date response on which sepsis was present
SEPSISPRESTM_TXT VARCHAR(10) Y The time response on which sepsis was present
SEPSISPRES_DT_TM DATETIME Y The date/time on which sepsis was present.
SEPSISPRES_FLAG DOUBLE Y Identifies if severe sepsis was present.1 - Yes, 2 - No, 999 - Missing
SEPSISPRES_UTC_DT_TM DATETIME Y The date/time on which sepsis was present; normalized to GMT.
SEPSIS_3HR_CNT DOUBLE Y Sepsis three hour counter
SEPSIS_6HR_CNT DOUBLE Y Sepsis six hour counter
SEPSIS_EXPIRED_MIN DOUBLE Y Sepsis Expired Time (in minutes)
SHOCKPRESDT_TXT VARCHAR(10) Y The date response septic shock was present
SHOCKPRESTM_TXT VARCHAR(10) Y The time response septic shock was present
SHOCKPRES_DT_TM DATETIME Y The date/time when septic shock was present
SHOCKPRES_FLAG DOUBLE Y Identifies if septic shock present.1 - Yes, 2 - No, 999 - Missing
SHOCKPRES_UTC_DT_TM DATETIME Y The date/time when septic shock was present; normalized to GMT.
SHOCK_3HR_CNT DOUBLE Y Shock three hour counter
SHOCK_6HR_CNT DOUBLE Y Shock six hour counter
SHOCK_EXP_MIN DOUBLE Y Shock Expired Time (in minutes)
SHOCK_PA_6HR_CNT DOUBLE Y Shock physical assessment six hour counter
SHOCK_PRES_MIN DOUBLE Y Shock Presentation Time (in minutes)
SHOCK_VASO_6HR_CNT DOUBLE Y Shock vasopressor six hour counter.
SKINEXAMDT_TXT VARCHAR(10) Y The date response skin examination performed
SKINEXAMPERF_FLAG DOUBLE Y Identifies skin examination performed.1 - Yes, 2 - No, 999 - Missing
SKINEXAMTM_TXT VARCHAR(10) Y The time response skin examination performed
SKINEXAM_DT_TM DATETIME Y The date/time skin examination performed
SKINEXAM_UTC_DT_TM DATETIME Y The date/time skin examination performed; normalized to GMT.
SKIN_EXAM_FLD_MIN DOUBLE Y Skin Exam Fluid Time (in minutes)
SKIN_EXAM_MIN DOUBLE Y Skin Exam Time (in minutes)
TRANSFERED_FLAG DOUBLE Y Identifies if a patient was transferred from another hospital or ASC. 0 - TBD, 1 - Yes, 2 - No, 999 - Missing
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_SOURCE VARCHAR(50) Y The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) Y The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VASOADMINDT_TXT VARCHAR(10) Y The date response of vasopressor administration
VASOADMINTM_TXT VARCHAR(10) Y The time response of vasopressor administration
VASOADMIN_DT_TM DATETIME Y The date/time of vasopressor administration
VASOADMIN_FLAG DOUBLE Y Identifies if vasopressor administration was done. 1 - Yes, 2 - No, 999 - Missing
VASOADMIN_UTC_DT_TM DATETIME Y The date/time of vasopressor administration; normalized to GMT.
VASO_MIN DOUBLE Y Vasopressor Time (in minutes)
VITAL_SIGNS_FLD_MIN DOUBLE Y Vital Signs Fluid Time (in minutes)
VITAL_SIGNS_MIN DOUBLE Y Vital Signs Time (in minutes)
VSREVIEWDT_TXT VARCHAR(10) Y The date response vital signs review was performed
VSREVIEWPERF_FLAG DOUBLE Y Identifies vital signs review performed.1 - Yes, 2 - No, 999 - Missing
VSREVIEWTM_TXT VARCHAR(10) Y The time response vital signs review was performed
VSREVIEW_DT_TM DATETIME Y The date/time vital signs review was performed
VSREVIEW_UTC_DT_TM DATETIME Y The date/time vital signs review was performed; normalized to GMT.


LH_ABS_SKIP_LOGIC



Column Section Top of Page


Table-level Detail

Description: LH_ABS_SKIP_LOGIC
Definition: Structure to define the Skip Logic for Lighthouse Abstractor (eQuality Check)
Table Type: REFERENCE





Column Detail - LH_ABS_SKIP_LOGIC


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
COND_ANSWER_ID DOUBLE N The Conditional Answer for cond_question_id that will cause the lh_abs_question_id to be skipped.Foreign Key to LH_ABS_ANSWER
COND_QUESTION_ID DOUBLE N The Conditional Question that when paired with cond_answer_id will cause the lh_abs_question_id to be skipped.Foreign Key to LH_ABS_QUESTION
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.
GROUP_SEQ DOUBLE Y Conditions that should be evaluated as AND conditions will contain the same group_seq. All conditions with a unique group_seq will be evaluated as ORs.
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 The question which the cond_question_id and cond_answer_id are evaluating for.Foreign Key to LH_ABS_QUESTION
LH_ABS_SKIP_LOGIC_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_SKIP_LOGIC table.
NOT_IND DOUBLE N Identifies when logic should be inverted
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.


LH_ABS_SMD_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_ABS_SMD_METRICS
Definition: Contains information for the Screening for Metabolic Disorders IPFQR condition
Table Type: ACTIVITY





Column Detail - LH_ABS_SMD_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.
BMI_FLAG DOUBLE Y Identifies if BMI was documented in the patient's medical record
BP_FLAG DOUBLE Y Identifies if blood pressure was documented in the patient's medical record
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
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 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. Foreign key to the LH_D_BR_CCN
D_BR_HCO_ID DOUBLE N Healthcare organization Number. Foreign key to the LH_D_BR_HCO
D_DISCHARGE_BUILDING_ID DOUBLE N The building from which the patient was discharged
D_DISCHARGE_FACILITY_ID DOUBLE N The facility from which the patient was discharged
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type.
D_MED_SERVICE_ID DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others.
D_METRIC_1_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the LH_D_PERSON
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXCLUDE_1_IND DOUBLE Y Identifies if this case meets the criteria to be 'excluded' for the Screening for Metabolic Disorders metric.
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
GLUCOSE_FLAG DOUBLE Y Identifies if blood glucose was documented in the patient's medical 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_SMD_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_SMD_METRICS table.
LIPID_FLAG DOUBLE Y Identifies if a lipid panel was documented in the patient's medical record
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 if this case meets the criteria to be 'met' or 'not met' for the Screening for Metabolic Disorders metric.
NUM_PSYCH_MED VARCHAR(10) Y Indicates the number of antipsychotic medications prescribed for the patient at discharge
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(400) Y A comma separated list of dates the other procedures associated with the encounter were performed.
OTH_PROCEDURE_LIST VARCHAR(400) 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.
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)
PSYCHSETNG_FLAG DOUBLE Y Identifies if there is a response for Psychiatric Care Setting. 0 - No, 1 - Yes, 999 - Missing.
REJECT_1_IND DOUBLE Y Identifies if this case meets the criteria to be 'rejected' for the Screening for Metabolic Disorders metric.
RSNINCOMPMS_FLAG DOUBLE Y Identifies if a reason for not performing a metabolic screening was documented in the patient's medical record
SAMPLE_IND DOUBLE Y Indicates if the case was sampled
SMD1_REASON_TXT VARCHAR(250) Y Stores the category reason obtained during the completion of abstraction.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_SOURCE VARCHAR(50) Y The script name responsible for updating the reecord.
UPDT_TASK VARCHAR(50) Y The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - LH_ABS_SMD_METRICS


Child Column in LH_ABS_SMD_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_ADMIT_SRC_ID LH_D_ADMIT_SRC D_ADMIT_SRC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_SRC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_TYPE_ID LH_D_ADMIT_TYPE D_ADMIT_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_TYPE HEALTH_SYSTEM_SOURCE_ID
D_BR_CCN_ID LH_D_BR_CCN D_BR_CCN_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_CCN HEALTH_SYSTEM_SOURCE_ID
D_BR_HCO_ID LH_D_BR_HCO D_BR_HCO_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_HCO HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_MED_SERVICE_ID LH_D_MED_SERVICE D_MED_SERVICE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_MED_SERVICE HEALTH_SYSTEM_SOURCE_ID
D_METRIC_1_ID LH_D_METRIC D_METRIC_ID
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_SPECIAL_SKIP_LOGIC



Column Section Relationship Section Top of Page


Table-level Detail

Description: lh_abs_special_skip_logic
Definition: Holds skip information for special skip cases
Table Type: REFERENCE





Column Detail - LH_ABS_SPECIAL_SKIP_LOGIC


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 Category_id the skip logic belongs to
CHECK_KEY VARCHAR(30) N Identifier to group a given skip logic
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_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 Question that is skipped in the logic case
LH_ABS_SPECIAL_SKIP_LOGIC_ID DOUBLE N Unique generated number that identifies a single row on the lh_abs_special_skip_logic 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.
LOGIC_TYPE VARCHAR(30) N Type of logic
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_SPECIAL_SKIP_LOGIC


Child Column in LH_ABS_SPECIAL_SKIP_LOGIC(FK) Parent Table Name Parent Column Name
Parents: BR_DATAMART_CATEGORY_ID BR_DATAMART_CATEGORY BR_DATAMART_CATEGORY_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_QUESTION HEALTH_SYSTEM_SOURCE_ID
LH_ABS_QUESTION_ID LH_ABS_QUESTION LH_ABS_QUESTION_ID