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