HR_CP_TRAV_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 , B.JPM_YN_1 ,B.JPM_YN_2 , B.JPM_YN_3 , B.JPM_OBSTACLE_1 , ' ' , ' ' , ' ' , ' ' , ' ' 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 = '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_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 JPM_YN_1 Character(1) VARCHAR2(1) NOT NULL Generic Yes No property for profile items
    N=No
    Y=Yes
    4 JPM_YN_2 Character(1) VARCHAR2(1) NOT NULL Generic Yes No property for profile items
    N=No
    Y=Yes
    5 JPM_YN_3 Character(1) VARCHAR2(1) NOT NULL Generic Yes No property for profile items
    N=No
    Y=Yes
    6 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
    7 TRAVELLING Character(1) VARCHAR2(1) NOT NULL Willing to Travel
    N=No
    Y=Yes

    Default Value: Y

    8 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    9 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    10 DESCR3 Character(30) VARCHAR2(30) NOT NULL Descr 3
    11 DESCR4 Character(30) VARCHAR2(30) NOT NULL Descr 4