Details and examples: Property Lookup Fields data set

The 'Property Lookup Fields' data set contains the values that can be used to identify properties available in the application by the end of extraction period can be collected. Such details are fixed sets of fields.

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.

Property Lookup Fields are exported in the Daily Extract file for which 'Property Lookup Fields' is selected as the entity. The 'Property Lookup Fields' file can include only the following fields: 'Property ID', 'Property Language', 'Property Name' and 'Text Entry Identifier.'

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 'properties' root element that contains 'property' elements. 'property' elements are sets of 'Field' elements whose attributes are names of fields used to identify the property and whose contents are their corresponding values.

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

Field	Label	Description
Property ID	property_name.pn_propertyid	Unique internal identifier of the property in the system.
Property Language	property_name.pn_lid	Integer that corresponds to the language defined for the property name.
Property Name	property_name.pntext	Name of the property.
Text Entry Identifier	property_name.pnindex	Internal property name identifier (0-property name, -1 = property hint, other integer of string value - identifier of enumeration value)

Note: No changes for this data set.

Custom activity, inventory, resource, user and service request lookup properties (except file properties) which is available by the end of the extraction period can be processed. File properties are extracted according to configuration defined in the Property File Fields data set.

This table provides the custom properties that can be configured:

Type	Configurable
String	Yes
Integer	Yes
Enumeration	Yes
File	No

Example: Property Lookup Fields file

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

Unique internal identifier of the property, for example, Property ID
Integer that corresponds to the language of property, for example, Property Language, with the following options
- 1: English
- 2: Spanish
Number of the default value, for example, Property Index
Name of the property or its default value, for example, Property Text

Details for Properties 154897, 356850 are exported. 154897 is 'Activity ID', two languages can be used for the property and there are no values to choose from. 356850 is 'Resource Type', two languages can be used for the property and there are three values the resource type can be chosen from.

<?xml version="1.0" encoding="UTF-8"?>
<properties>
   <property>
      <Field name=”Property ID”>154897</Field>
      <Field name=”Property Language”>1</Field>
      <Field name=”Property Index”>0</Field>
      <Field name=”Property Text”>Activity ID</Field>
   </property>
   <property>
      <Field name=”Property ID”>154897</Field>
      <Field name=”Property Language”>2</Field>
      <Field name=”Property Index”>0</Field>
      <Field name=”Property Text”>ID de Actividad</Field>
   </property>
   <property>
      <Field name=”Property ID”>356850</Field>
      <Field name=”Property Language”>1</Field>
      <Field name=”Property Index”>0</Field>
      <Field name=”Property Text”>Resource Type</Field>
   </property>
   <property>
      <Field name=”Property ID”>356850</Field>
      <Field name=”Property Language”>2</Field>
      <Field name=”Property Index”>0</Field>
      <Field name=”Property Text”>Tipo de Recurso</Field>
   </property>
   <property>
      <Field name=”Property ID”>356850</Field>
      <Field name=”Property Language”>1</Field>
      <Field name=”Property Index”>1</Field>
      <Field name=”Property Text”>Technician</Field>
   </property>
   <property>
      <Field name=”Property ID”>356850</Field>
      <Field name=”Property Language”>2</Field>
      <Field name=”Property Index”>1</Field>
      <Field name=”Property Text”>Tecnico</Field>
   </property>
   <property>
      <Field name=”Property ID”>356850</Field>
      <Field name=”Property Language”>1</Field>
      <Field name=”Property Index”>2</Field>
      <Field name=”Property Text”>Bucket</Field>
   </property>
   <property>
      <Field name=”Property ID”>356850</Field>
      <Field name=”Property Language”>2</Field>
      <Field name=”Property Index”>2</Field>
      <Field name=”Property Text”>Cubo</Field>
   </property>
   <property>
      <Field name=”Property ID”>356850</Field>
      <Field name=”Property Language”>1</Field>
      <Field name=”Property Index”>3</Field>
      <Field name=”Property Text”>Group</Field>
   </property>
   <property>
      <Field name=”Property ID”>356850</Field>
      <Field name=”Property Language”>2</Field>
      <Field name=”Property Index”>3</Field>
      <Field name=”Property Text”>Grupo</Field>
   </property>
</properties>