GPGB_EYUXML_TBL

#	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	GPGB_RTIXML_S_FAC	Number(8,0)	INTEGER NOT NULL	RTI XML Split Factor
4	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
5	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
6	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
7	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	MIDDLE_NAME
8	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
9	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix
10	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
11	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
12	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
13	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
14	ADDRESS1_OTHER	Character(55)	VARCHAR2(55) NOT NULL	Address 1 Other
15	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
16	BIRTHDATE	Date(10)	DATE	Date of Birth
17	PASSPORT_NBR	Character(15)	VARCHAR2(15) NOT NULL	Passport Number
18	NATIONAL_ID_FORMAT	Character(20)	VARCHAR2(20) NOT NULL	National ID Format
19	FIRST_NAME_EDI	Character(30)	VARCHAR2(30) NOT NULL	First Name
20	LAST_NAME_EDI	Character(30)	VARCHAR2(30) NOT NULL	Last Name
21	NAME_AC_LAST	Character(30)	VARCHAR2(30) NOT NULL	Last Name