HR_CP_CARTRN_VW

(SQL View)
 Index Back

CP IDP Career Training Plan

Data used for Career Planning Individual Development Plan report.

SELECT EMPLID , EFFDT , TRN_PROGRAM , EST_COMPLETION_DT , COURSE_SEQUENCE , COURSE , COURSE_TITLE , INTERNAL_EXTERNAL , TRAINING_REASON , REQUIRED_CRSE , SCHOOL_CODE , SCHOOL , NEED_IDENTIFIED_DT , ACT_COMPLETION_DT , ' ' , ' ' , ' ' , ' ' , ' ' , 0 , ' ' , GVT_SELF_DEVELOP , GVT_ESTIMATED_COST , GVT_ACTUAL_COST , GVT_ACT_STATUS FROM PS_CAREER_TRAINING

  • Parent record: CAREERPLAN

    • # 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 TRN_PROGRAM Character(6) VARCHAR2(6) NOT NULL Training Program
    4 EST_COMPLETION_DT Date(10) DATE Estimated Completion Date
    5 COURSE_SEQUENCE Number(2,0) SMALLINT NOT NULL Course Sequence
    6 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code

    Prompt Table: COURSE_TBL

    7 COURSE_TITLE Character(30) VARCHAR2(30) NOT NULL Course Title
    8 INTERNAL_EXTERNAL Character(1) VARCHAR2(1) NOT NULL Internal/External
    E=External
    I=Internal
    9 TRAINING_REASON Character(2) VARCHAR2(2) NOT NULL Training Reason
    CM=Compliance
    DV=Development
    EN=Enrichment
    JR=Job Requirement
    LC=License Renewal
    MD=Management Discretion
    RQ=Requalification
    SE=Skill Enhancement
    10 REQUIRED_CRSE Character(1) VARCHAR2(1) NOT NULL Required

    Y/N Table Edit

    Default Value: N

    11 SCHOOL_CODE Character(10) VARCHAR2(10) NOT NULL School Code

    Prompt Table: SCHOOL_TBL_VW2

    12 SCHOOL Character(30) VARCHAR2(30) NOT NULL School Name
    13 NEED_IDENTIFIED_DT Date(10) DATE Date Need Identified

    Default Value: CAREERPLAN.EFFDT

    14 ACT_COMPLETION_DT Date(10) DATE Actual Completion Date
    15 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    16 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    17 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    18 DESCR3 Character(30) VARCHAR2(30) NOT NULL Descr 3
    19 DESCR4 Character(30) VARCHAR2(30) NOT NULL Descr 4
    20 DURATION_TIME Number(6,1) DECIMAL(5,1) NOT NULL Duration Time
    21 COST_UNIT_CD Character(10) VARCHAR2(10) NOT NULL Cost Unit
    22 GVT_SELF_DEVELOP Character(1) VARCHAR2(1) NOT NULL Self-Development

    Y/N Table Edit

    Default Value: N

    23 GVT_ESTIMATED_COST Number(10,2) DECIMAL(9,2) NOT NULL Estimated Cost
    24 GVT_ACTUAL_COST Number(10,2) DECIMAL(9,2) NOT NULL Actual Cost
    25 GVT_ACT_STATUS Character(2) VARCHAR2(2) NOT NULL Activity Status
    1=Requested
    2=Approved
    3=Disapproved
    4=Deferred
    5=In Progress
    6=Completed