FOEMPTEMP_UPG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	SEQUENCE_NBR	Number(2,0)	SMALLINT NOT NULL	Sequence Number
4	SCHOOL_CODE	Character(10)	VARCHAR2(10) NOT NULL	School Code
5	SCHOOL_NAME	Character(50)	VARCHAR2(50) NOT NULL	School Name
6	SCHOOL_TYPE	Character(3)	VARCHAR2(3) NOT NULL	School Type 000=High School 010=Community College 020=Technical or Trade School 030=Professional School 040=College 050=University 997=Unavailable 998=Not Investigated 999=Other
7	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
8	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_NAMES_TBL
9	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Default Value: OPRDEFTBL_UPG.COUNTRY Prompt Table: COUNTRY_TBL
10	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPRDEFTBL_UPG.SETID
11	FO_DEGREE	Character(3)	VARCHAR2(3) NOT NULL	Degree
12	MAJOR_CODE	Character(10)	VARCHAR2(10) NOT NULL	Major Code
13	MAJOR_NAME	Character(50)	VARCHAR2(50) NOT NULL	Major Name
14	MAJOR_OTHER	Character(10)	VARCHAR2(10) NOT NULL	Other
15	MAJOR_NAME_2ND	Character(50)	VARCHAR2(50) NOT NULL	Major Name
16	DATE_ACQUIRED	Date(10)	DATE	Date Acquired
17	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
18	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)