COMPETENCYELEMENT_CDPrompt Table: CM_ELEMENT_TBL
COMPETENCY_ELEM(SQL View) |
Index Back |
|---|---|
Competency Element TableThis table allows a competency element to be attached to a competency or multiple competencies. Release 9 Job Profile Managment (JPM): Table became a view to JPM data. Ownership of table transferred from HR Core Objects to JPM. |
| SELECT %Substring(JPM_CAT_ITEM_ID,1,8) ,%Substring(JPM_CAT_ITEM_ID2,1,10) FROM PS_JPM_CAT_I_RLAT WHERE JPM_CAT_TYPE IN ('COMPETENCY','NVQ UNIT') AND JPM_CAT_TYPE2 IN ('ELEMENT','NVQ ELEMENT') AND JPM_CAT_RLAT_CD = 'P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL | Competency |
| 2 | ELEMENT_CD |
Character(10) | VARCHAR2(10) NOT NULL |
Element code
Prompt Table: CM_ELEMENT_TBL |