PERSON_IDPrompt Table: RD_PERSON
COMPETENCYPrompt Table: COMPETENCY_TBL
LANGUAGE_CDRF_WRKRCMP_SLVW(SQL View) |
Index Back |
|---|---|
Worker Competencies Search RLRelated Language record for RF_WRKRCMP_S_VW. |
| SELECT A.PERSON_ID , A.COMPETENCY , B.LANGUAGE_CD , A.DESCR FROM PS_RF_WRKRCMP_S_VW A , PS_COMPETENCY_LANG B WHERE A.COMPETENCY = B.COMPETENCY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Prompt Table: RD_PERSON |
| 2 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL |
Competency - this field is brought over from HRMS
Prompt Table: COMPETENCY_TBL |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |