JProjAssignee

Last updated
Save as PDF

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
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.
primaryKey	PRIMARY_KEY (NUMBER)		x			int	The unique ID of the assignee.
statusId	STATUS_ID (NUMBER)					number
projectID	PROJECT_ID (NUMBER)					number
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
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.
objectDefinitionId	OBJECT_DEFINITION_ID (NUMBER)					number
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.