GPIT_770_RP_002

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GPIT_TAX_CD_1	Character(16)	VARCHAR2(16) NOT NULL	Tax Code Prompt Table: GPIT_PROV
3	GPIT_FILE_NBR4	Number(4,0)	SMALLINT NOT NULL	File Number
4	COMP_CODE_ITA	Character(30)	VARCHAR2(30) NOT NULL	Company Codes ITA
5	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
6	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
7	GPIT_TAX_CD_2	Character(16)	VARCHAR2(16) NOT NULL	Tax Code
8	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
9	GPIT_ACTIVITY_CODE	Character(5)	VARCHAR2(5) NOT NULL	Activity Code
10	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
11	PHONE1	Character(24)	VARCHAR2(24) NOT NULL	Phone number field for discounts and perks eligibility file.
12	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
13	CITY_ITA	Character(50)	VARCHAR2(50) NOT NULL	City for Italy
14	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
15	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
16	GPIT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status
17	GPIT_JUR_NATURE	Character(2)	VARCHAR2(2) NOT NULL	Juridical Nature
18	GPIT_SITUATION	Character(1)	VARCHAR2(1) NOT NULL	Situation
19	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
20	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
21	GPIT_TAX_CD	Character(16)	VARCHAR2(16) NOT NULL	Tax Code
22	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
23	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
24	BIRTHDATE	Date(10)	DATE	Date of Birth
25	GPIT_BIRTHPLACE	Character(40)	VARCHAR2(40) NOT NULL	Birth Place
26	BIRTHSTATE	Character(6)	VARCHAR2(6) NOT NULL	Birth State
27	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
28	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
29	POSTAL2	Character(12)	VARCHAR2(12) NOT NULL	Postal Code
30	CITY_AC	Character(30)	VARCHAR2(30) NOT NULL	Alternate Character City
31	STATE2	Character(6)	VARCHAR2(6) NOT NULL	State
32	PHONE2	Character(24)	VARCHAR2(24) NOT NULL	Phone number field for discounts and perks eligibility file.