Details and Examples: Type List Fields Data Set
The 'Type List Fields' data set contains the values identifying the type of entity used in the application. Details of all entity types available in the application by the end of extraction period can be collected.
Type List Fields are exported in the Daily Extract file for which 'Type List Fields' is selected as the entity. Any properties and fields used to identify entity types in Oracle Field Service (for example, 'type_id', 'type_label', 'type_name'.) 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 the 'types' root element which contains 'type' elements. 'type' elements are sets of 'Field' elements whose attributes are names of the properties and fields used to identify entity types and whose contents are their corresponding values.
This table provides the label and description for those fields that can be configured:
Field | Label | Description |
---|---|---|
Activity Type Group ID |
activity_type.group_id |
Unique internal identifier of Activity Group |
Lookup Type |
lookup.llookup_type |
Internal name of the lookup type |
Text |
translation.ttext |
Name of the type |
Type ID |
lookup.lid |
Unique internal identifier of the type |
Type Label |
lookup.llabel |
Unique label of the type |
Type Language |
language.lcode |
2-letter language code of the type |
Add new type |
type=user |
Company User Types has been added and can be processed as all other types. |
Example: Type List Fields file
The following data is collected. Provide a meaningful name to the report.
Unique internal identifier of the type, for example, Type ID
Unique label of the type, for example, Type Label
Language available for the type, for example, Type Language, which can have the following values.
en: English
sp: Spanish
Name that corresponds to the type and language, for example,
Entity, type of which is defined, for example, , which can have the following values:
Resource
Activity
Inventory
Service request
Work skill
Non-working reason
Launch Condition Name
In this example, details for types 028, 029 and 035 are exported. 028 and 029 are related to a resource, 028 is labeled 'gr' and in English corresponds to Group and in Spanish corresponds to Grupo, 029 is labeled 'buc' and corresponds to Bucket in English and to Cubo in Spanish. Type 035 is related to Activity and labeled 'in', it correspond to 'Installation' in English and 'Instalación' in Spanish.
<?xml version="1.0" encoding="UTF-8"?>
<types>
<type>
<Field name=”Type ID”>028</Field>
<Field name=”Type Label”>gr</Field>
<Field name=”Type Language”>en</Field>
<Field name=”Type Text”>Group</Field>
<Field name=”Type Entity”>resource</Field>
</type>
<type>
<Field name=”Type ID”>028</Field>
<Field name=”Type Label”>gr</Field>
<Field name=”Type Language”>sp</Field>
<Field name=”Type Text”>Grupo</Field>
<Field name=”Type Entity”>resource</Field>
</type>
<type>
<Field name=”Type ID”>029</Field>
<Field name=”Type Label”>buc</Field>
<Field name=”Type Language”>en</Field>
<Field name=”Type Text”>Bucket</Field>
<Field name=”Type Entity”>resource</Field>
</type>
<type>
<Field name=”Type ID”>029</Field>
<Field name=”Type Label”>buc</Field>
<Field name=”Type Language”>sp</Field>
<Field name=”Type Text”>Cubo</Field>
<Field name=”Type Entity”>resource</Field>
</type>
<type>
<Field name=”Type ID”>035</Field>
<Field name=”Type Label”>in</Field>
<Field name=”Type Language”>en</Field>
<Field name=”Type Text”>Installation</Field>
<Field name=”Type Entity”>activity</Field>
</type>
<type>
<Field name=”Type ID”>035</Field>
<Field name=”Type Label”>in</Field>
<Field name=”Type Language”>sp</Field>
<Field name=”Type Text”>Instalación</Field>
<Field name=”Type Entity”>activity</Field>
</type>
</types>