CQM_STDBATCH_QUE



Column Section Top of Page


Table-level Detail

Description: STANDARD BATCH INTERFACE
Definition: Transactions from ESO for standard batch interfaces are placed in this table and read by the outbound comserver.
Table Type: ACTIVITY





Column Detail - CQM_STDBATCH_QUE


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.
CLASS VARCHAR(15) Y Identifies the trigger explosion class of the transaction.
CONTRIBUTOR_EVENT_DT_TM DATETIME Y Significant date and time associated with the transaction row as supplied by the contributor application.
CONTRIBUTOR_ID DOUBLE N This is the value of hte unique primary identifier of the CQM contributor configuration table. It is an internal system assigned number.
CONTRIBUTOR_REFNUM VARCHAR(48) N A reference or key assigned to the transaction row by the contributor application. It recommended that this identifier be unique although it is not required.
CREATE_DT_TM DATETIME N The date and time the row was inserted.
CREATE_RETURN_FLAG DOUBLE Y The current trigger explosion state for this transaction row.
CREATE_RETURN_TEXT VARCHAR(132) Y Return text string from the trigger explosion process of this transaction row.
DEBUG_IND DOUBLE Y Defines whether debugging is active or inactive for the queue transaction unidentified in this row.
MESSAGE LONGBLOB Y This is the binary longraw field which contains the contents of the original message.
MESSAGE_LEN DOUBLE N The length of the textual or binary object placed in the message field.
PARAM_LIST_IND DOUBLE Y Identifies whether there are row in the queue parameters table associated with this transaction row.
PRIORITY DOUBLE N Identifies the priority of this transaction row that may or may not be used to process in a prioritized method. The value range for priority is 1 through 99, highest to lowest, respectively.
PROCESS_STATUS_FLAG DOUBLE N The current trigger explosion state for this transaction row.
QUEUE_ID DOUBLE N This is the value of the unique primary identifier of the CQM queue table. It is an internal system assigned number.
SUBTYPE VARCHAR(15) Y Identifies the trigger explosion subtype of the transaction.
SUBTYPE_DETAIL VARCHAR(15) Y Identifies the trigger explosion subtype detail of the transaction.
TRIG_CREATE_END_DT_TM DATETIME Y The date and time the trigger explosion completed on this transaction row.
TRIG_CREATE_START_DT_TM DATETIME Y The date and time the trigger explosion began on this transaction row.
TRIG_MODULE_IDENTIFIER VARCHAR(16) Y Trigger Module Identifier.
TYPE VARCHAR(15) Y Identifies the trigger explosion 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.
VERBOSITY_FLAG DOUBLE Y Defines the verbosity level during debugging for the processing of the transaction.


CQM_STDBATCH_TR_1



Column Section Top of Page


Table-level Detail

Description: STANDARD BATCH INTERFACE
Definition: Trigger transactions from ESO for standard batch interfaces are placed in this table and read by the outbound comserver to obtain queued messages.
Table Type: ACTIVITY





Column Detail - CQM_STDBATCH_TR_1


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.
COMPLETION_SEQUENCE_ID DOUBLE N Order in which rows are processed.
CREATE_DT_TM DATETIME N The date and time the row was inserted
DEBUG_IND DOUBLE Y Defines whether debugging is active or inactive for the listener trigger explosion event unidentified in this row
LAST_RETRY_DT_TM DATETIME Y The date and time of the last retry to process this trigger exploded transaction row. This field may or may not be used by the listener application
LISTENER_ID DOUBLE N This is the value of the unique primary identifier of the CQM listener configuration table. It is an internal system assigned number
L_R_PROCESS_STATUS_FLAG DOUBLE Y The last retry processing state for this trigger exploded transaction row. This field may or may not be used by the listener application.
L_R_TRIGGER_STATUS_TEXT VARCHAR(132) Y The last retry processing text for this trigger exploded transaction row. This field may or may not be used by the listener application.
NUMBER_OF_RETRIES DOUBLE Y Set to 0 on insert. Optionally incremented by 1 by the listener application to specify the number of times the listener attempted to process the trigger exploded transaction
PRIORITY DOUBLE N Identifies the priority of this transaction row that may or may not be used to process in a prioritized method. The value range for priority is 1 throug 99, highest to lowest, respectively.
PROCESS_START_DT_TM DATETIME Y The date and time the listener application started processing on this exploded transaction.
PROCESS_STATUS_FLAG DOUBLE N The current processing state for this trigger exploded transaction row.
PROCESS_STOP_DT_TM DATETIME Y The date and time the listener application completed processing on this exploded transaction
QUEUE_ID DOUBLE N This is the value of the unique primary identifier from the CQM queue table. It is an internal system assigned number
SCHEDULE_DT_TM DATETIME N The date and time this exploded transaction row is scheduled for processing.
TRIGGER_ID DOUBLE N This is the value of the unique primary identifier of the CQM listener trigger table. It is an internal system assigned number
TRIGGER_STATUS_TEXT VARCHAR(132) Y The status text associated with the processing status flag.
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.
VERBOSITY_FLAG DOUBLE Y Defines the verbosity level during debugging for the processing of the transaction.


ESO_TRANSACTION_RECORD



Column Section Relationship Section Top of Page


Table-level Detail

Description: ESO TRANSACTION RECORDS
Definition: Contains details of events that are processed or filtered
Table Type: ACTIVITY





Column Detail - ESO_TRANSACTION_RECORD


Column Name Type Null? Definition
ENCNTR_ID DOUBLE N Encounter ID from the ENCOUNTER table
ESO_TRANSACTION_RECORD_ID DOUBLE N PRIMARY KEY
PARENT_ENTITY_ID DOUBLE N The unique identifier from the parent table referrenced in PARENT_ENTITIY_NAME column.
PARENT_ENTITY_NAME VARCHAR(30) N Name of the parent table for the value referrenced in PARENT_ENTITY_ID
PROCESS_STATUS_FLAG DOUBLE N Indicate the status of parent_entity_id0 = Not Defined 10 = Processed 20 = Filtered 30 = Hold
TRANSACTION_GROUP_IDENT DOUBLE N The identifer used to group the events from the CQM_FSIESO_QE table. Typically a value from that table, but can be a value not yet written to that table. Therefore, no Foreign Key relationship exists.
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_TRANSACTION_RECORD


Child Column in ESO_TRANSACTION_RECORD(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID


SI_ALERT_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Alert Event
Definition: Table containing a record of alert events encountered during interface processing
Table Type: ACTIVITY





Column Detail - SI_ALERT_EVENT


Column Name Type Null? Definition
ALERT_STATUS_TFLG VARCHAR(10) N Text value that represents the status of this row. The possible values for alert_status_tflg are Active and Cleared
ALERT_TYPE_TFLG VARCHAR(30) N Text value that classifies the alert type. Current alert_type_tflg values are: LOAD_SCRIPT - ROUTE_SCRIPT - FORMAT_SCRIPT - TCP_IP - TERMINATION - INITIALIZATION - ROUTE_QUEUE - ROUTE_SRV -; ROUTE_FORMAT - NO_PERSONALITY - ROUTE_LIST - NO_CUST_ROUTE - FORWARD_TO_EJS - DATABASE - MEMORY_ALLOC - ESO_TERMINATE
APPLICATION_NAME VARCHAR(12) N The application name denotes a specific functional area of System Integration processing.
CLEAR_DT_TM DATETIME Y The date and time that the alert event ended.
CREATE_DT_TM DATETIME N The date and time that the alert event occurred.
ERROR_TXT VARCHAR(500) Y Error message from the process that created the alert event.
EXPIRE_DT_TM DATETIME Y The date and time when an extendable alert automatically clears.
FSIESO_TRIGGER_ID DOUBLE Y the transaction trigger_id generated during the context of an ESO transaction and is stored in the cqm_fsieso_tr_1 as the trigger_id field.
INSTANCE_NBR DOUBLE Y Server instance number.
LISTENER_ALIAS VARCHAR(48) N LISTENER_ALIAS value from table cqm_listener_config
NODE_NAME VARCHAR(64) Y Node on which the server generating the alert is running on.
OENINTERFACE_TRIGGER_ID DOUBLE Y the transaction trigger_id generated during the context of an OEN transaction and is stored in the cqm_oeninterface_tr_1 as the trigger_id field.
PROCESS_NAME VARCHAR(32) N The name of the interface server process. This a core server or interface communication server process.
SCP_NBR DOUBLE Y SCP entry number for the interface server.
SI_ALERT_EVENT_ID DOUBLE N PRIMARY KEY
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 - SI_ALERT_EVENT


Child Column in SI_ALERT_EVENT(FK) Parent Table Name Parent Column Name
Parents: FSIESO_TRIGGER_ID CQM_FSIESO_TR_1 TRIGGER_ID
OENINTERFACE_TRIGGER_ID CQM_OENINTERFACE_TR_1 TRIGGER_ID


SI_CDA_TEMPLATE_IDENT



Column Section Top of Page


Table-level Detail

Description: SI CDA TEMPLATE IDENTIFIERS
Definition: This table contains information needed to retrieve Clinical Document Architecture (CDA) document template identifiers.
Table Type: REFERENCE





Column Detail - SI_CDA_TEMPLATE_IDENT


Column Name Type Null? Definition
CDA_CONTENT_DISPLAY VARCHAR(255) N The display for the code value outbound alias for this document type
CDA_CONTENT_IDENT VARCHAR(255) N The identifier for the code value outbound alias for this document type
CDA_DOC_TEMPLATE_EXT VARCHAR(255) N The CDA Document template identifier to be included as the value for the ClinicalDocument /templateId @extension.
CDA_DOC_TEMPLATE_IDENT VARCHAR(255) N The CDA Document template identifier to be included as the value for the ClinicalDocument /templateId @root.
CONTRIBUTOR_SOURCE_CD DOUBLE N The Contributor Source for the code value outbound alias.
OUTPUT_CONTENT_TYPE_CD DOUBLE N The output format of this document (such as CDA-Wrapped PDF, Consolidated CDA).
SECTION_CD DOUBLE N The section code value related to the identifier supplied. This will relate the identifier to a section during CDA document generation.
SI_CDA_TEMPLATE_IDENT_ID DOUBLE N PRIMARY KEY
SUMMARY_CARE_TYPE_CD DOUBLE N If selected, then this document must meet all required specifications for the selected type.
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.