GM_PERS_EDUC_VW

(SQL View)
 Index Back

Person Accomps w/ Category Vw

This view selects the education accomplishments of a professional (by category=DEG)

SELECT A.EMPLID , A.ACCOMPLISHMENT , B.DESCR , A.DT_ISSUED , A.MAJOR_CODE , B.ACCOMP_CATEGORY , A.YR_ACQUIRED , %subrec(LIC_CERT_SBR,A) , %subrec(EDUCATION_SBR,A) , %subrec(EDUCATN_GER_SBR,A) FROM PS_ACCOMPLISHMENTS A , PS_ACCOMP_TBL B WHERE A.ACCOMPLISHMENT=B.ACCOMPLISHMENT AND B.ACCOMP_CATEGORY='DEG'

  • Related Language Record: GM_PERS_EDLN_VW

    • # 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 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

    Prompt Table: MAJOR_TBL

    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 YR_ACQUIRED Number(4,0) SMALLINT NOT NULL Year Acquired
    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 MAJOR Character(30) VARCHAR2(30) NOT NULL Major
    16 IPE_SW Character(1) VARCHAR2(1) NOT NULL Intern. Professional Education

    Y/N Table Edit

    Default Value: N

    17 AVERAGE_GRADE Character(5) VARCHAR2(5) NOT NULL Average Grade
    18 EDUCATOR Character(50) VARCHAR2(50) NOT NULL Educator
    19 GRADUATE_INDICATOR Character(1) VARCHAR2(1) NOT NULL Graduated

    Y/N Table Edit

    Default Value: Y

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

    Prompt Table: SCHOOL_TBL

    21 SCHOOL Character(30) VARCHAR2(30) NOT NULL School Name
    22 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other

    Prompt Table: STATE_NAMES_OTH

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

    Prompt Table: COUNTRY_TBL

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

    Y/N Table Edit

    Default Value: N

    25 PRACTIC_GRADE_GER Character(4) VARCHAR2(4) NOT NULL Practical Grade
    26 THEORY_GRADE_GER Character(4) VARCHAR2(4) NOT NULL Theoretical Grade