User List Fields

This section provides a list of user list fields.

Name	Label	Data Type	Mandatory	Description
End of blocking	security_user.login_blocked_to	DATE		User login is blocked until the specified date and time.
Failed login attempts	security_user.login_attempts	INTEGER		Number of consecutive login attempts 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 system identifier for the resource, which is set as the main resource for the user. The field can be empty, if the main resource is not 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 is not 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	User's login
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