Table Detail Report
LH_CNT_IC_ADV_LTD
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_CNT_IC_ADV_LTD |
Definition: | This table will be used to store results of Lines, Tubes, Drains (LTD) for our advisor. |
Table Type: | ACTIVITY |
Column Detail - LH_CNT_IC_ADV_LTD
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. |
CE_DYNAMIC_LABEL_ID | DOUBLE | N | The label_id of the dynamic label that this LTD is associated with. (From CE_DYNAMIC_LABEL table) |
DISCONTINUE_DT_TM | DATETIME | Y | This field will be used to store the discontinue date time of the LTD. If the line has not yet been discontinued, the value in this column will be NULL. |
EKS_ADVSR_EVENT_ID | DOUBLE | N | Foreign key to EKS_ADVSR_EVENT table. This will allow us to identify the unique instance of an advisor that this row belongs to. |
ENCNTR_ID | DOUBLE | N | Foreign key to ENCOUNTER table. Stores the encounter that the LTD was attached to. |
INSERT_DT_TM | DATETIME | Y | This field will be used to store the insertion date time of the LTD. |
LH_CNT_IC_ADV_LTD_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_CNT_IC_ADV_LTD table. |
LOC_BED_CD | DOUBLE | N | This field is the patient location with a location type of bed at the time this LTD was placed. CODE SET: 220 |
LOC_FACILITY_CD | DOUBLE | N | This field contains the internal identification code for the facility location at which this LTD was placed. CODE SET: 220 |
LOC_NURSE_UNIT_CD | DOUBLE | N | This field contains the internal identification code for the nurse unit location at which this LTD was placed. CODE SET: 220 |
LOC_ROOM_CD | DOUBLE | N | This field is the patient location with a location type of room at the time this LTD was placed. CODE SET: 220 |
LTD_CATEGORY_NAME | VARCHAR(255) | Y | This field indicates which category of LTD this row belongs to. Examples include: Central, Arterial, Artificial Airway, et al. |
LTD_DESCRIPTION | VARCHAR(1000) | Y | This field indicates the general description of the LTD. Factors such as the size of the LTD usually go here. |
LTD_LOCATION | VARCHAR(100) | Y | This field indicates the location of the LTD. Generally, factors such as the laterality and site usually are used for this column. |
LTD_TYPE | VARCHAR(255) | Y | This field indicates the type of LTD that this row belongs to. Examples include Non-Tunneled for Central Line, Permanent for Central Line, Indwelling/Continuous for Urinary Catheter, et al. |
PRESENT_ON_ADMISSION_IND | DOUBLE | Y | This field will be set to 1 if the LTD was present on admission, 0 otherwise. |
TOTAL_DURATION_DAYS | DOUBLE | Y | This field indicates the total duration of the LTD. This is calculated via the time difference between the insertion date time and discontinued date time. If the line has not yet been discontinued, then total duration will be calculated from the time difference between insertion date time and current date time |
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_ADV_LTD
Child Column in LH_CNT_IC_ADV_LTD(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CE_DYNAMIC_LABEL_ID | CE_DYNAMIC_LABEL | CE_DYNAMIC_LABEL_ID |
EKS_ADVSR_EVENT_ID | EKS_ADVSR_EVENT | EKS_ADVSR_EVENT_ID | |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
LH_CNT_IC_ADV_MICRO
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH CNT IC ADV MICRO |
Definition: | Stores microbiology culture results that were signed from the IC Advisor |
Table Type: | ACTIVITY |
Column Detail - LH_CNT_IC_ADV_MICRO
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. |
BODY_SITE_CD | DOUBLE | N | Body location where the collection was done (left arm, right thumb, etc.). |
COLLECT_DT_TM | DATETIME | Y | This field includes the date and time the specimen was collected. |
COLLECT_LOC_BED_CD | DOUBLE | N | This field contains the internal identification code for the bed location at which this order was collected. This could be used to join to the LOCATION table. |
COLLECT_LOC_BUILDING_CD | DOUBLE | N | This field contains the internal identification code for the building location at which this order was collected. This could be used to join to the LOCATION table. |
COLLECT_LOC_FACILITY_CD | DOUBLE | N | This field contains the internal identification code for the facility location at which this order was collected. This could be used to join to the LOCATION table. |
COLLECT_LOC_NURSE_UNIT_CD | DOUBLE | N | This field contains the internal identification code for the nurse unit location at which this order was collected. This could be used to join to the LOCATION table. |
COLLECT_LOC_ROOM_CD | DOUBLE | N | This field contains the internal identification code for the room location at which this order was collected. This could be used to join to the LOCATION table. |
EKS_ADVSR_EVENT_ID | DOUBLE | N | Foreign key to EKS_ADVSR_EVENT table. |
ENCNTR_ID | DOUBLE | N | ENCOUNTER ID for this record |
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 | It is the code that identifies the most basic unit of the storage, i.e. RBC, discharge summary, image. |
EVENT_CLASS_CD | DOUBLE | N | Coded value which specifies how the event is stored in and retrieved from the event table's sub-tables. For example, Event_Class_CDs identify events as numeric results, textual results, calculations, medications, etc. |
EVENT_ID | DOUBLE | N | Unique identifier for an event. Uniquely identifies a logical clinical event row. There may be more than one row with the same event_id. |
LH_CNT_IC_ADV_MICRO_ID | DOUBLE | N | THE PRIMARY KEY |
NORMALCY_CD | DOUBLE | N | States whether the result is normal. This can be used to determine whether to display the event tag in different color on the flowsheet. For group results, this represents an "overall" normalcy. i.e. Is any result in the group abnormal? Also allows different purge criteria to be applied based on result. |
POSITIVE_IND | DOUBLE | N | This field indicates whether or not the procedure is considered positive. Microbiology procedures are considered positive when a preliminary or final report is issued that includes a positive response or organism. Valid values include: 0 = Not positive, 1 = Positive. |
RESULT_STATUS_CD | DOUBLE | N | CODE SET 8. Result status code. Valid values: authenticated, unauthenticated, unknown, cancelled, pending, in lab, active, modified, superseded, transcribed, not done. |
SOURCE_TYPE_CD | DOUBLE | N | Source of collection (blood, sputum, stool, etc.) |
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_MICRO
Child Column in LH_CNT_IC_ADV_MICRO(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | EKS_ADVSR_EVENT_ID | EKS_ADVSR_EVENT | EKS_ADVSR_EVENT_ID |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
Parent Column in LH_CNT_IC_ADV_MICRO (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | LH_CNT_IC_ADV_MICRO_ID | LH_CNT_IC_ADV_MICRO_ORG | LH_CNT_IC_ADV_MICRO_ID |
LH_CNT_IC_ADV_MICRO_ANTI
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_CNT_IC_ADV_MICRO_ANTI |
Definition: | Child table of LH_CNT_IC_ADV_MICRO_ORG. Stores antibiotics for an organism. There can be multiple antibiotics per organism |
Table Type: | ACTIVITY |
Column Detail - LH_CNT_IC_ADV_MICRO_ANTI
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. |
ANTIBIOTIC_CD | DOUBLE | N | The type of antibiotic for microbiology susceptibility results. |
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. |
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_MICRO_ANTI_ID | DOUBLE | N | PRIMARY KEY |
LH_CNT_IC_ADV_MICRO_ORG_ID | DOUBLE | N | Foreign key to LH_CNT_IC_ADV_MICRO_ORG table. |
NHSN_ANTIBIOTIC_MEANING | VARCHAR(200) | Y | The NHSN defined meaning of the antibiotic. |
NHSN_SUSCEPTIBILITY | VARCHAR(40) | Y | This column will be the NHSN equivalent of Cerner's SUSCEPTIBILITY_RESULT_CD column in this table. |
SUSCEPTIBILITY_RESULT_CD | DOUBLE | N | Interpretation_cd received from the clinical_event service. |
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_ADV_MICRO_ANTI
Child Column in LH_CNT_IC_ADV_MICRO_ANTI(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LH_CNT_IC_ADV_MICRO_ORG_ID | LH_CNT_IC_ADV_MICRO_ORG | LH_CNT_IC_ADV_MICRO_ORG_ID |
LH_CNT_IC_ADV_MICRO_ORG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_CNT_IC_ADV_MICRO_ORG |
Definition: | Child table of LH_CNT_IC_ADV_MICRO. Stores organisms found on a given microbiology culture, there can be multiple organisms per culture |
Table Type: | ACTIVITY |
Column Detail - LH_CNT_IC_ADV_MICRO_ORG
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. |
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_MICRO_ID | DOUBLE | N | Foreign key to LH_CNT_IC_ADV_MICRO table. |
LH_CNT_IC_ADV_MICRO_ORG_ID | DOUBLE | N | PRIMARY KEY |
MDRO_CAT_NAME | VARCHAR(150) | Y | Stores the name assigned to the category. |
MDRO_IN_PLAN_IND | DOUBLE | N | Value can be 0 or 1. If 1, then it means that the organism is found in the MDRO plan for NHSN, else it will be 0. |
MICRO_SEQ_NBR | DOUBLE | Y | Used for uniqueness in cases where there are multiple micro records per clinical_event. |
ORGANISM_CD | DOUBLE | N | A unique identifier for organism. |
ORGANISM_OCCURENCE_NBR | DOUBLE | Y | A unique number to identify parts of the same organism. |
PATHOGEN_NUMBER | DOUBLE | Y | Stores the pathogen number for the organism. |
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_ADV_MICRO_ORG
Child Column in LH_CNT_IC_ADV_MICRO_ORG(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LH_CNT_IC_ADV_MICRO_ID | LH_CNT_IC_ADV_MICRO | LH_CNT_IC_ADV_MICRO_ID |
Parent Column in LH_CNT_IC_ADV_MICRO_ORG (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | LH_CNT_IC_ADV_MICRO_ORG_ID | LH_CNT_IC_ADV_MICRO_ANTI | LH_CNT_IC_ADV_MICRO_ORG_ID |
LH_CNT_IC_ADV_RISK_FACTOR
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_CNT_IC_ADV_RISK_FACTOR |
Definition: | Stores the risk factors saved within the Risk Factors component of the IC Advisor. |
Table Type: | ACTIVITY |
Column Detail - LH_CNT_IC_ADV_RISK_FACTOR
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. |
BIRTHWEIGHT_IN_GRAMS | VARCHAR(255) | Y | The birthweight of the patient in grams. Value to be submitted to NHSN. |
CENTRAL_LINE_FLAG | DOUBLE | N | Indicates selection of the ""Central Line"" radio button. 0 - Unknown, 1 - Yes, 2 - No |
EKS_ADVSR_EVENT_ID | DOUBLE | N | Foreign key to the 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. |
INSERTION_DT_TM | DATETIME | Y | Date and time of insertion of the device. |
INSERTION_LOC_CD | DOUBLE | N | Location code of where the device was inserted. |
LH_CNT_IC_ADV_RISK_FACTOR_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_CNT_IC_ADV_RISK_FACTOR table. |
LOCATION_TYPE_FLAG | DOUBLE | N | Indicates the NHSN location type at the moment of save, per the bedrock settings. 0 - Unknown, 1 - NICU, 2 - ICU, 3 - SCA. |
PERM_CENTRAL_LINE_FLAG | DOUBLE | N | Indicates selection of the ""Permanent Central Line"" radio button. 0 - Unknown, 1 - Yes, 2 - No |
TEMP_CENTRAL_LINE_FLAG | DOUBLE | N | Indicates selection of the ""Temporary Central Line"" radio button. 0 - Unknown, 1 - Yes, 2 - No |
UMBILICAL_LINE_FLAG | DOUBLE | N | Indicates selection of the ""Central Line(including umbilical catheter)"" radio button. 0 - Unknown, 1 - Yes, 2 - No |
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. |
URINARY_CATHETER_FLAG | DOUBLE | N | Indicates selection from within the Urinary Catheter radio group. 0 = Nothing Selected(not a UTI), 1 = "In Place", 2 = "Removed within 2 days prior", 3 = "Neither". |
VENTILATOR_FLAG | DOUBLE | N | Indicates selection of the ""Ventilator"" radio button. 0 - Unknown, 1 - Yes, 2 - No |
Relationship Detail - LH_CNT_IC_ADV_RISK_FACTOR
Child Column in LH_CNT_IC_ADV_RISK_FACTOR(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | EKS_ADVSR_EVENT_ID | EKS_ADVSR_EVENT | EKS_ADVSR_EVENT_ID |