HR_CP_ADM_PATH(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.TARGETED_READY_DT ,A.READINESS ,A.BUSINESS_UNIT , %subrec(CAR_PTH_FED_SBR, A) FROM PS_CAREERPATH A WHERE A.EVALUATION_TYPE = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_CAREERPATH B WHERE B.EMPLID = A.EMPLID AND B.EVALUATION_TYPE = 'A' 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
Default Value: 1 |
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 | 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 | GVT_SELF_DEVELOP | Character(1) | VARCHAR2(1) NOT NULL |
Self-Development
Y/N Table Edit Default Value: N |
13 | GVT_ESTIMATED_COST | Number(10,2) | DECIMAL(9,2) NOT NULL | Estimated Cost |
14 | GVT_ACTUAL_COST | Number(10,2) | DECIMAL(9,2) NOT NULL | Actual Cost |
15 | GVT_ACT_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Activity Status
1=Requested 2=Approved 3=Disapproved 4=Deferred 5=In Progress 6=Completed |
16 | GVT_REQD_ACTVTY | Character(1) | VARCHAR2(1) NOT NULL |
Activity Required
Y/N Table Edit Default Value: N |
17 | NEED_IDENTIFIED_DT | Date(10) | DATE | Date Need Identified |
18 | 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 |