ACCOMPLISHMT_VW

(SQL View)
 Index Back

Person Accomplishments

ACCOMPLISHMENTS contains the degrees, tests, languages, honors/awards, licenses/certifications, and professional memberships of your employees, applicants and contractors.

SELECT A.EMPLID , A.ACCOMPLISHMENT , A.DT_ISSUED , A.MAJOR_CODE , B.ACCOMP_CATEGORY , %subrec(TESTS_SBR,A) , %subrec(LIC_CERT_SBR,A) , %subrec(LANGUAGE_SBR,A) , %subrec(MEMBERSHIP_SBR,A) , %subrec(EDUCATION_SBR,A) , %subrec(EDUCATN_GER_SBR,A) , %subrec(HONOR_AWARD_SBR,A) , %subrec(HONO_AW_FRA_SBR,A) , %subrec(EDUCATN_FED_SBR, A) , A.SELECT_CMP FROM PS_ACCOMPLISHMENTS A , PS_ACCOMP_TBL B WHERE A.ACCOMPLISHMENT = B.ACCOMPLISHMENT

  • Related Language Record: ACCOMPLISH_LANG

  • Parent record: PERSONAL_DATA

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

    Prompt Table: PERSONAL_DATA

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

    Prompt Table: %RECNAME_EDIT

    3 DT_ISSUED Date(10) DATE Issue Date
    4 MAJOR_CODE Character(10) VARCHAR2(10) NOT NULL Major Code

    Prompt Table: MAJOR_TBL

    5 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
    6 SCORE Number(7,2) DECIMAL(6,2) NOT NULL Test Score
    7 PASSED Character(1) VARCHAR2(1) NOT NULL Passed Test

    Y/N Table Edit

    Default Value: N

    8 LICENSE_NBR Character(15) VARCHAR2(15) NOT NULL License/Certification Number
    9 ISSUED_BY Character(30) VARCHAR2(30) NOT NULL Issued By
    10 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: Y

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

    Prompt Table: SCHOOL_TBL

    32 SCHOOL Character(30) VARCHAR2(30) NOT NULL School Name
    33 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other

    Prompt Table: STATE_NAMES_OTH

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

    Prompt Table: COUNTRY_TBL

    35 TERMINAL_DEGREE Character(1) VARCHAR2(1) NOT NULL Terminal Degree for Discipline

    Y/N Table Edit

    Default Value: N

    36 PRACTIC_GRADE_GER Character(4) VARCHAR2(4) NOT NULL Practical Grade
    37 THEORY_GRADE_GER Character(4) VARCHAR2(4) NOT NULL Theoretical Grade
    38 GRANTOR Character(20) VARCHAR2(20) NOT NULL Grantor
    39 END_DATE Date(10) DATE End Date
    40 BONUS_DT_FRA Date(10) DATE Bonus Date
    41 BONUS_AMOUNT_FRA Number(8,2) DECIMAL(7,2) NOT NULL Bonus
    42 GVT_CREDIT_HOURS Character(3) VARCHAR2(3) NOT NULL Credit Hours
    43 GVT_CRED_HRS_TYPE Character(1) VARCHAR2(1) NOT NULL Credit Hours Type
    44 GPA Number(5,2) DECIMAL(4,2) NOT NULL GPA
    45 YR_ACQUIRED Number(4,0) SMALLINT NOT NULL Year Acquired
    46 SELECT_CMP Character(1) VARCHAR2(1) NOT NULL Include Competency for Search