HR_CP_LOC_PREF

(SQL View)
 Index Back

EE Career Plan

Location Preference

SELECT B.EMPLID ,B.JPM_JP_TYPE , C.JPM_CAT_TYPE , C.JPM_LOC_BUNIT_1 , C.JPM_LOC_BUNIT_2 , C.JPM_LOCATION_1 , C.JPM_LOCATION_2 FROM PS_JPM_PROFILE B , PS_JPM_JP_ITEMS C WHERE B.JPM_PROFILE_ID = C.JPM_PROFILE_ID AND C.JPM_CAT_TYPE = 'LOCATN_PREF' AND C.JPM_CAT_ITEM_ID = 'LOCATN_PREF'

  • 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_LOC_BUNIT_1 Character(5) VARCHAR2(5) NOT NULL generic profile item location BU property

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

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

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    6 JPM_LOCATION_1 Character(10) VARCHAR2(10) NOT NULL generic profile item location property
    7 JPM_LOCATION_2 Character(10) VARCHAR2(10) NOT NULL generic profile item location property