1. Tables and Views for Sales and Fusion Service
  2. SVC_FS_ACC_SCHED_OFFDAYS

SVC_FS_ACC_SCHED_OFFDAYS

This table is used to store access schedule days off which are dates technicians are not allowed to be on site. This table and the SVC_FS_ACC_SCHED_HOURS make up the access schedule defined in the SVC_FS_ACCESS_SCHEDULES table. SCHED_OFFDAYS_ID is the primary / unique key in this table.

Details

  • Schema: FUSION

  • Object owner: SVC

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

SVC_FS_ACC_SCHED_OFFDAYS_PK

SCHED_OFFDAYS_ID

Columns

Name Datatype Length Precision Not-null Comments
SCHED_OFFDAYS_ID NUMBER 18 Yes Auto-generated number and primary key for this table.
ACC_SCHEDULE_ID NUMBER 18 Yes Foreign key referencing SVC_FS_ACCESS_SCHEDULES (ACC_SCHEDULE_ID), the Access Schedule for these access hours.
LABEL VARCHAR2 60 Yes The label for the non working day.
OFF_DAY NUMBER 2 The number of the day of the month the field service resource isn't allowed to be on the customer site.
OFF_MONTH_CD VARCHAR2 30 Yes The month of the year the field service resource isn't allowed to be on the customer site.
OFF_YEAR NUMBER 4 The four digit year the field service resource isn't allowed to be on the customer site.
DAY_OF_WEEK_OCCURRENCE_CD VARCHAR2 30 Occurrence to calculate date by in a month.
DAY_OF_WEEK_CD VARCHAR2 30 Day of the week for occurrence based dates.
OVERRIDE_CD VARCHAR2 30 Lookup code that indicates the override type for this access schedule day such as Add or Remove.
OVERRIDE_SERVICE_PROFILE_ID NUMBER 18 Foreign key referencing SVC_SERVICE_PROFILES (SERVICE_PROFILE_ID), the service profile access schedule day that is overridden.
OVERRIDE_WO_ID NUMBER 18 Foreign key referencing SVC_WORK_ORDERS (WO_ID), the Work Order that overrides the access schedule day for the combination of account, country, and region.
COMMENTS VARCHAR2 250 Comments about the access schedule day the technician isn't allowed to be on the customer site.
ACTIVE_FLAG VARCHAR2 1 Yes Property used to identify if a specific access schedule day is active.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to 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.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Foreign Keys

Table Foreign Table Foreign Key Column
SVC_FS_ACC_SCHED_OFFDAYS svc_fs_access_schedules ACC_SCHEDULE_ID
SVC_FS_ACC_SCHED_OFFDAYS svc_work_orders OVERRIDE_WO_ID
SVC_FS_ACC_SCHED_OFFDAYS svc_service_profiles OVERRIDE_SERVICE_PROFILE_ID

Indexes

Index Uniqueness Tablespace Columns
SVC_FS_ACC_SCHED_OFFDAYS_PK Unique Default SCHED_OFFDAYS_ID
SVC_FS_ACC_SCHED_OFFDAYS_U1 Unique Default ACC_SCHEDULE_ID, OFF_DAY, OFF_MONTH_CD, OFF_YEAR, DAY_OF_WEEK_OCCURRENCE_CD, DAY_OF_WEEK_CD, OVERRIDE_SERVICE_PROFILE_ID, OVERRIDE_WO_ID