FFS_SCHEDULING_BASELINE
Contains routing savings baseline settings defined on the day level.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: DATA
Primary Key
| Name | Columns |
|---|---|
|
FFS_SCHEDULING_BASELINE_PK |
ROUTE_DATE |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| ROUTE_DATE | DATE | Yes | Defines the date for which the baseline parameters are relevant. If the settings do not depend on the date, the filed is set to the date of '3000-01-01'. | |
| RESOURCE_COST | NUMBER | Yes | Monetized cost of the fully-loaded field resource per minute that is common for the company. The cost includes all types of expenses related to the field resource like salary, benefits, training, overheads, equipment and other. | |
| COST_PER_MILE | NUMBER | Yes | Monetized travel cost per km/mile regarding units that the company uses. | |
| OVERTIME_INCREASE | NUMBER | Yes | Multiplier of the resource cost increase when the resource works in overtime. The value 0.5 correspond to 50% of overtime increase on the GUI. | |
| AVG_RESOURCE_WORK_TIME | NUMBER | Yes | Average field resource daily work time in minutes that is common for the company. | |
| AVG_RESOURCE_TRAVEL_TIME | NUMBER | Yes | Average field resource daily travel time in minutes that is common for the company. | |
| AVG_RESOURCE_OVERTIME | NUMBER | Yes | Average field resource overtime in minutes that is common or allowed in the company. | |
| TRAVEL_SPEED | NUMBER | Yes | Average travel speed km/miles per minutes that is common for the company. | |
| PART_FULL_DAY_PAID_RESOURCES | NUMBER | Yes | Part of field resources who are full-day paid. The field defines the ratio between full-time and hourly paid field resources in the company. By default the field is set up to 0.8. | |
| WORKDAY_DURATION | NUMBER | Yes | Average workday duration in minutes that is common and normal for the company. By default it is 480 min (8 hours). | |
| SAVINGS_VIEW | VARCHAR2 | 1 | There are two possible options of the view, time and cost. Time view shows savings in terms of saved work time, overtime and travel time. Cost viewpoint monetize those savings. | |
| 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_SCHEDULING_BASELINE_PK | Unique | DATA | ROUTE_DATE |