Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

assignedOn

ASSIGNED_ON

(DATE)

Assigned On

(Assignees block)

x

date

The date the user was assigned to the project.

isActive

IS_ACTIVE

(NUMBER)

Status

(Assignees block)

x

boolean

Indicates whether the assignee is active.

1 - is Active

0 - not Active

x

owner-->

OWNER_ID

(NUMBER)

x

x

TProject

object

8 The project to which the assignee belongs.

--> Links to specific information about the project record.

x

primaryKey

PRIMARY_KEY

(NUMBER)

x

int

The unique ID of the assignee.

relationType-->

Before TeamConnect 3.3 SP2: type-->

TYPE_ID

(NUMBER)

Role

(Assignees block)

x

x

LProjAssigneeType

object

8 The type (or role) of the assignee.

--> Links to the available assignee types.

x

unassignedOn

UNASSIGNED_ON

(DATE)

Unassigned On

(Assignees block)

x

date

The date the user was un-assigned.

user-->

USER_ID

(NUMBER)

Assignee

(Assignees block)

x

x

YUser

object

8 The user who is an assignee.

--> Links to specific information about the user account.

x

version

VERSION

(NUMBER)

x

int

Indicates how many times the assignee has been updated.