PJR_RESOURCE_REQUEST_DETAILS

The PJR_RESOURCE_REQUEST_DETAILS table contains resource requirement details that associate a resource request with qualifications and keywords.

Details

• Schema: FUSION

• Object owner: PJR

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
PJR_RESOURCE_REQUEST_DETA_PK	RESOURCE_REQUEST_DETAIL_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ENTERPRISE_ID	NUMBER		18	Yes	Enterprise identifier that uniquely identifies a tenant in a multi-tenant environment.
RESOURCE_REQUEST_DETAIL_ID	NUMBER		18	Yes	Automatically-generated unique identifier for a detail, such as a qualification, on a project resource request.
RESOURCE_REQUEST_ID	NUMBER		18	Yes	Unique identifier for a project resource request.
CONTENT_ITEM_ID	NUMBER		18		Unique identifier of a qualification on the project resource request. Oracle Fusion Project Resource Management supports the use of qualifications only from a subset of predefined qualification content types in Oracle Fusion Profile Management.
SECTION_ID	NUMBER		18		Section ID of the content section the qualification content item is associated with. Foreign Key to HRT_PROFILE_TYP_SECTIONS
KEYWORD	VARCHAR2	240			Keyword requirement for the project resource request. A requirement is a keyword when it is entered as text in the project resource request instead of selected from the list of qualifications from Oracle Fusion Profile Management.
RATING_LEVEL_ID	NUMBER		18		Unique identifier of the proficiency rating level for a competency. The rating levels for the competency content type are defined in Oracle Fusion Profile Management.
READING_RATING_LEVEL_ID	NUMBER		18		Unique identifier of the reading proficiency rating level for a language The rating levels for the language content type are defined in Oracle Fusion Profile Management.
WRITING_RATING_LEVEL_ID	NUMBER		18		Unique identifier of the writing proficiency rating level for a language. The rating levels for the language content type are defined in Oracle Fusion Profile Management.
SPEAKING_RATING_LEVEL_ID	NUMBER		18		Unique identifier of the speaking proficiency rating level for a language. The rating levels for the language content type are defined in Oracle Fusion Profile Management.
MANDATORY_FLAG	VARCHAR2	1			Indicates if the qualification is mandatory for Search and Evaluate that will result in filtering out those resources who don't have this qualification.The 'Y' value of flag indicates that qualification is mandatory and 'N' or Null value indicates that it is optional.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
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.
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
PJR_RESOURCE_REQUEST_DETAILS	pjr_resource_requests	RESOURCE_REQUEST_ID

Indexes

Index	Uniqueness	Tablespace	Columns
PJR_REQUEST_DETAILS_N1	Non Unique	Default	RESOURCE_REQUEST_ID
PJR_REQUEST_DETAILS_U1	Unique	FUSION_TS_TX_IDX	RESOURCE_REQUEST_DETAIL_ID