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 |