Rules

accountExpiresOn

ACCOUNT_EXPIRES_ON

(DATE)

Account expires on
(General tab)

x

date

Date when the user account expires.

ACCOUNT_ACTIVE

(NUMBER)

authenticationType

AUTH_
TYPE
 

(VARCHAR2) (10)

Authentication
(General tab)

x

string (10)

The mechanism by which the user is authenticated.

byPassSearchLimits

BYPASS _SEARCH_LIMITS

(NUMBER)

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.

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

YUserFunctionalAccess

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

IS_MFA_DEVICE_REGISTERED

(NUMBER)

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.

MFA_SALT

NVARCHAR2 (250)

nvarchar2 (250)

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.

userPasswordSavedDate

USER_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.

POSITION_TYPE_IID

(NUMBER)

primaryKey

PRIMARY_KEY
(NUMBER)

x

int

The unique ID of the user account.

settingList
-->

n/a

x

YUser Setting

Links to the user's preferences settings.

SALT

NVARCHAR2 (250) 

nvarchar2 (250)

SECURITY_TYPE_IID

(NUMBER)

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.