Table Detail Report

SI_OEN_CHANN_ENDPOINT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Open engine ComChannel Endpoint Relation
Definition: This table is used to relate ComChannels to the Endpoints that it uses for communication for both source and destination
Table Type: REFERENCE





Column Detail - SI_OEN_CHANN_ENDPOINT_R


Column Name Type Null? Definition
RELATION_TYPE VARCHAR(31) N Identifies whether the comchannel is using the endpoint as a source or destination for transaction data.
SI_OEN_CHANN_ENDPOINT_R_ID DOUBLE N Primary Key
SI_OEN_COMCHANNEL_ID DOUBLE N Id of the comchannel related to the endpoint
SI_OEN_ENDPOINT_ID DOUBLE N Id of the endpoint related to the comchannel
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_CHANN_ENDPOINT_R


Child Column in SI_OEN_CHANN_ENDPOINT_R(FK) Parent Table Name Parent Column Name
Parents: SI_OEN_COMCHANNEL_ID SI_OEN_COMCHANNEL SI_OEN_COMCHANNEL_ID
SI_OEN_ENDPOINT_ID SI_OEN_ENDPOINT SI_OEN_ENDPOINT_ID


SI_OEN_COMCHANNEL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Open Engine Comserver Channel
Definition: Defines comserver channels that are loaded and ran inside of Open Engine comservers
Table Type: REFERENCE





Column Detail - SI_OEN_COMCHANNEL


Column Name Type Null? Definition
AUTOSTART_IND DOUBLE N Indicator for flagging comchannels that should be started when the comserver is started
COMCHANNEL_NAME VARCHAR(255) N User provided name for the comchannel
COMCHANNEL_PROPERTY_ID DOUBLE N ID for configuration properties for the com channel
COMCHANNEL_TYPE VARCHAR(100) Y The type of channel for this comserver
DESCRIPTION VARCHAR(255) Y Long description of the comchannel
ROUTER_PROPERTY_ID DOUBLE N ID for configuration properties for the router
ROUTER_TYPE VARCHAR(100) Y Class name of the router implementation to be used by the comchannel
SI_OEN_COMCHANNEL_ID DOUBLE N Primary Key
SI_OEN_CONTEXT_ID DOUBLE N ID of the comserver that the comchannel will run in
SI_OEN_SUBSCRIPTION_ID DOUBLE N ID for the step subscriptions used by the comchannel
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_COMCHANNEL


Child Column in SI_OEN_COMCHANNEL(FK) Parent Table Name Parent Column Name
Parents: SI_OEN_CONTEXT_ID SI_OEN_CONTEXT SI_OEN_CONTEXT_ID
COMCHANNEL_PROPERTY_ID SI_OEN_PROPERTY SI_OEN_PROPERTY_ID
ROUTER_PROPERTY_ID SI_OEN_PROPERTY SI_OEN_PROPERTY_ID
SI_OEN_SUBSCRIPTION_ID SI_OEN_SUBSCRIPTION SI_OEN_SUBSCRIPTION_ID




Parent Column in SI_OEN_COMCHANNEL (PK) Child Table Name Child Column Name
Children: SI_OEN_COMCHANNEL_ID SI_OEN_CHANN_ENDPOINT_R SI_OEN_COMCHANNEL_ID


SI_OEN_CONTEXT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Open Engine Context
Definition: Defines the comservers that exist in the domain
Table Type: REFERENCE





Column Detail - SI_OEN_CONTEXT


Column Name Type Null? Definition
ADDITIONAL_PARAMS VARCHAR(255) Y CONTEXT ADDITIONAL PARAMS
CONTEXT_NAME VARCHAR(100) N Unique Name of the comserver
CURRENT_NODE VARCHAR(100) Y The name of the node that the comserver is currently being run on.
DESCRIPTION VARCHAR(255) Y Description of the comserver
FAILOVER_LAUNCH_ENTRY VARCHAR(100) Y IDENTIFIER FOR THE FAIL OVER LAUNCH ENTRY
LAUNCH_ENTRY VARCHAR(100) Y The identifier for the entry that the comserver will be launched by. For example an scp id
LAUNCH_ENTRY_TYPE VARCHAR(31) Y The type of entry used to launch the comserver
RESOURCE_GROUP VARCHAR(100) Y The resource group that the comserver runs in. This is usually equal to the node that it should run on.
SERVICE_URL VARCHAR(255) N The RMI url for connecting to the comserver
SI_OEN_CONTEXT_ID DOUBLE N Primary Key
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_CONTEXT




Parent Column in SI_OEN_CONTEXT (PK) Child Table Name Child Column Name
Children: SI_OEN_CONTEXT_ID SI_OEN_COMCHANNEL SI_OEN_CONTEXT_ID
SI_OEN_ENDPOINT SI_OEN_CONTEXT_ID
SI_OEN_WORK_POOL SI_OEN_CONTEXT_ID


SI_OEN_ENDPOINT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Open Engine Endpoints
Definition: Definition of endpoints used for connecting with external systems
Table Type: REFERENCE





Column Detail - SI_OEN_ENDPOINT


Column Name Type Null? Definition
CONNECTION_PROPERTY_ID DOUBLE N ID that links to the connection adapter configuration properties for the endpoint
CONNECTION_TYPE VARCHAR(100) Y The class name of the connection adapter to be used by the endpoint
DEDICATED_IND DOUBLE N Indicator that flags the endpoint as being able to only be used in one comchannel.
DESCRIPTION VARCHAR(255) Y Description of the endpoint
ENDPOINT_NAME VARCHAR(255) N Name of the endpoint
ENDPOINT_PROPERTY_ID DOUBLE N ID that links the endpoint to its configuration properties
ENDPOINT_TYPE VARCHAR(100) Y Describes the type of endpoint: source, destination, or bidirectional
EXCLUSIONARY_IND DOUBLE N Indicator that flags the endpoint as being the only endpoint that can be used by the comchannel to that particular type
PROTOCOL_PROPERTY_ID DOUBLE N ID that links to the protocol configuration properties for the endpoint
PROTOCOL_TYPE VARCHAR(100) Y The class name of the protocol to be used to read from or write to the connection
SI_OEN_CONTEXT_ID DOUBLE N ID that links the endpoint to the comserver that it is used in.
SI_OEN_ENDPOINT_ID DOUBLE N PRIMARY KEY
SI_OEN_SUBSCRIPTION_ID DOUBLE N ID that links to the event subscriptions used by the endpoint
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_ENDPOINT


Child Column in SI_OEN_ENDPOINT(FK) Parent Table Name Parent Column Name
Parents: SI_OEN_CONTEXT_ID SI_OEN_CONTEXT SI_OEN_CONTEXT_ID
CONNECTION_PROPERTY_ID SI_OEN_PROPERTY SI_OEN_PROPERTY_ID
ENDPOINT_PROPERTY_ID SI_OEN_PROPERTY SI_OEN_PROPERTY_ID
PROTOCOL_PROPERTY_ID SI_OEN_PROPERTY SI_OEN_PROPERTY_ID
SI_OEN_SUBSCRIPTION_ID SI_OEN_SUBSCRIPTION SI_OEN_SUBSCRIPTION_ID




Parent Column in SI_OEN_ENDPOINT (PK) Child Table Name Child Column Name
Children: SI_OEN_ENDPOINT_ID SI_OEN_CHANN_ENDPOINT_R SI_OEN_ENDPOINT_ID


SI_OEN_PROPERTY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Open Engine Property
Definition: Defines configuration properties for Open engine processes
Table Type: REFERENCE





Column Detail - SI_OEN_PROPERTY


Column Name Type Null? Definition
PROPERTY_NAME VARCHAR(100) N Name of the property
PROPERTY_SET_ID DOUBLE N The set of properties that the property belongs to
PROPERTY_TYPE VARCHAR(31) N Data type of the property value
PROPERTY_VALUE_TXT VARCHAR(255) Y The configured valued for the property
SI_OEN_PROPERTY_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.



Relationship Detail - SI_OEN_PROPERTY


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




Parent Column in SI_OEN_PROPERTY (PK) Child Table Name Child Column Name
Children: SI_OEN_PROPERTY_ID SI_OEN_COMCHANNEL COMCHANNEL_PROPERTY_ID
SI_OEN_COMCHANNEL ROUTER_PROPERTY_ID
SI_OEN_ENDPOINT CONNECTION_PROPERTY_ID
SI_OEN_ENDPOINT ENDPOINT_PROPERTY_ID
SI_OEN_ENDPOINT PROTOCOL_PROPERTY_ID
SI_OEN_PROPERTY PROPERTY_SET_ID
SI_OEN_STEP STEP_PROPERTY_ID
SI_OEN_SUBSCRIPTION SUBSCRIPTION_PROPERTY_ID