Table Detail Report

LH_CNT_IC_PATIENT_FOLLOWUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH CNT IC PATIENT FOLLOW UP
Definition: This table stores patient follow up information
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_PATIENT_FOLLOWUP


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.
LH_CNT_IC_PATIENT_FOLLOWUP_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_PATIENT_FOLLOWUP table.
LH_CNT_IC_PATIENT_POP_ID DOUBLE N Foreign key to lh_cnt_ic_patient_pop
STICKY_NOTE_HOVER_TXT VARCHAR(255) Y Description for the sticky note
STICKY_NOTE_TYPE_CD DOUBLE N The type of sticky note
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_FOLLOWUP


Child Column in LH_CNT_IC_PATIENT_FOLLOWUP(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_HAI_RISK



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH CNT IC PATIENT HAI RISK
Definition: This table stores hospital acquired infection risk information related to patient
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_PATIENT_HAI_RISK


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.
BSI_IND DOUBLE N 0=No BSI risk, 1=BSI risk
CREATED_DT_TM DATETIME N Stores date time when the row is created.
HAI_DISPLAY VARCHAR(255) Y Shows which HAI risks the patient has
LH_CNT_IC_PATIENT_HAI_RISK_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_PATIENT_HAI_RISK table.
LH_CNT_IC_PATIENT_POP_ID DOUBLE N Foreign key to lh_cnt_ic_patient_pop.
PNEU_IND DOUBLE N 0=No PNEU risk, 1=PNEU risk
SSI_IND DOUBLE N 0=No SSI risk, 1=SSI risk
SURGERY_DT_TM DATETIME Y The surgery_dt_tm on the lh_cnt_ic_patient_hai_risk table is the date and time the surgery was completed that triggered the SSI HAI Risk.
SURGERY_NAME VARCHAR(40) Y The surgery_name on the lh_cnt_ic_patient_hai_risk tables is the name of the surgery that triggered the SSI HAI Risk.
SURG_PROC_CD DOUBLE N Stores code value of the surgical procedure order
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.
UTI_IND DOUBLE N 0=No UTI risk, 1=UTI risk



Relationship Detail - LH_CNT_IC_PATIENT_HAI_RISK


Child Column in LH_CNT_IC_PATIENT_HAI_RISK(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




Parent Column in LH_CNT_IC_PATIENT_HAI_RISK (PK) Child Table Name Child Column Name
Children: LH_CNT_IC_PATIENT_HAI_RISK_ID LH_CNT_IC_PAT_HAI_CODE LH_CNT_IC_PATIENT_HAI_RISK_ID


LH_CNT_IC_PATIENT_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH CNT IC PATIENT INFO
Definition: The table stores the patient demographic information
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_PATIENT_INFO


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.
ADMIT_DT_TM DATETIME Y Admit date/time of the patient
AGE_DISPLAY VARCHAR(100) Y The textual representation of the patient's age including unit of measure display. Ex: 50 years old.
ALTERNATE_ALIAS VARCHAR(200) Y The patients alternate alias such as community MRN.
DECEASED_IND DOUBLE N 0=Not deceased, 1=Deceased
DISCH_DT_TM DATETIME Y Patient's discharge date/time
DOB_DT_TM DATETIME Y Patient's date of birth
FIN_DISPLAY VARCHAR(200) Y The patients FIN number
GENDER_DISPLAY VARCHAR(40) Y Patient's gender
LENGTH_OF_STAY DOUBLE N Length of stay for this encounter
LH_CNT_IC_PATIENT_INFO_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_PATIENT_INFO table.
LH_CNT_IC_PATIENT_POP_ID DOUBLE N Foreign key to lh_cnt_ic_patient_pop.
LOCATION_DISPLAY VARCHAR(255) Y The location for this patient's encounter
MRN_DISPLAY VARCHAR(200) Y The patients MRN number
NAME_FULL_FORMATTED VARCHAR(100) Y Full name of the patient
PCP_NAME VARCHAR(100) Y The patient's primary care physician
REASON_FOR_VISIT VARCHAR(255) Y The description of reason for visit. Otherwise known as admitting symptom, presenting symptom, etc. It is a brief description of why the person has presented for examination or treatment and may be the patient described symptom.
RECURRING_IND DOUBLE N Indicator to determine if the patient's encounter is recurring. 0=Not recurring, 1=Recurring.
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_INFO


Child Column in LH_CNT_IC_PATIENT_INFO(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_ISOL



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH CNT IC PATIENT ISOL
Definition: The table stores patient's ISOL information
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_PATIENT_ISOL


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.
ADDITIONAL_INFO_TXT VARCHAR(2000) Y Additional information about the ISOL
DISCONTINUE_DT_TM DATETIME Y The date/time the ISOL was discontinued
DISCONTINUE_PRSNL_ID DOUBLE N The personnel ID of the user who discontinued the ISOL
DISCONTINUE_PRSNL_NAME VARCHAR(100) Y The personnel name full formatted of the user who discontinued the ISOL
ISOLATION_SEQ DOUBLE N Sequence to indicate the order the isolation actions took place
ISOLATION_TYPE VARCHAR(2000) Y The type of isolation
LH_CNT_IC_PATIENT_ISOL_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_PATIENT_ISOL table.
LH_CNT_IC_PATIENT_POP_ID DOUBLE N Foreign key to lh_cnt_ic_patient_pop
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 (ORDERS/CLINICAL_EVENT)
START_DT_TM DATETIME Y The start date/time the ISOL action occurred.
START_PRSNL_ID DOUBLE N The personnel ID of the user who initiated the ISOL action
START_PRSNL_NAME VARCHAR(100) Y The personnel name full formatted of the user who initiated the ISOL action
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_ISOL


Child Column in LH_CNT_IC_PATIENT_ISOL(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_LAB



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH CNT IC PATIENT LAB
Definition: This table stores patient's lab result information.
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_PATIENT_LAB


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.
BODY_SITE_CD DOUBLE N Stores code value of the body site from where the specimen is collected.
BODY_SITE_DISPLAY VARCHAR(40) Y The display for the body site
COLLECTED_DT_TM DATETIME Y The date/time the lab specimen was collected
CREATED_DT_TM DATETIME N Stores date time when the row is created.
EVENT_CD DOUBLE N Stores the event code from clinical event.
EVENT_DISPLAY VARCHAR(40) Y The display for this lab event
LAB_TYPE_FLAG DOUBLE N Used to determine which type of lab result this is. 1=Micro, 2=Fecal, 3= Sero
LH_CNT_IC_PATIENT_LAB_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_PATIENT_LAB table.
LH_CNT_IC_PATIENT_POP_ID DOUBLE N Foreign key to lh_cnt_ic_patient_pop
ORDER_DT_TM DATETIME Y The date/time the lab order was placed
ORDER_ID DOUBLE N The order ID of the lab order.
ORGANISM_DESCRIPTION VARCHAR(2000) Y The description of the organism causing infection
PARENT_EVENT_ID DOUBLE N Stores the parent event id from clinical event
POSITIVE_FLAG DOUBLE N Flag to determine if this result is positive, negative, or in progress. 1 = positive, 2 = negative, 3 = in progress
RESULT_STATUS_CD DOUBLE N Stores the status code of the result.
RESULT_STATUS_DISPLAY VARCHAR(40) Y The status of the result
SOURCE_SITE_DISPLAY VARCHAR(40) Y The display for the source site
SPECIMEN_TYPE_CD DOUBLE N Stores code value of the type of specimen collected
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_LAB


Child Column in LH_CNT_IC_PATIENT_LAB(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
ORDER_ID ORDERS ORDER_ID