SETIDPrompt Table: SET_VLD_HR_02
EMPLIDLANGUAGE_CDEFFDTDefault Value: %date
CAREER_RPT_LNG(SQL View) |
Index Back |
|---|---|
Career Plan Report ViewCareer Plan Report View |
| SELECT M.SETID , A.EMPLID , K.LANG_CD , A.EFFDT , ( SELECT C.DESCR FROM PS_DEPT_TBL_LANG C WHERE C.DEPTID = A.DEPTID AND C.SETID = M.SETID AND C.LANGUAGE_CD = K.LANG_CD AND C.EFFDT = ( SELECT MAX(S.EFFDT) FROM PS_DEPT_TBL_LANG S WHERE S.SETID = C.SETID AND S.DEPTID = C.DEPTID AND S.EFFDT <= A.EFFDT)) ,( SELECT B.DESCR FROM PS_JOBCODE_LANG B WHERE B.JOBCODE = A.JOBCODE AND B.SETID = N.SETID AND B.LANGUAGE_CD = K.LANG_CD AND B.EFFDT = ( SELECT MAX(T.EFFDT) FROM PS_JOBCODE_LANG T WHERE T.SETID = B.SETID AND T.JOBCODE = B.JOBCODE AND T.LANGUAGE_CD = B.LANGUAGE_CD AND T.EFFDT <= A.EFFDT)) FROM PS_CAREERPATH A, PS_LANGUAGE_CD_VW K, PS_SET_CNTRL_GROUP M, PS_SET_CNTRL_GROUP N WHERE K.EFFDT = ( SELECT K1.EFFDT FROM PS_LANGUAGE_CD_VW K1 WHERE K.LANG_CD = K1.LANG_CD AND K1.EFFDT <= %CurrentDateIn) AND K.EFF_STATUS = 'A' AND M.REC_GROUP_ID = 'HR_01' AND M.SETCNTRLVALUE = A.BUSINESS_UNIT AND N.REC_GROUP_ID = 'HR_02' AND N.SETCNTRLVALUE = A.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SET_VLD_HR_02 |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | DEPT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Department Description |
| 6 | JOBCODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Code Description |