PJR_PROJ_ROLE_QUALIFICATIONS
The PJR_PROJ_ROLE_QUALIFICATIONS table contains default qualifications and keywords for project roles.
Details
-
Schema: FUSION
-
Object owner: PJR
-
Object type: TABLE
-
Tablespace: FUSION_TS_SEED
Primary Key
| Name | Columns |
|---|---|
|
PJR_PROJ_ROLE_TYPES_QUAL_PK |
PROJECT_ROLE_QUALIFICATION_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. | |
| PROJECT_ROLE_QUALIFICATION_ID | NUMBER | 18 | Yes | Automatically-generated unique identifier of a qualification for a project role. | |
| PROJECT_ROLE_ID | NUMBER | 18 | Yes | Unique identifier of a project role the qualification is associated with. | |
| CONTENT_ITEM_ID | NUMBER | 18 | Unique identifier of a predefined qualification for a project role. 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 content item is associated with. Foreign Key to HRT_PROFILE_TYP_SECTIONS. | ||
| KEYWORD | VARCHAR2 | 240 | Keyword qualification for the project role. A qualification is a keyword when it is entered as text for the project role instead of selected from the list of predefined 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_PROJ_ROLE_QUALIFICATIONS | pjf_proj_role_types_b | PROJECT_ROLE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJR_PROJ_ROLE_TYPES_QUAL_U1 | Unique | FUSION_TS_SEED | PROJECT_ROLE_QUALIFICATION_ID |