DEGREE_VW

(SQL View)
 Index Back

Accomplishment Table

The ACCOMP_TBL contains all your organizations accomplishments. Accomplishments are: 1) languages 2) degrees 3) licenses or certificates 4) honors or awards 5) professional memberships or 6) tests 7)NVQs (UK only) that your employees, applicants or contractors may achieve. The ACCOMPLISHMENT field must be unique across all these accomplishment types. The field ACCOMP_CATEGORY identifies the accomplishment as one of the above listed cateories.

SELECT A.ACCOMPLISHMENT ,A.DESCR ,A.DESCRSHORT ,A.ACCOMP_CATEGORY , %subrec(LIC_CERTIF_SBR,A) , %subrec(DEGREE_SBR,A) FROM PS_ACCOMP_TBL A WHERE ACCOMP_CATEGORY = 'DEG'

  • Related Language Record: DEGREE_LVW

    • # 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 RENEWAL_REQUIRED Character(1) VARCHAR2(1) NOT NULL Renewal Required

    Y/N Table Edit

    Default Value: N

    6 RENEWAL_PERIOD Character(1) VARCHAR2(1) NOT NULL Renewal Period
    D=Days
    M=Months
    W=Weeks
    Y=Years
    7 RENEWAL_LENGTH Number(3,0) SMALLINT NOT NULL Renewal Length
    8 YEARS_OF_EDUCATN Number(2,0) SMALLINT NOT NULL Years Of Education
    9 EDUCATION_LVL Character(2) VARCHAR2(2) NOT NULL Education Level
    1=No Formal Education
    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=Masters Degree
    18=Post Masters
    19=Sixth Year Degree
    2=Elementary School Completed
    20=Post Sixth Year
    21=Doctorate Degree
    22=Post Doctorate
    3=Some High School
    4=High School Graduate
    5=Terminal Occupation Prog DNC
    6=Terminal Occupation Program
    7=Some College - Less than 1 Yr
    8=One Year College
    9=Two Years College
    A=University - Advanced
    T=Trade School
    U=University
    10 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    11 FIELD_OF_STUDY_GER Character(3) VARCHAR2(3) NOT NULL Field Of Study
    12 TYPE_OF_STUDY_GER Character(3) VARCHAR2(3) NOT NULL Type Of Study
    13 DURATION_MONTH Number(3,0) SMALLINT NOT NULL Length of Stay Duration in Months