FFS_ST_SLT_DATA
Stores all "street level" routing service results to be included into travel statistics.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: DATA
Primary Key
| Name | Columns |
|---|---|
|
FFS_ST_SLT_DATA_PK |
RECORD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RECORD_ID | NUMBER | 10 | Yes | Unique Identifier of this record. | |
| STATUS | VARCHAR2 | 7 | Defines if this record should be included into the statistics. | ||
| FROM_ACTIVITY_ID | NUMBER | 10 | Yes | ID of origin activity. '0' ID value denotes 'start travel'. | |
| FROM_LOCATION_ID | NUMBER | 10 | Yes | In case of 'start travel', it contains an ID of the start location. | |
| FROM_COORD_STATUS | VARCHAR2 | 7 | Defines if there are valid coordinates. | ||
| FROM_COORD_X | NUMBER | 8 | X coordinate (Longitude) of the source. | ||
| FROM_COORD_Y | NUMBER | 8 | Y coordinate (Latitude) of the source. | ||
| TO_ACTIVITY_ID | NUMBER | 10 | Yes | ID of destination activity. '0' ID value denotes 'final travel'. | |
| TO_LOCATION_ID | NUMBER | 10 | Yes | In case of 'final travel', it contains an ID of the final location. | |
| TO_COORD_STATUS | VARCHAR2 | 7 | Defines if there are valid coordinates. | ||
| TO_COORD_X | NUMBER | 8 | X coordinate (Longitude) of the destination. | ||
| TO_COORD_Y | NUMBER | 8 | Y coordinate (Latitude) of the destination. | ||
| TRAVEL_DISTANCE | NUMBER | Yes | Estimated travel distance in meters. | ||
| TRAVEL_DURATION | NUMBER | 5 | Yes | Street level travel time in minutes. | |
| TRAVEL_DURATION_DEVIATION | NUMBER | 5 | Yes | Possible deviation of the estimated travel time value; Minutes. | |
| WEIGHT | NUMBER | 12 | Yes | Weightage assigned to the record for computational purposes. | |
| CREATED | TIMESTAMP | Yes | Creation time of this street level data record. | ||
| 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_ST_SLT_DATA_N1 | Non Unique | DATA | FROM_ACTIVITY_ID, TO_ACTIVITY_ID, FROM_LOCATION_ID, TO_LOCATION_ID |
| FFS_ST_SLT_DATA_PK | Unique | DATA | RECORD_ID |