Table Detail Report

LH_CNT_IC_PAT_ORGANISM



Column Section Top of Page


Table-level Detail

Description: Lighthouse Content Infection control Patient Organisms
Definition: This table will contain a list of organisms corresponding to each lab entry in LH_CNT_IC_PATIENT_LAB.
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_PAT_ORGANISM


Column Name Type Null? Definition
EVENT_ID DOUBLE N The event id associated with the microbiology result.
LH_CNT_IC_PAT_ORGANISM_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_PAT_LAB_ORGANISM table.
MICRO_SEQ_NBR DOUBLE N Defines uniqueness in cases with multiple micro records per clinical event.
ORGANISM_CD DOUBLE N Code value of the organism.
ORGANISM_DESCRIPTION VARCHAR(80) N The description of the organism including occurrence number, causing infection.
ORGANISM_OCCURRENCE_NBR DOUBLE N A unique number to identify parts of the same organism.
PARENT_ENTITY_ID DOUBLE N Id row from the Parent Entity table.
PARENT_ENTITY_NAME VARCHAR(30) N Name of the Parent Entity Table
UPDT_APPLCTX DOUBLE N The application context number from the record info block. 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_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE 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_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VALID_UNTIL_DT_TM DATETIME N The date time until which the ce_microbiology result is valid.


LH_CNT_IC_RPT_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_IC_RPT_EVENT
Definition: This table will store Lighthouse Content Report data.
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_RPT_EVENT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
CE_DYNAMIC_LABEL_ID DOUBLE N The dynamic label is a grouper id for the dynamic groups documented on the clinical event table.
DISCONTINUE_DT_TM DATETIME Y The date and time the line was removed. From the clinical event tables, event_end_dt_tm.
ENCNTR_ID DOUBLE N The encounter id on lh_cnt_ic_rpt_event relates to the encounter table.
EVENT_CD DOUBLE N The event cd on the lh_cnt_ic_rpt_event relates to the clinical event documented on the patient.
EVENT_DT_TM DATETIME Y The event date time is the date and time the event was documented from the clinical event table
EVENT_ID DOUBLE N The event id on the lh_cnt_ic_rpt_event relates to the clinical event table.
EVENT_TYPE_FLAG DOUBLE N The event type flag is an identifier for the type of event.1=Contact Person,2=Contact Method,3=Contact Agency,4 =Contact Date,5=Condition,6=Device Type,7=Device Location,8=Device Line Care,9=Device Vent Mode,10=Blood Pressure,11=Device Description,12=Device Laterality,13=Device Insert/Start,14 = Device,Discontinue/End,15=Birthweight,16=Present on Admission,20=Central line,21=Arterial line,22=PA line,23=LA line,24=IA Balloon Pump,25=Peripheral line,26=Chest Tube,27=Gastric Tube,28-35....
INSERT_DT_TM DATETIME Y The date and time the line was inserted. From the clinical event tables, event_end_dt_tm.
LH_CNT_IC_RPT_EVENT_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_RPT_EVENT table.
RESULT_DISPLAY VARCHAR(255) Y The result display is the text version of the results documented on events on the clinical event table.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. 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_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE 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_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - LH_CNT_IC_RPT_EVENT


Child Column in LH_CNT_IC_RPT_EVENT(FK) Parent Table Name Parent Column Name
Parents: CE_DYNAMIC_LABEL_ID CE_DYNAMIC_LABEL CE_DYNAMIC_LABEL_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID


LH_CNT_IC_VAE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse Content Infection Control Ventilator Associated Event
Definition: Infection Control VAE table.
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_VAE


Column Name Type Null? Definition
ADMIT_DT_TM DATETIME Y Admit Date of the patient
APRV_IND DOUBLE Y Indicator for APRV (Airway Pressure Release Ventilation). Set to 1 when there is APRV mode of ventilation present
BSI_SECONDARY_IND DOUBLE Y Indicator for a secondary Blood Stream Infection
ENCNTR_ID DOUBLE N Encounter ID from the encounter table
EVENT_DT_TM DATETIME Y Event Date of the VAE Event
EVENT_LOC_CD DOUBLE N Location the VAE Event is attributed to.
LH_CNT_IC_VAE_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_VAE table.
LOCATION_CD DOUBLE N Location associated to the patient.
LUNG_HIST_IND DOUBLE Y Indicates if the patient qualifies for Lung Histopathology (1 = Positive, 0 = Negative).
MANUAL_ADD_IND DOUBLE N This column indicates a patient was manually added to the VAE population by a user. 0=System added,1=Manually added by user.
MV_DT_TM DATETIME Y Mechanical Ventiliation Date/Time
MV_LOC_CD DOUBLE N Mechanical Ventiliation Location.
PERSON_ID DOUBLE N Person ID from the person table
PLEURAL_FLUID_IND DOUBLE Y Indicates if the Pleural Fluid was obtained during Thoracentisis or Initial Chest Tube Insertion (1 = Yes, 0 = No).
POST_PROC_CD DOUBLE N Post Procedure VAE NHSN Code, populated if this record was related to Post Procedure VAE (as indicated in POST_PROC_IND).
POST_PROC_DISP VARCHAR(255) Y Post Procedure Display
POST_PROC_DT_TM DATETIME Y Post Procedure Data/Time
POST_PROC_IND DOUBLE Y Post Procedure Indicator
REVIEWED_FLAG DOUBLE Y Representation of what review state the patient is in.1 - Not Started2 - In Progress3 - Complete4 - Modified
SUPPRESS_UNTIL_DT_TM DATETIME Y This column stores the date/time that the VAE event will be suppressed until re-evaluation. Once this date exceeds current date/time, the event will be re-evaluated by the VAE ops job.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. 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_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE 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_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VAE_CRITERIA_TXT VARCHAR(255) Y Textual representation of the criteria for given VAE
VAE_DEATH_IND DOUBLE Y Indicator if the VAE contributed to the patients death
VAE_START_DT_TM DATETIME Y Start Date/Time of the VAE
VAE_TYPE_FLAG DOUBLE Y Indicates what grouping the patient falls in on the VAE Worklist.0 - Risk for VAE1 - VAC2 - IVAC3 - Possible VAP4 - Probable VAP5 - IVAC Patients with Positive Pleural Fluid Culture6 - IVAC Patients with Lung Histopathology Result7 - Patient Removed8 - No NHSN Event



Relationship Detail - LH_CNT_IC_VAE


Child Column in LH_CNT_IC_VAE(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
EVENT_LOC_CD LOCATION LOCATION_CD
LOCATION_CD LOCATION LOCATION_CD
MV_LOC_CD LOCATION LOCATION_CD
PERSON_ID PERSON PERSON_ID




Parent Column in LH_CNT_IC_VAE (PK) Child Table Name Child Column Name
Children: LH_CNT_IC_VAE_ID LH_CNT_IC_VAE_EVENT_DTL LH_CNT_IC_VAE_ID
LH_CNT_IC_VAE_HIST LH_CNT_IC_VAE_ID


LH_CNT_IC_VAE_EVENT_DTL



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_IC_VAE_EVENT_DTL
Definition: Contains event details for a patient on a ventilator
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_VAE_EVENT_DTL


Column Name Type Null? Definition
APRV_IND DOUBLE Y Indicates whether the patient has been APRV mode of ventilation for the given mechanical vent date
FIO2_HL_IND DOUBLE Y Indicates that FiO2 was a factor for VAE
FIO2_MIN_VALUE DOUBLE N Daily minimum FiO2 value for the given date
LH_CNT_IC_VAE_EVENT_DTL_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_VAE_EVENT_DTL table.
LH_CNT_IC_VAE_ID DOUBLE N Key to LH_CNT_IC_VAE table.
MECH_VENT_DT_TM DATETIME Y Date and Time patient was on a mechanical ventilator
OFF_VENT_IND DOUBLE Y Indicates the patient was off the mechanical ventilator
ORDER_ID DOUBLE N FK value from ORDERS table entry
PEEP_MIN_HL_IND DOUBLE Y Indicates that PEEP Min was a factor for VAE
PEEP_MIN_VALUE DOUBLE N Daily minimum PEEP value for the given date
POLY_HL_IND DOUBLE Y Indicates that Polys was a factor for VAE
POLY_IND DOUBLE Y Indicates if the result for neutrophils met the criteria
POS_LEGION_HL_IND DOUBLE Y Indicates that Pos Legionella or viral pathogen was a factor for VAE
POS_LEGION_IND DOUBLE Y Indicates if there is a positive result of Legionella spp or viral pathogens.
POS_LUNG_HL_IND DOUBLE Y Indicates that Pos Lung Histopathology was a factor for VAE
POS_PLEURAL_HL_IND DOUBLE Y Indicates that Pos Pleural Fluid cx was a factor for VAE
POS_PLEURAL_IND DOUBLE Y Indicates whether the pleural fluid culture is positive or negative
QADS_HL_IND DOUBLE Y Indicates that QADS was a factor for VAE
QADS_IND DOUBLE Y Indicates whether the given date is a qualifying anti microbial drug day
QUANT_CRIT_HL_IND DOUBLE Y Indicates that Quant criteria was a factor for VAE
QUANT_CRIT_IND DOUBLE Y Indicates if the quantitative or semi -quantitative results meet the threshold criteria, for the specimen types
SPECIMEN_CD DOUBLE N Codeset: 2052, Specimen culture type that has been ordered
SPECIMEN_HL_IND DOUBLE Y Indicates that Specimen was a factor for VAE
SPUTUM_HL_IND DOUBLE Y Indicates that Pos Sputum cx or qual cx was factor for VAE
SPUTUM_IND DOUBLE Y Indicates if the qualitative results criteria is met, for the specimen types
SQUAM_HL_IND DOUBLE Y Indicates that Squam Epis was a factor for VAE
SQUAM_IND DOUBLE Y Indicates if the result for squamous epithileal cells met the criteria
TEMP_MAX_HL_IND DOUBLE Y Indicates that Temp Max was a factor for VAE
TEMP_MAX_TXT VARCHAR(255) Y Daily maximum temperature for the given date
TEMP_MIN_HL_IND DOUBLE Y Indicates that Temp Min was a factor for VAE
TEMP_MIN_TXT VARCHAR(255) Y Daily minimum Temperature for the given date
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
WBC_MAX_HL_IND DOUBLE Y Indicates that WBC Max was a factor for VAE
WBC_MAX_TXT VARCHAR(255) Y Daily minimum WBC for the given date
WBC_MIN_HL_IND DOUBLE Y Indicates that WBC Min was a factor for VAE
WBC_MIN_TXT VARCHAR(255) Y Daily minimum WBC for the given date



Relationship Detail - LH_CNT_IC_VAE_EVENT_DTL


Child Column in LH_CNT_IC_VAE_EVENT_DTL(FK) Parent Table Name Parent Column Name
Parents: LH_CNT_IC_VAE_ID LH_CNT_IC_VAE LH_CNT_IC_VAE_ID
ORDER_ID ORDERS ORDER_ID


LH_CNT_IC_VAE_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_IC_VAE_HIST
Definition: This table stores a history of VAE event type changes.
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_VAE_HIST


Column Name Type Null? Definition
LH_CNT_IC_VAE_HIST_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_VAE_HIST table.
LH_CNT_IC_VAE_ID DOUBLE N Foreign key to the LH_CNT_IC_VAE table.
PERFORMED_BY_PRSNL_ID DOUBLE N The user who updated the vae_type_flag.
PERFORMED_DT_TM DATETIME Y The date/time the vae_type_flag was changed.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
VAE_TYPE_FLAG DOUBLE N The VAE event type/category from the LH_CNT_IC_VAE table.0 - Risk for VAE1 - VAC2 - IVAC3 - Possible VAP4 - Probable VAP5 - IVAC Patients with Positive Pleural Fluid Culture6 - IVAC Patients with Lung Histopathology Result7 - Patient Removed8 - No NHSN Event



Relationship Detail - LH_CNT_IC_VAE_HIST


Child Column in LH_CNT_IC_VAE_HIST(FK) Parent Table Name Parent Column Name
Parents: LH_CNT_IC_VAE_ID LH_CNT_IC_VAE LH_CNT_IC_VAE_ID
PERFORMED_BY_PRSNL_ID PRSNL PERSON_ID