SUPERVISOR_IDSUPERVIS_EMPL_RCDEMPLIDEMPL_RCDEFFDTDefault Value: %date
LANGUAGE_CDHR_GSS_PG_LVW(SQL View) |
Index Back |
|---|---|
Scatter Plot Pivot Lang ViewScatter Plot Pivot Base Lang View |
| SELECT A.SUPERVISOR_ID , A.SUPERVIS_EMPL_RCD , A.EMPLID , A.EMPL_RCD , B.EFFDT , RATEL.LANGUAGE_CD , %Coalesce((SELECT DEPTLNG.DESCR FROM PS_DEPT_TBL_LANG DEPTLNG WHERE DEPTLNG.DEPTID= B.DEPTID AND DEPTLNG.SETID= B.SETID_DEPT AND DEPTLNG.LANGUAGE_CD=RATEL.LANGUAGE_CD AND DEPTLNG.EFFDT=( SELECT MAX(DEPT1.EFFDT) FROM PS_DEPT_TBL_LANG DEPT1 WHERE DEPT1.DEPTID=DEPTLNG.DEPTID AND DEPT1.EFFDT<=%CurrentDateIn AND DEPT1.LANGUAGE_CD=DEPTLNG.LANGUAGE_CD AND DEPT1.SETID=DEPTLNG.SETID)),'') , %Coalesce((SELECT LOCLNG.DESCR FROM PS_LOCATION_LANG LOCLNG WHERE LOCLNG.LOCATION=B.LOCATION AND LOCLNG.SETID=B.SETID_LOCATION AND RATEL.LANGUAGE_CD =LOCLNG.LANGUAGE_CD AND LOCLNG.EFFDT=( SELECT MAX(LOC1.EFFDT) FROM PS_LOCATION_LANG LOC1 WHERE LOC1.LOCATION=LOCLNG.LOCATION AND LOC1.EFFDT<=%CurrentDateIn AND LOC1.LANGUAGE_CD =LOCLNG.LANGUAGE_CD AND LOC1.SETID=LOCLNG.SETID)),'') , %Coalesce((SELECT JTBLLNG.DESCR FROM PS_JOBCODE_LANG JTBLLNG WHERE JTBLLNG.JOBCODE=B.JOBCODE AND JTBLLNG.SETID=B.SETID_JOBCODE AND RATEL.LANGUAGE_CD =JTBLLNG.LANGUAGE_CD AND JTBLLNG.EFFDT=( SELECT MAX(JTBL1.EFFDT) FROM PS_JOBCODE_LANG JTBL1 WHERE JTBL1.JOBCODE=JTBLLNG.JOBCODE AND JTBL1.EFFDT<=%CurrentDateIn AND JTBL1.LANGUAGE_CD =JTBLLNG.LANGUAGE_CD AND JTBL1.SETID=JTBLLNG.SETID)),'') , RATEL.DESCR FROM PS_HR_GSS_PG_DIR_V A , PS_JOB B , PS_EP_APPR APPR , PS_REVW_RATING_LNG RATEL WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.JOB_EFFDT = B.EFFDT AND B.EFFSEQ = ( SELECT MAX(JB2.EFFSEQ) FROM PS_JOB JB2 WHERE JB2.EMPLID = B.EMPLID AND JB2.EFFDT = B.EFFDT AND JB2.EMPL_RCD = B.EMPL_RCD) AND B.EMPLID = APPR.EMPLID AND B.EMPL_RCD = APPR.EMPL_RCD AND APPR.EP_APPRAISAL_ID = ( SELECT MAX(B1.EP_APPRAISAL_ID) FROM PS_HR_GSS_PG_EP_VW B1 WHERE B1.EMPLID = APPR.EMPLID AND B1.EMPL_RCD = APPR.EMPL_RCD) AND RATEL.RATING_MODEL = APPR.RATING_MODEL AND RATEL.REVIEW_RATING = APPR.REVIEW_RATING AND RATEL.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_REVW_RATING_LNG D WHERE D.RATING_MODEL = RATEL.RATING_MODEL AND D.REVIEW_RATING = RATEL.REVIEW_RATING AND D.LANGUAGE_CD = RATEL.LANGUAGE_CD AND D.EFFDT <= %CurrentDateIn) AND (B.PER_ORG = 'EMP' OR B.PER_ORG = 'CWR') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SUPERVISOR_ID |
Character(11) | VARCHAR2(11) NOT NULL | Supervisor ID |
| 2 | SUPERVIS_EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Supervisor employee record. |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 8 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 9 | DESCR3 | Character(30) | VARCHAR2(30) NOT NULL | Descr 3 |
| 10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |