ACCOMP_TBL

(SQL View)
 Index Back

Accomplishment Table

As of HCM 9.0 This table has become a view to Job Profile Managment Items where accomplishments are now stored. 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 %Substring(A.JPM_CAT_ITEM_ID,1,8) ,%Substring(A.JPM_DESCR90,1,30) ,A.DESCRSHORT ,%Substring(A.JPM_CAT_TYPE,1,3) ,A.JPM_YN_1 ,A.JPM_DURATION_TYPE1 ,A.JPM_DURATION_1 ,A.JPM_DURATION_1 ,A.EDUCATION_LVL ,A.COUNTRY ,A.FIELD_OF_STUDY_GER ,A.TYPE_OF_STUDY_GER ,A.JPM_DURATION_2 ,A.JPM_DESCR90 ,A.NVQ_LEVEL ,A.JPM_DATE_1 ,A.HP_STATS_DEG_LVL ,A.FP_DEGREE_LVL FROM PS_JPM_CAT_ITEMS A WHERE A.JPM_CAT_TYPE IN('DEG', 'HON', 'LIC', 'LNG', 'MEM', 'NVQ', 'TST') AND A.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_JPM_CAT_ITEMS X WHERE A.JPM_CAT_TYPE = X.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID = X.JPM_CAT_ITEM_ID AND X.EFFDT <= %CurrentDateIn)

  • 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
    N=No
    Y=Yes

    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
    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)
    14 NVQ_TITLE Character(90) VARCHAR2(90) NOT NULL Title
    15 NVQ_LEVEL Character(1) VARCHAR2(1) NOT NULL Level
    1=1
    2=2
    3=3
    4=4
    5=5
    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 Program
    05=Bachelor
    06=Professional Designation
    07=Undergraduate Diploma
    08=No Degree/Diploma/Prof.Desgnt
    09=Unknown
    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