ACCOMP_TBL

(SQL Table)
 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 yo

  • Related Language Record: ACCOMP_TBL_LANG

    • # 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
    14 NVQ_TITLE Character(90) VARCHAR2(90) NOT NULL Title
    15 NVQ_LEVEL Character(1) VARCHAR2(1) NOT NULL Level
    16 NVQ_EXPDATE Date(10) DATE Expiry Date
    17 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 License
    05=Bachelor
    06=Professional Designation
    07=Undergraduate Diploma
    08=No Degree/Diploma/Prof.Desgntn
    99=Unknown
    18 VALID_GRANT_GOV Character(1) VARCHAR2(1) NOT NULL VALID_GRANT_GOV

    Y/N Table Edit