HR_SP_MOBILITY

(SQL View)
 Index Back

Succession Plan - EE Mobility

Mobility data for Succession Planning. This view joins to HR_SP_DEFAULT.SP_PRI_PERS_TYP to determine the appropriate profile type.

SELECT B.EMPLID , B.JPM_JP_TYPE , C.JPM_CAT_TYPE , C.JPM_YN_1 , C.JPM_YN_2 , C.JPM_YN_3 , C.JPM_LOC_BUNIT_1 , C.JPM_LOC_BUNIT_2 , C.JPM_LOCATION_1 , C.JPM_LOCATION_2 , C.JPM_OBSTACLE_1 , C.JPM_CNTRY_PREF_1 , C.JPM_CNTRY_PREF_2 , C.JPM_CNTRY_PREF_3 , C.JPM_AREA_PREF_1 , C.JPM_AREA_PREF_2 , C.JPM_AREA_PREF_3 FROM PS_HR_SP_DEFAULT A , PS_JPM_PROFILE B , PS_JPM_JP_ITEMS C WHERE A.SP_PRI_PERS_TYP = B.JPM_JP_TYPE AND B.JPM_PROFILE_ID = C.JPM_PROFILE_ID AND C.JPM_CAT_TYPE IN ('LOCATION','LOCATN_PREF','GEOG_PREF','INTL_PREF','TRAVEL')

  • 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_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type
    3 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.

    Prompt Table: JPM_CAT_TYPES

    4 JPM_YN_1 Character(1) VARCHAR2(1) NOT NULL Generic Yes No property for profile items
    N=No
    Y=Yes
    5 JPM_YN_2 Character(1) VARCHAR2(1) NOT NULL Generic Yes No property for profile items
    N=No
    Y=Yes
    6 JPM_YN_3 Character(1) VARCHAR2(1) NOT NULL Generic Yes No property for profile items
    N=No
    Y=Yes
    7 JPM_LOC_BUNIT_1 Character(5) VARCHAR2(5) NOT NULL generic profile item location BU property

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    8 JPM_LOC_BUNIT_2 Character(5) VARCHAR2(5) NOT NULL generic profile item location BU property

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    9 JPM_LOCATION_1 Character(10) VARCHAR2(10) NOT NULL generic profile item location property
    10 JPM_LOCATION_2 Character(10) VARCHAR2(10) NOT NULL generic profile item location property
    11 JPM_OBSTACLE_1 Character(2) VARCHAR2(2) NOT NULL Obstacle property
    FE=Family Member's Education
    FH=Family Member's Health
    FJ=Family Member's Job
    H=Homeowner
    N=None
    OT=Other
    P=Prefer Current Location
    12 JPM_CNTRY_PREF_1 Character(3) VARCHAR2(3) NOT NULL Generic profile item property for country preference
    13 JPM_CNTRY_PREF_2 Character(3) VARCHAR2(3) NOT NULL Generic profile item property for country preference
    14 JPM_CNTRY_PREF_3 Character(3) VARCHAR2(3) NOT NULL Generic profile item property for country preference
    15 JPM_AREA_PREF_1 Character(2) VARCHAR2(2) NOT NULL Generic profile item property
    16 JPM_AREA_PREF_2 Character(2) VARCHAR2(2) NOT NULL Generic profile item property
    17 JPM_AREA_PREF_3 Character(2) VARCHAR2(2) NOT NULL Generic profile item property