UPG_COMP_LNG (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_COMP_LNG

(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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

5 EP_DESCR254 Long Character(1325) VARCHAR2(1325) 1325 character description field used in ePerformance

6 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPETENCY	Character(8)	VARCHAR2(8) NOT NULL	Competency
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
5	EP_DESCR254	Long Character(1325)	VARCHAR2(1325)	1325 character description field used in ePerformance
6	DESCRLONG	Long Character	CLOB	Long Description