HCTS_CP_ADM_PTH(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 DISTINCT A.EMPLID ,A.EVALUATION_TYPE ,A.CAREER_MOVE ,A.PRE_MOVE_OPTION ,A.JOB_OPTION_NBR ,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 = 'A' 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 | 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 | 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 |
4 | PRE_MOVE_OPTION | Number(2,0) | SMALLINT NOT NULL |
Previous Move Option
Default Value: 1 |
5 | HCTS_JOB_OPT_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 | HCTS_JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
8 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
9 | TARGETED_READY_DT | Date(10) | DATE | Targeted Ready Date |
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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_HR |
12 | 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 |
13 | HCTS_JOB_OPT_NBR2 | Number(2,0) | SMALLINT NOT NULL | Option Number |
14 | HCTS_JOBCODE2 | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
15 | 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 |
16 | HCTS_JOB_OPT_NBR3 | Number(2,0) | SMALLINT NOT NULL | Option Number |
17 | HCTS_JOBCODE3 | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
18 | GVT_SELF_DEVELOP | Character(1) | VARCHAR2(1) NOT NULL |
Self-Development
Y/N Table Edit Default Value: N |
19 | GVT_ESTIMATED_COST | Number(10,2) | DECIMAL(9,2) NOT NULL | Estimated Cost |
20 | GVT_ACTUAL_COST | Number(10,2) | DECIMAL(9,2) NOT NULL | Actual Cost |
21 | GVT_ACT_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Activity Status
1=Requested 2=Approved 3=Disapproved 4=Deferred 5=In Progress 6=Completed |
22 | GVT_REQD_ACTVTY | Character(1) | VARCHAR2(1) NOT NULL |
Activity Required
Y/N Table Edit Default Value: N |
23 | NEED_IDENTIFIED_DT | Date(10) | DATE | Date Need Identified |
24 | 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 |