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 |