Show/Hide Toolbars

JProjAssignee contains information about the assignees in a project record, such as the assigned user, date assigned, project to which the assignee belongs, and assignee's role (such as adjuster). This table represents the Assignees block on the Assignees tab of a project record.

Object: JProjAssignee (J_PROJ_ASSIGNEE)

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.