Details and Examples: Resource Work Skill Fields Data Set

The 'Resource Work Skill Fields' data set contains details of work skills per resource at the moment of extraction.

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.

Resource Work Skill Fields are exported in the Daily Extract file for which 'Resource Work Skill Fields' is selected as the entity. The 'Resource Work Skill Fields' file can include only the following fields: 'provider_id', 'Resource Work Skill Level', 'Resource Work Skill ID', 'Resource Work Skill From' and 'Resource Work Skill To'.

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 'provider_work_skills' root element that contains 'provider_work_skill' elements. 'provider_work_skill' elements are sets of 'Field' elements whose attributes are names of resource work skill fields and whose contents are their corresponding values.

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

Field Label Description

Resource ID

provider_work_skill.provider_id

Unique internal identifier of the resource to which the work skill was assigned

Resource Work Skill: Start Date

provider_work_skill.start_date

Work skill for resource is active starting from this date.

Resource Work Skill: ID

provider_work_skill.work_skill_id

Identifier of the work skill defined for the activity

Resource Work Skill: Level

provider_work_skill.ratio

The level of resource experience for the Work Skill

Resource Work Skill: End Date

provider_work_skill.end_date

Work skill for resource is expired after this date.

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

Example: Resource Work Skill Fields File

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

  • Identifier of the resource, for example, pid

  • Identifier of the work skill defined for the resource, for example, work_skill_id

  • The level of experience for the skill, for example, ratio

Resource 300001 has only one work skill – Update (identifier – 5) with 100 per cent ratio.

<?xml version="1.0" encoding="UTF-8"?>
<provider_work_skills>
   <provider_work_skill>
      <Field name=”pid”>120345</Field>
      <Field name=”work_skill_id”>1</Field>
      <Field name=”ratio”>80</Field>
   </provider_work_skill>
   <provider_work_skill>
      <Field name=”pid”>120345</Field>
      <Field name=”work_skill_id”>2</Field>
      <Field name=”ration”>60</Field>
   </provider_work_skill>
   <provider_work_skill>
      <Field name=”pid”>300001</Field>
      <Field name=”work_skill_id”>5</Field>
      <Field name=”ratio”>100</Field>
   </provider_work_skill>
</provider_work_skills>