Show/Hide Toolbars

JProjPhase contains information about the phases that have occurred in a project record. This includes the phase type (such as open or close), duration, transition date, and user who made the transition. This table represents the Phase History block on the Phases tab of a project record.

Object: JProjPhase (J_PROJ_PHASE)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

Commonly used in:

Rules

Temp/Wiz

owner-->

PROJECT_ID

(NUMBER)

 

x

x

TProject

object

8 The project for which the phase has been selected.

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

 

 

phaseDuration

PHASE_DURATION

(NUMBER)

Duration

(Phases block in project record)

x

 

 

int

The duration of the phase.

 

 

primaryKey

PRIMARY_KEY

(NUMBER)

 

x

 

 

int

The unique ID of the phase.

 

 

transitionedBy-->

TRANSITIONED_BY_ ID

(NUMBER)

Set By

(Phases block in project record)

x

x

YUser

object

8 The user who changed the project to this phase.

--> Links to specific information about the user account.

 

 

transitionedOn

TRANSITIONED_ON

(DATE)

Set On

(Phases block in project record)

x

 

 

date

The date on which the phase was selected for the project (or, the date that the phase was changed).

 

 

relationType-->

Before TeamConnect 3.3 SP2: type-->

TYPE_ID

(NUMBER)

Phase

(Phases block in project record)

x

x

WObjdPhaseType

object

8 The phase type that was selected for the record.

--> Links to specific information about phases defined for the project object.

 

 

version

VERSION

(NUMBER)

 

x

 

 

int

Indicates the number of times the phase has been updated.