FFS_RESOURCE
Used to stores all created resources.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FFS_RESOURCE_PK |
RESOURCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RESOURCE_ID | NUMBER | 8 | Yes | Unique identifier of the resource. | |
| ACTIVE | NUMBER | 1 | Yes | Indicates current resource availability status. Values: 1 - active, 0 - inactive. | |
| PARENT | NUMBER | 8 | Yes | Unique identifier of a parent resources. If this resource is the top resource in the hierarchy then the value is 0. | |
| EXTERNAL_ID | VARCHAR2 | 128 | Unique identifier of the resource used for integrations (external identifier). | ||
| TYPE | NUMBER | 10 | Yes | Indicates type of the resource. | |
| QTS_BUCKET_RESOURCE_ID | NUMBER | 8 | Defines if this resource is also used as a capacity area. It happens when a value of this field is equal to 'resource_id'. | ||
| NAME | VARCHAR2 | 160 | The name of the resource. The maximum character length of this field is 40 characters. | ||
| ORGANIZATION_ID | NUMBER | 5 | Unique identifier of an organization this resource belongs to. | ||
| LANGUAGE_ID | NUMBER | 3 | Unique identifier of a preferred language for the resource. | ||
| TIME_FORMAT_ID | NUMBER | 10 | Yes | Unique identifier of a preferred time format for the resource. | |
| DATE_FORMAT_ID | NUMBER | 10 | Yes | Unique identifier of a preferred date format for the resource. | |
| TIME_ZONE_ID | NUMBER | 3 | Unique identifier a time zone for the resource. | ||
| VARCHAR2 | 1020 | Email address of the resource. The maximum character length of this field is 255 characters. | |||
| PHONE | VARCHAR2 | 64 | Phone number of the resource. The maximum character length of this field is 16 characters. Only digits and plus sign are allowed (e.g. '+123456789'). | ||
| CREATED | TIMESTAMP | Indicates the date and time of the resource creation. | |||
| UPDATED | TIMESTAMP | Yes | Indicates the date and time of the resource most recent update. | ||
| TRAVEL_KEY | VARCHAR2 | 200 | Resource Travel Key. Filled automatically based on configured 'Resource Travel Key' on Business Rules screen. | ||
| SD_KEY | VARCHAR2 | 200 | Unique identifier for Resource Duration key value. | ||
| STARTTIMEKEY | VARCHAR2 | 200 | Deprecated field, can be removed. | ||
| SCHEDULING_PROFILE_ID | NUMBER | 8 | Identifier of the scheduling profile which the configuration of the resource is related to. It is the foreign key to the table FFS_SCHEDULING_PROFILE. | ||
| FEATURES | NUMBER | 10 | Bit mask: 2 - route owner, 4 - is a bucket, 16 - allow child providers, 32 - allow to assist to, 64 - allow to be a teamholder, 128 - share inventory in teamwork, 256 - allow users, 512 - enable capacity, 1024 - use in routing, 2048 - starting travel is worktime, 4096 - ending travel is worktime, 8192 - track location, 16384 - share location in teamwork, 32768 - enable 'not activate in time' alert, 65536 - share work skills in teamwork, 131072 - contingent workers, 262144 - is a warehouse. | ||
| COLOR | VARCHAR2 | 6 | Hex color (6 hex symbols, e.g. 'FF0000'). Used as a background color for resource's avatar in graphical interface. | ||
| SD_INITIAL_RATIO | NUMBER | Yes | Initial ratio for the calculation of an activity duration when the resource is new. | ||
| SD_INITIAL_RATIO_READONLY | NUMBER | 3 | Yes | Parameter to indicate if the Initial ratio of the resource was modified by Stats duration job. | |
| SKIP_DAYS_FOR_STATS | NUMBER | 5 | Yes | Indicates number of days which are skipped for learning statistics. | |
| SKIP_DAYS_UPDATED | TIMESTAMP | Indicates the date and time of most recent SKIP_DAYS_FOR_STATS update. | |||
| ORGANIZATION_ID_OLD | NUMBER | 5 | Deprecated. Was used as a backup ORGANIZATION_ID field while upgrading from 23B to 23C version. | ||
| 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_RESOURCE_N1 | Non Unique | DATA | PARENT |
| FFS_RESOURCE_N2 | Non Unique | DATA | NAME |
| FFS_RESOURCE_N3 | Non Unique | DATA | SCHEDULING_PROFILE_ID |
| FFS_RESOURCE_PK | Unique | DATA | RESOURCE_ID, ORA_SEED_SET1 |
| FFS_RESOURCE_PK1 | Unique | DATA | RESOURCE_ID, ORA_SEED_SET2 |