HR_CP_TRAVEL

(SQL View)
 Index Back

EE Career Plan

Travel Preference

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_OBSTACLE_1 FROM PS_JPM_PROFILE B , PS_JPM_JP_ITEMS C WHERE B.JPM_PROFILE_ID = C.JPM_PROFILE_ID AND C.JPM_CAT_TYPE = 'TRAVEL' AND C.JPM_CAT_ITEM_ID = 'TRAVEL'

# 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_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