HCTS_CP_EE_PTH

(SQL View)
 Index Back

EE Career Path View

HR_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 DISTINCT 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 ,B.CAREER_MOVE ,B.JOB_OPTION_NBR ,B.JOBCODE ,C.CAREER_MOVE ,C.JOB_OPTION_NBR ,C.JOBCODE , %subrec(CAR_PTH_FED_SBR, A) FROM PS_CAREERPATH A LEFT OUTER JOIN PS_CAREERPATH B ON B.EMPLID = A.EMPLID AND B.EVALUATION_TYPE = A.EVALUATION_TYPE AND B.CAREER_MOVE = 2 AND B.PRE_MOVE_OPTION = A.JOB_OPTION_NBR LEFT OUTER JOIN PS_CAREERPATH C ON C.EMPLID = A.EMPLID AND C.EVALUATION_TYPE = A.EVALUATION_TYPE AND C.CAREER_MOVE = 3 AND C.PRE_MOVE_OPTION = B.JOB_OPTION_NBR AND C.PRE_MOVE_OPTION = A.JOB_OPTION_NBR WHERE A.EVALUATION_TYPE = 'S' AND A.CAREER_MOVE = 1 AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_CAREERPATH A1 WHERE A1.EMPLID = A. EMPLID AND A1.EVALUATION_TYPE = A.EVALUATION_TYPE AND A1.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 HCTS_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
5 PRE_MOVE_OPTION Number(2,0) SMALLINT NOT NULL Previous Move Option

Default Value: HR_CP_ADM_PATH.PRE_MOVE_OPTION

6 HCTS_JOB_OPT_NBR Number(2,0) SMALLINT NOT NULL Option Number
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 HCTS_JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
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 HCTS_CAREER_MOVE2 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
15 HCTS_JOB_OPT_NBR2 Number(2,0) SMALLINT NOT NULL Option Number
16 HCTS_JOBCODE2 Character(6) VARCHAR2(6) NOT NULL Job Code
17 HCTS_CAREER_MOVE3 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
18 HCTS_JOB_OPT_NBR3 Number(2,0) SMALLINT NOT NULL Option Number
19 HCTS_JOBCODE3 Character(6) VARCHAR2(6) NOT NULL Job Code
20 GVT_SELF_DEVELOP Character(1) VARCHAR2(1) NOT NULL Self-Development

Y/N Table Edit

Default Value: N

21 GVT_ESTIMATED_COST Number(10,2) DECIMAL(9,2) NOT NULL Estimated Cost
22 GVT_ACTUAL_COST Number(10,2) DECIMAL(9,2) NOT NULL Actual Cost
23 GVT_ACT_STATUS Character(2) VARCHAR2(2) NOT NULL Activity Status
1=Requested
2=Approved
3=Disapproved
4=Deferred
5=In Progress
6=Completed
24 GVT_REQD_ACTVTY Character(1) VARCHAR2(1) NOT NULL Activity Required

Y/N Table Edit

Default Value: N

25 NEED_IDENTIFIED_DT Date(10) DATE Date Need Identified
26 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