UPG_PM_CP_AET (SQL Table)	Index Back
Upgrade Only Upgrade Only - State record for converting Career Planning Mobility to Profile Management

UPG_PM_CP_AET

(SQL Table)

Upgrade Only

Upgrade Only - State record for converting Career Planning Mobility to Profile Management

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 EFFDT Date(10) DATE Effective Date

4 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

6 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID

7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

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

9 RELOCATE Character(1) VARCHAR2(1) NOT NULL Willing to Relocate
N=No
Y=Yes

10 INTERNATIONAL Character(1) VARCHAR2(1) NOT NULL Take International Assignment

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

12 JPM_SETID_LOC_1 Character(5) VARCHAR2(5) NOT NULL Generic Location Setid property

13 JPM_LOCATION_1 Character(10) VARCHAR2(10) NOT NULL generic profile item location property

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

15 JPM_SETID_LOC_2 Character(5) VARCHAR2(5) NOT NULL Generic Location Setid property

16 JPM_LOCATION_2 Character(10) VARCHAR2(10) NOT NULL generic profile item location property

17 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

18 JPM_AREA_PREF_1 Character(2) VARCHAR2(2) NOT NULL Generic profile item property

19 JPM_AREA_PREF_2 Character(2) VARCHAR2(2) NOT NULL Generic profile item property

20 JPM_AREA_PREF_3 Character(2) VARCHAR2(2) NOT NULL Generic profile item property

21 JPM_CNTRY_PREF_1 Character(3) VARCHAR2(3) NOT NULL Generic profile item property for country preference

22 JPM_CNTRY_PREF_2 Character(3) VARCHAR2(3) NOT NULL Generic profile item property for country preference

23 JPM_CNTRY_PREF_3 Character(3) VARCHAR2(3) NOT NULL Generic profile item property for country preference

24 JPM_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.

25 JPM_DISTINCT_IND Character(1) VARCHAR2(1) NOT NULL Discinct Indicator

26 JPM_ITEM_KEY_ID Number(12,0) DECIMAL(12) NOT NULL Unique identifier of an item within a profile. This is the primary key of profile items. It is a generic autoassigned value (a number). The unique key permits the addition of items that are not inheritently unique. They may have the same effective date, item type, item id, yet differ in a property or other value. The concept of key fields in a profile is a loose term as an object in a profile can have very different needs in identification.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EFFDT	Date(10)	DATE	Effective Date
4	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
7	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
8	TRAVELLING	Character(1)	VARCHAR2(1) NOT NULL	Willing to Travel N=No Y=Yes
9	RELOCATE	Character(1)	VARCHAR2(1) NOT NULL	Willing to Relocate N=No Y=Yes
10	INTERNATIONAL	Character(1)	VARCHAR2(1) NOT NULL	Take International Assignment
11	JPM_LOC_BUNIT_1	Character(5)	VARCHAR2(5) NOT NULL	generic profile item location BU property
12	JPM_SETID_LOC_1	Character(5)	VARCHAR2(5) NOT NULL	Generic Location Setid property
13	JPM_LOCATION_1	Character(10)	VARCHAR2(10) NOT NULL	generic profile item location property
14	JPM_LOC_BUNIT_2	Character(5)	VARCHAR2(5) NOT NULL	generic profile item location BU property
15	JPM_SETID_LOC_2	Character(5)	VARCHAR2(5) NOT NULL	Generic Location Setid property
16	JPM_LOCATION_2	Character(10)	VARCHAR2(10) NOT NULL	generic profile item location property
17	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
18	JPM_AREA_PREF_1	Character(2)	VARCHAR2(2) NOT NULL	Generic profile item property
19	JPM_AREA_PREF_2	Character(2)	VARCHAR2(2) NOT NULL	Generic profile item property
20	JPM_AREA_PREF_3	Character(2)	VARCHAR2(2) NOT NULL	Generic profile item property
21	JPM_CNTRY_PREF_1	Character(3)	VARCHAR2(3) NOT NULL	Generic profile item property for country preference
22	JPM_CNTRY_PREF_2	Character(3)	VARCHAR2(3) NOT NULL	Generic profile item property for country preference
23	JPM_CNTRY_PREF_3	Character(3)	VARCHAR2(3) NOT NULL	Generic profile item property for country preference
24	JPM_PROFILE_ID	Character(12)	VARCHAR2(12) NOT NULL	The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.
25	JPM_DISTINCT_IND	Character(1)	VARCHAR2(1) NOT NULL	Discinct Indicator
26	JPM_ITEM_KEY_ID	Number(12,0)	DECIMAL(12) NOT NULL	Unique identifier of an item within a profile. This is the primary key of profile items. It is a generic autoassigned value (a number). The unique key permits the addition of items that are not inheritently unique. They may have the same effective date, item type, item id, yet differ in a property or other value. The concept of key fields in a profile is a loose term as an object in a profile can have very different needs in identification.