Table Detail Report

OEN_STD_PROCINFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Open Engine Std Proc Info
Definition: The table contains all standard interfaces
Table Type: REFERENCE





Column Detail - OEN_STD_PROCINFO


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
SERVICE_TYPE_CD DOUBLE N Service type code. Defines what type of service the interface.
STD_INTERFACE_ID DOUBLE N Interface Id. Identifier for the interface. Generated from the script. No sequence used.
STD_INTERFACE_NAME VARCHAR(40) N Name of the interface.
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 - OEN_STD_PROCINFO




Parent Column in OEN_STD_PROCINFO (PK) Child Table Name Child Column Name
Children: STD_INTERFACE_ID OEN_STD_PROCINFO_TRAITS STD_INTERFACE_ID


OEN_STD_PROCINFO_TRAITS



Column Section Relationship Section Top of Page


Table-level Detail

Description: OEN Std Procinfo Traits
Definition: This table contains all standard interface traits.
Table Type: REFERENCE





Column Detail - OEN_STD_PROCINFO_TRAITS


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
INTERFACE_TRAITS_ID DOUBLE N Interface Traits Id. Identifier for the interface trait.
STD_INTERFACE_ID DOUBLE N Interface Id. Identifier for the interface. FK from table OEN_STD_PROCINFO
TRAIT_NAME VARCHAR(32) N Name of the trait.Column
TRAIT_VALUE VARCHAR(80) N Value of the trait.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 - OEN_STD_PROCINFO_TRAITS


Child Column in OEN_STD_PROCINFO_TRAITS(FK) Parent Table Name Parent Column Name
Parents: STD_INTERFACE_ID OEN_STD_PROCINFO STD_INTERFACE_ID


OEN_STEP



Column Section Relationship Section Top of Page


Table-level Detail

Description: OEN STEP
Definition: Holds list of all valid Open Engine STEPS.
Table Type: REFERENCE





Column Detail - OEN_STEP


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.
STEP_DESC VARCHAR(255) Y Holds a description of this Step.Column
STEP_ID DOUBLE N Holds a unique number representing this Step.Column
STEP_VALUE VARCHAR(30) Y Holds a single letter representing this Step.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 - OEN_STEP




Parent Column in OEN_STEP (PK) Child Table Name Child Column Name
Children: STEP_ID OEN_ERROR STEP_ID
OEN_SEQ_STEP_R STEP_ID


OEN_SUBSCRIBER_RULE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: OEN SUBSCRIBER RULE R
Definition: Holds relation between subscriber and rule.
Table Type: REFERENCE





Column Detail - OEN_SUBSCRIBER_RULE_R


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.
INTERFACE_ID DOUBLE N link to interface table.
RULE_ID DOUBLE N link to rule table
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 - OEN_SUBSCRIBER_RULE_R


Child Column in OEN_SUBSCRIBER_RULE_R(FK) Parent Table Name Parent Column Name
Parents: INTERFACE_ID OEN_INTERFACE INTERFACE_ID


OEN_TELOG



Column Section Top of Page


Table-level Detail

Description: Transaction event log
Definition: Transaction message activity through the open engine.
Table Type: ACTIVITY





Column Detail - OEN_TELOG


Column Name Type Null? Definition
CREATE_DT_TM DATETIME Y The date and time the row was insertedColumn
EID DOUBLE N if event is from inbound or outbound interface
ESTATUS CHAR(1) Y Flag which states success or Failure
EVENT_DATE CHAR(10) Y Date the event logged.
EVENT_KEY CHAR(25) N Unique identifier consist of tx id and time.
EVENT_TIME CHAR(8) Y Time the event was logged.
OPID DOUBLE N The inbound interface, the tx came from.
OTID CHAR(15) Y original tx id.
PID DOUBLE N Interface id logging the event.
TID CHAR(15) N tx id for the current interface