LIC_CERTIF_VW

(SQL View)
 Index Back

License Certificate View


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 Accomplishment
    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
    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