HR_CP_MOBIL_VW

(SQL View)
 Index Back

Employee Resume Mobility

This view is created from JPM_JP_ITEMS table and is used for the Mobility grid in the Employee Self-Service Internal Resume.

SELECT DISTINCT A.EMPLID , B.JPM_CAT_TYPE , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_HR_CP_CAT_VW A , PS_JPM_JP_ITEMS B , PS_JPM_CAT_ITEMS C WHERE A.JPM_PROFILE_ID = B.JPM_PROFILE_ID AND A.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND A.JPM_CAT_TYPE = C.JPM_CAT_TYPE AND B.JPM_CAT_ITEM_ID = C.JPM_CAT_ITEM_ID AND A.JPM_CAT_TYPE IN ('LOCATION','LOCATN_PREF','GEOG_PREF','INTL_PREF','TRAVEL') AND C.EFF_STATUS = 'A' AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_JPM_JP_ITEMS C1 WHERE B.JPM_PROFILE_ID = C1.JPM_PROFILE_ID AND B.JPM_CAT_TYPE = C1.JPM_CAT_TYPE AND B.JPM_CAT_ITEM_ID = C1.JPM_CAT_ITEM_ID AND B.JPM_CAT_ITEM_QUAL = C1.JPM_CAT_ITEM_QUAL AND B.JPM_CAT_ITEM_QUAL2 = C1.JPM_CAT_ITEM_QUAL2 AND C1.EFFDT <= %CurrentDateIn)

  • Parent record: PERSON

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

    Prompt Table: PERSON

    2 JPM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL The name of the type of items that will be used in a Catalog and or in a Profile.
    3 DESCRSHORT1_JPN Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: Y

    4 GVT_DES_LOC_LBL Character(1) VARCHAR2(1) NOT NULL Desired Locations

    Default Value: Y

    5 GEOG_PREFERENCE Character(2) VARCHAR2(2) NOT NULL Geographic Preferences
    C=Canada
    E=East
    I=International
    MW=Midwest
    N=North
    NE=Northeast
    NW=Northwest
    S=South
    SE=Southeast
    SW=Southwest
    W=West

    Default Value: S

    6 TRAVELLING Character(1) VARCHAR2(1) NOT NULL Willing to Travel
    N=No
    Y=Yes

    Default Value: Y

    7 GVT_INTL_PREF_LBL Character(1) VARCHAR2(1) NOT NULL International Preferences

    Default Value: Y