GPES_TAX_EE_DTA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
7	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
8	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
9	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. Y/N Table Edit
10	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%
11	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
12	GPES_NID_SPOUSE	Character(10)	VARCHAR2(10) NOT NULL	NID Spouse
13	GPES_DEPN_TOTAL	Number(3,0)	SMALLINT NOT NULL	Total number of descendants.
14	GPES_DEPN_UNDER3	Number(3,0)	SMALLINT NOT NULL	Number of dependents younger than 3 years old.
15	GPES_DEPN_3_16	Number(3,0)	SMALLINT NOT NULL	Number of dependents between 6 and 16 years old.
16	GPES_DEPN_16_25	Number(3,0)	SMALLINT NOT NULL	Number of dependents between 16 and 25 years old.
17	GPES_DEPN_DISBL33	Number(3,0)	SMALLINT NOT NULL	Number of descendants with disability between 33% and 65%.
18	GPES_DEPN_DISBL65	Number(3,0)	SMALLINT NOT NULL	Number of descendants with disability greater than 65%.
19	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
20	GPES_DEPN_ENTIRELY	Number(2,0)	SMALLINT NOT NULL	Number of descendants depending upon the payee entirely.
21	GPES_ASC_TOTAL	Number(1,0)	SMALLINT NOT NULL	Total number of ascendants.
22	GPES_ASC_ENTIRELY	Number(1,0)	SMALLINT NOT NULL	Number of ascendants depending upon the payee entirely.
23	GPES_ASC_DISBL65	Number(1,0)	SMALLINT NOT NULL	Number of ascendants with disability greater than 65%.
24	GPES_ASC_DISBL33	Number(1,0)	SMALLINT NOT NULL	Number of ascendants with disability between 33% and 65%.
25	GPES_DEPN_UND3_X1	Number(3,0)	SMALLINT NOT NULL	Descendants under 3 years whole
26	GPES_DEPN_UP3	Number(3,0)	SMALLINT NOT NULL	Descendants up 3 years
27	GPES_DEPN_UP3_X1	Number(3,0)	SMALLINT NOT NULL	Descendants up 3 years whole
28	GPES_DEPN_D33_X1	Number(3,0)	SMALLINT NOT NULL	33-65% disabled descendants whole
29	GPES_DEPN_D65_X1	Number(3,0)	SMALLINT NOT NULL	+65% disabled descendants whole
30	GPES_DEPN_ASST	Number(3,0)	SMALLINT NOT NULL	Need assistance dependents
31	GPES_DEPN_ASST_X1	Number(3,0)	SMALLINT NOT NULL	Need assistance dependents whole
32	GPES_ASC_UND75	Number(3,0)	SMALLINT NOT NULL	Under 75 years ascendants
33	GPES_ASC_UND75_X1	Number(3,0)	SMALLINT NOT NULL	Under 75 years ascendants whole
34	GPES_ASC_UP75	Number(3,0)	SMALLINT NOT NULL	Up 75 years ascendants
35	GPES_ASC_UP75_X1	Number(3,0)	SMALLINT NOT NULL	Up 75 years ascendants whole
36	GPES_ASC_D33_X1	Number(3,0)	SMALLINT NOT NULL	33-65% disabled ascendants
37	GPES_ASC_D65_X1	Number(3,0)	SMALLINT NOT NULL	+65% disabled ascendants
38	GPES_ASC_ASST	Number(3,0)	SMALLINT NOT NULL	Need assistance ascendants
39	GPES_ASC_ASST_X1	Number(3,0)	SMALLINT NOT NULL	Need assistance ascendants whole
40	GPES_RED_GEO	Character(1)	VARCHAR2(1) NOT NULL	Geographic Mobility reduction.
41	GPES_RED_WORK_EXT	Character(1)	VARCHAR2(1) NOT NULL	Work life Extension reduction.