SUPERVISOR_IDSUPERVIS_EMPL_RCDEMPLIDEMPL_RCDEFFDTDefault Value: %date
LANGUAGE_CDHR_TM_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 , L.LANGUAGE_CD , ( SELECT DEPTLNG.DESCR FROM PS_DEPT_TBL_LANG DEPTLNG WHERE DEPTLNG.DEPTID = B.DEPTID AND DEPTLNG.SETID = B.SETID_DEPT AND DEPTLNG.LANGUAGE_CD = L.LANGUAGE_CD AND %EffdtCheck(DEPT_TBL_LANG DEPTLNG1, DEPTLNG, %CurrentDateIn)), ( SELECT LOCLNG.DESCR FROM PS_LOCATION_LANG LOCLNG WHERE LOCLNG.LOCATION = B.LOCATION AND LOCLNG.SETID = B.SETID_LOCATION AND LOCLNG.LANGUAGE_CD = L.LANGUAGE_CD AND %EffdtCheck(LOCATION_LANG LOC1, LOCLNG, %CurrentDateIn)), ( SELECT JTBLLNG.DESCR FROM PS_JOBCODE_LANG JTBLLNG WHERE JTBLLNG.JOBCODE = B.JOBCODE AND JTBLLNG.SETID = B.SETID_JOBCODE AND JTBLLNG.LANGUAGE_CD = L.LANGUAGE_CD AND %EffdtCheck(JOBCODE_LANG JTBL1, JTBLLNG, %CurrentDateIn)), ( SELECT RATEL.DESCR FROM PS_REVW_RATING_LNG RATEL WHERE RATEL.RATING_MODEL = APPR.RATING_MODEL AND RATEL.REVIEW_RATING = APPR.REVIEW_RATING AND RATEL.LANGUAGE_CD = L.LANGUAGE_CD AND %EffdtCheck(REVW_RATING_LNG RATEL1, RATEL, %CurrentDateIn)), ( SELECT PL.NAME_DISPLAY FROM PS_PERSONAL_DTALNG PL WHERE PL.EMPLID = B.EMPLID AND PL.LANGUAGE_CD = L.LANGUAGE_CD) FROM PS_HR_TM_PG_DIR_VW A, PS_JOB B, PS_EP_APPR APPR, PSLANGUAGES L 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_EP_PG_RATING_VW B1 WHERE B1.EMPLID = APPR.EMPLID AND B1.EMPL_RCD = APPR.EMPL_RCD) AND (B.PER_ORG = 'EMP' OR B.PER_ORG = 'CWR') AND L.INSTALLED = 1 AND L.LANGUAGE_CD <> ( SELECT O.LANGUAGE_CD FROM PSOPTIONS O) |
| # | 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 |
| 11 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |