Details and Examples: Resource Location Fields Data Set

Details for all resource locations 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.

Resource Location Fields are exported in the Daily Extract file for which 'Resource Location Fields' is selected as the entity. The 'Resource Location Fields' file can include only the following fields: 'Latitude', 'Longitude', 'Location label', 'Location Type' and 'Resource ID'.

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 'locations' root element that contains 'location' elements. 'location' 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
Latitude	location.lcoord_y	Geographic coordinate Y resolved for the location
Location Address	location.laddress	Address resolved for the location
Location City	location.lcity	City resolved for the location
Location Label	location.llabel	Label of the location which is assigned to the resource
Location Postal Code	location.lzip	ZIP/Postal code resolved for the location
Location State	location.lstate	State/Area resolved for the location
Location Type	provider_location.pltype	Type of the location which is assigned to the resource
Location by days	provider_location.plweekdays	Days of the week on which the location is assigned to the resource
Longitude	location.lcoord_x	Geographic coordinate X resolved for the location
Resource ID	provider_location.pl_pid	Identifier of the resource to which the location is assigned,
location.lid	Location ID	Internal identifier for the location
provider.external_id	Resource External ID	External identifier for resource with the location

Note: Custom properties are not supported for this data set.

Example: Resource Location Fields file

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

• Unique internal identifier of the resource to which the location is assigned, for example, system_pid

• External identifier of the resource to which the location is assigned, for example, provider_id

• Location type, for example, location_type

• Location label, for example, location_label

• geographic coordinates resolved for the location, for example, coord_x, coord_y

• days of the week on which the location is assigned to the resource, for example, weekdays, where the following values:

  • 0: No

  • 1: Mo

  • 2: Tu

  • 3: We

  • 4: Th

  • 5: Fr

  • 6: Sa

  • 7: Su

Details of two resource locations are provided in the examples: Location of type 'start', labeled 'warehouse', assigned to resource with internal identifier Basile Terry, external identifier 33035, geographic coordinates of the location are -106.03448 and 39.64311, the location is assigned to the resource on Mondays, Wednesdays and Saturdays.

Location of type 'end', labelled 'garage', assigned to the same resource geographic coordinates of the location are -104.59838 and 38.28359, the location is assigned to the resource on Mondays, Wednesdays and Saturdays.

<?xml version="1.0" encoding="UTF-8"?>
<locations>
   <location>
      <Field name="system_pid">Basile Terry</Field>
      <Field name="provider_id">33035</Field>
      <Field name="location_type">start</Field>
      <Field name="location_label">warehouse</Field>
      <Field name="coord_x">-106.03448</Field>
      <Field name="coord_y">39.64311</Field>
      <Field name="weekdays">137</Field>
   </location>
   <location>
      <Field name="system_pid">Basile Terry</Field>
      <Field name="provider_id">33035</Field>
      <Field name="location_type">end</Field>
      <Field name="location_label">garage</Field>
      <Field name="coord_x">-104.59838</Field>
      <Field name="coord_y">338.28359 </Field>
      <Field name="weekdays">137</Field>
   </location>
</locations>