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