HR_CP_EE_PATH(SQL View) |
Index Back |
---|---|
EE Career Path ViewHR_CP_EE_PATH is a view of CAREERPATH which retrieves the career paths from the career path table for an employee based on evaluation type "S"elf. |
SELECT A.EMPLID , A.EFFDT ,A.EVALUATION_TYPE ,A.CAREER_MOVE ,A.PRE_MOVE_OPTION ,A.JOB_OPTION_NBR ,A.PRIVATE_PATH ,A.POSITION_NBR ,A.JOBCODE ,A.DEPTID ,A.TARGETED_READY_DT ,A.READINESS ,A.BUSINESS_UNIT , %subrec(CAR_PTH_FED_SBR, A) FROM PS_CAREERPATH A WHERE A.EVALUATION_TYPE = 'S' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_CAREERPATH B WHERE B.EMPLID = A.EMPLID AND B.EVALUATION_TYPE = 'S' 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 | 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 Default Value: S |
4 | 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 Default Value: HR_CP_ADM_PATH.CAREER_MOVE |
5 | PRE_MOVE_OPTION | Number(2,0) | SMALLINT NOT NULL |
Previous Move Option
Default Value: HR_CP_ADM_PATH.PRE_MOVE_OPTION |
6 | JOB_OPTION_NBR | Number(2,0) | SMALLINT NOT NULL |
Option Number
Default Value: 1 |
7 | PRIVATE_PATH | Character(1) | VARCHAR2(1) NOT NULL |
Private Path
N=N Y=Y Y/N Table Edit Default Value: Y |
8 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Prompt Table: HR_CP_POSN_VW |
9 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: HR_CPJOBCODE_VW |
10 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: HR_CP_DEPT_VW |
11 | TARGETED_READY_DT | Date(10) | DATE | Targeted Ready Date |
12 | READINESS | Character(1) | VARCHAR2(1) NOT NULL |
Readiness
0=Ready Now 1=1 - 2 Years 2=3 - 5 Years E=Emergency R=Retirement |
13 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: CPBUSUNITTBL_HR |
14 | GVT_SELF_DEVELOP | Character(1) | VARCHAR2(1) NOT NULL |
Self-Development
Y/N Table Edit Default Value: N |
15 | GVT_ESTIMATED_COST | Number(10,2) | DECIMAL(9,2) NOT NULL | Estimated Cost |
16 | GVT_ACTUAL_COST | Number(10,2) | DECIMAL(9,2) NOT NULL | Actual Cost |
17 | GVT_ACT_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Activity Status
1=Requested 2=Approved 3=Disapproved 4=Deferred 5=In Progress 6=Completed |
18 | GVT_REQD_ACTVTY | Character(1) | VARCHAR2(1) NOT NULL |
Activity Required
Y/N Table Edit Default Value: N |
19 | NEED_IDENTIFIED_DT | Date(10) | DATE | Date Need Identified |
20 | GVT_ACTVTY_REASON | Character(2) | VARCHAR2(2) NOT NULL |
Reason Activity Pursued
CM=Compliance DV=Development EN=Enrichment JR=Job Requirement LC=License Renewal MD=Management Discretion RQ=Requalification SE=Skill Enhancement |