EMPLIDEVALUATION_IDCOMPETENCYEFFDTDefault Value: %date
ELEMENT_CDLANGUAGE_CDCM_ELEM_DTL_LNG(SQL View) |
Index Back |
|---|---|
Language table for Element TblThis is the related language table of CM_ELEMENT_TBL. |
| SELECT B.EMPLID ,A.EVALUATION_ID ,%Substring(C.JPM_CAT_ITEM_ID,1,8) ,A.EFFDT ,%Substring(A.JPM_CAT_ITEM_ID,1,10) ,D.LANGUAGE_CD ,A.JPM_TEXT254_5 FROM PS_JPM_JP_ITEMS A , PS_JPM_PROFILE B , PS_JPM_JP_ITEMS C ,PSOPRDEFN D WHERE A.JPM_PROFILE_ID = B.JPM_PROFILE_ID AND A.JPM_PROFILE_ID = C.JPM_PROFILE_ID AND A.JPM_PARENT_KEY_ID = C.JPM_ITEM_KEY_ID AND B.JPM_JP_TYPE = 'PERSON' AND A.JPM_CAT_TYPE IN ('ELEMENT','NVQ ELEMENT') AND C.JPM_CAT_TYPE IN ('COMPETENCY','NVQ UNIT') AND A.JPM_ITEM_KEY_ID = ( SELECT MAX(X.JPM_ITEM_KEY_ID) FROM PS_JPM_JP_ITEMS X WHERE A.JPM_PROFILE_ID = X.JPM_PROFILE_ID AND A.JPM_CAT_TYPE = X.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID = X.JPM_CAT_ITEM_ID AND A.EFFDT = X.EFFDT AND A.EVALUATION_ID = X.EVALUATION_ID ) AND D.OPRID = %OperatorId |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EVALUATION_ID |
Character(2) | VARCHAR2(2) NOT NULL | Evaluation ID |
| 3 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL | Competency |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | ELEMENT_CD |
Character(10) | VARCHAR2(10) NOT NULL | Element code |
| 6 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | DESCRLONG | Long Character | CLOB | Long Description |