FFS_QTS_BUCKET_PROFILE
Contains additional configuration parameters for capacity areas.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: DATA
Primary Key
| Name | Columns |
|---|---|
|
FFS_QTS_BUCKET_PROFILE_PK |
BUCKET_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BUCKET_ID | NUMBER | 8 | Yes | Primary Key. Uniqueue identifies capacity bucket. It also points to RESOURCE_ID in FFS_RESOURCE where QTS_BUCKET_RESOURCE_ID equal to RESOURCE_ID. | |
| QUOTA_FLAGS | NUMBER | 5 | Yes | Bitmask field that defines levels the quota can be defined for. | |
| CLOSE_QUOTA_FLAGS | NUMBER | 5 | Yes | Bitmask field that defines levels the quota can be closed on. | |
| MAX_CAPACITY_FLAGS | NUMBER | 5 | Yes | Bitmask field that defines levels and a method to estimate the max capacity. | |
| AVAILABLE_CAPACITY_FLAGS | NUMBER | 5 | Yes | Bitmask field that defines a logic for the available capacity constraint. | |
| DAY_QUOTA_FLAGS | NUMBER | 5 | Yes | Bitmask field that defines a logic for the day level quota. | |
| TIME_SLOT_QUOTA_FLAGS | NUMBER | 5 | Yes | Bitmask field that defines a logic for the time slot level quota. | |
| CATEGORY_QUOTA_FLAGS | NUMBER | 5 | Yes | Bitmask field that defines a logic for the capacity category level quota. | |
| HISTORICAL_DATA_PERIOD | VARCHAR2 | 10 | Period of time to be used for the historical data analysis. | ||
| 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_QTS_BUCKET_PROFILE_PK | Unique | DATA | BUCKET_ID |