UPG_JOB_PROF (SQL Table)	Index Back
Upgrade Only - Legacy Backup Upgrade Only - Legacy Backup This table holds a backup of Legacy Data created during the upgrade to Profile Management 9.0. When the customer is satisfied with the upgrade or no longer needs a copy of the prior data, this table should be dropped from the Database.

UPG_JOB_PROF

(SQL Table)

Upgrade Only - Legacy Backup

Upgrade Only - Legacy Backup This table holds a backup of Legacy Data created during the upgrade to Profile Management 9.0. When the customer is satisfied with the upgrade or no longer needs a copy of the prior data, this table should be dropped from the Database.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JOB_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL Job Profile ID

2 EFFDT Date(10) DATE Effective Date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

4 JOB_PROF_DESCR Character(30) VARCHAR2(30) NOT NULL Job Profile Description

5 JOB_PROF_DESCRSHRT Character(10) VARCHAR2(10) NOT NULL Short Description

6 JOB_PROF_DESCRLONG Long Character CLOB Job Profile Long Description

7 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JOB_PROFILE_ID	Character(12)	VARCHAR2(12) NOT NULL	Job Profile ID
2	EFFDT	Date(10)	DATE	Effective Date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
4	JOB_PROF_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Job Profile Description
5	JOB_PROF_DESCRSHRT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
6	JOB_PROF_DESCRLONG	Long Character	CLOB	Job Profile Long Description
7	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.