HR_CP_PATH_VW(SQL View) |
Index Back |
|---|---|
sp/cp viewview joining career plan and career path |
| SELECT B.EMPLID , B.EFFDT , CP1.READINESS , NEXT_CAREERPLAN_DT , EVALUATION_TYPE , CAREER_MOVE FROM PS_CAREERPLAN B LEFT OUTER JOIN PS_CAREERPATH CP1 ON B.EMPLID = CP1.EMPLID AND B.EFFDT = CP1.EFFDT WHERE CP1.CAREER_MOVE = '1' AND CP1.PRE_MOVE_OPTION = 1 AND CP1.EVALUATION_TYPE = 'A' AND CP1.JOB_OPTION_NBR = ( SELECT MAX(CP2.JOB_OPTION_NBR) FROM PS_CAREERPATH CP2 WHERE CP1.EMPLID = CP2.EMPLID AND CP1.EFFDT = CP2.EFFDT AND CP2.CAREER_MOVE = '1' AND CP2.PRE_MOVE_OPTION = 1 AND CP2.EVALUATION_TYPE = 'A') AND %EffdtCheck(CAREERPLAN, B, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | READINESS | Character(1) | VARCHAR2(1) NOT NULL |
Readiness
0=Ready Now 1=1 - 2 Years 2=3 - 5 Years E=Emergency R=Retirement |
| 4 | NEXT_CAREERPLAN_DT | Date(10) | DATE | Career Plan Review Date |
| 5 | EVALUATION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Evaluation Type
A=Approved/Official B=Subordinate C=Customer E=Executive Committee L=Learning M=Mentor P=Peer R=Supervisor/Manager S=Self |
| 6 | CAREER_MOVE | Character(1) | VARCHAR2(1) NOT NULL |
Career Move
1=1st Move 2=2nd Move 3=3rd Move 4=4th Move 5=5th Move 6=6th Move 7=7th Move 8=8th Move 9=9th Move |