What data sets are available for extraction?

Data sets are groups of details from extracted data that are related to the same entity. You can select the fields that you want to extract and schedule the extraction. For example, you can select activity fields, resource fields, inventory fields, message fields, or GPS fields. The following important note applies to all the topics in the Daily Extract and Data Sets sections.

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.

Data from several data sets can't be extracted in one file, but data from one data set can be divided to be extracted in several files. For example, the file created for the Activity Fields entity can't also include data for the Resource Fields entity. At the same time, one file can see several database tables according to the exported field's configuration. For example, an Activity Fields file might include data from the Queue Fields table, when configured so.

You can configure the list of data sets you want to export. Data sets associated with entities configured in Business Rules are deleted within 90 days (or sooner) as defined in Retention period. For more information, see the Retention period section in the "How do I configure Business Rules?" topic.

The data sets available for export is listed below. The data set name is a link that opens more details and an example:

  • Activity Fields—Data on all fields/properties assigned by the end of extraction period to activities processed in the application during the extraction period (activities that were to be performed or were performed during the extraction period).

  • Activity Link Fields—Details of all links between activities defined in the application by the end of extraction period.

  • Activity Work Skill Fields—Details of work skills per activity at the time of extraction.

  • Manual Move Fields—Details of the fields related to activities that were manually moved in the application during the extraction period.
  • GPS Details—Details of all GPS data gathered during the data extraction period, including gpstracks.

    • GPS Track Fields (gpstracks)—Data calculated based on the GPS data in Oracle Field Service in fixed format native for Oracle Field Service. All GPS data collected for each resource for the extraction period is gathered.

  • Inventory Fields—Data on all fields and properties assigned to all inventory items, except inventory in resources' pools, available in the application by the end of extraction period.

  • Message Details—Data on all messages generated (all messages that were sent or were to be sent by the application) during the extraction period divided into two data sets.

  • Message Fields—Basic details of the messages excluding the actual text of the message.

  • Message Text Fields—Parameters of the text of each message.

  • PAS Answers Fields—Details of customer’s answers to questions asked in the Post Appointment Survey that are present in the application with status 'Delivered' at the time of extraction.

  • PAS Questions Fields—Details of questions for Post Appointment Surveys at the time of extraction.

  • Property Fields—Details of all fields and custom properties available in the application by the end of the extraction period.

  • Property File Fields—Contents of file properties (for example, images) available in the application by the end of the extraction period.

  • Property Lookup Fields—Sets of values that can be used to identify a field or custom property for all fields and custom properties available in the application by the end of extraction period.

  • Resource Fields—Details of the properties of all resources available in the application by the end of the extraction period (including inactive resources) and their position in the Resource Tree.

  • Resource Location Fields—Details of the locations defined for each resource in the application by the end of the extraction period.

  • Resource Property Fields—Details of all properties defined for each resource in the application by the end of the extraction period.

  • Resource Work Skill Fields—Details of work skills per resource at the moment of extraction.

  • Route Fields—Data on all fields/properties assigned to the routes processed in the application during the extraction period (routes that were to be executed during the extraction period), including all fields and properties assigned to resources, to which a route is directly assigned by the end of the extraction period.

  • Routing Run Result Fields—Details of the routing run results, including numeric statistics on the business parameters of the routes.
  • Service Request Fields—Details of service requests created in the application during the extraction period.

  • Time Slots Fields—Details of time slots defined in the application by the end of extraction period.

  • Type List Fields—Sets of values used to identify the type of entity by its ID for all types available in the application by the end of the extraction period.

  • User List Fields—Details of all users existing in the application by the end of the extraction period.

  • User-Resource Relation Fields—Details of resources visible to each user as defined in the application by the end of the extraction period.

Note: The Daily Extract processes property labels regardless of whether any special symbols or capital letters.