CAREER_RPT

(SQL View)
 Index Back

Career Plan Report View

Career Plan Report View

SELECT B.SETID , A.EMPLID , A.EFFDT , D.NAME , A.CAREER_MOVE , A.JOB_OPTION_NBR , C.DESCR , B.DESCR , A.READINESS , A.EVALUATION_TYPE FROM PS_CAREERPATH A , PS_JOBCODE_TBL B , PS_DEPT_TBL C , PS_PERSON_NAME D WHERE B.JOBCODE = A.JOBCODE AND C.DEPTID = A.DEPTID AND D.EMPLID = A.EMPLID AND ( B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JOBCODE_TBL WHERE B.JOBCODE = JOBCODE AND EFFDT <= A.EFFDT AND SETID = B.SETID) AND C.EFFDT = ( SELECT MAX(EFFDT) FROM PS_DEPT_TBL WHERE C.DEPTID = DEPTID AND EFFDT <= A.EFFDT AND SETID = C.SETID) )

  • 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
    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=First Move from Current Job
    2=Second Move from Current Job
    3=Third Move from Current Job
    4=Fourth Move from Current Job
    5=Fifth Move from Current Job
    6=Sixth Move from Current Job
    7=Seventh Move from Current Job
    8=Eighth Move from Current Job
    9=Ninth Move from Current Job
    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 Timeframe
    0=Ready Now
    1=Ready in 1 to 2 Years
    2=Ready in 3 to 5 Years
    E=Ready in an Emergency
    R=Retire in Current Position
    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