CO_LIC_CERT_VW

(SQL View)
 Index Back

Accomplishments - Lic/Certif

This is a clone of LIC_CERTIF_VW, but with the Description as the default search field in order to satisfy GUI requirements for self-service.

SELECT ACCOMPLISHMENT ,DESCR ,DESCRSHORT ,ACCOMP_CATEGORY ,RENEWAL_REQUIRED ,RENEWAL_PERIOD ,RENEWAL_LENGTH ,YEARS_OF_EDUCATN ,EDUCATION_LVL ,COUNTRY ,FIELD_OF_STUDY_GER ,TYPE_OF_STUDY_GER ,DURATION_MONTH FROM PS_ACCOMP_TBL WHERE ACCOMP_CATEGORY = 'LIC'

  • Related Language Record: LIC_CERTVW_LNG

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

    Default Value: LIC_CERTIF_VW.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

    Default Value: LIC

    5 RENEWAL_REQUIRED Character(1) VARCHAR2(1) NOT NULL Renewal Required
    N=No
    Y=Yes
    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
    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
    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
    COM=Commercial
    IDN=Industrial
    TEC=Technical
    12 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
    13 DURATION_MONTH Number(3,0) SMALLINT NOT NULL Duration (Months)