| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 3 |
GPES_HELP_NEEDED |
Character(1) |
VARCHAR2(1) NOT NULL |
Payee requires assistance to go to work.
N=No
Y=Yes
|
| 4 |
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
Default Value: 3
|
| 5 |
GPES_NID_SPOUSE |
Character(10) |
VARCHAR2(10) NOT NULL |
NID Spouse
|
| 6 |
GPES_TAX_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Fiscal Territory. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
Prompt Table:
GPES_TAX_LOCATN
|
| 7 |
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
Default Value: N
|
| 8 |
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
Default Value: 1
|
| 9 |
HANDICAP_PCNT_ESP |
Number(3,0) |
SMALLINT NOT NULL |
Handicap Percent
|
| 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 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Type
Default Value: HOME
Prompt Table:
PERSON_ADDRESS
|
| 12 |
GPES_RED_GEO |
Character(1) |
VARCHAR2(1) NOT NULL |
Geographic Mobility reduction.
Y/N Table Edit
Default Value: N
|
| 13 |
GPES_RED_WORK_EXT |
Character(1) |
VARCHAR2(1) NOT NULL |
Work life Extension reduction.
Y/N Table Edit
Default Value: N
|
| 14 |
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
Default Value: N
|
| 15 |
GPES_TRANS_MOB |
Character(1) |
VARCHAR2(1) NOT NULL |
Transnational Mobility
Y/N Table Edit
Default Value: N
|
| 16 |
GPES_RESID_COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country of Residence
Prompt Table:
COUNTRY_TBL
|
| 17 |
GPES_PAY_COMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Compensation
Y/N Table Edit
Default Value: Y
|
| 18 |
GPES_TAX_CALC |
Character(1) |
VARCHAR2(1) NOT NULL |
Taxes Calculation
0=Not calculate
1=Pay IRPF (Regular Taxes)
2=Pay IRNR (Non-residents Taxes)
3=IRNR (Non-residents Not taxed)
Default Value: 1
|
| 19 |
GPES_SS_CALC |
Character(1) |
VARCHAR2(1) NOT NULL |
Social Security Calculation
Y/N Table Edit
Default Value: Y
|
| 20 |
GPES_ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address type.
Prompt Table:
GPES_EXPT_ADDR
|
| 21 |
NATIONAL_ID_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
National ID Type
Prompt Table:
GPES_PERSNID_VW
|
| 22 |
GPES_TUTOR_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Legal tutor employee ID. Legal tutors have to represent the child in exercising the child's rights. They must also protect the child's property by administering it prudently, diligently, honestly and loyally, in order to remit it to the child when they attain majority or are emancipated.
Prompt Table:
PERSON
|