GPIT_RP_002_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
4	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
6	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
7	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
8	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
9	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
10	SLICE_END_DT	Date(10)	DATE	Element Slice End Date
11	GPIT_BASE_SALARY	Number(19,6)	DECIMAL(18,6) NOT NULL	Base Salary for reports
12	GPIT_CONTINGENCY	Number(19,6)	DECIMAL(18,6) NOT NULL	Contingency for reports
13	GPIT_SENIORITY	Number(19,6)	DECIMAL(18,6) NOT NULL	Seniority for reports
14	GPIT_SUPERMINIMO	Number(19,6)	DECIMAL(18,6) NOT NULL	Superminimo for reports
15	GPIT_TOT_FIX_ELEM	Number(19,6)	DECIMAL(18,6) NOT NULL	Total of fixed elements for reports
16	GPIT_DAILY_RATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Daily rate for reports
17	GPIT_HOURLY_RATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Hourly rate for reports
18	GPIT_WORKED_DAYS	Number(5,2)	DECIMAL(4,2) NOT NULL	Worked days for reports
19	GPIT_WORKED_HRS	Number(3,0)	SMALLINT NOT NULL	Worked hours for reports
20	GPIT_PREV_ROUND	Number(19,6)	DECIMAL(18,6) NOT NULL	Previous rounding for reports
21	GPIT_CURR_ROUND	Number(19,6)	DECIMAL(18,6) NOT NULL	Current rounding for reports
22	GPIT_NET_TO_PAY	Number(19,6)	DECIMAL(18,6) NOT NULL	Net to pay for reports
23	GPIT_INAIL_INCOME	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	INAIL Income for reports
24	GPIT_CTR_INCOME	Number(19,6)	DECIMAL(18,6) NOT NULL	CTR income for reports
25	GPIT_IVS	Number(19,6)	DECIMAL(18,6) NOT NULL	Compulsary Pension deduction for reports
26	GPIT_IVS_AGG	Number(19,6)	DECIMAL(18,6) NOT NULL	Additional IVS for reports
27	GPIT_CIG	Number(19,6)	DECIMAL(18,6) NOT NULL	CIG deducion for reports
28	GPIT_FPC_INCOME	Number(19,6)	DECIMAL(18,6) NOT NULL	Facultative Pension deduction for reports
29	GPIT_FPC_EMPLOYER	Number(19,6)	DECIMAL(18,6) NOT NULL	Facultative Pension employer's deduction for reports
30	GPIT_FPC_EMPLOYEE	Number(16,3)	DECIMAL(15,3) NOT NULL	Facultative Pension employee's deduction for reports
31	GPIT_CTR_FPC_TFR	Number(19,6)	DECIMAL(18,6) NOT NULL	Facultative Pension deduction for TFR for reports
32	GPIT_TOT_CTR	Number(19,6)	DECIMAL(18,6) NOT NULL	Total of contribution for reports
33	GPIT_TAX_INCOME	Number(19,6)	DECIMAL(18,6) NOT NULL	Tax income for reports
34	GPIT_GROSS_IRPEF	Number(19,6)	DECIMAL(18,6) NOT NULL	Gross IRPEF for reports
35	GPIT_NET_IRPEF	Number(19,6)	DECIMAL(18,6) NOT NULL	Net IRPEF for reports
36	GPIT_INC_FOR_TFR	Number(19,6)	DECIMAL(18,6) NOT NULL	Income for TFR for reports
37	GPIT_TAX_RED_DAYS	Number(19,6)	DECIMAL(18,6) NOT NULL	Tax reduction days for reports
38	GPIT_TAX_RED_WORK	Number(19,6)	DECIMAL(18,6) NOT NULL	Dependent work detraction for reports
39	GPIT_SPOUSE_DETR	Number(19,6)	DECIMAL(18,6) NOT NULL	Spouse detraction for reports
40	GPIT_DEP_DET	Number(19,6)	DECIMAL(18,6) NOT NULL	Dependent detractions for reports
41	GPIT_DEDUCT_COST	Number(16,3)	DECIMAL(15,3) NOT NULL	Deductible costs for reports
42	GPIT_TOT_DETR	Number(19,6)	DECIMAL(18,6) NOT NULL	Total of detractions for reports
43	GPIT_ALTRCOMP_INC	Number(19,6)	DECIMAL(18,6) NOT NULL	INPS other payments income
44	GPIT_COMPCORR_INC	Number(19,6)	DECIMAL(18,6) NOT NULL	INPS current payments income
45	GPIT_EVR_CCPOS	Number(19,6)	DECIMAL(18,6) NOT NULL	INPS EVR current payments +
46	GPIT_EVR_CCNEG	Number(19,6)	DECIMAL(18,6) NOT NULL	INPS EVR current payment -
47	GPIT_EVR_ACPOS	Number(19,6)	DECIMAL(18,6) NOT NULL	INPS EVR other payments +
48	GPIT_EVR_ACNEG	Number(19,6)	DECIMAL(18,6) NOT NULL	INPS EVR other payments -
49	GPIT_INPS_PTWEEKS	Number(5,2)	DECIMAL(4,2) NOT NULL	INPS part time weeks
50	GPIT_INPS_CONTRIB	Number(19,6)	DECIMAL(18,6) NOT NULL	Total mandatory contributions
51	GPIT_INPS_BONUS	Number(19,6)	DECIMAL(18,6) NOT NULL	Late Retirement Total Bonus
52	GPIT_INCOME_1002	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Income 1002
53	GPIT_IRPEF_1002	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	IRPEF 1002
54	GPIT_AMT_NOIVSASS	Number(19,6)	DECIMAL(18,6) NOT NULL	Field for the Previdential CUD Report which contains the amount of IVS not asseassable
55	GPIT_INPD_CYINCOME	Number(19,6)	DECIMAL(18,6) NOT NULL	Field which contains the INPDAI monthly income for current year
56	GPIT_INPD_PYINCOME	Number(19,6)	DECIMAL(18,6) NOT NULL	Field which contains the INPDAI monthly income for previous year
57	GPIT_INPD_MONTDAYS	Number(2,0)	SMALLINT NOT NULL	Field which contains the INPDAI monthly days
58	GPIT_INPD_EMPLCTR	Number(19,6)	DECIMAL(18,6) NOT NULL	Field which contains the INPDAI employee contributions
59	GPIT_INPD_CONVINC	Number(19,6)	DECIMAL(18,6) NOT NULL	Field which contains the INPDAI conventionate income
60	GPIT_PYSL_AMTH3	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Dummy charcter
61	GPIT_PYSL_AMTH4	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Dummy number
62	GPIT_PYSL_AMTH5	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Dummy number
63	GPIT_PYSL_AMTH6	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Dummy number
64	GPIT_PYSL_AMTH7	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	dummy number
65	GPIT_PYSL_AMTH8	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Dummy number
66	GPIT_PYSL_AMTH9	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Dummy number
67	GPIT_PYSL_AMTF1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Dummy number
68	GPIT_PYSL_AMTF2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Dummy number
69	GPIT_PYSL_AMTF3	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Dummy number
70	GPIT_PYSL_AMTF4	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Dummy number
71	GPIT_PYSL_AMTF5	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Dummy number
72	GPIT_PYSL_AMTF6	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Dummy number
73	GPIT_PYSL_AMTF7	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Workable days (from monday to saturday) in segment. Field of the record GPIT_RP_0002 and used in the Cud Social Security AE.
74	GPIT_PYSL_AMTF8	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Dummy number
75	GPIT_SBONUS_AMT	Number(9,0)	DECIMAL(9) NOT NULL	Amount
76	GPIT_SBONUS_BGN_DT	Date(10)	DATE	Begin Date.