PJF_RBS_PRJ_ASSIGNMENTS

This table stores information about resource breakdown structures (RBS) and the projects with which they are associated. It stores the usages, such as workplan, financial plan, reporting, for an RBS on a project.

Details

• Schema: FUSION

• Object owner: PJF

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
PJF_RBS_PRJ_ASSIGN_PK	RBS_PRJ_ASSIGNMENT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RBS_PRJ_ASSIGNMENT_ID	NUMBER		18	Yes	Unique identifier of the RBS association.
PROJECT_ID	NUMBER		18	Yes	Identifier of the Project to which the RBS is associated.
RBS_VERSION_ID	NUMBER		18	Yes	Identifier of the RBS version to which the project is associated.
RBS_HEADER_ID	NUMBER		18	Yes	Identifier of the RBS to which the project is associated.
REPORTING_USAGE_FLAG	VARCHAR2	1		Yes	Flag to indicate whether the RBS is used for reporting always Y.
PLANNING_USAGE_FLAG	VARCHAR2	1		Yes	Flag to indicate whether the RBS is used for financial or project planning. *****
PRIMARY_PLANNING_RBS_FLAG	VARCHAR2	1		Yes	Flag indicating whether the RBS is the default RBS to be used in financial and project planning. *****
PRIMARY_REPORTING_RBS_FLAG	VARCHAR2	1		Yes	Flag indicating whether the RBS is the default RBS to be displayed on reporting pages.
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.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated 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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
PJF_RBS_PRJ_ASSIGNMENTS	pjf_projects_all_b	PROJECT_ID
PJF_RBS_PRJ_ASSIGNMENTS	pjf_rbs_versions_b	RBS_VERSION_ID
PJF_RBS_PRJ_ASSIGNMENTS	pjf_rbs_headers_b	RBS_HEADER_ID

Indexes

Index	Uniqueness	Tablespace	Columns
PJF_RBS_PRJ_ASSIGNMENTS_N1	Non Unique	Default	PROJECT_ID
PJF_RBS_PRJ_ASSIGNMENTS_N2	Non Unique	Default	RBS_VERSION_ID
PJF_RBS_PRJ_ASSIGNMENTS_U1	Unique	Default	RBS_PRJ_ASSIGNMENT_ID