FFS_SD_RES_GT

Contains temporary resource duration data.

Details

• Schema: FUSION

• Object owner: FFS

• Object type: TABLE

• Tablespace: ffs_sd_res_gt

Primary Key

Name	Columns
FFS_SD_RES_GT_PK	ACTIVITY_KEY_ID

Columns

Name	Datatype	Precision	Not-null	Comments
ACTIVITY_KEY_ID	NUMBER	10	Yes	Unique identifier for Activity Duration key value.
MIN_AVG	NUMBER	10		Minimum average travel time in minutes.
MAX_AVG	NUMBER	10		Maximum average travel time in minutes.
CORRECTION_COEFF	NUMBER	10		Correction coefficient for Sigma.

Indexes

Index	Uniqueness	Columns
FFS_SD_RES_GT_PK	Unique	ACTIVITY_KEY_ID