FFS_RESOURCE_WORK_ZONE
Contains work zones configured on the resource level.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: DATA
Primary Key
| Name | Columns |
|---|---|
|
FFS_RESOURCE_WORK_ZONE_PK |
RECORD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RECORD_ID | NUMBER | 8 | Yes | Unique identifier for the resource work zone record. | |
| RESOURCE_ID | NUMBER | 8 | Identifier of the resource this work zone is assigned to. | ||
| WORK_ZONE_ID | NUMBER | 8 | Yes | Foreign Key. Points to WORK_ZONE_ID in FFS_WORK_ZONE. | |
| START_DATE | DATE | Work zone activation start date. Example: 2019-02-25. | |||
| END_DATE | DATE | Work zone activation end date. Example: 2019-02-25, only for temporary Work Zones. | |||
| RECURRENCE | VARCHAR2 | 6 | Indicates schedule for the Work Zone if the resource is alternating between Work Zone assignments. Example: 'daily', 'weekly, 'none'. | ||
| RECUR_EVERY | NUMBER | 10 | Indicates number of days after which the assignment of the Work Zone repeats. Value is 0 in case the 'recurrence' field is set to 'none'. | ||
| WEEKDAYS | NUMBER | 10 | Indicates weekdays in case 'reccurence' is set to 'weekly'. Value is defined as power of 2 for each week day. Example Sunday is 1 (2 pow 0), Wednesday is 8, Saturday is 64. Selected week days values are summed up. Example selected Mon, Wed, Fri value will be 42. | ||
| RATIO | NUMBER | 10 | Yes | Indicates ratio of assigned work zone to a resource in range of 1 to 100. Means level of the likelihood that this resource is assigned activities in this work zone. | |
| TYPE | VARCHAR2 | 8 | Indicates type of Work Zone, value can be 'regular' in case the assigned Work Zone is new to the resource or 'override' in case the Work Zone is already assigned to the parent bucket. | ||
| 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_RESOURCE_WORK_ZONE_N1 | Non Unique | DATA | RESOURCE_ID |
| FFS_RESOURCE_WORK_ZONE_PK | Unique | DATA | RECORD_ID |