UPG_SUBPROF_TBL (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_SUBPROF_TBL

(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 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency

2 EP_SUB_ID Character(12) VARCHAR2(12) NOT NULL Sub-Item unique identifier

3 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating
Prompt Table: REVW_RATING_TBL

4 EP_PROF_STATEMENT Character(254) VARCHAR2(254) NOT NULL Proficiency statement

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPETENCY	Character(8)	VARCHAR2(8) NOT NULL	Competency
2	EP_SUB_ID	Character(12)	VARCHAR2(12) NOT NULL	Sub-Item unique identifier
3	REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Review Rating Prompt Table: REVW_RATING_TBL
4	EP_PROF_STATEMENT	Character(254)	VARCHAR2(254) NOT NULL	Proficiency statement
5	JPM_DISTINCT_IND	Character(1)	VARCHAR2(1) NOT NULL	Discinct Indicator