FFS_RESOURCE_TYPE
Contains a complete list of resource types registered in the system.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FFS_RESOURCE_TYPE_PK |
TYPE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TYPE_ID | NUMBER | 5 | Yes | It is an unique ID of the type. | |
| LABEL | VARCHAR2 | 128 | It is a text label of the type. The provider type labels are unique inside of the same company. | ||
| STATUS | VARCHAR2 | 8 | It is a status of the type. The status controls an ability to select this type in GUI for a new object. | ||
| FEATURES | NUMBER | 10 | It is a bitmask field that defines active features for this provider type. | ||
| ROLE | VARCHAR2 | 17 | Role of the resource. Affects resource types features. | ||
| ICONS | NUMBER | 5 | Yes | It is a reference to a set of icons to be used to represent providers of this type in GUI. | |
| LOAD_DETERMINATION_METHOD | VARCHAR2 | 17 | These parameters are used to determine and represent a level of load for providers of this type in GUI. | ||
| UNDERLOAD_THRESHOLD | NUMBER | 8 | Quantity of activities in the route equals to or less than value. | ||
| OVERLOAD_THRESHOLD | NUMBER | 8 | Quantity of activities in the route equals to or greater than value. | ||
| WORKING_HOURS_COST | NUMBER | It defines an average cost of one minute of technician's time during regular working hours. | |||
| TRAVEL_COST | NUMBER | It defines a balance between cost of travel time and cost of work duration. (percents, (0; 100)). | |||
| OVERTIME_SOFT_COST | NUMBER | It defines an increase of technician's time cost for overtime. (percents). | |||
| OVERTIME_LIMIT | NUMBER | 10 | It defines a limit for overtime that is used to add additional cost. (percents). | ||
| OVERTIME_HARD_COST | NUMBER | It defines an increase of technician's time cost for overtime exceeding the limit. (percents). | |||
| GPS_TRACK_INACTIVE | NUMBER | 3 | Yes | Mobile interfaces: It defines if GPS coordinates should be collected for a resource when route of this resource is inactive. | |
| GPS_HIGH_PRECISION | NUMBER | 3 | Yes | Mobile interfaces: It defines if a high accuracy method should be used to retrieve GPS coordinates. | |
| GPS_FREQUENCY_WORKING | NUMBER | 3 | Yes | Defines a frequency of sending coordinates from browser. Value in minutes. | |
| GPS_FREQUENCY_IDLE | NUMBER | 3 | Yes | Defines a frequency of sending coordinates from browser when user has not a started activity. Value in minutes. | |
| USE_PERSONAL_PROFILE_FOR_CALC | NUMBER | 3 | Yes | If set, this provider type is used for activity duration calculation. | |
| DURATION_AFFECTS_AVG | NUMBER | 3 | Yes | If set, Reported duration data affects company average. | |
| SKIP_DAYS_FOR_STATS | NUMBER | 5 | Yes | Skip first n days for learning statistics. | |
| UNPAID_START_TRAVEL | NUMBER | 10 | Unpaid part travel from start provider location - minutes. | ||
| UNPAID_FINAL_TRAVEL | NUMBER | 10 | Unpaid part travel to final provider location - minutes. | ||
| 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. | |
| DELETED_FLAG | VARCHAR2 | 1 | Indicates whether the record is logically deleted (Y - soft deleted, N or NULL - active). |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FFS_RESOURCE_TYPE_PK | Unique | DATA | TYPE_ID, ORA_SEED_SET1 |
| FFS_RESOURCE_TYPE_PK1 | Unique | DATA | TYPE_ID, ORA_SEED_SET2 |