1. Tables and Views for Sales, Fusion Service, and Field Service
  2. FFS_RESOURCE_UTIL_STATS

FFS_RESOURCE_UTIL_STATS

Contains routing resource utilization statistics collected on the routing bucket level and for particular days.

Details

  • Schema: FUSION

  • Object owner: FFS

  • Object type: TABLE

  • Tablespace: DATA

Columns

Name Datatype Length Precision Not-null Comments
RESOURCE_ID NUMBER 10 Yes Identifier of the resource with the bucket role. It is the foreign key to the table FFS_RESOURCE.
ROUTE_DATE DATE Yes Date for which the resource utilisation statistics is calculated for.
ROUTING_RUNS NUMBER 10 Yes Deprecated field. Will be removed soon.
SERVICE_TIME_PARAM NUMBER 10 Yes Deprecated field. Will be removed soon.
TOTAL_TIME_WORK_DAY NUMBER 10 Yes Total paid daily time per field resource according to the full-time scheme of payment. The time equals to the workday duration if the field resource is finished before the workday end and considers an overtime if the field resource works after the workday end.
TOTAL_TIME_HOURLY_PAY NUMBER 10 Yes Total paid daily time per field resource according to hourly-based scheme of payment. The time equals to the sum of the working time, travel time and overtime.
SERVICE_TIME NUMBER 10 Yes Time-measured total amount of daily provided service per field resource. It may differ from the total number of actual working hours due to fatigue in overtime. Then a field resource needs more time to complete the same scope of work.
AVG_WORKING_TIME NUMBER 10 Yes Average daily working time per field resource in the bucket RESOURCE_ID on the ROUTE_DATE. The working time does not include the overtime.
AVG_TRAVEL_TIME NUMBER 10 Yes Average daily travel time per field resource in the bucket RESOURCE_ID on the ROUTE_DATE.
AVG_OVERTIME NUMBER 10 Yes Average overtime per field resource in the bucket RESOURCE_ID on the ROUTE_DATE.
RESOURCE_USED_NUMBER NUMBER 10 Yes Number of field resources with active user in the bucket RESOURCE_ID on the ROUTE_DATE.
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.

Indexes

Index Uniqueness Tablespace Columns
FFS_RESOURCE_UTIL_STATS_U1 Unique DATA ROUTE_DATE, RESOURCE_ID