ACCOMP_VW

(SQL View)
 Index Back

Accomplishments View

Accomplishments View - Used as edit prompt.

SELECT A.ACCOMPLISHMENT ,A.DESCR ,A.DESCRSHORT ,A.ACCOMP_CATEGORY ,A.HP_STATS_DEG_LVL , %subrec(LIC_CERTIF_SBR,A) , %subrec(DEGREE_SBR,A) , %subrec(NVQ_ACCOMP_SBR,A) , %subrec(DEGREE_FP_SBR,A) FROM PS_ACCOMP_TBL A

  • Related Language Record: ACCOMPVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: ACCOMP_TBL.DESCR

    4 ACCOMP_CATEGORY Character(3) VARCHAR2(3) NOT NULL Accomplishment Category
    DEG=Degree
    HON=Honor or Award
    LIC=License or Certification
    LNG=Language
    MEM=Membership
    NVQ=NVQ
    TST=Test
    5 HP_STATS_DEG_LVL Character(2) VARCHAR2(2) NOT NULL Stats-Can Degree Level
    01=Doctoral
    02=Professional Para-Medical
    03=Masters & Equivalent License
    04=Graduate Program
    05=Bachelor
    06=Professional Designation
    07=Undergraduate Diploma
    08=No Degree/Diploma/Prof.Desgnt
    09=Unknown
    6 RENEWAL_REQUIRED Character(1) VARCHAR2(1) NOT NULL Renewal Required
    N=No
    Y=Yes

    Default Value: N

    7 RENEWAL_PERIOD Character(1) VARCHAR2(1) NOT NULL Renewal Period
    D=Days
    M=Months
    W=Weeks
    Y=Years
    8 RENEWAL_LENGTH Number(3,0) SMALLINT NOT NULL Renewal Length
    9 YEARS_OF_EDUCATN Number(2,0) SMALLINT NOT NULL Years Of Education
    10 EDUCATION_LVL Character(2) VARCHAR2(2) NOT NULL Education Level
    01=No Formal Education
    02=Elementary School Completed
    03=Some High School
    04=High School Graduate
    05=Terminal Occupation Prog DNC
    06=Terminal Occupation Program
    07=Some College - Less than 1 Yr
    08=One Year College
    09=Two Years College
    10=Associate Degree
    11=Three Years College
    12=Four Years College
    13=Bachelor Degree
    14=Post Bachelors
    15=First Professional
    16=Post-first Professional
    17=Master's Degree
    18=Post Master's
    19=Sixth-year Degree
    20=Post-sixth Year
    21=Doctorate Degree
    22=Post-Doctorate
    A=University - Advanced
    T=Trade School
    U=University
    11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    12 FIELD_OF_STUDY_GER Character(3) VARCHAR2(3) NOT NULL Field Of Study
    COM=Commercial
    IDN=Industrial
    TEC=Technical
    13 TYPE_OF_STUDY_GER Character(3) VARCHAR2(3) NOT NULL Type Of Study
    CHE=Chemistry/Physics/Mat. Appl.
    COM=Commerce/Banks
    ELE=Electronics/Data Processing
    FOD=Food/Kindered Products
    FOR=Forestry/Timber/Agriculture
    GLA=Glass/Ceramics
    HOT=Hotels/Restaurants
    MET=Metalworker/Mechanic/Engineer.
    MIN=Construction/Mining
    OTH=Other
    PRI=Printing/Paper
    PUB=Public Sector
    TEX=Textiles/Clothing
    14 DURATION_MONTH Number(3,0) SMALLINT NOT NULL Duration (Months)
    15 NVQ_TITLE Character(90) VARCHAR2(90) NOT NULL Title
    16 NVQ_LEVEL Character(1) VARCHAR2(1) NOT NULL Level
    1=1
    2=2
    3=3
    4=4
    5=5
    17 NVQ_EXPDATE Date(10) DATE Expiry Date
    18 FP_DEGREE_LVL Character(1) VARCHAR2(1) NOT NULL Level
    1=Primary Leaving Certificate
    2=VcalTrainCertifandAlternatives
    3=TechSchool CertifandAlternativ
    4=High School Diploma
    5=2 Years' Higher Education
    6=3 Years' Higher Education
    7=4 Years' Higher Education
    8=5 + > Years' Higher Education