EMPLIDPrompt Table: PERSONAL_DATA
COMPETENCYPrompt Table: COMPETENCY_TBL
LANGUAGE_CDRS_WRKR_COMP_VL(SQL View) |
Index Back |
|---|
| SELECT C.EMPLID , C.COMPETENCY , L.LANGUAGE_CD , L.DESCR , L.DESCRLONG FROM %Table(COMPETENCIES) C , %Table(RS_EVALUATIONS) E , %Table(COMPETENCY_TBL) A , %Table(INSTALLATION_RS) I , %Table(COMPETENCY_LANG) L WHERE C.EFFDT = ( SELECT MAX(C2.EFFDT) FROM %Table(COMPETENCIES) C2 , %Table(RS_EVALUATIONS) E2 , %Table(INSTALLATION_RS) I2 WHERE E2.EMPLID = E.EMPLID AND E2.EVALUATION_TYPE = I2.EVALUATION_TYPE AND E2.REVIEW_STATUS = 'Y' AND C2.EMPLID = E2.EMPLID AND C2.EVALUATION_ID = E2.EVALUATION_ID AND C2.COMPETENCY = C.COMPETENCY AND C2.EFFDT <= %CurrentDateIn) AND E.EMPLID = C.EMPLID AND E.EVALUATION_ID = C.EVALUATION_ID AND E.EVALUATION_TYPE = I.EVALUATION_TYPE AND E.REVIEW_STATUS = 'Y' AND A.COMPETENCY = C.COMPETENCY AND L.COMPETENCY = A.COMPETENCY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 2 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL |
Competency
Prompt Table: COMPETENCY_TBL |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRLONG | Long Character | CLOB | Long Description |