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 |