Table Detail Report

OEN_TX_STATS_LOG



Column Section Top of Page


Table-level Detail

Description: OEN TX STATS LOG
Definition: This table is used to keep statistic information on transactions through OE
Table Type: ACTIVITY





Column Detail - OEN_TX_STATS_LOG


Column Name Type Null? Definition
END_DT_TM DATETIME Y The ending date and time for this row.Column
START_DT_TM DATETIME Y The start date and time for this row.Column
STAT_ID DOUBLE N Unique ID.Column
TOTAL_COUNT DOUBLE Y Total count of transactions for this time period


SI_AUDIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: SI Audit
Definition: Contains a log of all transactions sent and received.
Table Type: ACTIVITY





Column Detail - SI_AUDIT


Column Name Type Null? Definition
ERROR_CD DOUBLE N This is the error code of the current transaction. it can indicate a specific error in a given system.
ERROR_TEXT VARCHAR(500) N This is the text provided for the given error code.
MSG_CREATION_DT_TM DATETIME N Date and time the message was created.
MSG_IDENT VARCHAR(250) N This is the unique identifier for the given message (alpha-numeric)
MSG_TRIG_ACTION_TXT VARCHAR(250) N This is the message trigger
MSG_TYPE_TXT VARCHAR(250) N This is the message type
PARENT_ENTITY_ID DOUBLE N This is the identifier of the table referenced by parent_entity_name
PARENT_ENTITY_NAME VARCHAR(30) N This is the name of the parent table referenced
PERSON_ID DOUBLE N This is the unique identifier for the person
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 and storing it in this table to support not_slot_cancel resend functionality.
RECV_APP_IDENT VARCHAR(250) N This is the identifier of the receiving application
RECV_FAC_IDENT VARCHAR(250) Y This is the identifier of the receiving facility
REFER_TO_MSG_IDENT VARCHAR(250) N This is the unique identifier of a message referred to by the current message
RETAIN_UNTIL_DT_TM DATETIME Y This field contains the DATE/TIME value that indicates retention period of the rows before purging.
SEND_APP_IDENT VARCHAR(250) N This is the identifier of the sending application.
SEND_FAC_IDENT VARCHAR(250) Y This is the identifier of the sending facility
SI_AUDIT_ID DOUBLE N Unique row identifier for each audit event
STATUS_CD DOUBLE N This is the status code of the current transaction. It can indicate an application success or failure in a given system.
SYS_DIRECTION_CD DOUBLE N This is the direction or usage of the contributor system. This will differentiate between inbound and outbound transactions.
TRN_CONV_IDENT VARCHAR(250) Y This is a unique identifier for conversation between two parties. The Party initiating a conversation determines the value of the ConversationId element that SHALL be reflected in all messages pertaining to that conversation.
TRN_MSG_IDENT VARCHAR(250) Y This is a unique identifier for ebxml message
TRN_REF_TO_MSG_IDENT VARCHAR(250) Y RefToMessageId element contains the MessageId of the message whose delivery is being reported. This is always the message id from the previous message.
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 - SI_AUDIT


Child Column in SI_AUDIT(FK) Parent Table Name Parent Column Name
Parents: QUEUE_ID CQM_FSIESO_QUE QUEUE_ID


SI_BATCH



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table holds descriptive information on an outbound batch.
Definition: Each row corresponds to a single outbound batch.
Table Type: ACTIVITY





Column Detail - SI_BATCH


Column Name Type Null? Definition
BATCH_DESCRIPTION VARCHAR(255) N A non-unique descriptive string to identify the batch.Column
BATCH_ID DOUBLE N Unique batch identifier.
BATCH_NUMBER VARCHAR(25) N Unique domain string to identify the outbound batch.
BATCH_ORIGIN_CD DOUBLE N Code Set (25452) that identifies the sending domain.
BATCH_STATUS_FLAG DOUBLE N Indicates the current processing status of the outbound batch.Column
INTERFACE_TYPE_CD DOUBLE N Code Set (19169) that identifies the interface type.
MESSAGE_FORMAT_CD DOUBLE N Code Set (25453) that identifies the UI Message type.
MESSAGE_LOCATION VARCHAR(255) N This points to the storage location for the individual batch events.
SYS_DIRECTION_CD DOUBLE N Indicates the direction, Inbound or Outbound, the batch events are flowing.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 - SI_BATCH




Parent Column in SI_BATCH (PK) Child Table Name Child Column Name
Children: BATCH_ID GL_TRANS_LOG SI_BATCH_ID
MM_TRANS_HEADER BATCH_ID
MM_TRANS_LINE BATCH_ID
SI_BATCH_EVENT BATCH_ID
SI_BATCH_STATS BATCH_ID


SI_COMSRV_MSG_MAP_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table stores the relationships between UI messages and the mapping objects.
Definition: This table stores the relationships between the SI_MESSAGE and SI_MAPPING_OBJECT
Table Type: REFERENCE





Column Detail - SI_COMSRV_MSG_MAP_R


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.
CREATE_DT_TM DATETIME N The date and time the row was created.Column
MAP_ID DOUBLE N This is foreign key into the SI_MAPPING_OBJECT table. It identifies a mapping object required of processing of UI message.
MESSAGE_ID DOUBLE N This is a foreign key into the SI_MESSAGE table. It indicates for which UI message the row applies.
PARAM_GROUP_ID DOUBLE N This is a foreign key into the SI_PARAMETER table. It indicates the group of parameters that apply to this mapping object for the given UI message.
SEQ_NUM DOUBLE N Indicates the order in which the mapping objects should be executed for the given UI message.
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 - SI_COMSRV_MSG_MAP_R


Child Column in SI_COMSRV_MSG_MAP_R(FK) Parent Table Name Parent Column Name
Parents: MAP_ID SI_MAPPING_OBJECT MAP_ID
MESSAGE_ID SI_MESSAGE MESSAGE_ID


SI_ESO_TRIGGER_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration ESO Trigger History
Definition: This table stores all modifications made to the ESO_Trigger table.
Table Type: REFERENCE





Column Detail - SI_ESO_TRIGGER_HIST


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.
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.
CALL_SRV_FLAG DOUBLE N Defines interaction with the ESO Servers
DESCRIPTION VARCHAR(30) N This string provides a description of the event trigger row.
MODIFY_PRSNL_ID DOUBLE N Prsnl ID of the user who made new modification on the Outbound_Field_Processing table
ORIG_PRSNL_ID DOUBLE N Prsnl ID of the user who made original record on the Outbound_Field_Processing table
PARENT_ACTIVE_IND DOUBLE N Parent Active Indicator used to track the active indicator of the Parent Table.
PROCESSING_CONTROL DOUBLE N Processing Control number
REC_BEG_EFF_DT_TM DATETIME Y Copy of the Beg_Eff_Dt_TM from the ESO_TRIGGER Table
SERVER_PRCS_CLASS VARCHAR(30) N Identifies the ESO server processing class of the transaction.
SERVER_PRCS_SUBTYPE VARCHAR(30) N Identifies the ESO server processing subtype of the transaction.
SERVER_PRCS_TYPE VARCHAR(30) N Identifies the ESO server processing type of the transaction.
SI_ESO_TRIGGER_HIST_ID DOUBLE N System Integration ESO Trigger History ID - Primary Key
TRIGGER_ID DOUBLE N Foreign Key to ESO_Trigger table
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 - SI_ESO_TRIGGER_HIST


Child Column in SI_ESO_TRIGGER_HIST(FK) Parent Table Name Parent Column Name
Parents: TRIGGER_ID ESO_TRIGGER TRIGGER_ID