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 |