JProjPhase

Last updated
Save as PDF

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
Attribute	Database column name	Field in UI	End of path	Bridge	Links to object table:	Data type	Comments
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.
transitioneOn	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	WObjd PhaseType	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.

WObjdPhaseType

WObjdPhaseType contains the information that defines project phase types. This includes the name of the phase and the unique code. This table also links to lists of phase transitions for which the phase type is the beginning phase or resulting phase. This table represents the Phases block on the Phases tab of custom object definitions.

Object: WObjdPhaseType (W_OBJD_PHASE_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
displayOrder	DISPLAY_ORDER (NUMBER)	Order (Phases tab in Object Definition)	x			int	The order in which the phase appears in the list of phases in the Phase Transitions tab.
fromPhase Transition List-->	n/a		x	x	WObjd Phase Transition		8 The list of all phase transitions in which this phase is the phase from which the transition begins. --> Links to the specific information for phase transitions in which this phase is the phase from which the transition takes place.
name	NAME (VARCHAR2) (250)	Phase Name (Phases tab in Object Definition)	x			string (250)	The name of the phase.
primaryKey	PRIMARY_KEY (NUMBER)		x			int	The unique ID of the phase.
toPhaseTransition List-->	n/a		x	x	WObjd Phase Transition		8 The list of all phase transitions in which this phase is the phase to which the transition goes. --> Links to the specific information for phase transitions in which this phase is the phase to which the transition goes.
uniqueCode	UNIQUE_CODE (VARCHAR2) (4)	Unique Code (Phases tab in Object Definition)	x			string (4)	The unique four- character alphanumeric code that is created when the phase is defined.
version	VERSION (NUMBER)		x			int	Indicates the number of times the phase has been updated.

WObjdPhaseTransition

WObjdPhaseTransition contains information about phase transitions, such as the name and the starting and ending phase. This table represents the Phase Transitions block on the Phase Transitions tab of custom object definitions.

Object: WObjdPhaseTransition (W_OBJD_PHASE_TRANSITION)

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
createdBy-->	CREATED_BY_ID (NUMBER)		x	x	YUser	object	8 The user who created the phase transition. --> Links to specific information about the user account.
createdOn	CREATED_ON (DATE)		x			date	The date the phase transition was defined.
leftProjectPhase-->	LEFT_PROJECT_ PHASE_ID (NUMBER)	From Phase (Phase Transitions tab)	x	x	WObjdPhaseType	object	8 The phase from which the phase transition begins. --> Links to specific information about the phase definition.
modifiedBy-->	MODIFIED_BY_ID (NUMBER)		x	x	YUser	object	8 The user who last modified the phase transition. --> Links to specific information about the user account.
modifiedOn	MODIFIED_ON (DATE)		x			date	The date the phase transition was last modified.
name	NAME (VARCHAR2) (250)	Name	x			string (250)	The name of the phase transition.
primaryKey	PRIMARY_KEY (NUMBER)		x			int	The unique ID of the phase transition.
rightProjectPhase-->	RIGHT_PROJECT_ PHASE _ID (NUMBER)	To Phase (Phase Transitions tab)	x	x	WObjdPhaseType	object	8 The phase at which the phase transition ends. --> Links to specific information about the phase definition.
version	VERSION (NUMBER)		x			int	Indicates the number of times the phase transition has been updated.