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 |