OPL_SERVER_CONFIG



Column Section Top of Page


Table-level Detail

Description: OPENlink Server Configuration
Definition: This table will store server configuration of openlink Engine (aka Designs) data for clients.
Table Type: REFERENCE





Column Detail - OPL_SERVER_CONFIG


Column Name Type Null? Definition
ALERT_PORT_NBR DOUBLE N The design Server Alert port number, where OPENLink core engine can be requested design alerts.
MACHINE_NAME VARCHAR(255) N Host name of the OPENLink Engine
OPL_SERVER_CONFIG_ID DOUBLE N Unique, generated number that identifies a single row on the OPL_SERVER_CONFIG table.
SERVER_DISPLAY_NAME VARCHAR(256) N Display name of the OPENLink Engine server
SERVER_NBR DOUBLE N The design Server number managed by core OPENLink Engine
SERVER_PORT_NBR DOUBLE N The design Server port number, where the OPENLink core engine can be requested for all design status and operations.
SERVER_SUB_TYPE_TXT VARCHAR(256) Y Sub-Type of server design Example: ENTERPRISE, MILLENNIUM, MILLENNIUM_LEGACY, CLOUD
SERVER_TYPE_TXT VARCHAR(256) N Type of design Example: ENGINE, ADAPTER & PROXY
TENANT_IDENT VARCHAR(128) N Tenant indicator, identifies the tenant
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.


OPL_SERVICE_SETTING



Column Section Top of Page


Table-level Detail

Description: OPENLink Service Setting
Definition: This table will store manifest agreement for clients. The OPENLink.Next Application has the capability of displaying a customizable click-through banner at logon which prevents further activity on the information system unless and until the user executes a positive action to manifest agreement by clicking on a box indicating OK. Note: "OK" was designed in OPENLink as "Accept". This table will store the flag's for this functionality and User Agreement.
Table Type: REFERENCE





Column Detail - OPL_SERVICE_SETTING


Column Name Type Null? Definition
BANNER_CLOB LONGTEXT Y A clob of text (similar to User Agreement, for usage of the application) , Displayed upon login
BANNER_ENABLED_IND DOUBLE N A flag which indicates if the banner(User Agreement) was enabled for the the current client group
DISPLAY_BANNER_DECLINED_IND DOUBLE N A flag indicating if the Banner(User Agreement) was declined
OPL_SERVICE_SETTING_ID DOUBLE N Unique, generated number that identifies a single row on the OPL_SERVICE_SETTING table.
TENANT_IDENT VARCHAR(128) N Tenant indicator, identifies the tenant
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.