EP_CP_EEPATH_V(SQL View) |
Index Back |
|---|---|
Personal Career Pathview used on ePerf documents in the Career Plan Summary section |
| SELECT A.EMPLID , A.EFFDT , A.EVALUATION_TYPE , A.POSITION_NBR , A.CAREER_MOVE , A.JOBCODE , A.BUSINESS_UNIT , ' ' , ' ' , A.READINESS , A.TARGETED_READY_DT , A.JOB_OPTION_NBR , ' ' FROM PS_CAREERPATH A WHERE A.EVALUATION_TYPE = 'S' AND A.PRIVATE_PATH = 'N' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_CAREERPATH B WHERE B.EMPLID = A.EMPLID AND B.EVALUATION_TYPE = 'S' AND B.PRIVATE_PATH = 'N' AND B.EFFDT <= %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 | 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 |
| 4 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 5 | 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 |
| 6 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | GRADE | Character(3) | VARCHAR2(3) NOT NULL | Salary Grade |
| 9 | SAL_ADMIN_PLAN | Character(4) | VARCHAR2(4) NOT NULL | Salary Administration Plan |
| 10 | READINESS | Character(1) | VARCHAR2(1) NOT NULL |
Readiness
0=Ready Now 1=1 - 2 Years 2=3 - 5 Years E=Emergency R=Retirement |
| 11 | TARGETED_READY_DT | Date(10) | DATE | Targeted Ready Date |
| 12 | JOB_OPTION_NBR | Number(2,0) | SMALLINT NOT NULL | Option Number |
| 13 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |