HR_CP_EP_CNODE(SQL View) |
Index Back |
|---|---|
EE Current Career Path ViewHR_CP_ADM_PATH is a view of CAREERPATH which retrieves the career paths from the career path table for an employee based on evaluation type of "A"dministrators. |
| SELECT A.EMPLID ,A.EVALUATION_TYPE ,A.CAREER_MOVE ,A.PRE_MOVE_OPTION ,A.JOB_OPTION_NBR ,A.POSITION_NBR ,A.JOBCODE ,A.DEPTID ,A.BUSINESS_UNIT FROM PS_CAREERPATH A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_CAREERPATH B WHERE B.EMPLID = A.EMPLID AND B.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | 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 |
| 3 | 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 |
| 4 | PRE_MOVE_OPTION |
Number(2,0) | SMALLINT NOT NULL |
Previous Move Option
Default Value: 1 |
| 5 | JOB_OPTION_NBR |
Number(2,0) | SMALLINT NOT NULL | Option Number |
| 6 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Prompt Table: POSITION_DATA |
| 7 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: JOBCODE_TBL |
| 8 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 9 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_HR |