FFS_ST_LOCATION_GT
Global temporary table to calculate Stats area.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: ffs_st_location_gt
Primary Key
| Name | Columns |
|---|---|
|
FFS_ST_LOCATION_GT_PK |
LOCATION |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LOCATION | VARCHAR2 | 200 | Yes | Value of the Activity Work Zone key. | |
| AREA_ID | NUMBER | 8 | Unique identifier for the travel area. | ||
| ADDITIONAL_INFO | VARCHAR2 | 4000 | Oracle internal use only. Stores the additional information during calculation. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| FFS_ST_LOCATION_GT_PK | Unique | LOCATION |