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 |