GPIT_CUDE_TMP05

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GPIT_YEAR_NUM4	Number(4,0)	SMALLINT NOT NULL	Year
3	GPIT_RUN_MONTH	Character(2)	VARCHAR2(2) NOT NULL	A report could be runned on a 3 months period. This field will have the value of the month to be processed. 01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December
4	GPIT_COMP_CODFIS	Character(16)	VARCHAR2(16) NOT NULL	Company tax code
5	GPIT_INPS_POS_10	Character(10)	VARCHAR2(10) NOT NULL	INPS Position.
6	GPIT_TAX_CD_1	Character(16)	VARCHAR2(16) NOT NULL	Tax Code
7	EMPL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Employee Type E=Exception Hourly H=Hourly N=Not Applicable S=Salaried
8	WEEKOFYEAR	Number(2,0)	SMALLINT NOT NULL	Week Of Year
9	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
10	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
11	GPIT_TMP_NBR06_01	Number(6,0)	INTEGER NOT NULL	Temporary number field.
12	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
13	GPIT_SI_COVERAGE	Character(1)	VARCHAR2(1) NOT NULL	Insurance Coverage Type
14	ABSENCE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Absence Type
15	GPIT_SALARY	Number(19,6)	DECIMAL(18,6) NOT NULL	Lost Salary