Table Detail Report

SI_OEN_SKIPPED_MSGS



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration OEN Skipped Messages
Definition: Table containing a record of transactions skipped due to processing issues
Table Type: ACTIVITY





Column Detail - SI_OEN_SKIPPED_MSGS


Column Name Type Null? Definition
ERROR_TXT VARCHAR(500) Y Error message for the event that resulted in the transaction getting skipped by the interface
ERROR_TYPE_TXT VARCHAR(30) Y Text value that classifies the error.
PARENT_ENTITY_ID DOUBLE N The identifier of the interface from the appropriate configuration model. A PK value from the table identified in PARENT_ENTITY_NAME.
PARENT_ENTITY_NAME VARCHAR(30) Y The name of the configuration model for the interface ( A table name - currently either OEN_PROCINFO or SI_OEN_COMCHANNEL )
PROCESS_PHASE_TXT VARCHAR(30) Y Text value that indicates what phase of processing the interface was in when the error occurred.
QUEUE_ID DOUBLE N The queue_id of the transaction from the cqm_oeninterface_que table, if available.
SCRIPT_NAME VARCHAR(50) Y Name of the script that was being executed when the error occurred, if applicable.
SI_OEN_SKIPPED_MSGS_ID DOUBLE N PRIMARY KEY
SKIPPED_DT_TM DATETIME Y The date and time that the transaction was skipped by the interface
STATUS_DT_TM DATETIME Y The date and time of the last change in the status of the row.
STATUS_PRSNL_ID DOUBLE N Identifier of the last user to change the status of the row.
STATUS_TXT VARCHAR(20) Y Text value that represents the status of this row. It is used to indicate if a user has looked at the message that was skipped and what action the user might have taken.
TRIGGER_ID DOUBLE N The trigger_id of the transaction from the cqm_oeninterface_tr_1 table, if available.
TX_KEY_TXT VARCHAR(27) Y Key for the transaction stored on the OEN_TXLOG table, if available.
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_OEN_SKIPPED_MSGS


Child Column in SI_OEN_SKIPPED_MSGS(FK) Parent Table Name Parent Column Name
Parents: QUEUE_ID CQM_OENINTERFACE_QUE QUEUE_ID
TRIGGER_ID CQM_OENINTERFACE_TR_1 TRIGGER_ID
STATUS_PRSNL_ID PRSNL PERSON_ID


SI_OEN_STEP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Open Engine Step
Definition: Definition of steps used in the open engine processes
Table Type: REFERENCE





Column Detail - SI_OEN_STEP


Column Name Type Null? Definition
DESCRIPTION VARCHAR(100) Y Description of the step
SI_OEN_STEP_ID DOUBLE N PRIMARY KEY
STEP_NAME VARCHAR(100) N Name of the step
STEP_PROPERTY_ID DOUBLE N ID that links to the configuration properties for the step
STEP_TYPE VARCHAR(100) N The class name of the step
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_OEN_STEP


Child Column in SI_OEN_STEP(FK) Parent Table Name Parent Column Name
Parents: STEP_PROPERTY_ID SI_OEN_PROPERTY SI_OEN_PROPERTY_ID




Parent Column in SI_OEN_STEP (PK) Child Table Name Child Column Name
Children: SI_OEN_STEP_ID SI_OEN_SUBSCRIPTION_STEP_R SI_OEN_STEP_ID


SI_OEN_SUBSCRIPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Open engine subscription
Definition: Defines the configured event subscriptions
Table Type: REFERENCE





Column Detail - SI_OEN_SUBSCRIPTION


Column Name Type Null? Definition
BROADCAST_ENABLED_IND DOUBLE N Indicator that defines whether the completion of the subscription should send a notification to the Controller service
EVENT_TYPE VARCHAR(100) N The class name of the event the subscription handles
SI_OEN_SUBSCRIPTION_ID DOUBLE N PRIMARY KEY
SUBSCRIPTION_PROPERTY_ID DOUBLE N ID that links the subscription to its configuration properties
SUBSCRIPTION_SET_ID DOUBLE N ID that links the subscription to the subscription set it belongs to.
SUBSCRIPTION_TYPE VARCHAR(31) N Identifies the row as a subscription or subscription set
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_OEN_SUBSCRIPTION


Child Column in SI_OEN_SUBSCRIPTION(FK) Parent Table Name Parent Column Name
Parents: SUBSCRIPTION_PROPERTY_ID SI_OEN_PROPERTY SI_OEN_PROPERTY_ID
SUBSCRIPTION_SET_ID SI_OEN_SUBSCRIPTION SI_OEN_SUBSCRIPTION_ID




Parent Column in SI_OEN_SUBSCRIPTION (PK) Child Table Name Child Column Name
Children: SI_OEN_SUBSCRIPTION_ID SI_OEN_COMCHANNEL SI_OEN_SUBSCRIPTION_ID
SI_OEN_ENDPOINT SI_OEN_SUBSCRIPTION_ID
SI_OEN_SUBSCRIPTION SUBSCRIPTION_SET_ID
SI_OEN_SUBSCRIPTION_STEP_R SI_OEN_SUBSCRIPTION_ID


SI_OEN_SUBSCRIPTION_STEP_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Open engine Subscription Step relationship
Definition: Defines the relationship and sequence of steps to the subscriptions that they are used in.
Table Type: REFERENCE





Column Detail - SI_OEN_SUBSCRIPTION_STEP_R


Column Name Type Null? Definition
SI_OEN_STEP_ID DOUBLE N ID of the step related to the subscription
SI_OEN_SUBSCRIPTION_ID DOUBLE N ID of the subscription related to the step
SI_OEN_SUBSCRIPTION_STEP_R_ID DOUBLE N PRIMARY KEY
SI_OEN_WORK_POOL_ID DOUBLE Y The work thread pool that will be used to execute the step. If not populated, the step will be executed in the caller thread.
STEP_SEQUENCE DOUBLE Y The execution sequence of the step
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_OEN_SUBSCRIPTION_STEP_R


Child Column in SI_OEN_SUBSCRIPTION_STEP_R(FK) Parent Table Name Parent Column Name
Parents: SI_OEN_STEP_ID SI_OEN_STEP SI_OEN_STEP_ID
SI_OEN_SUBSCRIPTION_ID SI_OEN_SUBSCRIPTION SI_OEN_SUBSCRIPTION_ID
SI_OEN_WORK_POOL_ID SI_OEN_WORK_POOL SI_OEN_WORK_POOL_ID


SI_OEN_WORK_POOL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Open Engine Work Pool
Definition: Defines work pools used to execute processing steps.
Table Type: REFERENCE





Column Detail - SI_OEN_WORK_POOL


Column Name Type Null? Definition
CORE_POOL_SIZE DOUBLE Y The initial number of threads in the work pool
KEEP_ALIVE_SECONDS DOUBLE Y The amount of time, in seconds, to keep idle threads alive in the work pool
MAX_POOL_SIZE DOUBLE Y The maximum number of threads in the work pool
QUEUE_CAPACITY DOUBLE Y The maximum depth of the task queue for backlogged tasks waiting to be executed by the work pool
SI_OEN_CONTEXT_ID DOUBLE N ID that identifies the comserver the workpool is used in
SI_OEN_WORK_POOL_ID DOUBLE N PRIMARY KEY
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.
WORK_POOL_NAME VARCHAR(100) N The name of the work pool



Relationship Detail - SI_OEN_WORK_POOL


Child Column in SI_OEN_WORK_POOL(FK) Parent Table Name Parent Column Name
Parents: SI_OEN_CONTEXT_ID SI_OEN_CONTEXT SI_OEN_CONTEXT_ID




Parent Column in SI_OEN_WORK_POOL (PK) Child Table Name Child Column Name
Children: SI_OEN_WORK_POOL_ID SI_OEN_SUBSCRIPTION_STEP_R SI_OEN_WORK_POOL_ID