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