GPIT_770_RP_003

#	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	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
6	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
7	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
8	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
9	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
10	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
11	BIRTHDATE	Date(10)	DATE	Date of Birth
12	BIRTHPLACE	Character(30)	VARCHAR2(30) NOT NULL	Birth Location
13	GPIT_FPC_TYP	Character(2)	VARCHAR2(2) NOT NULL	Complementary Fund Type
14	GPIT_770_SPCL_CTG	Character(2)	VARCHAR2(2) NOT NULL	Special Category
15	CITY50	Character(50)	VARCHAR2(50) NOT NULL	City
16	STATE2	Character(6)	VARCHAR2(6) NOT NULL	State
17	CITY_CD_FC_ITA	Character(4)	VARCHAR2(4) NOT NULL	Fiscal Code for City
18	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
19	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company