GPIT_FCUD_T2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
6	SLICE_END_DT	Date(10)	DATE	Element Slice End Date
7	HIRE_DT	Date(10)	DATE	First Start Date
8	TERMINATION_DT	Date(10)	DATE	Termination Date
9	COMP_CODE_ITA	Character(30)	VARCHAR2(30) NOT NULL	Company Codes ITA
10	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
11	CITY_ITA	Character(50)	VARCHAR2(50) NOT NULL	City for Italy
12	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
13	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
14	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
15	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
16	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
17	PHONE1	Character(24)	VARCHAR2(24) NOT NULL	Phone number field for discounts and perks eligibility file.
18	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
19	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
20	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
21	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
22	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
23	BIRTHDATE	Date(10)	DATE	Date of Birth
24	BIRTHPLACE	Character(30)	VARCHAR2(30) NOT NULL	Birth Location
25	BIRTHSTATE	Character(6)	VARCHAR2(6) NOT NULL	Birth State
26	BIRTHCOUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Birth Country
27	GPIT_FPC_TYP	Character(2)	VARCHAR2(2) NOT NULL	Complementary Fund Type
28	CITY50	Character(50)	VARCHAR2(50) NOT NULL	City
29	STATE2	Character(6)	VARCHAR2(6) NOT NULL	State
30	CITY_CD_FC_ITA	Character(4)	VARCHAR2(4) NOT NULL	Fiscal Code for City
31	PRINT_DATE	Date(10)	DATE	Print Date
32	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
33	DESCR50_1	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50