Details and Examples: Time Slot Fields Data Set

Details of fields and custom properties for all time slots existing in the application by the end of the extraction period can be extracted.

Important: This information only applies to Oracle Field Service environments. You can verify whether you've Oracle Field Service or Oracle Fusion Field Service, by signing in and checking on the About page.

Time Slot Fields are exported in the Daily Extract file for which 'Time Slot Fields' is selected as the entity. Any time slot properties and fields available in Oracle Field Service (for example, 'Time Slot Label', 'Time Slot Status', 'Time Slot Name'.) can be included in the Daily Extract by adding them to the file structure.

Depending on the requirements of the company, the list of exported properties and fields can be changed at any time by removing or adding certain fields.

Data can be retrieved as one or more XML files consisting of 'time_slots' root element which contains 'time_slot' elements. 'time_slot' elements are sets of 'Field' elements whose attributes are names of time slot fields and custom properties and whose contents are their corresponding values.

This table provides the label and description for those fields that can be configured:

Field	Label	Description
Time Slot End	time_slot.tstime_to	Time, at which the times slot ends
Time Slot ID	time_slot.tsid	Unique internal identifier of the time slot
Time Slot Label	time_slot.tslabel	Unique label of the time slot
Time Slot Name	time_slot.tsname	Name of the time slot
Time Slot Start	time_slot.tstime_from	Time, at which the times slot starts
Time Slot Status	time_slot.tsstatus	Time slot status

Note: There are no changes for this data set and custom properties are not supported.

Example: Time Slot Fields file

The following data is collected. Provide a meaningful name to the report.

Unique internal identifier of the time slot, for example, TSlot ID
Unique label of the time slot, for example, TSlot Label
Name of the time slot (value displayed at the screen), for example, TSlot Name
Field that identifies if the time slot is active (used by the application), for example, Is TSlot Active, with the following values
- 1: Time slot is active
- 0: Time slot is not active
Time, at which the times slot starts, for example, TSlot Start
Time, at which the times slot ends, for example, TSlot End

In this example, details for two active time slots are extracted: Time Slot 01, labeled '08-10', named '08-10' which starts at 08:00 and ends at 10:00 and Time Slot 03, labeled 'lun' and named 'Lunch' that starts at 12:00 and ends at 13:00.

<?xml version="1.0" encoding="UTF-8"?>
<time_slots>
   <time_slot>
      <Field name=”TSlot ID”>01</Field>
      <Field name=”TSlot Label”>08-10</Field>
      <Field name=”TSlot Name”>08-10</Field>
      <Field name=”Is TSlot Active”>1</Field>
      <Field name=”TSlot Start”>08:00</Field>
      <Field name=”TSlot End”>10:00</Field>
   </time_slot>
   <time_slot>
      <Field name=”TSlot ID”>03</Field>
      <Field name=”TSlot Label”>lun</Field>
      <Field name=”TSlot Name”>Lunch</Field>
      <Field name=”Is TSlot Active”>1</Field>
      <Field name=”TSlot Start”>12:00</Field>
      <Field name=”TSlot End”>13:00</Field>
   </time_slot>
</time_slots>