FFS_ROUTE
Stores resource routes created for particular days.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: DATA
Primary Key
| Name | Columns |
|---|---|
|
FFS_ROUTE_PK |
ROUTE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ARCH_DATE | DATE | Yes | DB record partitioning date. Set automatically by DB Optimization job. | ||
| ROUTE_ID | NUMBER | 10 | Yes | Unique identifier of the route. | |
| RESOURCE_ID | NUMBER | 10 | Yes | Identifier of the resource this route belongs to. | |
| ROUTE_DATE | DATE | Route date in YYYY-MM-DD format. | |||
| ACTIVATED | TIMESTAMP | Resource's route activation time. Time is specified in 'YYYY-MM-DD HH:MM:SS format and in the time zone of the resource to which the route is assigned. | |||
| DEACTIVATED | TIMESTAMP | Resource's route deactivation time. Time is specified in 'YYYY-MM-DD HH:MM:SS format and in the time zone of the resource to which the route is assigned. | |||
| TIME_ZONE_ID | NUMBER | 3 | Yes | Resource's route time zone .Reference to resource time zone identifier. | |
| DIFF | NUMBER | 5 | Yes | Resource's route time zone diffirence from GMT time. Calculated automatically after time_zone_id selection. | |
| FINAL_TRAVEL | NUMBER | 5 | Travel to final resource location. | ||
| FINAL_TRAVEL_ESTIMATION_METHOD | NUMBER | 3 | Yes | Method that was used to make current traveling time estimation. | |
| FINAL_TRAVEL_FROM_ACTIVITY_ID | NUMBER | 10 | Identifier of a previous activity for the final travel. It is only used when a final travel is set with an adjustment. | ||
| CALENDAR_TIME_FROM | TIMESTAMP | Start of working time interval. | |||
| CALENDAR_TIME_TO | TIMESTAMP | Resource's route end of working time interval. | |||
| CALENDAR_POINTS | NUMBER | 5 | Resource's route number of available points for distrubution by routing. | ||
| CALENDAR_SCHEDULE_ID | NUMBER | 8 | Resource's route schedule .Reference to schedule identifier. | ||
| CALENDAR_SHIFT_ID | NUMBER | 8 | Resource's route shift .Reference to shift identifier. | ||
| CALENDAR_NON_WORKING_REASON_ID | NUMBER | 5 | Resource's route non-working reason .Reference to non-working reasoins identifier. | ||
| START_LOCATION_ID | NUMBER | 10 | ID of start location for this day. | ||
| FINAL_LOCATION_ID | NUMBER | 10 | ID of final location for this day. | ||
| REACTIVATED | TIMESTAMP | Resource's route reactivation time. Time is specified in 'YYYY-MM-DD HH:MM:SS format and in the time zone of the resource to which the route is assigned. | |||
| UNPAID_START_TRAVEL | NUMBER | 10 | Really occupied part of unpaid travel from start provider location - minutes. | ||
| UNPAID_FINAL_TRAVEL | NUMBER | 10 | Really occupied part of unpaid travel to final provider location - minutes. | ||
| VERSION_NUM | NUMBER | 10 | Activities in the past. Version of queue cache where this queue was last modified. | ||
| 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_ROUTE_N1 | Non Unique | DATA | RESOURCE_ID |
| FFS_ROUTE_PK | Unique | DATA | ROUTE_ID |
| FFS_ROUTE_U1 | Unique | DATA | ROUTE_DATE, RESOURCE_ID |