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 |