Table Detail Report
OEN_TX_STATS_DETAIL
| Column Section | Top of Page |
Table-level Detail
| Description: | OEN TX STATS DETAIL |
| Definition: | This table holds detailed information about each stat_id. |
| Table Type: | ACTIVITY |
Column Detail - OEN_TX_STATS_DETAIL
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| AVG_IN_FORMAT_TIME | DOUBLE | Y | Average time to format transaction.Column |
| AVG_OE_PROCESS_TIME | DOUBLE | Y | Average time to process transaction.Column |
| AVG_OUT_FORMAT_TIME | DOUBLE | Y | Average time for outbound formatting.Column |
| AVG_SEND_TIME | DOUBLE | Y | Average time to send the transaction.Column |
| AVG_SIZE | DOUBLE | Y | Average size of transaction.Column |
| AVG_SIZE_CAL_COUNT | DOUBLE | Y | Number of messages used to calculate average size.Column |
| STAT_ID | DOUBLE | N | Unique stat_idColumn |
| TX_TYPE | VARCHAR(32) | N | Transaction type.Column |
| TYPE_COUNT | DOUBLE | Y | Number of transactions for this type.Column |
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 |