FFS_QTS_FILL_SCHEDULE
Stores quota auto-populate schedule.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: DATA
Primary Key
| Name | Columns |
|---|---|
|
FFS_QTS_FILL_SCHEDULE_PK |
BUCKET_ID, QUOTA_LEVEL, TIME_SLOT_ID, CATEGORY_ID, FIELD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BUCKET_ID | NUMBER | 8 | Yes | Foreign Key. Points to BUCKET_ID in FFS_QTS_BUCKET_PROFILE. | |
| QUOTA_LEVEL | VARCHAR2 | 9 | Yes | Level of quota the operation should be performed on. | |
| 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. | |
| FIELD_ID | NUMBER | 3 | Yes | Identifier of quota field the operation should be performed for. | |
| STATUS | VARCHAR2 | 8 | Status of this record that controls if the corresponding action is performed automatically. | ||
| OPERATION | VARCHAR2 | 24 | Operation that should be performed. | ||
| SOURCE_FIELD_ID | NUMBER | 3 | Identifier of the field that should be used as a source of data. | ||
| SOURCE_OFFSET | NUMBER | 8 | Offset of a first day/week that should be used as a source of data. | ||
| SOURCE_COUNT | NUMBER | 8 | Number of days/weeks that should be used as a source of data. | ||
| TARGET_OFFSET | NUMBER | 3 | Offset of a first day/week that should be populated. | ||
| TARGET_COUNT | NUMBER | 8 | Number of days/weeks that should be populated. | ||
| MULTIPLY_BY | NUMBER | Percent value for the percent_shift operation. | |||
| RECURRENCE | VARCHAR2 | 6 | Defines when this operation should be performed automatically. | ||
| DAY_OF_WEEK | NUMBER | 3 | Day of week when this operation should be performed. Zero value means everyday. | ||
| START_TIME | NUMBER | 5 | Yes | Time of day when this operation should be performed. | |
| WITHIN | NUMBER | 5 | Yes | Length of the time interval in minutes when schedule should be applied after start time. Zero value means that this applying window is disabled. | |
| UPDATED | TIMESTAMP | Yes | Time when the auto-populate parameters were changed last time. | ||
| LAST_RUN | TIMESTAMP | Time when this operation was performed last time. | |||
| NEXT_RUN | TIMESTAMP | Time when this operation is expected to be performed next time. | |||
| 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_FILL_SCHEDULE_PK | Unique | DATA | BUCKET_ID, QUOTA_LEVEL, TIME_SLOT_ID, CATEGORY_ID, FIELD_ID |