FFS_SCHEDULE_ITEM
Contains shifts and non-working time records added to work schedules.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FFS_SCHEDULE_ITEM_PK |
ITEM_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ITEM_ID | NUMBER | 8 | Yes | PK.It is an unique ID of this record. | |
| SCHEDULE_ID | NUMBER | 8 | Yes | It is an ID of the work schedule this item belongs to. | |
| RECORD_TYPE | VARCHAR2 | 11 | It defines if this record refers to a shift or to a non-working time. | ||
| SHIFT_TYPE | VARCHAR2 | 7 | Defines a Shift Type. Possible values - regular, on-call. | ||
| START_DATE | DATE | Yes | It is an interval of dates where this record is active. | ||
| END_DATE | DATE | It is an interval of dates where this record is active. | |||
| SHIFT_ID | NUMBER | 8 | It is a reference to a shift.This field is only assigned if type of this record is 'working'. | ||
| NON_WORKING_REASON_ID | NUMBER | 5 | It is a reference to a non-working reason.This field is only assigned if type of this record is 'non-working'. | ||
| COMMENTS | VARCHAR2 | 1020 | It is a free text description of this record. | ||
| RECURRENCE | VARCHAR2 | 6 | It is a recurrence type for this record. | ||
| WEEKDAYS | NUMBER | 3 | It is a bitmask that defines the days of week to be selected.This field is only assigned if recurrence is 'weekly'.1 - Sun, 2 - Mon, 4 - Tue, 8 - Wed, 16 - Thu, 32 - Fri, 64 - Sun. | ||
| RECUR_EVERY | NUMBER | 3 | It defines a number of days(daily) or weeks(weekly) to skip.This field is only assigned if recurrence is 'daily' or 'weekly'. | ||
| FROM_DAY | DATE | It is a period of days of year.These fields are only assigned if recurrence is 'yearly'. | |||
| TO_DAY | DATE | Indicates deactivation day date value. | |||
| DECORATION | VARCHAR2 | 64 | Decoration options for on-call shift. | ||
| 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. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. | |
| DELETED_FLAG | VARCHAR2 | 1 | Indicates whether the record is logically deleted (Y - soft deleted, N or NULL - active). |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FFS_SCHEDULE_ITEM_N1 | Non Unique | Default | SCHEDULE_ID |
| FFS_SCHEDULE_ITEM_PK | Unique | Default | ITEM_ID, ORA_SEED_SET1 |
| FFS_SCHEDULE_ITEM_PK1 | Unique | Default | ITEM_ID, ORA_SEED_SET2 |