Table Detail Report

LH_CNT_IC_PATIENT_MDRO_RSK



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH CNT IC PATIENT MDRO RSK
Definition: This table stores patient's MDRO risk information
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_PATIENT_MDRO_RSK


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.
CATEGORY_NAME VARCHAR(150) Y The MDRO category name
EVENT_CD DOUBLE N The event code for this mdro
LH_CNT_IC_PATIENT_MDRO_RSK_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_PATIENT_MDRO_RISK table.
LH_CNT_IC_PATIENT_POP_ID DOUBLE N Foreign key to lh_cnt_ic_patient_pop
STATUS_FLAG DOUBLE N 1=NEW, 2=HIST, 3=RECURRING
TYPE_FLAG DOUBLE N 1 = NHSN, 2 = OTHER
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.



Relationship Detail - LH_CNT_IC_PATIENT_MDRO_RSK


Child Column in LH_CNT_IC_PATIENT_MDRO_RSK(FK) Parent Table Name Parent Column Name
Parents: LH_CNT_IC_PATIENT_POP_ID LH_CNT_IC_PATIENT_POP LH_CNT_IC_PATIENT_POP_ID


LH_CNT_IC_PATIENT_NOTIF



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH CNT IC PATIENT NOTIF
Definition: This table stores patient's related notifications
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_PATIENT_NOTIF


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.
COMMENT_TXT VARCHAR(2000) Y The comment for this notification
LH_CNT_IC_PATIENT_NOTIF_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_PATIENT_NOTIF table.
LH_CNT_IC_PATIENT_POP_ID DOUBLE N Foreign key to lh_cnt_ic_patient_pop
NOTIFICATION_DISPLAY VARCHAR(255) Y The display for this notification
NOTIFICATION_DT_TM DATETIME Y The date/time for this notification
PARENT_ENTITY_ID DOUBLE N Used to store the identifier for the parent
PARENT_ENTITY_NAME VARCHAR(30) N Used to store the name for the parent
STATUS_DISPLAY VARCHAR(40) Y The status for this notification
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.



Relationship Detail - LH_CNT_IC_PATIENT_NOTIF


Child Column in LH_CNT_IC_PATIENT_NOTIF(FK) Parent Table Name Parent Column Name
Parents: LH_CNT_IC_PATIENT_POP_ID LH_CNT_IC_PATIENT_POP LH_CNT_IC_PATIENT_POP_ID


LH_CNT_IC_PATIENT_POP



Column Section Relationship Section Top of Page


Table-level Detail

Description: LIGHTHOUSE CONTENT INFECTION CONTROL PATIENT POPULATION
Definition: This table stores the infection control patient population
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_PATIENT_POP


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.
DEVICE_TRIGGER_IND DOUBLE N An indicator to determine if the patient had device data that caused them to move to Needs Assessment category. 0=Not a triggering factor, 1=Triggering factor
ENCNTR_ID DOUBLE N The encntr_id of the patient.
FECAL_TRIGGER_IND DOUBLE N An indicator to determine if the patient had fecal data that caused them to move to Needs Assessment category. 0=Not a triggering factor, 1=Triggering factor
ISOLATION_TRIGGER_IND DOUBLE N An indicator to determine if the patient had isolation data that caused them to move to Needs Assessment category. 0=Not a triggering factor, 1=Triggering factor
LH_CNT_IC_PATIENT_POP_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_PATIENT_POP table.
LOCATION_CD DOUBLE N The facility for the patient's encounter.
MICRO_TRIGGER_IND DOUBLE N An indicator to determine if the patient had micro data that caused them to move to Needs Assessment category. 0=Not a triggering factor, 1=Triggering factor
NOTIF_TRIGGER_IND DOUBLE N An indicator to determine if the patient had notification data that caused them to move to Needs Assessment category. 0=Not a triggering factor, 1=Triggering factor
PATIENT_GROUP_DT_TM DATETIME Y This is the date/time the patient was manually moved to the Ongoing assessment or Deleted categories. It should be NULL if the patient_group_flag is 0 or 1.
PATIENT_GROUP_FLAG DOUBLE N This flag is used to assign patients to groups used by Infection Preventionists for organizing the level of care needed. 0=Default value, no group assigned, 1=Needs Assessment, 2=Ongoing Assessment, 3=No longer being assessed/deleted
PATIENT_INFO_TRIGGER_IND DOUBLE N An indicator to determine if the patient info data caused them to move to Needs Assessment category. 0=Not a triggering factor, 1=Triggering factor
PERFORMED_BY_PRSNL_ID DOUBLE N The personnel ID of the user who triggered the patient to be added to this table. The triggering occurs by a Discern rule when certain orders/clinical events occur.
PERSON_ID DOUBLE N The person_id of the patient.
PROCESS_FLAG DOUBLE N This flag is used by an ops job to determine which patient's need to have data generated. 0= Do not process, 1=Process, 2=Current being processed
RISK_TRIGGER_IND DOUBLE N An indicator to determine if the patient had risk data that caused them to move to Needs Assessment category. 0=Not a triggering factor, 1=Triggering factor
SERO_TRIGGER_IND DOUBLE N An indicator to determine if the patient had serology data that caused them to move to Needs Assessment category. 0=Not a triggering factor, 1=Triggering factor
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.
XRAY_TRIGGER_IND DOUBLE N An indicator to determine if the patient had xray data that caused them to move to Needs Assessment category. 0=Not a triggering factor, 1=Triggering factor



Relationship Detail - LH_CNT_IC_PATIENT_POP


Child Column in LH_CNT_IC_PATIENT_POP(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
PERFORMED_BY_PRSNL_ID PRSNL PERSON_ID




Parent Column in LH_CNT_IC_PATIENT_POP (PK) Child Table Name Child Column Name
Children: LH_CNT_IC_PATIENT_POP_ID LH_CNT_IC_PATIENT_DEVICE LH_CNT_IC_PATIENT_POP_ID
LH_CNT_IC_PATIENT_FOLLOWUP LH_CNT_IC_PATIENT_POP_ID
LH_CNT_IC_PATIENT_HAI_RISK LH_CNT_IC_PATIENT_POP_ID
LH_CNT_IC_PATIENT_INFO LH_CNT_IC_PATIENT_POP_ID
LH_CNT_IC_PATIENT_ISOL LH_CNT_IC_PATIENT_POP_ID
LH_CNT_IC_PATIENT_LAB LH_CNT_IC_PATIENT_POP_ID
LH_CNT_IC_PATIENT_MDRO_RSK LH_CNT_IC_PATIENT_POP_ID
LH_CNT_IC_PATIENT_NOTIF LH_CNT_IC_PATIENT_POP_ID
LH_CNT_IC_PATIENT_POP_HIST LH_CNT_IC_PATIENT_POP_ID
LH_CNT_IC_PATIENT_READMIT LH_CNT_IC_PATIENT_POP_ID
LH_CNT_IC_PATIENT_READ_SRG LH_CNT_IC_PATIENT_POP_ID
LH_CNT_IC_PATIENT_RPT_RISK LH_CNT_IC_PATIENT_POP_ID
LH_CNT_IC_PATIENT_XRAY LH_CNT_IC_PATIENT_POP_ID


LH_CNT_IC_PATIENT_POP_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_IC_PATIENT_POP_HIST
Definition: Infection Control Worklist history table for patient movement between categories.
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_PATIENT_POP_HIST


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.
DEVICE_TRIGGER_IND DOUBLE N Stores a 0 or 1 indicating that a device is what triggered a patient onto the ICP Worklist.
FECAL_TRIGGER_IND DOUBLE N Stores a 0 or 1 indicating that a fecal is what triggered a patient onto the ICP Worklist.
ISOLATION_TRIGGER_IND DOUBLE N Stores a 0 or 1 indicating that an isolation is what triggered a patient onto the ICP Worklist.
LH_CNT_IC_PATIENT_POP_HIST_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_PATIENT_POP_HIST table.
LH_CNT_IC_PATIENT_POP_ID DOUBLE N Foreign key to LH_CNT_IC_PATIENT_POP table.
MICRO_TRIGGER_IND DOUBLE N Stores a 0 or 1 indicating that a micro is what triggered a patient onto the ICP Worklist.
NOTIF_TRIGGER_IND DOUBLE N Stores a 0 or 1 indicating that a notification is what triggered a patient onto the ICP Worklist.
PATIENT_GROUP_DT_TM DATETIME Y Stores the date and time that a patient's PATIENT_GROUP_FLAG was updated.
PATIENT_GROUP_FLAG DOUBLE N Currently stores a value of 0 - 3 which corresponds to a particular grouping such as Needs Assessment, Ongoing Assessment, Deleted etc.
PATIENT_INFO_TRIGGER_IND DOUBLE N Stores a 0 or 1 indicating that a change in patient information is what triggered a patient onto the ICP Worklist.
RISK_TRIGGER_IND DOUBLE N Stores a 0 or 1 indicating that a risk is what triggered a patient onto the ICP Worklist.
SERO_TRIGGER_IND DOUBLE N Stores a 0 or 1 indicating that a sero is what triggered a patient onto the ICP Worklist.
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.
XRAY_TRIGGER_IND DOUBLE N Stores a 0 or 1 indicating that a xray is what triggered a patient onto the ICP Worklist.



Relationship Detail - LH_CNT_IC_PATIENT_POP_HIST


Child Column in LH_CNT_IC_PATIENT_POP_HIST(FK) Parent Table Name Parent Column Name
Parents: LH_CNT_IC_PATIENT_POP_ID LH_CNT_IC_PATIENT_POP LH_CNT_IC_PATIENT_POP_ID


LH_CNT_IC_PATIENT_POP_TAGS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_IC_PATIENT_POP_TAGS
Definition: Infection Control Worklist patient tags table.
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_PATIENT_POP_TAGS


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.
BEG_EFFECTIVE_PRSNL_ID DOUBLE N Stores the id of the person who inserted a row into the 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.
END_EFFECTIVE_PRSNL_ID DOUBLE N Stores the id of the person who deemed a row no longer valid.
LH_CNT_IC_PATIENT_POP_TAGS_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_PATIENT_POP_TAGS table.
PATIENT_TAG_CD DOUBLE N Currently stores a code value from the code_value table associated to code_set 4003266. These code values are used to group patients together for quicker sorting/filtering on the ICP Worklist.
PERSON_ID DOUBLE N Foreign key to PERSON table.
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.



Relationship Detail - LH_CNT_IC_PATIENT_POP_TAGS


Child Column in LH_CNT_IC_PATIENT_POP_TAGS(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
BEG_EFFECTIVE_PRSNL_ID PRSNL PERSON_ID
END_EFFECTIVE_PRSNL_ID PRSNL PERSON_ID