User List Fields

This section provides a list of user list 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.

Name	Label	Data Type	Required	Description
End of blocking	security_user.login_blocked_to	DATE		User is blocked until the specified date and time.
Failed login attempts	security_user.login_attempts	INTEGER		Number of consecutive sign in tries for the user.
Last login	security_user.last_login	DATE		Date and time when the user last logged in.
Last password change	security_user.last_password_change	DATE		Date and time when the user has changed the password last time
Name	security_user.uname	VARCHAR2		Name of the user.
Registered	security_user.sucreated	DATE		Date and time when the user was created.
Resource External ID	provider.external_id	VARCHAR2		External application 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.
Resource ID	provider.pid	INTEGER		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.
Resource Time Zone	time_zone.name	VARCHAR2		Standard Oracle Time zone name
Status	security_user.sustatus	VARCHAR2		Status of the user (active, inactive or deleted)
Updated	security_user.suupdated	DATE		Date and time when the user was updated last time.
User Login	security_user.ulogin	VARCHAR2	True	The User Login serves as the primary key in the database. Updating this field from Field Service might cause a new row to be created in the Autonomous Database instead of updating the existing record.
User Type Label	user_type.label	VARCHAR2		Label of User Type for which the user is assigned to.
Week Start	security_user.suweek_start	VARCHAR2		Starting day of the week for the user
*	User custom properties