Skip to main content
Mitratech Success Center

JprojRelation

JProjRelation contains information about the project relations in a project record.

This information includes the project on the left and right sides of the relationship and the type of relationship between the two projects (such as related). This table represents the Relations block on the Relations tab of a project record.

Object: ProjRelation (J_PROJ_RELATION)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/
Wiz

leftProject
-->

LEFT_
PROJECT_ID (NUMBER)

Project
(left side, Relations block)

 

x

TProject

object

The project on the left side of the relationship.

 

x

primary Key

PRIMARY_ KEY (NUMBER)

 

x

   

int

The unique ID of this item.

   

right
Project-->

RIGHT_
PROJECT_
ID (NUMBER)

Project 
(right side, Relations block)

 

x

TProject

object

The project on the right side of the relationship.

 

x

relation Type-->

Before TeamConnect 3.3 SP2:
type-->

TYPE_ID (NUMBER)

Relation (Relations block)

x

x

LProj
Relation
Type

object

8 The type of relationship between the two projects.

--> Links to specific definition information for the relation.

 

x

version

VERSION (NUMBER)

 

x

   

int

Indicates the number of times the item has been updated.

   

LProjRelationType

LProjRelationType contains information about the project relation types defined for custom objects, such as the name of the relation and the tree position. This table represents the Project Relation Type system lookup table.

Object: LProjRelationType (L_PROJ_RELATION_TYPE)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/
Wiz

childList-->

n/a

         

Do not apply. These lookup items cannot have a hierarchical structure.

   

parent-->

PARENT_ ID (NUMBER)

         

Do not apply. These lookup items cannot have a hierarchical structure.

   

display Order

DISPLAY_ORDER (NUMBER)

Order (System Lookup Tables, Project Relation Type)

x

   

int

Indicates the order in which this relation appears in the Type of relationship list in the Relations block of a project.

   

name

NAME (VARCHAR2) (50)

Item Name (System Lookup Tables, Project Relation Type)

x

   

string (50)

The name of the relationship type.

   

primary
Key

PRIMARY_KEY (NUMBER)

 

x

   

int

The unique ID of this item.

   

tree
Position

TREE_
POSITION (VARCHAR2) (250)

Tree Position (System Lookup Tables, Project Relation Type)

x

   

string (250)

The unique four- character alphanumeric code that is created when the relation is defined.

   

version

VERSION (NUMBER)

 

x

   

int

Indicates the number of times the item has been updated.

   
  • Was this article helpful?