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