FFS_QBI_CAPACITY_AREA

Stores parameters of capacity areas and sub-areas to be used in Quota and Capacity Management.

Details

• Schema: FUSION

• Object owner: FFS

• Object type: TABLE

• Tablespace: DATA

Primary Key

Name	Columns
FFS_QBI_CAPACITY_AREA_PK	AREA_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
AREA_ID	NUMBER		10	Yes	Primary Key. Unique identifies capacity area.
ORGANIZATION_ID	NUMBER		5		Foreign Key. Points to ORGANIZATION_ID in FFS_ORGANIZATION. It is only populated for sub-areas.
BUCKET_ID	NUMBER		8	Yes	Foreign Key. Points to RESOURCE_ID in FFS_RESOURCE. Identifies of a bucket in the main resource tree to be used to place booked activities into.
OPTIONS	NUMBER		10	Yes	Bitmask field that defines related rules.
SWITCH_TO_PLANS_DAYS	NUMBER		5	Yes	Number of next days after which switch to plans.
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.
START_THRESHOLD	NUMBER		2	Yes	The last part of time slot in percent where we do not suggest booking options.
BOOKING_WITH_FORECAST_MIN_DAYS	NUMBER		3	Yes	Earliest day for booking with forecasting which is defined by the number of days regarding today.
BOOKING_WITH_FORECAST_MAX_DAYS	NUMBER		3	Yes	Latest day for booking with forecasting which is defined by the number of days regarding today.

Indexes

Index	Uniqueness	Tablespace	Columns
FFS_QBI_CAPACITY_AREA_N1	Non Unique	DATA	BUCKET_ID
FFS_QBI_CAPACITY_AREA_N2	Non Unique	DATA	ORGANIZATION_ID
FFS_QBI_CAPACITY_AREA_PK	Unique	DATA	AREA_ID