Details and Examples: User List Fields Data Set
Details of all users existing in the application and resources assigned to such users by the end of the extraction period can be extracted.
User List Fields are exported in the Daily Extract file for which 'User List 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 for those fields that can be configured:
| Field | Label | Description |
|---|---|---|
End of blocking |
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 sign in tries 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 application identifier for the resource, which is set as the Visible Resource for the user. If multiple providers are set in the Visible Resource list, then one resource from the list is exported. |
Resource ID |
provider.pid |
Unique internal identifier for the resource, which is set as the Visible Resource for the user. If multiple providers are set in the Visible Resource list, then one resource from the list is exported. |
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 Start Time |
provider.time_from |
Working time start for the resource for which the user is assigned to. |
Resource End Time |
provider.time_to |
Working time end for the resource for which the user is assigned to. |
Resource Time Zone |
time_zone.name |
Standard Oracle Time zone name |
Resource Time Zone Name |
time_zone.zoneinfo_name |
Standard IANA Time zone name |
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 sign in name |
User Type Comment |
user_type.comment |
Description of User Type for which the user is assigned to. |
User Type ID |
user_type.type_id |
ID of User Type for which the user is assigned to. |
User Type Label |
user_type.label |
Label of User Type for which the user is assigned to. |
User Type Status |
user_type.status |
Status of User Type for which the user is assigned to |
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 |
main_resource_id |
Unique internal identifier for the resource, which is set as the main resource for the user. The field can be empty, if the main resource isn't set for the user. |
User 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 user custom properties that can be configured:
| Type | Configurable |
|---|---|
String |
Yes |
Integer |
Yes |
Enumeration |
Yes |
File |
No |
Example: User List 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
Name of the user, for example, user_name
User's login, for example, login
User's status, for example, status, where the options include
0: Inactive
1: Active
Unique internal identifier of the resource assigned to the user, for example, provider_id
Name of the resource assigned to the user, for example, provider_name
Login policy selected for the user, for example, login_policy
Display profile assigned to the user, for example, display_profile
Time of the user's last login, for example, last_login
Time of last password reset for the user, for example, last_password_reset
User's time zone, for example, time_zone_name
Time of user creation, for example, registered
Time of user last update, for example, updated
Indicator of whether the forced password change at next login is enabled for the user, for example, force_reset_next_login, where the options include
0: No
1: Yes
Details of properties of two users are provided in the examples:
User with ID 2324, name Admin, login 'admin', status 'active', with no resources assigned, the user's login policy is 2, display profile 7, the user logged in last on 19 July, 2013, at 07:30:09, the password was reset last on 27 September, 2011, at 18:00:56, the user's time zone is Eastern, the user was Page 58 of 65 Confidential || Oracle Example of User List Fields File Daily Extract Description registered on 03 February, 2006 at 09:20:08 and updated on 15 May, 2013, at 12:28:04. No forced password change has been enabled for this user.
User with ID 4395, name Billy Holm, login 'billy', status 'inactive', assigned resource is Billy Holm, ID 33003, the user's login policy is 2, display profile 8, the user logged in last on 12 May, 2013, at 11:03:33, the password was reset last on 09 May, 2013, at 11:04:13, the user's time zone is Eastern, the user was registered on 15 September, 2010 at 14:27:50 and updated on 15 May, 2013, at 11:53:13. Forced password change has been enabled for this user.
<?xml version="1.0" encoding="UTF-8"?>
<users>
<user>
<Field name="user_id">2324</Field>
<Field name="user_name">Admin</Field>
<Field name="login">admin</Field>
<Field name="status">active</Field>
<Field name="provider_id"/>
<Field name="provider_name"/>
<Field name="login_policy">2</Field>
<Field name="display_profile">7</Field>
<Field name="last_login">2013-07-19 07:30:09</Field>
<Field name="last_password_reset">2011-09-27 18:00:56</Field>
<Field name="time_zone_name">Eastern</Field>
<Field name="registered">2006-02-03 09:20:08</Field>
<Field name="updated">2013-05-15 12:28:04</Field>
<Field name="force_reset_next_login">0</Field>
</user>
<user>
<Field name="user_id">4395</Field>
<Field name="user_name">Billy Holm</Field>
<Field name="login">billy</Field>
<Field name="status">inactive</Field>
<Field name="provider_id">33033</Field>
<Field name="provider_name">Billy Holm</Field>
<Field name="login_policy">2</Field>
<Field name="display_profile">8</Field>
<Field name="last_login">2013-05-12 11:03:33</Field>
<Field name="last_password_reset">2013-05-09 11:04:13</Field>
<Field name="time_zone_name">Eastern</Field>
<Field name="registered">2011-09-15 14:27:50</Field>
<Field name="updated">2013-05-15 11:53:13</Field>
<Field name="force_reset_next_login">1</Field>
</user>
</users>