Skip to main content
Mitratech Success Center

JProjAssignee

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

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

owner-->

OWNER_ ID

(NUMBER)

 

x

x

TProject

object

8 The project to which the assignee belongs.

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

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

LProj
Assignee
Type

object

8 The type (or role) of the assignee.

--> Links to the available assignee types.

unassignedOn

UNASSIGNED_ON (DATE)

Unassigned On (Assignees block)

x

   

date

The date the user was un-

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.

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the assignee has been updated.

LProjAssigneeType

LProjAssigneeType contains information that defines project assignee roles. This information includes the name of the role, tree position, and custom object definition to which it belongs. This table represents the Assignee Role Type system lookup table, which appears on the Assignee Roles tab of custom object definitions.

Object: LProjAssigneeType (L_PROJ_ASSIGNEE_TYPE)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

embeddedProjects
-->

BeforeTeamConnect 3.3

SP2: childList-- >

n/a

 

x

x

LProj
Assignee
Type

 

8 The list of all assignee roles that are child roles to the currently selected role.

--> Links to specific information about assignee roles that are defined for the project object.

displayOrder

DISPLAY_ORDER (NUMBER)

Order 
(Assignee Roles tab)

x

   

int

Indicates the order of this assignee role in the list of assignee roles in the GUI.

name

NAME (VARCHAR2) (50)

Role Name (Assignee Roles tab)

x

   

string (50)

The name of the assignee role.

parent-->

PARENT_ID (NAME)

 

x

x

LProj
Assignee
Type

object

8 The parent assignee role of the currently selected role.

--> Links to specific information about assignee roles that are defined for the project object.

primaryKey

PRIMARY_KEY (NUMBER)

 

x

   

int

The unique ID of the assignee role.

treePosition

TREE_POSITION (VARCHAR2) (250)

Tree Position (Assignee Roles tab)

x

   

string (250)

Indicates the tree position for the assignee role.

isActive

IS_ACTIVE (NUMBER)

Status 
(Assignees block)

x

   

boolean

Indicates whether the assignee is active.

1 - is Active
0 - not Active

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the assignee role has been updated.

  • Was this article helpful?