SCHOOL_EDUCAT

(SQL View)
 Index Back

School Education

Contains information about education achieved by an employee. Release 9 Job Profile Managment (JPM): Table became a view to JPM data. Ownership of table transferred from Human Resources to JPM.

SELECT B.EMPLID ,A.EFFDT ,A.COUNTRY ,A.SCHOOL_TYPE ,%Substring(A.JPM_CAT_ITEM_ID,1,3) ,A.JPM_YN_1 ,A.SCHOOL_CODE ,%Substring(A.JPM_TEXT254_4,1,30) ,A.AVERAGE_GRADE ,A.STATE FROM PS_JPM_JP_ITEMS A , PS_JPM_PROFILE B WHERE A.JPM_PROFILE_ID = B.JPM_PROFILE_ID AND B.JPM_JP_TYPE = 'PERSON' AND A.JPM_CAT_TYPE = 'EDLVLACHV' AND A.JPM_ITEM_KEY_ID = ( SELECT MAX(X.JPM_ITEM_KEY_ID) FROM PS_JPM_JP_ITEMS X WHERE A.JPM_PROFILE_ID = X.JPM_PROFILE_ID AND A.JPM_CAT_TYPE = X.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID = X.JPM_CAT_ITEM_ID AND A.EFFDT = X.EFFDT)

  • Related Language Record: SCHL_EDUC_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 DATE_ACQUIRED Date(10) DATE Date Acquired
    3 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Default Value: OPR_DEF_TBL_HR.COUNTRY

    Prompt Table: COUNTRY_TBL

    4 SCHOOL_TYPE Character(3) VARCHAR2(3) NOT NULL School Type

    Default Value: UNK

    Prompt Table: SCHOOL_TYPE_TBL

    5 EDUCATION_LVL_ACHV Character(3) VARCHAR2(3) NOT NULL Education Level Achieved

    Prompt Table: EDLVL_ACHV_TBL

    6 COMPLETED Character(1) VARCHAR2(1) NOT NULL Completed

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: SCHOOL_TBL

    8 SCHOOL Character(30) VARCHAR2(30) NOT NULL School Name
    9 AVERAGE_GRADE Character(5) VARCHAR2(5) NOT NULL Average Grade
    10 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL