FFS_PLUGIN
Contains a list of plugins configured in the system.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FFS_PLUGIN_PK |
PLUGIN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PLUGIN_ID | NUMBER | 5 | Yes | Unique identifier of Plugin, automatically populated by the system. | |
| LABEL | VARCHAR2 | 1020 | Legacy column, is not used. Removed in 24C. | ||
| TYPE | VARCHAR2 | 15 | Type defines attributes and functionality available to plugin. Possible options: 'addon' - plugin that utilizes the field service plugin framework; 'external' - external application opened as a web link; 'external_native' - external application opened as another application on the same device; 'internal' - reserved legacy option, is not used. | ||
| PATH | VARCHAR2 | 4000 | Url of the main page of plugin. Does not contain scheme and domain part for plugins hosted internally by Field Service (Plugin Archive, Standard Plugin). May does not contain scheme and domain part for External Applications (TYPE is 'external_native'). | ||
| POST_DATA | VARCHAR2 | 4000 | Data sent in the body of post request for External Applications. Fields separated by new line character. | ||
| PRIVILEGE_OBJECT_ID | NUMBER | 8 | Relation to FFS_PRIVILEGE_OBJECT.PRIVILEGE_OBJECT_ID value. | ||
| WIDTH | NUMBER | 5 | Dialog width in pixels for External Application opened as web link (applicable when TYPE is 'external'). | ||
| HEIGHT | NUMBER | 5 | Dialog height in pixels for External Application opened as web link (applicable when TYPE is 'external'). | ||
| OPTIONS | NUMBER | 3 | Bit mask represents plugin attributes. 1 - plugin_option_tab_layout, 2 - plugin_option_scrollbars - applicable only if TYPE is 'external_native', 4 - plugin_option_is_online - Whether to show the plugin in offline or not, 8 - plugin_option_is_server_script - Reserved legacy option. Has no effect, 16 - plugin_option_menu_item, 32 - plugin_option_property_config - Reserved legacy option. Has no effect since 20c, 64 - plugin_option_standard_plugin - plugin is a Standard Plugin. | ||
| USER_AGENT_MASK | VARCHAR2 | 128 | Regular expression. Field service sorts all records that have the same ACTION_LINK_ID by sort_order and opens as another application path of the first record whose USER_AGENT_MASK matches the browser's user agent string (applicable only if TYPE is 'external_native'). | ||
| SORT_ORDER | NUMBER | 3 | Yes | Order position used to determine the priority of the USER_AGENT_MASK to be applied first (applicable only if TYPE is 'external_native'). | |
| NATIVE_APP_LABEL | VARCHAR2 | 128 | External Application label (applicable only if TYPE is 'external_native'). | ||
| ACTION_LINK_ID | NUMBER | 10 | Relation to FFS_ACTION_LINK.ACTION_LINK_ID value. Action Link ID that the plugin is associated with. One plugin associated with one Action Link ID. | ||
| AUTH_TYPE | VARCHAR2 | 5 | Type of authentication used by the external server hosting the plug-in source to verify access to the plug-in. Possible options: 'basic', 'hmac'. | ||
| AUTH_LOGIN | VARCHAR2 | 1020 | User name to log in to the plug-in. Applicable only if AUTH_TYPE is 'basic'. | ||
| AUTH_PASSWORD | VARCHAR2 | 255 | Password to log in to the plug-in. Applicable only if AUTH_TYPE is 'basic'. | ||
| PLUGIN_HOSTED_ID | NUMBER | 5 | Relation to FFS_PLUGIN_HOSTED.PLUGIN_HOSTED_ID VALUE. If it contains some value means that plugin is hosted internally by Field Service (Plugin Archive). | ||
| SECURED_DATA | CLOB | Data of plugin parameters. Applicable only if TYPE is 'addon'. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FFS_PLUGIN_PK | Unique | DATA | PLUGIN_ID, ORA_SEED_SET1 |
| FFS_PLUGIN_PK1 | Unique | DATA | PLUGIN_ID, ORA_SEED_SET2 |