LH_CNT_ADVSR_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_ADVSR_EVENT
Definition: This table will be used to track advisor events for the Infection Control Uplift Advisor.
Table Type: ACTIVITY





Column Detail - LH_CNT_ADVSR_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.
ADV_EVENT_DT_TM DATETIME Y This is used to flex the Advisor release rules for the advisor. This will be the time that we will report the event off of. This date swings the release version.
ADV_SPECIFIC_EVENT_TYPE_CD DOUBLE N This will store the specific event type
BEG_EFFECTIVE_DT_TM DATETIME N 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.
COMMENT_LONG_TEXT_ID DOUBLE N Foreign key to LONG_TEXT table that will store the contents of the comments field in the advisor
EKS_ADVSR_EVENT_ID DOUBLE N Foreign key to EKS_ADVSR_EVENT table.
END_EFFECTIVE_DT_TM DATETIME N 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.
LH_CNT_ADVSR_EVENT_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_ADVSR_EVENT table.
UNCHART_LONG_TEXT_ID DOUBLE N Foreign key to LONG_TEXT table that will store the text when the user uncharts the advisor
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_ADVSR_EVENT


Child Column in LH_CNT_ADVSR_EVENT(FK) Parent Table Name Parent Column Name
Parents: EKS_ADVSR_EVENT_ID EKS_ADVSR_EVENT EKS_ADVSR_EVENT_ID
COMMENT_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
UNCHART_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID


LH_CNT_ADVSR_VTE_ACTION



Column Section Top of Page


Table-level Detail

Description: LH_CNT_ADVSR_VTE_ACTION
Definition: This table holds VTE scenario information among different guideline types
Table Type: REFERENCE





Column Detail - LH_CNT_ADVSR_VTE_ACTION


Column Name Type Null? Definition
BMI_FLAG DOUBLE N This flag determines if the patient's BMI is greater than or equal to 40. 1=Yes; 2=No; 3= NA
CATEGORY_REQS VARCHAR(100) Y Order categories (pharm, mech) that are required for the scenario.
DELAYED_PHOPHYLAXIS_REASON_TXT VARCHAR(100) Y Reason for delayed prophylaxis.
EST_CRCL_TAG VARCHAR(100) Y Calculated value of the creatinine clearance (e.g. <30).
GUIDELINE_TYPE_NAME VARCHAR(30) Y The organization (ACCP, NICE, etc.) that created the guideline
HIT_CONTRA_ABS_FLAG DOUBLE N This flag determines if HIT contraindications have been identified. 1=Yes; 2=No; 3=NA
LH_CNT_ADVSR_VTE_ACTION_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_ADVSR_VTE_ACTION table.
MECH_CONTRA_IND DOUBLE N This flag determines if there a mechanical Contraindication. 1=Yes; 0=No.
PATIENT_TYPE_TXT VARCHAR(100) Y The type of patient identified in the advisor (e.g. Medical or Bariatric Surgery).
PHARM_CONTRA_ABS_FLAG DOUBLE N This flag determines if pharmacologic contraindications have been identified. 1=Yes; 2=No; 3=NA.
RISK_SCORE_SYSTEM_NAME VARCHAR(30) Y The scoring system (caprini, padua, etc.) that is used to assess risk for the patient type.
RISK_SCORE_TAG VARCHAR(100) Y Calculated value of risk score (e.g. >4 Padua)
SCENARIO_NBR DOUBLE N The scenario number that the row describes.
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.
WEIGHT_ENOXAPARIN_FLAG DOUBLE N This flag determines if the patient is on enoxaparin and their weight is less than 45 kg. 1=Yes; 2=No; 3=NA
WEIGHT_FONDAPARINUX_FLAG DOUBLE N This flag determines if the patient is on fondaparinux and their weight is less than 50 kg. 1=Yes; 2=No; 3=NA.


LH_CNT_IC_ADV_EVENT_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_IC_ADV_EVENT_DETAIL
Definition: Stores the event details saved within the Event Details component of the IC Advisor.
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_ADV_EVENT_DETAIL


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME N 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.
BSI_INFECTION_FLAG DOUBLE N Indicates the selection of ""Secondary BSI infection"" radio button.
CHLORHEXIDINE_FLAG DOUBLE N Indicates the selection of ""Chlorhexidine Shower or Bath Complete"" radio button.
DEATH_CONTRIBUTE_FLAG DOUBLE N Indicates the selection of ""Event Contributed to Death"" radio button.
EKS_ADVSR_EVENT_ID DOUBLE N Foreign key to EKS_ADVSR_EVENT table.
END_EFFECTIVE_DT_TM DATETIME N 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.
ICU_CDAD_FLAG DOUBLE N Indicates the selection of ""Admitted to ICU for CDAD Complications"" radio button.
INF_AT_SURG_FLAG DOUBLE N Flag value to determine the status of the "Infection Present at time of Surgery?" radio button question
LH_CNT_IC_ADV_EVENT_DETAIL_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_ADV_EVENT_DETAIL table.
NHSN_PROCEDURE_CD DOUBLE N NHSN Procedure code for the procedure associated to the HAI event.
PATIENT_DIED_FLAG DOUBLE N Indicates the selection of ""Patient Died"" radio button.
POST_PROCEDURE_FLAG DOUBLE N Indicates the selection of ""Post Procedure"" radio button.
PROCEDURE_DT_TM DATETIME Y Date of the procedure to be reported.
SURG_CDAD_FLAG DOUBLE N Indicates the selection of ""Surgery due to CDAD complications"".
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_ADV_EVENT_DETAIL


Child Column in LH_CNT_IC_ADV_EVENT_DETAIL(FK) Parent Table Name Parent Column Name
Parents: EKS_ADVSR_EVENT_ID EKS_ADVSR_EVENT EKS_ADVSR_EVENT_ID


LH_CNT_IC_ADV_EVENT_LOC



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_IC_ADV_EVENT_LOC
Definition: Infection Control advisor saved location of event data. Stores location of event data that has been associated to an advisor and saved.
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_ADV_EVENT_LOC


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME N 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.
EKS_ADVSR_EVENT_ID DOUBLE N Foreign key to EKS_ADVSR_EVENT table.
ENCNTR_ID DOUBLE N Foreign key to ENCOUNTER table.
ENCNTR_LOC_HIST_ID DOUBLE N Foreign key to ENCNTR_LOC_HIST table.
END_EFFECTIVE_DT_TM DATETIME N 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.
LH_CNT_IC_ADV_EVENT_LOC_ID DOUBLE N PRIMARY KEY
LOC_BED_CD DOUBLE N Stores the location bed code for the saved location event.
LOC_END_DT_TM DATETIME Y Stores the end_effective_dt_tm from the ENCNTR_LOC_HIST table for the saved location event.
LOC_FACILITY_CD DOUBLE N Stores the location facility code for the saved location event.
LOC_NURSE_UNIT_CD DOUBLE N Stores the location nurse unit code for the saved location event.
LOC_ROOM_CD DOUBLE N Stores the location room code for the saved location event.
LOC_START_DT_TM DATETIME Y Stores the beg_effective_dt_tm from the ENCNTR_LOC_HIST table for the saved location event.
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_ADV_EVENT_LOC


Child Column in LH_CNT_IC_ADV_EVENT_LOC(FK) Parent Table Name Parent Column Name
Parents: EKS_ADVSR_EVENT_ID EKS_ADVSR_EVENT EKS_ADVSR_EVENT_ID
ENCNTR_LOC_HIST_ID ENCNTR_LOC_HIST ENCNTR_LOC_HIST_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID


LH_CNT_IC_ADV_LAB_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse Content Infection Control Advisor Lab Data
Definition: Infection Control advisor saved lab data. Stores lab data that has been associated to an advisor and saved.
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_ADV_LAB_DATA


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME N 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.
COLLECT_DT_TM DATETIME Y Stores the collection date time of the saved lab event.
EKS_ADVSR_EVENT_ID DOUBLE N Foreign key to EKS_ADVSR_EVENT table.
ENCNTR_ID DOUBLE N Foreign key to ENCOUNTER table.
END_EFFECTIVE_DT_TM DATETIME N 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.
EVENT_CD DOUBLE N Event code value for the saved lab event.
EVENT_ID DOUBLE N Pseudo Foreign key to CLINICAL_EVENT table.
LH_CNT_IC_ADV_LAB_DATA_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_ADV_LAB_DATA table.
MDRO_CAT_NAME VARCHAR(150) Y Stores the name assigned to the category.
MDRO_IN_PLAN_IND DOUBLE N MDRO category in NHSN plan indicator. 1 = MDRO Category in Plan
RESULT_STATUS_CD DOUBLE N Stores the result status code of the saved lab event.
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.
VALUE_NOMENCLATURE_DISP VARCHAR(250) Y Stores the result display for the saved lab event



Relationship Detail - LH_CNT_IC_ADV_LAB_DATA


Child Column in LH_CNT_IC_ADV_LAB_DATA(FK) Parent Table Name Parent Column Name
Parents: EKS_ADVSR_EVENT_ID EKS_ADVSR_EVENT EKS_ADVSR_EVENT_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID