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