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 |