PJF_PROJECT_STATUS_TYPES_B

Status types (also known as status objects) are references to project-related objects, such as project, progress or milestone, which have statuses centrally defined and managed. Properties for each status type control functionality available to associated system statuses and statuses.

Details

• Schema: FUSION

• Object owner: PJF

• Object type: TABLE

• Tablespace: REFERENCE

Primary Key

Name	Columns
PJF_PROJECT_STATUS_TYPES_B_PK	STATUS_TYPE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
STATUS_TYPE	VARCHAR2	30		Yes	The status object short code for which system statuses and statuses are defined, such as PROJECT, PROGRESS, MILESTONE.
INITIAL_STATUS_FLAG	VARCHAR2	1		Yes	Indicates whether the status type supports the Initial Status property for associated statuses. Valid values: Y, N
WORKFLOW_FLAG	VARCHAR2	1		Yes	Indicates whether the status type supports workflow approval for status transitions. If enabled, the Enable Workflow, Status After Change Accepted, and Status After Change Rejected properties of associated statuses are applicable. Valid values: Y, N
STATUS_CONTROLS_FLAG	VARCHAR2	1		Yes	Indicates whether the status type supports Action Controls to be defined for associated statuses. Valid values: Y, N
NEXT_ALLOWABLE_STATUSES_FLAG	VARCHAR2	1		Yes	Indicates whether the statuses associated with the status type exist within a lifecycle, where transitions between specific statuses may need to be controlled. If enabled, next allowable statuses can optionally be defined for each status. If disabled, an object is either expected to be able to transition from or to any status (such as RAG statuses), or status transitions are expected to be implicit only (such as being set procedurally). Valid values: Y, N
NEXT_ALLOW_STATUS_TYPE_FLAG	VARCHAR2	1		Yes	Indicates whether the Next Allowable Status Type property on associated statuses is updatable. When disabled, the Next Allowable Status Flag for associated statuses has a fixed value of 'U' (Status Name). Valid values: Y, N
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
SEED_DATA_SOURCE	VARCHAR2	512			Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
ORA_SEED_SET1	VARCHAR2	1		Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2	VARCHAR2	1		Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
PJF_PROJECT_STATUS_TYPES_B_U1	Unique	PJF_PROJECT_STATUS_TYPES_B_U1	STATUS_TYPE, ORA_SEED_SET1
PJF_PROJECT_STATUS_TYPES_B_U11	Unique	PJF_PROJECT_STATUS_TYPES_B_U2	STATUS_TYPE, ORA_SEED_SET2