PJR_SEARCH_QUAL_CACHE
The PJR_QUALIFICATIONS_CACHE table contains resource competency and language qualification data that the application uses to filter qualifications when you narrow resource search results based on qualifications. This table is populated by the Maintain Project Resource Search Index job set.
Details
-
Schema: FUSION
-
Object owner: PJR
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJR_SEARCH_QUAL_CACHE_PK |
RESOURCE_ID, CONTENT_TYPE_ID, CONTENT_ITEM_ID, SECTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RESOURCE_ID | NUMBER | 18 | Yes | Identifier of the resource. | |
| CONTENT_TYPE_ID | NUMBER | 18 | Yes | Content type identifier of a qualification content item. Value is 104 for a competency content type or 109 for a language content type. | |
| CONTENT_ITEM_ID | NUMBER | 18 | Yes | Content item identifier of a qualification that is either a competency with a content type value of 104, or a language with a content type value of 109. | |
| SECTION_ID | NUMBER | 18 | Yes | Section ID of the content section the qualification content item is associated with. Foreign Key to HRT_PROFILE_TYP_SECTIONS | |
| PERSON_ID | NUMBER | 18 | Identifier of the HCM person who is associated with the resource. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJR_SEARCH_QUAL_CACHE_N1 | Non Unique | FUSION_TS_TX_IDX | RESOURCE_ID, CONTENT_ITEM_ID, SECTION_ID |
| PJR_SEARCH_QUAL_CACHE_N2 | Non Unique | Default | CONTENT_TYPE_ID |
| PJR_SEARCH_QUAL_CACHE_U1 | Unique | FUSION_TS_TX_IDX | RESOURCE_ID, CONTENT_TYPE_ID, CONTENT_ITEM_ID, SECTION_ID |