User Resource Relation Fields
This section provides a list of user resource relation fields.
Name |
Label |
Data Type |
Description |
|---|---|---|---|
Capacity Area |
provider.pcapacity_bucket |
INTEGER |
ID of capacity bucket for the resource for which the user is assigned to. |
Date format (Resource) |
provider.pdate_fid |
INTEGER |
ID of date format for the resource for which the user is assigned to. |
Date format (User) |
security_user.sudate_fid |
INTEGER |
ID of date format for the user. |
Email address |
provider.email |
VARCHAR2 |
Email address for the resource for which the user is assigned to. |
End of blocking |
security_user.login_blocked_to |
DATE |
Email address for the resource for whom the activity is provided. |
Failed login attempts |
security_user.login_attempts |
INTEGER |
Number of consecutive login attempts for the user. |
Initial Ratio for Activity Duration |
provider.pinitial_ratio |
FLOAT |
Initial ratio for activity duration for the resource for which the user is assigned to. |
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 |
Long Date Format |
security_user.sulong_date_fid |
INTEGER |
ID of full date format (with weekday) for the resource for which the user is assigned to. |
Main Resource |
security_user.main_resource_id |
INTEGER |
ID of Main resource assigned to the user. |
Message Language |
provider.planguage |
VARCHAR2 |
Language for the resource for which the user is assigned to. |
Name |
security_user.uname |
VARCHAR2 |
Name of the user. |
Org Unit/Bucket |
security_user.organization_unit_id |
INTEGER |
|
Organization |
provider.organization_id |
INTEGER |
ID of organization for the resource the activity is assigned to. |
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 for which the user is assigned to. |
Resource ID |
provider.pid |
INTEGER |
Unique internal identifier of the resource for which the user is assigned to. |
Resource Name |
provider.pname |
VARCHAR2 |
Name (text identifier) of the resource for which the user is assigned to. |
Resource Parent |
provider.parent |
VARCHAR2 |
ID of parent resource for the resource for which the user is assigned to. |
Resource Phone |
provider.pphone |
VARCHAR2 |
Phone number of the resource for which the user is assigned to. |
Resource status |
provider.pactive |
VARCHAR2 |
Status of the resource for which the user is assigned to. |
Resource type |
provider.ptype |
VARCHAR2 |
Type of the resource for which the user is assigned to. |
Routing profile |
provider.p_rprid |
INTEGER |
ID of routing plan assigned to the resource for which the user is assigned to. |
Status |
security_user.sustatus |
VARCHAR2 |
Status of the user (active, inactive or deleted) |
Time Zone (Resource) |
provider.time_zone |
VARCHAR2 |
ID of time zone assigned to the resource for which the user is assigned to. |
Time Zone (User) |
security_user.su_zid |
INTEGER |
ID of time zone assigned to the user. |
Time format (Resource) |
provider.ptime_fid |
INTEGER |
ID of time format for the resource for which the user is assigned to. |
Time format (User) |
security_user.sutime_fid |
INTEGER |
ID of time format for the user. |
Updated |
security_user.suupdated |
DATE |
Date and time when the user was updated last time. |
User ID |
security_user.uid |
INTEGER |
Unique user ID |
User Language |
security_user.ulanguage |
VARCHAR2 |
User's language |
User Login |
security_user.ulogin |
VARCHAR2 |
User's login |
Week Start |
security_user.suweek_start |
VARCHAR2 |
Starting day of the week for the user |
Working days to start impacting duration estimations |
provider.skip_days_for_stats |
INTEGER |
Integer number of days which must be skipped for natural learning statistics |
| * | User Custom Properties |