Details and Examples: Resource Property Fields Data Set

The 'Resource Property 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 Property Fields are exported in the Daily Extract file for which 'Resource Property Fields' is selected as the entity. Any resource properties and fields available in Oracle Field Service (for example, 'Resource External ID', 'Email address', 'Status'.) 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 'provider_properties' root element that contains 'provider_property' elements. 'provider_property' elements are sets of 'Field' elements whose attributes are names of resource 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
Capacity Bucket	provider.pcapacity_bucket	ID of capacity bucket for the resource.
Date format (Resource)	provider.pdate_fid	ID of date format for the resource
Email address	provider.email	Email address for the resource
Initial Ratio for Activity Duration	provider.pinitial_ratio	Initial ratio for activity duration for the resource the activity belongs to.
Message Language	provider.planguage	Language for the resource.
Organization	provider.organization_id	ID of organization for the resource
Resource External ID	provider.external_id	External system identifier for the resource
Resource ID	provider.pid	Unique internal identifier of the resource.
Resource Name	provider.pname	Name (text identifier) of the resource
Resource Parent	provider.parent	ID of parent resource for the resource
Resource Phone	provider.pphone	Phone number of the resource
Resource status	provider.pactive	Resource status (active or inactive).
Resource type	provider.ptype	Resource type ID for the resource
Routing profile	provider.p_rprid	ID of routing plan assigned to the resource
Time Zone (Resource)	provider.time_zone	ID of time zone assigned to the resource
Time format (Resource)	provider.ptime_fid	ID of time format for the resource
Working days to start impacting duration estimations	provider.skip_days_for_stats	Integer number of days which must be skipped for natural learning statistics

Note: No changes for this data set.

Resource custom properties (except file properties) can be configured and extracted to the Property fields data set. File properties are extracted according to configuration defined in the Property File Fields data set.

This table provides the Resource custom properties that can be configured:

Type	Can be configured?
String	Yes
Integer	Yes
Enumeration	Yes
File	No

Example: Resource Property Fields file

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

Unique internal identifier of the resource, for example, provider_id
Resource name, for example, provider_name
Resource type, for example, provider_active
Resource’s status, for example, provider_active, where the following values are allowed
- 0: Inactive
- 1: Active

This example also includes a custom property, custom_property_1 that allows a value of 1, 2, 3, or 4.

Details of properties of two resources are provided in the examples – resource Norman Kilburn, with ID 33037, of type 2, having the status 'active', at the address: 120 Willow Dr., Lake Mary, FL, 32746; resource Deanna Bohn, with ID 55102, of type 4, having the status 'inactive', at the address: 500 Pine Way, Sanford, 32771.

<?xml version="1.0" encoding="UTF-8"?>
<provider_properties>
   <provider_property>
      <Field name="provider_id">33037</Field>
      <Field name="provider_name">Norman Kilburn</Field>
      <Field name="provider_type">2</Field>
      <Field name="provider_active">1</Field>
      <Field name="custom_property_1">120 Willow Dr.</Field>
      <Field name="custom_property_2">Lake Mary</Field>
      <Field name="custom_property_3">FL</Field>
      <Field name="custom_property_4">32746</Field>
   </provider_property>
   <provider_property>
      <Field name="provider_id">55102</Field>
      <Field name="provider_name">Deanna Bohn</Field>
      <Field name="provider_type">4</Field>
      <Field name="provider_active">0</Field>
      <Field name="custom_property_1">500 Pine Way</Field>
      <Field name="custom_property_2">Sanford</Field>
      <Field name="custom_property_3">FL</Field>
      <Field name="custom_property_4">32771</Field>
   </provider_property>
</provider_properties>