Skip to main content
Mitratech Success Center

YUser

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.

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

account
ExpiresOn

ACCOUNT_EXPIRES_ON (DATE)

Account expires on
(General tab)

x

   

date

Date when the user account expires.

   

authenticationType

AUTH_
TYPE

(VARCH AR2) (10)

Authentication
(General tab)

x

   

string (10)

The mechanism by which the user is authenticated.

   

byPass
Search
Limits

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.

   

calendar
AppUserID

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.

   

default
Group-- >

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

 

document
Folder-->

DOCUMENT_
FOLDER_
ID
(NUMBER)

   

x

TDocument

object

Links to the information about the personal document folder of the user.

   

functional
AccessList
-->

n/a

Rights tab

Category Rights tab

 

x

UUserFunctionalAccess

 

Links to the user's rights settings.

   

group
Member
List-->

n/a

   

x

UGrup
Member

 

Links to the join table that contains information for all groups in which this user is a member.

x

 

isAccount
Active

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

   

isChange
Password
NextLogin

IS_
CHANGE_
PWD_
NEXT_
LOG IN
(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

   

lastFailed
AttemptOn

LAST_
FAILED_
ATTEMPT_ON (DATE)

 

x

   

dateTime

Date and time of the last failed login.

   

lastLogin
On

LAST_
LOGIN_ON(DATE)

 

x

   

date

Indicates the last time the user logged on to TeamConnect.

   

ldapStatus
IID

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.

   

modified
On

MODIFIED_ON (DATE)

 

x

   

date

The date when the user account was last modified.

   

numberOf
Failed
Attempts

NUMBER_OF_FAILED_
ATTEMPTS (NUMBER)

 

x

   

int

Indicates the number of failed login attempts.

   

parent-->

PARENT _ID
(NUMBER)

         

Currently not used.

   

password

PASS
WORD
(VARCHAR2) (250)

Password
(General tab)

x

   

string (250)

The password required for the user to log in using this user account.

   

password
SavedDate

PASS
WORD_
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

UUser Setting

 

Links to the user's preferences settings.

   

short
Description

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

USER
NAME
(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.

   
  • Was this article helpful?