UPG_ACMP_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_ACMP_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 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

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

3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
Default Value: ACCOMP_TBL.DESCR

4 ACCOMP_CATEGORY Character(3) VARCHAR2(3) NOT NULL Accomplishment Category
DEG=Degree
HON=Honor or Award
LIC=License or Certification
LNG=Language
MEM=Membership
NVQ=NVQ
TST=Test

5 RENEWAL_REQUIRED Character(1) VARCHAR2(1) NOT NULL Renewal Required
N=No
Y=Yes
Default Value: N

6 RENEWAL_PERIOD Character(1) VARCHAR2(1) NOT NULL Renewal Period
D=Days
M=Months
W=Weeks
Y=Years

7 RENEWAL_LENGTH Number(3,0) SMALLINT NOT NULL Renewal Length

8 YEARS_OF_EDUCATN Number(2,0) SMALLINT NOT NULL Years Of Education

9 EDUCATION_LVL Character(2) VARCHAR2(2) NOT NULL Education Level
01=No Formal Education
02=Elementary School Completed
03=Some High School
04=High School Graduate
05=Terminal Occupation Prog DNC
06=Terminal Occupation Program
07=Some College - Less than 1 Yr
08=One Year College
09=Two Years College
10=Associate Degree
11=Three Years College
12=Four Years College
13=Bachelor Degree
14=Post Bachelors
15=First Professional
16=Post-first Professional
17=Master's Degree
18=Post Master's
19=Sixth-year Degree
20=Post-sixth Year
21=Doctorate Degree
22=Post-Doctorate
A=University - Advanced
T=Trade School
U=University

10 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

11 FIELD_OF_STUDY_GER Character(3) VARCHAR2(3) NOT NULL Field Of Study
COM=Commercial
IDN=Industrial
TEC=Technical

12 TYPE_OF_STUDY_GER Character(3) VARCHAR2(3) NOT NULL Type Of Study
CHE=Chemistry/Physics/Mat. Appl.
COM=Commerce/Banks
ELE=Electronics/Data Processing
FOD=Food/Kindered Products
FOR=Forestry/Timber/Agriculture
GLA=Glass/Ceramics
HOT=Hotels/Restaurants
MET=Metalworker/Mechanic/Engineer.
MIN=Construction/Mining
OTH=Other
PRI=Printing/Paper
PUB=Public Sector
TEX=Textiles/Clothing

13 DURATION_MONTH Number(3,0) SMALLINT NOT NULL Duration (Months)

14 NVQ_TITLE Character(90) VARCHAR2(90) NOT NULL Title

15 NVQ_LEVEL Character(1) VARCHAR2(1) NOT NULL Level
1=1
2=2
3=3
4=4
5=5

16 NVQ_EXPDATE Date(10) DATE Expiry Date

17 HP_STATS_DEG_LVL Character(2) VARCHAR2(2) NOT NULL Stats-Can Degree Level
01=Doctoral
02=Professional Para-Medical
03=Masters & Equivalent License
04=Graduate Program
05=Bachelor
06=Professional Designation
07=Undergraduate Diploma
08=No Degree/Diploma/Prof.Desgnt
09=Unknown

18 FP_DEGREE_LVL Character(1) VARCHAR2(1) NOT NULL Level
1=Primary Leaving Certificate
2=VcalTrainCertifandAlternatives
3=TechSchool CertifandAlternativ
4=High School Diploma
5=2 Years' Higher Education
6=3 Years' Higher Education
7=4 Years' Higher Education
8=5 + > Years' Higher Education

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACCOMPLISHMENT	Character(8)	VARCHAR2(8) NOT NULL	Accomplishment
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: ACCOMP_TBL.DESCR
4	ACCOMP_CATEGORY	Character(3)	VARCHAR2(3) NOT NULL	Accomplishment Category DEG=Degree HON=Honor or Award LIC=License or Certification LNG=Language MEM=Membership NVQ=NVQ TST=Test
5	RENEWAL_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Renewal Required N=No Y=Yes Default Value: N
6	RENEWAL_PERIOD	Character(1)	VARCHAR2(1) NOT NULL	Renewal Period D=Days M=Months W=Weeks Y=Years
7	RENEWAL_LENGTH	Number(3,0)	SMALLINT NOT NULL	Renewal Length
8	YEARS_OF_EDUCATN	Number(2,0)	SMALLINT NOT NULL	Years Of Education
9	EDUCATION_LVL	Character(2)	VARCHAR2(2) NOT NULL	Education Level 01=No Formal Education 02=Elementary School Completed 03=Some High School 04=High School Graduate 05=Terminal Occupation Prog DNC 06=Terminal Occupation Program 07=Some College - Less than 1 Yr 08=One Year College 09=Two Years College 10=Associate Degree 11=Three Years College 12=Four Years College 13=Bachelor Degree 14=Post Bachelors 15=First Professional 16=Post-first Professional 17=Master's Degree 18=Post Master's 19=Sixth-year Degree 20=Post-sixth Year 21=Doctorate Degree 22=Post-Doctorate A=University - Advanced T=Trade School U=University
10	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
11	FIELD_OF_STUDY_GER	Character(3)	VARCHAR2(3) NOT NULL	Field Of Study COM=Commercial IDN=Industrial TEC=Technical
12	TYPE_OF_STUDY_GER	Character(3)	VARCHAR2(3) NOT NULL	Type Of Study CHE=Chemistry/Physics/Mat. Appl. COM=Commerce/Banks ELE=Electronics/Data Processing FOD=Food/Kindered Products FOR=Forestry/Timber/Agriculture GLA=Glass/Ceramics HOT=Hotels/Restaurants MET=Metalworker/Mechanic/Engineer. MIN=Construction/Mining OTH=Other PRI=Printing/Paper PUB=Public Sector TEX=Textiles/Clothing
13	DURATION_MONTH	Number(3,0)	SMALLINT NOT NULL	Duration (Months)
14	NVQ_TITLE	Character(90)	VARCHAR2(90) NOT NULL	Title
15	NVQ_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Level 1=1 2=2 3=3 4=4 5=5
16	NVQ_EXPDATE	Date(10)	DATE	Expiry Date
17	HP_STATS_DEG_LVL	Character(2)	VARCHAR2(2) NOT NULL	Stats-Can Degree Level 01=Doctoral 02=Professional Para-Medical 03=Masters & Equivalent License 04=Graduate Program 05=Bachelor 06=Professional Designation 07=Undergraduate Diploma 08=No Degree/Diploma/Prof.Desgnt 09=Unknown
18	FP_DEGREE_LVL	Character(1)	VARCHAR2(1) NOT NULL	Level 1=Primary Leaving Certificate 2=VcalTrainCertifandAlternatives 3=TechSchool CertifandAlternativ 4=High School Diploma 5=2 Years' Higher Education 6=3 Years' Higher Education 7=4 Years' Higher Education 8=5 + > Years' Higher Education