GPES_TAX_R_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
4	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
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	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
11	GPES_TAX_BASE	Number(11,2)	DECIMAL(10,2) NOT NULL	Taxable base. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
12	GPES_TAX_BSE_FIXED	Number(11,2)	DECIMAL(10,2) NOT NULL	Taxable fixed base. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
13	GPES_TAX_BSE_INKND	Number(11,2)	DECIMAL(10,2) NOT NULL	Taxable in kind base. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
14	GPES_TAX_BSE_VRBLE	Number(11,2)	DECIMAL(10,2) NOT NULL	Taxable variable base. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
15	GPES_TAX_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Withholding percentage calculated. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
16	GPES_TAX_CONTRIBTN	Number(11,2)	DECIMAL(10,2) NOT NULL	Tax contribution. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
17	GPES_SS_CT_EE	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Employee Social Security contribution
18	GPES_TAX_MIN_FAMLR	Number(14,2)	DECIMAL(13,2) NOT NULL	Family Minimum Reduction. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
19	GPES_TAX_MIN_PERS	Number(14,2)	DECIMAL(13,2) NOT NULL	Personal Minimum Reduction. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
20	GPES_TAX_REDUCTION	Number(14,2)	DECIMAL(13,2) NOT NULL	Tax Reduction.
21	GPES_TAX_400E_DED	Number(14,2)	DECIMAL(13,2) NOT NULL	Deduction due article 80bis LIRPF (400 Euros deduction)
22	GPES_TAX_CALC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Tax calculation process type. This field is used to populate the GP Write Array, which is used to generate the Tax Reports. C=Calculated U=User Updated
23	GPES_GARN_SPOUSE	Number(16,2)	DECIMAL(15,2) NOT NULL	Amount paid by the payee in concept of garnishment for spouse alimony.
24	GPES_GARN_CHILDREN	Number(16,2)	DECIMAL(15,2) NOT NULL	Amount paid by the payee in concept of garnishment for children alimony.
25	GPES_CEUTA_MELILLA	Character(1)	VARCHAR2(1) NOT NULL	Payee is working in Spanish cities Ceuta or Melilla. This cities has a special tax status.
26	GPES_DISABLTY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of disability. 0=No Disabled 1=Disability 33%- 65% 2=Disability 33-65% Need Help 3=Disability > 65%
27	GPES_FAMLR_SITUATN	Character(1)	VARCHAR2(1) NOT NULL	Family situation. 1=1.- With fiscal dependent 2=2.- With spouse to support 3=3.- Other situations
28	GPES_NID_SPOUSE	Character(10)	VARCHAR2(10) NOT NULL	NID Spouse
29	GPES_DEPN_TOTAL	Number(3,0)	SMALLINT NOT NULL	Total number of descendants.
30	GPES_DEPN_UNDER3	Number(3,0)	SMALLINT NOT NULL	Number of dependents younger than 3 years old.
31	GPES_DEPN_3_16	Number(3,0)	SMALLINT NOT NULL	Number of dependents between 6 and 16 years old.
32	GPES_DEPN_16_25	Number(3,0)	SMALLINT NOT NULL	Number of dependents between 16 and 25 years old.
33	GPES_DEPN_DISBL33	Number(3,0)	SMALLINT NOT NULL	Number of descendants with disability between 33% and 65%.
34	GPES_DEPN_DISBL65	Number(3,0)	SMALLINT NOT NULL	Number of descendants with disability greater than 65%.
35	GPES_RELSHIP_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Labor Relationship Type. 1=1.- General Relationship 2=2.- Less 1 Year Relationship 3=3.- Special Relationship
36	GPES_DEPN_ENTIRELY	Number(2,0)	SMALLINT NOT NULL	Number of descendants depending upon the payee entirely.
37	GPES_ASC_TOTAL	Number(1,0)	SMALLINT NOT NULL	Total number of ascendants.
38	GPES_ASC_ENTIRELY	Number(1,0)	SMALLINT NOT NULL	Number of ascendants depending upon the payee entirely.
39	GPES_ASC_DISBL33	Number(1,0)	SMALLINT NOT NULL	Number of ascendants with disability between 33% and 65%.
40	GPES_ASC_DISBL65	Number(1,0)	SMALLINT NOT NULL	Number of ascendants with disability greater than 65%.
41	GPES_DEPN_UND3_X1	Number(3,0)	SMALLINT NOT NULL	Descendants under 3 years whole
42	GPES_DEPN_UP3	Number(3,0)	SMALLINT NOT NULL	Descendants upto 3 years
43	GPES_DEPN_UP3_X1	Number(3,0)	SMALLINT NOT NULL	Descendants upto 3 years old whole
44	GPES_DEPN_D33_X1	Number(3,0)	SMALLINT NOT NULL	33-65% disabled descendants whole
45	GPES_DEPN_D65_X1	Number(3,0)	SMALLINT NOT NULL	+65% disabled descendants whole
46	GPES_DEPN_ASST	Number(3,0)	SMALLINT NOT NULL	Need assistance dependents
47	GPES_DEPN_ASST_X1	Number(3,0)	SMALLINT NOT NULL	Need assistance dependents whole
48	GPES_DEPN_CHILD1	Number(1,0)	SMALLINT NOT NULL	First descendant dependancy.
49	GPES_DEPN_CHILD2	Number(1,0)	SMALLINT NOT NULL	Second Descendant Dependency
50	GPES_DEPN_CHILD3	Number(1,0)	SMALLINT NOT NULL	Third Descendant Dependency
51	GPES_ASC_UND75	Number(3,0)	SMALLINT NOT NULL	Under 75 years ascendants
52	GPES_ASC_UND75_X1	Number(3,0)	SMALLINT NOT NULL	Under 75 years ascendants whole
53	GPES_ASC_UP75	Number(3,0)	SMALLINT NOT NULL	Ascendants greater than 75 years old.
54	GPES_ASC_UP75_X1	Number(3,0)	SMALLINT NOT NULL	Ascendants greater than 75 years old whole
55	GPES_ASC_D33_X1	Number(3,0)	SMALLINT NOT NULL	33-65% disabled ascendants
56	GPES_ASC_D65_X1	Number(3,0)	SMALLINT NOT NULL	+65% disabled ascendants
57	GPES_ASC_ASST	Number(3,0)	SMALLINT NOT NULL	Need assistance ascendants
58	GPES_ASC_ASST_X1	Number(3,0)	SMALLINT NOT NULL	Need assistance ascendants whole
59	GPES_RED_GEO	Character(1)	VARCHAR2(1) NOT NULL	Geographic Mobility reduction.
60	GPES_RED_WORK_EXT	Character(1)	VARCHAR2(1) NOT NULL	Work life Extension reduction.
61	GPES_RED_MORTGAGE	Character(1)	VARCHAR2(1) NOT NULL	Eligibility Flag for Home Mortgage Reduction 1=Reduction From 2011 1=Reduction From 2011 N=No Reduction Y=Reduction Y=Reduction Before 2011
62	GPES_TAX_MORTGAGE	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Tax Reduction due home mortgage
63	GPES_TAX_MORTG_PRE	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Previous Tax Reduction due home mortgage
64	RSLT_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Result Version Number
65	RSLT_REV_NUM	Number(4,0)	SMALLINT NOT NULL	Result Revision Number
66	GPES_TAX_INC_IRREG	Number(14,2)	DECIMAL(13,2) NOT NULL	Taxable base. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
67	GPES_TAX_NET_BS	Number(14,2)	DECIMAL(13,2) NOT NULL	Taxable base. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
68	GPES_TAX_AC_CT	Number(14,2)	DECIMAL(13,2) NOT NULL	Taxable base. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
69	GPES_TAX_AC_TOT	Number(14,2)	DECIMAL(13,2) NOT NULL	Taxable base. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.