Details and Examples: Activity Work Skill Fields Data Set

The 'Activity Work Skill Fields' data set contains details of work skills per activity 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.

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

Depending on the requirements of the company, the list of exported 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 'appt_work_skills' root element that contains 'appt_work_skill' elements. 'appt_work_skill' elements are sets of 'Field' elements whose attributes are names of activity work skill fields and whose contents are their corresponding values.

This table provides the label and description of fields in the Activity Work Skill Fields data set:

Field	Label	Description
Activity ID	appt_work_skill.aid	Unique internal identifier of the activity to which the work skill was assigned
Activity Work Skill ID	appt_work_skill.work_skill_id	Identifier of the work skill defined for the activity
Work Skill Preferable Level	appt_work_skill.preferable_level	Preferable level of the skill for the activity
Work Skill Required Level	appt_work_skill.required_level	Required level of the skill for the activity

Note: No changes and custom properties for this data set.

Example: Activity Work Skills File

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

Identifier of the activity, for example, aid
Identifier of the work skill defined for the activity, for example, work_skill_id
Required level of the skill for the activity, for example, required_level
Preferable level of the skill for the activity, for example, preferable_level

The example file extracts the details of work skills for two activities: 12345 and 23456. Activity 12345 requires two work skills – Install (identifier – 1) and Deinstall (identifier – 2). The required level for Install is 70 and preferable is 100. The required level for Deinstall is 50 and preferable is 60. Activity 23456 requires only one work skill – Update (identifier – 5), required level for Update skill is 40 and preferable is 70.

<?xml version="1.0" encoding="UTF-8"?>
<appt_work_skills>
   <appt_work_skill>
      <Field name=aid”>12345</Field>
      <Field name=”work_skill_id”>1</Field>
      <Field name=”required_level”>70</Field>
      <Field name=”preferable_level”>100</Field>
   </appt_work_skill>
   <appt_work_skill>
      <Field name=aid”>12345</Field>
      <Field name=”work_skill_id”>2</Field>
      <Field name=”required_level”>50</Field>
      <Field name=”preferable_level”>60</Field>
   </appt_work_skill>
   <appt_work_skill>
      <Field name=aid”>23456</Field>
      <Field name=”work_skill_id”>5</Field>
      <Field name=”required_level”>40</Field>
      <Field name=”preferable_level”>70</Field>
   </appt_work_skill>
</appt_work_skills>