Details and Examples: User-Resource Relation Fields Data Set

You can extract the details of all users existing in the application and resources visible to such users by the end of the extraction period.

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.

User-Resource Relation Fields are exported in the Daily Extract file for which 'User-Resource Relation Fields' is selected as the entity. User properties and fields available in Oracle Field Service and the properties of resources assigned to such users (for example, 'User ID', 'User Login', 'Resource ID'.) 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 'users' root element that contains 'user' elements. 'user' 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 of fields in the Message Text Fields data set:

Field	Label	Description
Blocked To	security_user.login_blocked_to	User login is blocked until the specified date and time.
Capacity Bucket	provider.pcapacity_bucket	ID of capacity bucket for the resource for which the user is assigned to.
Date format (Resource)	provider.pdate_fid	ID of date format for the resource for which the user is assigned to.
Date format (User)	security_user.sudate_fid	ID of date format for the user.
Email address	provider.email	Email address for the resource for which the user is assigned to.
Failed login attempts	security_user.login_attempts	Number of consecutive login attempts for the user.
Initial Ratio for Activity Duration	provider.pinitial_ratio	Initial ratio for activity duration for the resource for which the user is assigned to.
Last login	security_user.last_login	Date and time when the user last logged in.
Last password change	security_user.last_password_change	Date and time when the user has changed the password last time
Long Date Format	security_user.sulong_date_fid	ID of full date format (with weekday) for the resource for which the user is assigned to.
Message Language	provider.planguage	Language for the resource for which the user is assigned to.
Name	security_user.uname	Name of the user.
Registered	security_user.sucreated	Date and time when the user was created.
Resource External ID	provider.external_id	External system identifier for the resource for which the user is assigned to.
Resource ID	provider.pid	Unique internal identifier of the resource for which the user is assigned to.
Resource Name	provider.pname	Name (text identifier) of the resource for which the user is assigned to.
Resource Parent	provider.parent	ID of parent resource for the resource for which the user is assigned to.
Resource Phone	provider.pphone	Phone number of the resource for which the user is assigned to.
Resource status	provider.pactive	Status of the resource for which the user is assigned to.
Resource type	provider.ptype	Type of the resource for which the user is assigned to.
Routing profile	provider.p_rprid	ID of routing plan assigned to the resource for which the user is assigned to.
Status	security_user.sustatus	Status of the user (active, inactive or deleted)
Time Zone (Resource)	provider.time_zone	ID of time zone assigned to the resource for which the user is assigned to.
Time Zone (User)	security_user.su_zid	ID of time zone assigned to the user.
Time format (Resource)	provider.ptime_fid	ID of time format for the resource for which the user is assigned to.
Time format (User)	security_user.sutime_fid	ID of time format for the user.
Updated	security_user.suupdated	Date and time when the user was updated last time.
User ID	security_user.uid	Unique user ID
User Language	security_user.ulanguage	User's language
User Login	security_user.ulogin	User's login
Week Start	security_user.suweek_start	Starting day of the week for the user
Working days to start impacting duration estimations	provider.skip_days_for_stats	Integer number of days which must be skipped for natural learning statistics
main_resource_id	Main resource	ID of main resource assigned to the user.

Custom user 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 custom user properties that can be configured:

Type	Configurable
String	Yes
Integer	Yes
Enumeration	Yes
File	No

Example: User-Resource Relation Fields file

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

User's identifier in Oracle Field Service, for example, user_id
User's login in Oracle Field Service, for example, login
Unique internal identifier of the resource visible to the user, for example, user_visibility_id
External identifier of the resource visible to the user, for example, user_visibility_external_id

In this example, details for two users are provided. User with ID 4374 and login engineer, able to view resource with internal identifier Arndt William and external identifier 33001. User with ID 2318 and login dispatcher, able to view resource with internal identifier Sunrise Enterprise and external identifier 22.

<?xml version="1.0" encoding="UTF-8"?>
   <users>
   <user>
      <Field name="user_id">4374</Field>
      <Field name="login">engineer</Field>
      <Field name="user_visibility_id">Arndt William</Field>
      <Field name="user_visibility_external_id">33001</Field>
   </user>
   <user>
      <Field name="user_id">2318</Field>
      <Field name="login">dispatcher</Field>
      <Field name="user_visibility_id">Sunrise Enterprise</Field>
      <Field name="user_visibility_external_id">22</Field>
   </user>
</users>