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

FFS_RESOURCE_CALENDAR

Contains calendar records configured on the resource level.

Details

  • Schema: FUSION

  • Object owner: FFS

  • Object type: TABLE

  • Tablespace: DATA

Primary Key

Name Columns

FFS_RESOURCE_CALENDAR_PK

CALENDAR_ID

Columns

Name Datatype Length Precision Not-null Comments
CALENDAR_ID NUMBER 10 Yes Unique identifier of the record.
RESOURCE_ID NUMBER 8 Yes Unique identifier of a resource.
RECORD_TYPE VARCHAR2 13 Type of resource calendar record. Available values: 'schedule', 'shift', 'extra_shift', 'working', 'extra_working', 'non-working'.
START_DATE DATE Yes Indicates date since when this record is active.
END_DATE DATE Indicates date until which this record is active. If empty - the calendar record is considered as infinite.
PARENT_ID NUMBER 10 Reference to a parent record which represents a work schedule (with RECORD_TYPE = 'schedule'). This field is only assigned if this record is added as a part of the schedule (RECORD_TYPE='schedule').
SCHEDULE_ID NUMBER 8 Unique identifier of a work schedule. This field is assigned only if RECORD_TYPE = 'schedule'.
SCHEDULE_ITEM_ID NUMBER 8 Unique identifier of a work schedule item. This field is assigned only if this record is added as a part of the schedule (RECORD_TYPE = 'schedule' and PARENT_ID is non empty).
SHIFT_ID NUMBER 8 Unique identifier of a work shift. This field is assigned only if RECORD_TYPE = 'shift'.
SHIFT_TYPE VARCHAR2 7 Work shift type. Available values: 'regular', 'on-call'. This field is assigned only if RECORD_TYPE in 'working', 'extra_working' or 'non-working'.
NON_WORKING_REASON_ID NUMBER 5 Unique identifier of a lookup (with FFS_LOOKUP.LOOKUP_TYPE = 7) representing a non working reason. This field is only assigned if RECORD_TYPE = 'non-working'.
TIME_FROM NUMBER 5 Indicates time since when the record is active. Represented in minutes since midnight in resource's time zone. This field is assigned only if RECORD_TYPE in 'Working' or 'Extra_Working'.
TIME_TO NUMBER 5 Indicates time until which the record is active. Represented in minutes since midnight in resource's time zone. This field is assigned only if RECORD_TYPE in 'Working' or 'Extra_Working'.
POINTS NUMBER 5 It is a number of available points for this shift. This field is assigned only if RECORD_TYPE in 'working' or 'extra_working'.
RECURRENCE VARCHAR2 6 Calendar recurrence type. Available values: 'none', 'daily', 'weekly', 'yearly'.
WEEKDAYS NUMBER 3 Bit mask which defines the days of week to be selected. This field is assigned only if RECURRENCE = 'weekly'. Values: 1 - Sun, 2 - Mon, 4 - Tue, 8 - Wed, 16 - Thu, 32 - Fri, 64 - Sun.
RECUR_EVERY NUMBER 3 Defines number of days (if RECURRENCE = Daily) or weeks (if RECURRENCE = weekly) to skip. This field is assigned only if RECURRENCE in 'daily' or 'weekly'.
FROM_DAY DATE Indicates date since when the period is active. This field is assigned only if RECURRENCE = 'yearly'.
TO_DAY DATE Indicates date until which the period is active. This field is assigned only if RECURRENCE = 'yearly'.
COMMENTS VARCHAR2 1020 Contains meaningfull text description of the calendar 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_RESOURCE_CALENDAR_N1 Non Unique DATA RESOURCE_ID
FFS_RESOURCE_CALENDAR_PK Unique DATA CALENDAR_ID