Table Detail Report
OEN_THRESH
Column Section | Top of Page |
Table-level Detail
Description: | Open engine threshold |
Definition: | The threshold defined fro the open engine interfaces |
Table Type: | REFERENCE |
Column Detail - OEN_THRESH
Column Name | Type | Null? | Definition |
---|---|---|---|
ALL_STATES | CHAR(1) | N | If threshold needs to be checked in all state of interface. i.e. if interface is running or not. |
INTERFACEID | DOUBLE | N | Unique interface id for which thresholds are defined. |
IN_CYCLE_TIME | DOUBLE | Y | Inbound cycle timeColumn |
MAX_QCOUNT | DOUBLE | Y | Maximum queue limit for the interface |
OUT_CYCLE_TIME | DOUBLE | Y | Outbound cycle time |
OEN_TRAIT
Column Section | Top of Page |
Table-level Detail
Description: | oen_trait |
Definition: | Holds all the possible interface traits. |
Table Type: | REFERENCE |
Column Detail - OEN_TRAIT
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. |
DOMAIN_NBR | DOUBLE | N | Defines which domain the trait belongs in. |
FORMAT_LIST | VARCHAR(30) | Y | Defines which formats this trait applies to. |
HIDDEN_IND | DOUBLE | Y | Should this trait be hidden |
LIST_IND | DOUBLE | Y | Is this trait a list? |
PROD_CHG_IND | DOUBLE | Y | Can this trait be changed while the interface is in production? |
PROTOCOL_LIST | VARCHAR(30) | Y | List of protocols this trait applies to. |
SERVICE_LIST | VARCHAR(30) | Y | Which services does this trait apply to |
TRAIT_DESC | VARCHAR(255) | Y | Description |
TRAIT_ID | DOUBLE | N | Id of the Trait |
TRAIT_NAME | VARCHAR(32) | N | Name of trait |
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. |
VALUE_TYPE | DOUBLE | Y | What type of value will this trait hold. |
VERSIONING_IND | DOUBLE | Y | Should this trait be versioned. |
OEN_TXLOG
Column Section | Top of Page |
Table-level Detail
Description: | Open engine Transaction log |
Definition: | Log of all tx's going through open engine interfaces. |
Table Type: | ACTIVITY |
Column Detail - OEN_TXLOG
Column Name | Type | Null? | Definition |
---|---|---|---|
CREATE_DT_TM | DATETIME | Y | The date and time the row was insertedColumn |
EVENTID | CHAR(4) | Y | if the tx is from inbound or outbound interface. |
GROUP_NAME | VARCHAR(40) | Y | Group NameColumn |
INTERFACEID | CHAR(5) | Y | The interface id from which the tx came |
MESSAGE_NAME | VARCHAR(40) | Y | Message NameColumn |
MSGID | CHAR(15) | Y | Actual message id |
MSG_DATE | CHAR(10) | Y | The date when Tx was logged |
MSG_LEN | DOUBLE | Y | Message Length |
MSG_SIZE | CHAR(5) | Y | The size of the tx message |
MSG_TEXT | LONGTEXT | Y | The actual tx message |
MSG_TIME | CHAR(8) | Y | The time message was logged |
PART_NO | CHAR(4) | Y | Future |
PART_SIZE | CHAR(5) | Y | Future |
RECEIVING_SYSTEM | VARCHAR(40) | Y | Receiving SystemColumn |
SENDING_SYSTEM | VARCHAR(40) | Y | Sending SystemColumn |
SEQ_NO | CHAR(10) | Y | Future |
TX_KEY | CHAR(27) | N | Unique identifier of the table. |
OEN_TX_MAX_STATS_LOG
Column Section | Top of Page |
Table-level Detail
Description: | OEN TX MAX STATS LOG |
Definition: | This table holds the max values for each stat_id. |
Table Type: | ACTIVITY |
Column Detail - OEN_TX_MAX_STATS_LOG
Column Name | Type | Null? | Definition |
---|---|---|---|
MAX_IN_FORMAT_DT_TM | DATETIME | Y | Date/Time when the maximum format time was reached.Column |
MAX_IN_FORMAT_TID | DOUBLE | N | Trigger_id that reached maximum format time.Column |
MAX_IN_FORMAT_TIME | DOUBLE | Y | Maximum format time inbound.Column |
MAX_OE_PROC_DT_TM | DATETIME | Y | Date/time when max oe process was reached.Column |
MAX_OE_PROC_TID | DOUBLE | N | Trigger_id.Column |
MAX_OE_PROC_TIME | DOUBLE | Y | Time for maximum OE process.Column |
MAX_OUT_FORMAT_DT_TM | DATETIME | Y | Maximum outoubnd format time.Column |
MAX_OUT_FORMAT_TID | DOUBLE | N | Trigger_id.Column |
MAX_OUT_FORMAT_TIME | DOUBLE | Y | Max outbound format_time.Column |
MAX_SEND_DT_TM | DATETIME | Y | Maximum send time.Column |
MAX_SEND_TID | DOUBLE | N | Trigger_idColumn |
MAX_SEND_TIME | DOUBLE | Y | Max send time.Column |
MAX_SEQ_NUM | DOUBLE | N | Max sequence number.Column |
MAX_SIZE | DOUBLE | Y | Maximum size.Column |
MAX_SIZE_DT_TM | DATETIME | Y | Date time max size was reached.Column |
MAX_SIZE_TID | DOUBLE | N | Trigger_id.Column |
STAT_ID | DOUBLE | N | unique_id.Column |
TX_TYPE | VARCHAR(32) | N | Transaction type.Column |
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 |