Table Detail Report

ESI_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: ESI LOG
Definition: External System Interface Inbound Log Table
Table Type: ACTIVITY





Column Detail - ESI_LOG


Column Name Type Null? Definition
ACCESSION_ID DOUBLE N Accession id from the inbound HL7 messageColumn
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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BATCH_EVENT_ID DOUBLE N This is the primary key from the SI_BATCH_EVENT table.Column
BINDING VARCHAR(32) Y This is the server"s binding parameter in SCP.
CARE_SET_FLAG DOUBLE Y This determines whether the order is a parent or a member of a CareSet.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CREATE_DT_TM DATETIME Y This is the date and time the row was created.
CREATE_TIME DOUBLE N The time in Milliseconds when the record was written
DOMAIN_ERROR_STAT_CD DOUBLE N This is the error code from an asynchronous domain server or script during the processing of a transaction. Its purpose is to track the status of a transaction after its release from ESI.
DOMAIN_ERROR_TEXT VARCHAR(500) Y This is the error(s) encountered during the domain"s transaction processing.
ENCNTR_ALIAS VARCHAR(255) Y Encounter Aliases related to the incoming message
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
END_DT_TM DATETIME Y This is the date and time the transaction was completed.
END_TIME VARCHAR(16) Y This is the time when ESI finished processing.
ENTITY_COUNT DOUBLE Y This is the number of identifiers created for an Entity Name. For example, if the Entity Name is 'ORDERS' and the entity count is 8, then eight orders where placed for the transaction.
ENTITY_LIST VARCHAR(128) Y This is a list of identifiers if more than one identifier was generated for this transaction. For example, if the Entity Name is 'ORDERS' and the Entity List is '1000, 10001, 10002,' then three additional orders with order_ids of 1000, 10001, and 10002 were created (in addition to the order in theorder_id column).
ENTITY_NAME VARCHAR(32) Y This is the Entity Name for the primary table that was added for the transaction, e.g., 'ORDERS', 'CLINICAL_EVENT,' 'SCH_SCHEDULE.'
ERROR_STAT VARCHAR(32) Y This is a string describing the transaction's status. Examples are SUCCESS, WARNING, RETRY, FAILURE, TERMINAL, TERMINATE.
ERROR_TEXT VARCHAR(500) Y This is the error(s) encountered during transaction processing.
ESI_INSTANCE DOUBLE Y This is the instance number of the ESI Server.
ESI_LOG_ID DOUBLE N This is the Primary Key for the Esi_Log table.
ESI_LOG_ORIG_ID DOUBLE N This is the original ESI_LOG_ID value. When the row is updated, a new row will actually be added with a new key. This field will associate the new row to the original row. This field, in conjunction with the ACTIVE family columns, will be used to track changes to a row.
ESI_TX_KEY VARCHAR(27) Y This is the transaction key from the oen_txlog table that the esi comserver logged.
EVENT_ID DOUBLE N This is the unique identifier for an event.
HL7_ACCESSION_NBR VARCHAR(20) Y Accession number from inbound HL7 messageColumn
HL7_ENTITY_ALIAS VARCHAR(255) Y This is the unique identifier the sending system uses to identify the entity processed.
HL7_ENTITY_CODE VARCHAR(128) Y This is the alias to the code to identify a specific order, result, schedule, etc. For example, for orders this is the code to identify a particular order catalog, e.g., 122200, if 122200 is an alias to a catalog code such as CBC.
HOLD_ALIAS_FLAG DOUBLE Y This field identifies the alias type that was received and configured to release items from hold. Examples are 1 for person_alias, 2 for encntr_alias, and 4 for order_alias. Each is the binary representation, so multiple release items can be identified.
HOLD_RELEASE_STAT DOUBLE Y This field identifies the error status returned from the Hold Release Server.
INTERNAL_MESSAGE_IDENT VARCHAR(40) Y System generated message identifier
LONG_BLOB_ID DOUBLE N Associated row onthe LONG_BLOB table which contains additional status information
MESSAGE_TRIGGER_CD DOUBLE Y UI message trigger codeColumn
MSGID VARCHAR(16) Y This is the unique transaction identifier used by the Open Port Com Client. This identifier will reference a raw HL7 transaction on the oen_txlog table.
MSH_CTRL_IDENT VARCHAR(100) Y This is the MSH Control Identifier.
MSH_DATE VARCHAR(32) Y This is the MSH Date and Time.
MSH_MSG_TRIG VARCHAR(8) Y This is the MSH Message Event Trigger, e.g., A01, A02.
MSH_MSG_TYPE VARCHAR(8) Y This is the MSH Message Type
MSH_SENDING_APP VARCHAR(32) Y This is the MSH Sending Application.
NAME_FULL_FORMATTED VARCHAR(100) Y This is the Person"s full formatted name.
ORDER_CTRL VARCHAR(8) Y This is the ORC Order Control Field, e.g., NW, CA.
ORDER_ID DOUBLE N This is the Order identifier.
PERSON_ALIAS VARCHAR(255) Y Person Aliases related to the incoming message.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PROCD_RESTORE_FLAG DOUBLE N Describes the restore action of the ESI transaction. 0 = no restore; 1 = restore on matched person; 2 = restore on merged person; 3 = restore on matched and merge persons; 4 = restore on reconciled persons; 5 = restore on matched and reconciled persons; 6 = restore on merged and reconciled persons; 7 = restore on matched, merged, and reconciled persons
QUEUE_ID DOUBLE N This is the primary key from the CQM_OENINTERFACE_QUE tableColumn
REFERRAL_ID DOUBLE Y Uniquely identifies the related referral documents.
SCH_EVENT_ID DOUBLE N This is the unique schedule identifier.
START_DT_TM DATETIME Y This is the date and time the transaction entered the ESI Server.
START_TIME VARCHAR(16) Y This is the time when ESI received a transaction.
TASK_ID DOUBLE N This is the primary key from the TASK_ACTIVITY table.Column
TX_KEY VARCHAR(27) Y This is the transaction key from the oen_txlog table that the inbound comserver logged.
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 - ESI_LOG


Child Column in ESI_LOG(FK) Parent Table Name Parent Column Name
Parents: ACCESSION_ID ACCESSION ACCESSION_ID
QUEUE_ID CQM_OENINTERFACE_QUE QUEUE_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
LONG_BLOB_ID LONG_BLOB LONG_BLOB_ID
ORDER_ID ORDERS ORDER_ID
PERSON_ID PERSON PERSON_ID
REFERRAL_ID REFERRAL REFERRAL_ID
SCH_EVENT_ID SCH_EVENT SCH_EVENT_ID
BATCH_EVENT_ID SI_BATCH_EVENT BATCH_EVENT_ID
TASK_ID TASK_ACTIVITY TASK_ID




Parent Column in ESI_LOG (PK) Child Table Name Child Column Name
Children: ESI_LOG_ID ESI_SCRIPT_USAGE ESI_LOG_ID
RX_PENDING_REFILL ESI_LOG_ID
RX_REFILL_HX ESI_LOG_ID


ESI_SCRIPT_USAGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: ESI Script Usage
Definition: This table stores the scripts, and their duration, executed by the ESI Server.
Table Type: ACTIVITY





Column Detail - ESI_SCRIPT_USAGE


Column Name Type Null? Definition
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CREATE_DT_TM DATETIME N The date and time message was created.
ELAPSED_TIME DOUBLE N Length of time spent executing the given script.The time in ms for script execution.
ESI_LOG_ID DOUBLE N ESI_LOG_ID associated to the message that used the listed scripts.
ESI_SCRIPT_USAGE_ID DOUBLE N Primary Key
MESSAGE_TYPE VARCHAR(20) N The message type used to generate the message associated to this script.
MESSGE_TRIGGER VARCHAR(20) N The message trigger used to generate the message associated to this script.
SCRIPT_NAME VARCHAR(40) N Name of the executed script.
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 - ESI_SCRIPT_USAGE


Child Column in ESI_SCRIPT_USAGE(FK) Parent Table Name Parent Column Name
Parents: ESI_LOG_ID ESI_LOG ESI_LOG_ID


ESO_TRIGGER



Column Section Relationship Section Top of Page


Table-level Detail

Description: ESO Trigger Table
Definition: This table defines the event triggers for the ESO Server to process. The element on this table illustrates how to identify each trigger. The active indicator on this table defines whether the trigger is configured for outbound processing.
Table Type: REFERENCE





Column Detail - ESO_TRIGGER


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.
CALL_SRV_FLAG DOUBLE Y This table row is 1 or 0. It either call the eso server or it doesn't
CLASS VARCHAR(15) Y Identifies the ESO server processing class of the transaction.
CREATE_DT_TM DATETIME N This is the date and time that a row is created in the eso_trigger table.
DESCRIPTION VARCHAR(256) Y This string provides a description of the event trigger row.
INTERFACE_TYPE_CD DOUBLE N This field creates at relation from the particular ESO trigger combination to a interface type. Multiple ESO triggers can be associated to a single interface type.
MESSAGE_FORMAT_CD DOUBLE N Format of the message
MESSAGE_TRIGGER_CD DOUBLE N message trigger codeColumn
MESSAGE_TYPE_CD DOUBLE N Type of the message
MESSAGE_VERSION_CD DOUBLE N Version of the message
PROCESSING_CONTROL DOUBLE Y This number controls specific ESO server processing method when executing the trigger event.
REQUEST_NBR DOUBLE N Ddefines the TDB request number for the HL7 csa objects.
SCP_BINDING VARCHAR(128) Y Identifies the ESO server processing scp binding of the transaction.
SOURCE_REQ_NBR DOUBLE Y For X12 transactions, it provides the TDB request number.
SUBTYPE VARCHAR(15) Y Identifies the ESO server processing subtype of the transaction.
SUBTYPE_DETAIL VARCHAR(15) Y Identifies the ESO server processing subtype detail of the transaction.
TRIGGER_ID DOUBLE N This is the value of the unique primary identifier of the eso_trigger table. It is an internal system assigned number.
TYPE VARCHAR(15) Y Identifies the ESO server processing type of the transaction.
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 - ESO_TRIGGER




Parent Column in ESO_TRIGGER (PK) Child Table Name Child Column Name
Children: TRIGGER_ID CHART_REQUEST TRIGGER_ID
CQM_FSIESO_TR_1 ESO_TRIGGER_ID
ESO_TRIG_ROUTINE_R TRIGGER_ID
SI_ESO_TRIGGER_HIST TRIGGER_ID


OEN_ERROR



Column Section Relationship Section Top of Page


Table-level Detail

Description: OEN ERROR
Definition: Holds all possible OE errors
Table Type: REFERENCE





Column Detail - OEN_ERROR


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.
ERROR_ID DOUBLE N Error_idColumn
ERROR_VALUE VARCHAR(10) N Error number returned from app
PROTOCOL_FLAG DOUBLE Y Define which protocol this is for.
SERVICE_FLAG DOUBLE Y The service this error is for.
STEP_ID DOUBLE N ID of the step
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 - OEN_ERROR


Child Column in OEN_ERROR(FK) Parent Table Name Parent Column Name
Parents: STEP_ID OEN_STEP STEP_ID




Parent Column in OEN_ERROR (PK) Child Table Name Child Column Name
Children: ERROR_ID OEN_ERROR_SEQ_R ERROR_ID
OEN_INTERFACE_ERR_R ERROR_ID


OEN_ERROR_SEQ_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: OEN ERROR SEQ R
Definition: Relation between the Error table and Sequence table.
Table Type: REFERENCE





Column Detail - OEN_ERROR_SEQ_R


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.
CUSTOM_IND DOUBLE Y Defines whether this Error/Seq relation was created by a user.Column
ERROR_ID DOUBLE N Error ID off the OEN_ERROR table.Column
ERROR_SEQ_ID DOUBLE N Unique number identifying this Error/Seq relation.Column
SEQUENCE_ID DOUBLE N ID from the OEN_SEQUENCE table.Column
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 - OEN_ERROR_SEQ_R


Child Column in OEN_ERROR_SEQ_R(FK) Parent Table Name Parent Column Name
Parents: ERROR_ID OEN_ERROR ERROR_ID
SEQUENCE_ID OEN_SEQUENCE SEQUENCE_ID