1. Tables and Views for Sales, Fusion Service, and Field Service
  2. FFS_QTS_QUOTA_CTGR

FFS_QTS_QUOTA_CTGR

Contains quota defined on the capacity category level.

Details

  • Schema: FUSION

  • Object owner: FFS

  • Object type: TABLE

  • Tablespace: DATA

Primary Key

Name Columns

FFS_QTS_QUOTA_CTGR_PK

PAGE_ID, TIME_SLOT_ID, CATEGORY_ID

Columns

Name Datatype Length Precision Not-null Comments
ARCH_DATE DATE Yes DB record partitioning date. Set automatically by DB Optimization job.
PAGE_ID NUMBER 10 Yes Foreign Key. Points to PAGE_ID in FFS_QTS_QUOTA_PAGE.
TIME_SLOT_ID NUMBER 5 Yes Foreign Key. Points to TIME_SLOT_ID in FFS_TIME_SLOT.
CATEGORY_ID NUMBER 5 Yes Foreign Key. Points to WORK_SKILL_ID in FFS_WORK_SKILL.
QUOTA_PERCENT NUMBER 5 Yes Value of quota percent either from max available or TS level.
MIN_QUOTA NUMBER 8 Yes Minimum number of minutes to be allocated for booking of activities that belong to this category.
QUOTA NUMBER 8 Yes Absolute value of quota in minutes.
STOP_BOOKING_AT NUMBER 5 Percent used quota on parent level when booking should be stopped for this category.
CLOSED_AT TIMESTAMP Time when this quota cell was closed. Capacity area time zone is used.
OPTIONS NUMBER 3 Yes Bitmask that defines status of quota 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_QTS_QUOTA_CTGR_PK Unique DATA PAGE_ID, TIME_SLOT_ID, CATEGORY_ID