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

FT_SCHEDUC

(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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 DATE_ACQUIRED Date(10) DATE Date Acquired

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

4 SCHOOL_TYPE Character(3) VARCHAR2(3) NOT NULL School Type

5 EDUCATION_LVL_ACHV Character(3) VARCHAR2(3) NOT NULL Education Level Achieved

6 COMPLETED Character(1) VARCHAR2(1) NOT NULL Completed
N=No
Y=Yes

7 SCHOOL_CODE Character(10) VARCHAR2(10) NOT NULL School Code

8 SCHOOL Character(30) VARCHAR2(30) NOT NULL School Name

9 AVERAGE_GRADE Character(5) VARCHAR2(5) NOT NULL Average Grade

10 STATE Character(6) VARCHAR2(6) NOT NULL State

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

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

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

14 FT_ALTERNATE_REC Character(50) VARCHAR2(50) NOT NULL Source Record

15 FT_ALTERNATE_KEY Character(254) VARCHAR2(254) NOT NULL Alternate Key

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	DATE_ACQUIRED	Date(10)	DATE	Date Acquired
3	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
4	SCHOOL_TYPE	Character(3)	VARCHAR2(3) NOT NULL	School Type
5	EDUCATION_LVL_ACHV	Character(3)	VARCHAR2(3) NOT NULL	Education Level Achieved
6	COMPLETED	Character(1)	VARCHAR2(1) NOT NULL	Completed N=No Y=Yes
7	SCHOOL_CODE	Character(10)	VARCHAR2(10) NOT NULL	School Code
8	SCHOOL	Character(30)	VARCHAR2(30) NOT NULL	School Name
9	AVERAGE_GRADE	Character(5)	VARCHAR2(5) NOT NULL	Average Grade
10	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
11	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.
12	JPM_DISTINCT_IND	Character(1)	VARCHAR2(1) NOT NULL	Discinct Indicator
13	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.
14	FT_ALTERNATE_REC	Character(50)	VARCHAR2(50) NOT NULL	Source Record
15	FT_ALTERNATE_KEY	Character(254)	VARCHAR2(254) NOT NULL	Alternate Key