Show/Hide Toolbars

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

TContact

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

YUser

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

YGroup

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

TDocument

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

UGrupMember

 

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

YUser

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.