HR_CP_CARPTH_VW

(SQL View)
 Index Back

CP IDP Career Path

Data used for Career Planning Individual Development Plan report.

SELECT EMPLID ,EFFDT , EVALUATION_TYPE , CAREER_MOVE , PRE_MOVE_OPTION , JOB_OPTION_NBR , ' ' , PRIVATE_PATH , POSITION_NBR , JOBCODE , DEPTID , ' ' , TARGETED_READY_DT , READINESS , BUSINESS_UNIT , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , GVT_SELF_DEVELOP , GVT_ESTIMATED_COST , GVT_ACTUAL_COST , GVT_ACT_STATUS , GVT_REQD_ACTVTY , NEED_IDENTIFIED_DT , GVT_ACTVTY_REASON FROM PS_CAREERPATH

  • Parent record: CAREERPATH_EVAL

    • # 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 NOT NULL 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
    4 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: 1

    6 JOB_OPTION_NBR Number(2,0) SMALLINT NOT NULL Option Number
    7 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
    8 PRIVATE_PATH Character(1) VARCHAR2(1) NOT NULL Private Path
    N=N
    Y=Y

    Default Value: Y

    9 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

    10 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    11 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    12 DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department Description
    13 TARGETED_READY_DT Date(10) DATE Targeted Ready Date
    14 READINESS Character(1) VARCHAR2(1) NOT NULL Readiness
    0=Ready Now
    1=1 - 2 Years
    2=3 - 5 Years
    E=Emergency
    R=Retirement
    15 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR

    16 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
    17 GVT_OCC_SERIES Character(4) VARCHAR2(4) NOT NULL Occupational Series
    18 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
    19 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    20 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    21 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    22 GVT_PAY_BASIS Character(2) VARCHAR2(2) NOT NULL Pay Basis
    BW=Bi-weekly
    FB=Fee Basis
    PA=Per Annum
    PD=Per Diem
    PH=Per Hour
    PM=Per Month
    PW=Piece Work
    SM=Semi-monthly
    SY=School Year
    WC=Without Compensation
    23 GVT_OCC_SERIES_LOW Character(4) VARCHAR2(4) NOT NULL Occ Series Lower Bound
    24 GRADE_BASIS_CHOICE Character(3) VARCHAR2(3) NOT NULL Grading Basis Choice
    AUD=Audited
    GRD=Graded
    NOG=No Grade Associated
    SUO=S/U Exclusive
    SUS=Satisfactory/Unsatisfactory
    25 DESCR3 Character(30) VARCHAR2(30) NOT NULL Descr 3
    26 DESCRSHORT1 Character(10) VARCHAR2(10) NOT NULL Descr Short One
    27 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    28 GVT_SELF_DEVELOP Character(1) VARCHAR2(1) NOT NULL Self-Development

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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