YUser contains information about the user accounts in TeamConnect. This information includes the username, user type (such as normal or super), expiration date, password, authentication mechanism, default group, and the associated contact record. It also links to lists that describe a user's access rights settings, group accounts to which a user is a member, tools rights settings, and preference settings.
Object: YUser (Y_USER)
Attribute |
Database column name |
Field in UI |
End of path |
Bridge |
Links to object table: |
Data type |
Comments |
Commonly used in: |
|
Rules |
Temp/Wiz |
||||||||
accountExpiresOn |
ACCOUNT_EXPIRES_ON (DATE) |
Account expires on (General tab) |
x |
|
|
date |
Date when the user account expires. |
|
|
authenticationType |
AUTH_TYPE (VARCHAR2) (10) |
Authentication (General tab) |
x |
|
|
string (10) |
The mechanism by which the user is authenticated. |
|
|
byPassSearchLimits |
BYPASS_SEARCH_LIMITS |
|
x |
|
|
boolean |
Indicates whether the user account is set to allow users to see the Return all results hyperlink in the search results heading. Clicking the hyperlink allows users to bypass the system settings for the maximum number of records retrieved or maximum number of seconds for a search. |
|
|
calendarAppUserID |
CALENDAR_APP_USER_ID (VARCHAR2) (250) |
Calendaring Application User ID |
|
|
|
string (250) |
Allows you to map a calendaring server user to a TeamConnect user. User ID of the appropriate calendaring application must be entered. Then, for TeamConnect, you must set: whether the account is active, the expiration date, whether the user must change password at next log-in, and whether to enable assistive technology. |
|
|
contact--> |
CONTACT_ID (NUMBER) |
Account belongs to (General tab) |
x |
x |
object |
8 The contact record associated with this user account. --> Links to specific information about the contact record. |
|
|
|
createdBy--> |
CREATED_BY_ID (NUMBER) |
|
x |
x |
object |
8 The user who created the user account. --> Links to specific information about the user account. |
|
|
|
createdOn |
CREATED_ON (DATE) |
|
x |
|
|
date |
The date when the user account was created. |
|
|
defaultGroup--> |
DEFAULT_GROUP_ID (NUMBER) |
Indicated by a blue diamond on Groups tab |
x |
x |
object |
8 The group that is selected as the default group for this user account. --> Links to specific information about the user group. |
x |
|
|
documentFolder--> |
DOCUMENT_FOLDER_ID (NUMBER) |
|
|
x |
object |
Links to the information about the personal document folder of the user. |
|
|
|
functionalAccessList--> |
n/a |
Rights tab Category Rights tab |
|
x |
UUserFunctionalAccess |
|
Links to the user's rights settings. |
|
|
groupMemberList--> |
n/a |
|
|
x |
|
Links to the join table that contains information for all groups in which this user is a member. |
x |
|
|
isAccountActive |
ACCOUNT_TYPE (NUMBER) |
Account expires on (check box, General tab) |
x |
|
|
boolean |
Indicates whether the user account is set to expire on a certain date. 0 - false 1 - true |
|
|
isActive |
IS_ACTIVE (NUMBER) |
Account is active (General tab) |
x |
|
|
boolean |
Indicates whether the user account is active. 0 - false 1 - true |
|
|
isChangePasswordNextLogin |
IS_CHANGE_PWD_NEXT_LOGIN (NUMBER) |
Must change password on next login (General tab) |
x |
|
|
boolean |
Indicates whether the user is required to change the password the next time he/she logs in to TeamConnect. 0 - false 1 - true |
|
|
isLocked |
IS_LOCKED (NUMBER) |
Account is locked (General tab) |
x |
|
|
boolean |
Indicates whether the user account is locked after a number of failed login attempts. 0 - false 1 - true |
|
|
lastFailedAttemptOn |
LAST_FAILED_ATTEMPT_ON (DATE) |
|
x |
|
|
dateTime |
Date and time of the last failed login. |
|
|
lastLoginOn |
LAST_LOGIN_ON (DATE) |
|
x |
|
|
date |
Indicates the last time the user logged on to TeamConnect. |
|
|
ldapStatusIID |
LDAP_STATUS_IID (DATE) |
|
x |
|
|
int |
Currently not used. |
|
|
longSettingList--> |
n/a |
|
|
|
|
|
Currently not used. |
|
|
modifiedBy--> |
MODIFIED_BY_ID (NUMBER) |
|
x |
x |
object |
8 The user who last modified this user account. --> Links to specific information about the user account. |
|
|
|
modifiedOn |
MODIFIED_ON (DATE) |
|
x |
|
|
date |
The date when the user account was last modified. |
|
|
numberOfFailedAttempts |
NUMBER_OF_FAILED_ATTEMPTS (NUMBER) |
|
x |
|
|
int |
Indicates the number of failed login attempts. |
|
|
parent--> |
PARENT_ID (NUMBER) |
|
|
|
|
|
Currently not used. |
|
|
password |
PASSWORD (VARCHAR2) (250) |
Password (General tab) |
x |
|
|
string (250) |
The password required for the user to log in using this user account. |
|
|
passwordSavedDate |
PASSWORD_SAVED_DATE (DATE) |
|
x |
|
|
date |
The date when the password was last saved. This value is used to determine whether the password has expired. |
|
|
primaryKey |
PRIMARY_KEY (NUMBER) |
|
x |
|
|
int |
The unique ID of the user account. |
|
|
settingList--> |
n/a |
|
|
x |
UUserSetting |
|
Links to the user's preferences settings. |
|
|
shortDescription |
SHORT_DESCRIPTION (VARCHAR2) (250) |
Description (General tab) |
x |
|
|
string (250) |
Description of the user account. |
|
|
toolList--> |
n/a |
|
|
x |
|
|
Links to the tools rights settings of the user. |
|
|
userTypeIID |
USER_TYPE_IID (NUMBER) |
User Type (General tab) |
x |
|
|
int |
Indicates the type of this user account, which may be: 1 - Super 2 - Normal 3 - Limited-Privilege |
|
|
username |
USERNAME (VARCHAR2) (100) |
Username (General tab) |
x |
|
|
string (100) |
The username assigned to this user account. |
|
|
version |
VERSION (NUMBER) |
|
x |
|
|
int |
Indicates how many times the user account has been updated. |
|
|
