CAREER_RPT

(SQL View)
 Index Back

Career Plan Report View

Career Plan Report View

SELECT F.SETID , A.EMPLID , A.EFFDT , D.NAME , A.CAREER_MOVE , A.JOB_OPTION_NBR , ( SELECT C.DESCR FROM PS_DEPT_TBL C WHERE C.DEPTID = A.DEPTID AND C.SETID = E.SETID AND C.EFFDT = ( SELECT MAX(S.EFFDT) FROM PS_DEPT_TBL S WHERE S.SETID = E.SETID AND S.DEPTID = C.DEPTID AND S.EFFDT <= A.EFFDT ) ) , ( SELECT B.DESCR FROM PS_JOBCODE_TBL B WHERE B.JOBCODE = A.JOBCODE AND B.SETID = F.SETID AND B.EFFDT = ( SELECT MAX(T.EFFDT) FROM PS_JOBCODE_TBL T WHERE T.SETID = F.SETID AND T.JOBCODE = B.JOBCODE AND T.EFFDT <= A.EFFDT )) , A.READINESS , A.EVALUATION_TYPE FROM PS_CAREERPATH A , PS_PERSON_NAME D ,PS_SET_CNTRL_GROUP E ,PS_SET_CNTRL_GROUP F WHERE E.SETCNTRLVALUE = A.BUSINESS_UNIT AND E.REC_GROUP_ID = 'HR_01' AND F.SETCNTRLVALUE = A.BUSINESS_UNIT AND F.REC_GROUP_ID = 'HR_02' AND D.EMPLID=A.EMPLID

  • Related Language Record: CAREER_RPT_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SET_VLD_HR_02

    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 EFFDT Date(10) DATE Effective Date
    4 NAME Character(50) VARCHAR2(50) NOT NULL Name
    5 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
    6 JOB_OPTION_NBR Number(2,0) SMALLINT NOT NULL Option Number
    7 DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department Description
    8 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description
    9 READINESS Character(1) VARCHAR2(1) NOT NULL Readiness
    0=Ready Now
    1=1 - 2 Years
    2=3 - 5 Years
    E=Emergency
    R=Retirement
    10 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