DSI_FEEDBACK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Decision Support Intervention Feedback
Definition: This table contains decision support intervention information with user feedback.
Table Type: ACTIVITY





Column Detail - DSI_FEEDBACK


Column Name Type Null? Definition
ACTION_FLAG DOUBLE N Flag for the action taken. 0 - Other, 1 - Viewed, 2 - Canceled, 3 - Continued, 4 - Modified.
ACTION_TXT VARCHAR(255) Y Action text for other (0) Action Flag.
DSI_DT_TM DATETIME Y Date and time of the intervention.
DSI_FEEDBACK_ID DOUBLE N Unique generated number that identifies a single row on the DSI_FEEDBACK table. Populated by Oracle sequence DSI_SEQ.
DSI_NAME VARCHAR(255) Y Name of the intervention the feedback is for..
ENCNTR_ID DOUBLE Y The Encounter Id associated to the intervention.
FEEDBACK_TXT LONGBLOB Y The user feedback for the intervention.
LOCATION_TXT VARCHAR(255) Y The location of the intervention.
PRSNL_ID DOUBLE Y Identifier of the Personnel creating the feedback. Foreign key to the PRSNL table.
RATING_NBR DOUBLE Y The user's rating for the alert. Rating range 1-5.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 - DSI_FEEDBACK


Child Column in DSI_FEEDBACK(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PRSNL_ID PRSNL PERSON_ID


EKS_ALERT_ESCALATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: EKS ALERT ESCALATION
Definition: EKS ALERT ESCALATION
Table Type: ACTIVITY





Column Detail - EKS_ALERT_ESCALATION


Column Name Type Null? Definition
ACK_BY_DT_TM DATETIME Y date and time that acknowledgement must be received by.
ALERT_ID DOUBLE N alert id
ALERT_SOURCE VARCHAR(100) Y alert source
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ESCALATION_LEVEL DOUBLE Y escalation level
MSG_LONG_TEXT_ID DOUBLE N message long text identifier
ORDER_ID DOUBLE N order that triggered the alert
PARENT_ALERT_ID DOUBLE N alert identifier of parent alert
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRIORITY DOUBLE Y message priority
PROCESS_FLAG DOUBLE Y process flag
SEND_DT_TM DATETIME Y date and time the alert was sent
SUBJECT_PREFIX_TEXT VARCHAR(100) Y prefix of the subject
SUBJECT_TEXT VARCHAR(200) Y text of the subject of the alert
TIMER_IND DOUBLE N time driven event indicator
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_ALERT_ESCALATION


Child Column in EKS_ALERT_ESCALATION(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
MSG_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORDER_ID ORDERS ORDER_ID
PERSON_ID PERSON PERSON_ID




Parent Column in EKS_ALERT_ESCALATION (PK) Child Table Name Child Column Name
Children: ALERT_ID EKS_ALERT_ESC_HIST PARENT_ALERT_ID
EKS_ALERT_RECIPIENT ALERT_ID


EKS_ALERT_ESC_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: eks_alert_esc_hist
Definition: eks alert escalation history
Table Type: ACTIVITY





Column Detail - EKS_ALERT_ESC_HIST


Column Name Type Null? Definition
ACK_BY_DT_TM DATETIME Y date and time that acknowledgement must be received by.
ACK_BY_ID DOUBLE N acknowledged by identifier
ACK_COMMENT VARCHAR(2000) Y acknowledgement comment
ACK_DT_TM DATETIME Y Acknowledgement date/time.
ALERT_ID DOUBLE N alert id
ALERT_SEQ DOUBLE N alert sequence
ALERT_SOURCE VARCHAR(100) Y alert source
CLOSED_IND DOUBLE Y Closed indicator
EKS_ALERT_ESC_HIST_ID DOUBLE N eks alert history identifier
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ESCALATION_LEVEL DOUBLE Y escalation level
EXPECTATION_FLAG DOUBLE Y flag to show that the expectation of a discern rule is met or not met.
FAILURE_REASON VARCHAR(100) Y Failure reason
MSG_LONG_TEXT_ID DOUBLE N message long text identifier
MSG_TYPE_CD DOUBLE N message type code
ORDER_ID DOUBLE N order that triggered the alert
PARENT_ALERT_ID DOUBLE N alert identifier of parent alert
PARENT_ENTITY2_ID DOUBLE N Parent Entity 2 Identifier
PARENT_ENTITY2_NAME VARCHAR(30) N Parent entity 2 name
PARENT_ENTITY_ID DOUBLE N Parent entity identifier
PARENT_ENTITY_NAME VARCHAR(30) N Name of the Parent Entity
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRIORITY DOUBLE Y priority value
RECIPIENT_NAME VARCHAR(100) Y recipient name
SEND_DT_TM DATETIME Y date and time the alert was sent
SUBJECT_PREFIX_TEXT VARCHAR(100) Y prefix of the subject
SUBJECT_TEXT VARCHAR(200) Y text of the subject of the alert
TIMER_IND DOUBLE N time driven event indicator
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_ALERT_ESC_HIST


Child Column in EKS_ALERT_ESC_HIST(FK) Parent Table Name Parent Column Name
Parents: PARENT_ALERT_ID EKS_ALERT_ESCALATION ALERT_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
MSG_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORDER_ID ORDERS ORDER_ID
PERSON_ID PERSON PERSON_ID
ACK_BY_ID PRSNL PERSON_ID


EKS_ALERT_RECIPIENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: eks alert recipient
Definition: eks alert recipient
Table Type: ACTIVITY





Column Detail - EKS_ALERT_RECIPIENT


Column Name Type Null? Definition
ALERT_ID DOUBLE N alert id
ALERT_SEQ DOUBLE N alert sequence
EKS_ALERT_RECIPIENT_ID DOUBLE N eks alert recipient identifier
FAILURE_REASON VARCHAR(100) Y failure reason
MSG_TYPE_CD DOUBLE N message type code
PARENT_ENTITY2_ID DOUBLE N parent entity identifier
PARENT_ENTITY2_NAME VARCHAR(30) N Parent entity 2 name
PARENT_ENTITY_ID DOUBLE N Parent entity identifier
PARENT_ENTITY_NAME VARCHAR(30) N Name of the Parent Entity
RECIPIENT_NAME VARCHAR(100) Y recipient name
UNACK_COMMENT VARCHAR(2000) Y unacknowledged comment
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_ALERT_RECIPIENT


Child Column in EKS_ALERT_RECIPIENT(FK) Parent Table Name Parent Column Name
Parents: ALERT_ID EKS_ALERT_ESCALATION ALERT_ID


EKS_DLG



Column Section Relationship Section Top of Page


Table-level Detail

Description: EKS DLG
Definition: Reference data for the installed Insights with versions and active dates.
Table Type: REFERENCE





Column Detail - EKS_DLG


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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.
DLG_NAME VARCHAR(255) N Unique identifier for an Insight.
END_EFFECTIVE_DT_TM DATETIME Y 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.
PROGRAM_NAME CHAR(30) Y File name for the ActiveX control which executes the client portion of and Insight.
TITLE VARCHAR(255) Y Full title of an Insight.
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.
VERSION_MAJOR DOUBLE Y Major version identifier for an Insight
VERSION_MINOR DOUBLE Y Minor version identifier for an Insight



Relationship Detail - EKS_DLG




Parent Column in EKS_DLG (PK) Child Table Name Child Column Name
Children: DLG_NAME EKS_DLG_EVENT DLG_NAME