AV_ACCOMP_VW

(SQL View)
 Index Back

Person accomplishments

Person accomplishments with category view.

SELECT A.EMPLID , A.ACCOMPLISHMENT , B.DESCR , A.DT_ISSUED , A.MAJOR_CODE , B.ACCOMP_CATEGORY , A.SCORE , A.PASSED , A.LICENSE_NBR , A.ISSUED_BY , A.COUNTRY , A.STATE , A.EXPIRATN_DT , A.LICENSE_VERIFIED , A.RENEWAL , A.NATIVE_LANGUAGE , A.TRANSLATOR , A.TEACHER , A.SPEAK_PROFICIENCY , A.READ_PROFICIENCY , A.WRITE_PROFICIENCY , A.EVALUATION_DT , A.MANDATE , A.MANDATE_FUNCTION , A.MANDATE_BEGIN_DATE , A.MANDATE_END_DATE , A.MAJOR , A.IPE_SW , A.AVERAGE_GRADE , A.EDUCATOR , A.GRADUATE_INDICATOR , A.COUNTRY_OTHER , A.STATE_OTHER , A.SCHOOL_CODE , A.SCHOOL , A.TERMINAL_DEGREE , A.PRACTIC_GRADE_GER , A.THEORY_GRADE_GER , A.GRANTOR , A.END_DATE , A.BONUS_DT_FRA , A.BONUS_AMOUNT_FRA FROM PS_ACCOMPLISHMENTS A , PS_ACCOMP_TBL B WHERE A.ACCOMPLISHMENT = B.ACCOMPLISHMENT

  • Related Language Record: AVACCOMPVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: AV_PEOPLE_SRCH

    2 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

    Prompt Table: %RECNAME_EDIT

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DT_ISSUED Date(10) DATE Issue Date
    5 MAJOR_CODE Character(10) VARCHAR2(10) NOT NULL Major Code
    6 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
    7 SCORE Number(7,2) DECIMAL(6,2) NOT NULL Test Score
    8 PASSED Character(1) VARCHAR2(1) NOT NULL Passed Test

    Y/N Table Edit

    Default Value: N

    9 LICENSE_NBR Character(15) VARCHAR2(15) NOT NULL License/Certification Number
    10 ISSUED_BY Character(30) VARCHAR2(30) NOT NULL Issued By
    11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Default Value: OPR_DEF_TBL_HR.COUNTRY

    Prompt Table: COUNTRY_TBL

    12 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: HCR_STONLY_I

    13 EXPIRATN_DT Date(10) DATE Expiration Date
    14 LICENSE_VERIFIED Character(1) VARCHAR2(1) NOT NULL License Verified

    Y/N Table Edit

    Default Value: N

    15 RENEWAL Character(1) VARCHAR2(1) NOT NULL Renewal in Progress

    Y/N Table Edit

    Default Value: N

    16 NATIVE_LANGUAGE Character(1) VARCHAR2(1) NOT NULL Native Language

    Y/N Table Edit

    Default Value: N

    17 TRANSLATOR Character(1) VARCHAR2(1) NOT NULL Able to Translate

    Y/N Table Edit

    Default Value: N

    18 TEACHER Character(1) VARCHAR2(1) NOT NULL Able to Teach

    Y/N Table Edit

    Default Value: N

    19 SPEAK_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Speaking Proficiency
    1=Low
    2=Moderate
    3=High
    20 READ_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Reading Proficiency
    1=Low
    2=Moderate
    3=High
    21 WRITE_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Writing Proficiency
    1=Low
    2=Moderate
    3=High
    22 EVALUATION_DT Date(10) DATE Evaluation Date
    23 MANDATE Character(15) VARCHAR2(15) NOT NULL Mandate
    24 MANDATE_FUNCTION Character(15) VARCHAR2(15) NOT NULL Mandate Position
    25 MANDATE_BEGIN_DATE Date(10) DATE Mandate Begin Date
    26 MANDATE_END_DATE Date(10) DATE Mandate End Date
    27 MAJOR Character(30) VARCHAR2(30) NOT NULL Major
    28 IPE_SW Character(1) VARCHAR2(1) NOT NULL Intern. Professional Education

    Y/N Table Edit

    Default Value: N

    29 AVERAGE_GRADE Character(5) VARCHAR2(5) NOT NULL Average Grade
    30 EDUCATOR Character(50) VARCHAR2(50) NOT NULL Educator
    31 GRADUATE_INDICATOR Character(1) VARCHAR2(1) NOT NULL Graduated

    Y/N Table Edit

    Default Value: N

    32 COUNTRY_OTHER Character(3) VARCHAR2(3) NOT NULL Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT

    Default Value: OPR_DEF_TBL_HR.COUNTRY

    Prompt Table: COUNTRY_TBL

    33 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other

    Prompt Table: HCR_STONLY_OT_I

    34 SCHOOL_CODE Character(10) VARCHAR2(10) NOT NULL School Code

    Prompt Table: SCHOOL_TBL_VW

    35 SCHOOL Character(30) VARCHAR2(30) NOT NULL School Name
    36 TERMINAL_DEGREE Character(1) VARCHAR2(1) NOT NULL Terminal Degree for Discipline

    Y/N Table Edit

    Default Value: N

    37 PRACTIC_GRADE_GER Character(4) VARCHAR2(4) NOT NULL Practical Grade
    38 THEORY_GRADE_GER Character(4) VARCHAR2(4) NOT NULL Theoretical Grade
    39 GRANTOR Character(20) VARCHAR2(20) NOT NULL The name of the person granting the award
    40 END_DATE Date(10) DATE End Date
    41 BONUS_DT_FRA Date(10) DATE Bonus Date
    42 BONUS_AMOUNT_FRA Number(8,2) DECIMAL(7,2) NOT NULL Bonus