Table Detail Report

LH_CNT_IC_ADV_SEL_CRITERIA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse Content Infection Control Advisor Selection Criteria
Definition: This table holds the checkbox codes for fields that are checked in the select criteria section of the Infection Control Advisor.
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_ADV_SEL_CRITERIA


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.
CDA_IND DOUBLE N Indicate whether or not the criteria is to be included in the CDA upon export.
CRITERIA_CD DOUBLE N Contains the Infection Control advisor criteria for the select criteria section. Examples are 'cough', 'fever', 'Dysuria', etc.
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.
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_SEL_CRITERIA_ID DOUBLE N The unique primary key of this table. It is generated internally by Cerner.
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_SEL_CRITERIA


Child Column in LH_CNT_IC_ADV_SEL_CRITERIA(FK) Parent Table Name Parent Column Name
Parents: EKS_ADVSR_EVENT_ID EKS_ADVSR_EVENT EKS_ADVSR_EVENT_ID


LH_CNT_IC_ADV_SPEC_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: lh_cnt_ic_adv_spec_event
Definition: Stores the data selected within the IC Advisor Specify Event section
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_ADV_SPEC_EVENT


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.
ASA_SCORE_CD DOUBLE N The event code of the selected ASA score from codeset 10051. (ASA I, ASA II).
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.
DETECTED_CD DOUBLE N The selected event code of where the event was first detected from codeset 4003139. (At admission, after discharge, etc.)
EKS_ADVSR_EVENT_ID DOUBLE N Foreign key to 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.
EVENT_FLAG DOUBLE N This flag indicates whether any generic events have been signed in the advisor. 0 - None, 1 - CAUTI, 2 - CLABSI, 3 - Aspiration Pneumonia
INFECTION_TYPE_CD DOUBLE N The event code of the selected infection type from codeset 4003137. (HAI, CAI, etc.)
LH_CNT_IC_ADV_SPEC_EVENT_ID DOUBLE N Unique generated number that identifies a single row on the lh_cnt_ic_adv_spec_event table.
SPECIFIC_EVENT_DT_TM DATETIME Y The documented event date and time to be reported to NHSN.
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.
WOUND_CLASS_CD DOUBLE N The event code of the selected wound class from codeset 10038. (Clean, contaminated, etc.)



Relationship Detail - LH_CNT_IC_ADV_SPEC_EVENT


Child Column in LH_CNT_IC_ADV_SPEC_EVENT(FK) Parent Table Name Parent Column Name
Parents: EKS_ADVSR_EVENT_ID EKS_ADVSR_EVENT EKS_ADVSR_EVENT_ID


LH_CNT_IC_ADV_SURG_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_IC_ADV_SURG_DATA
Definition: This tables stores surgical procedure data that has been selected by the user for export within an Infection Control Advisor.
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_ADV_SURG_DATA


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 and Time of related encounter.
AD_HOC_IND DOUBLE N Stores whether the procedure was pulled from Millennium and added or built as an ad hoc row.
ALIAS_DISP VARCHAR(200) Y The alias is an identifier (I.E., financial number, medical record number) for a patient or encounter.
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.
DURATION_DISP VARCHAR(100) Y Duration of the procedure in hours to be used in CDA creation.
EKS_ADVSR_EVENT_ID DOUBLE N Foreign key to EKS_ADVSR_EVENT table.
ENCNTR_ID DOUBLE N Foreign key to ENCOUNTER table for the surgical case encounter.
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_SURG_DATA_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_ADV_SURG_DATA table.
NHSN_IND DOUBLE N Stores frontend selection of the NSHN checkbox.
NHSN_PROC_CD DOUBLE N NHSN assigned procedure code value from custom codeset 4003149.
OUTPATIENT_FLAG DOUBLE N Outpatient encounter flag. 0 = Unknown 1 = Yes, 2 = No
PARENT_EVENT_ID DOUBLE N Foreign key to CLINICAL_EVENT table. Used for FSI surgical events, which are built as separate events all under the same parent_event_id. If a surgical procedure was FSI then it will have a PARENT_EVENT_ID.
PROC_DT_TM DATETIME Y Date and Time the procedure occurred.
SURGEON_NAME_FULL_FORMATTED VARCHAR(250) Y Display value of the Surgeon Name to be used in CDA creation.
SURGEON_PRSNL_ID DOUBLE N Foreign key to PRSNL table for the performing surgeon.
SURG_CASE_ID DOUBLE N Foreign key to SURGICAL_CASE table. If the surgical procedure came from the Surginet tables then it will have a surg_case_id.
SURG_CASE_NBR_FULL_FORMATTED VARCHAR(250) Y Display value of the Case Number to be used in CDA creation.
SURG_PROC_CD DOUBLE N The code value for the surgical procedure.
SURG_PROC_DISP VARCHAR(200) Y The string description of the surgical procedure entered via Ad hoc, FSI, or Surginet.
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_SURG_DATA


Child Column in LH_CNT_IC_ADV_SURG_DATA(FK) Parent Table Name Parent Column Name
Parents: EKS_ADVSR_EVENT_ID EKS_ADVSR_EVENT EKS_ADVSR_EVENT_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
SURGEON_PRSNL_ID PRSNL PERSON_ID
SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID


LH_CNT_IC_ADV_WOUND_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_IC_ADV_WOUND_DATA
Definition: Custom table for Infection Control Advisor that will store Incision/Wound data that has been saved by the user.
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_ADV_WOUND_DATA


Column Name Type Null? Definition
ABNORMALITY_TYPE_DISP VARCHAR(250) Y Display string for the documented Abnormality Type.
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.
CE_DYNAMIC_LABEL_ID DOUBLE N The label_id of the dynamic label that this Incision/Wound is associated with. (from ce_dynamic_label.label_id)
EKS_ADVSR_EVENT_ID DOUBLE N The foreign key to the EKS_ADVSR_EVENT table
ENCNTR_ID DOUBLE N The foreign key to the 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.
EVENT_DT_TM DATETIME Y The date time that the Incision/Wound event occurred.
EXUDATE_DISP VARCHAR(250) Y Display string for the documented Exudate.
INC_WOUND_DISP VARCHAR(250) Y The Incision/Wound display label. Concatenation of Laterality, Location Description, and Location.
LH_CNT_IC_ADV_WOUND_DATA_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_ADV_WOUND_DATA table.
SURGICAL_INC_WOUND_IND DOUBLE N Indicator to designate 'Surgical' or 'Other' Incision/Wounds. 0 = Other, 1 = Surgical
TISSUE_COLOR_DISP VARCHAR(250) Y Display string for the documented Tissue Color.
TISSUE_CONDITION_DISP VARCHAR(250) Y Display string for the documented Tissue Condition.
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_WOUND_DATA


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



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_IC_ANTIBGRM_GROUP
Definition: Holds the group names for the antibiogram reporting solution
Table Type: REFERENCE





Column Detail - LH_CNT_IC_ANTIBGRM_GROUP


Column Name Type Null? Definition
GROUP_NAME VARCHAR(100) N The name of the grouping
GROUP_TYPE_FLAG DOUBLE N Group Type Flag Values 1 = Organism Group, 2 = Encounter Group, 3 = Specimen Group
LH_CNT_IC_ANTIBGRM_GROUP_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_ANTIBGRM_GROUP 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_ANTIBGRM_GROUP




Parent Column in LH_CNT_IC_ANTIBGRM_GROUP (PK) Child Table Name Child Column Name
Children: LH_CNT_IC_ANTIBGRM_GROUP_ID LH_CNT_IC_ANTIBGRM_GROUP_R LH_CNT_IC_ANTIBGRM_GROUP_ID
LH_CNT_IC_ANTIBGRM_ORG_DSC LH_CNT_IC_ANTIBGRM_GROUP_ID