EKS_ADVSR_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: EKS Advisor Event
Definition: Event tracking table, contains a row for each time a Discern Advisor event has occurred.
Table Type: ACTIVITY





Column Detail - EKS_ADVSR_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.
ADVSR_EVENT_DESC VARCHAR(100) N This will be a brief description of the Discern Advisor that has been saved.
ADVSR_GROUP_ID DOUBLE N Group ID is used to track changes to the Discern Advisor event. The ADVSR_GROUP_ID will be the same for all rows of a specific Discern Advisor Event. The ADVSR_GROUP_ID will be the same as the EKS_ADVSR_EVENT_ID for the first event.
ADVSR_STATUS_CD DOUBLE N Indicates the status of the event itself (not the data in the row) such as COMPLETE, SAVED, SUBMITTED, INPROGRESS etc.
ADVSR_TYPE_CD DOUBLE N The type of event that row is being written from. Pre-defined values by Cerner.
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.
EKS_ADVSR_EVENT_ID DOUBLE N This is the unique identifier for rows on this table. The value of this field is identified by obtaining the next sequential number in the PathNet_Seq.
ENCNTR_ID DOUBLE N The encounter associated with the discern adviser event.
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 This field identifies the date/time the advisor event has occurred or will occur.
LOCATION_CD DOUBLE Y The field identifies the location of the patient.
LONG_TEXT_ID DOUBLE N Identifies entry in the long text table which contains contains the XML.
PERSON_ID DOUBLE N The ID of the person associated to the discern adviser event.
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 - EKS_ADVSR_EVENT


Child Column in EKS_ADVSR_EVENT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
LOCATION_CD LOCATION LOCATION_CD
PERSON_ID PERSON PERSON_ID




Parent Column in EKS_ADVSR_EVENT (PK) Child Table Name Child Column Name
Children: EKS_ADVSR_EVENT_ID LH_CNT_ADVSR_EVENT EKS_ADVSR_EVENT_ID
LH_CNT_IC_ADV_EVENT_DETAIL EKS_ADVSR_EVENT_ID
LH_CNT_IC_ADV_EVENT_LOC EKS_ADVSR_EVENT_ID
LH_CNT_IC_ADV_LAB_DATA EKS_ADVSR_EVENT_ID
LH_CNT_IC_ADV_LTD EKS_ADVSR_EVENT_ID
LH_CNT_IC_ADV_MICRO EKS_ADVSR_EVENT_ID
LH_CNT_IC_ADV_RISK_FACTOR EKS_ADVSR_EVENT_ID
LH_CNT_IC_ADV_SEL_CRITERIA EKS_ADVSR_EVENT_ID
LH_CNT_IC_ADV_SPEC_EVENT EKS_ADVSR_EVENT_ID
LH_CNT_IC_ADV_SURG_DATA EKS_ADVSR_EVENT_ID
LH_CNT_IC_ADV_WOUND_DATA EKS_ADVSR_EVENT_ID