GPES_CPER_TMP(SQL Table) |
Index Back |
|---|---|
Personal Information for IRPFPersonal Information for IRPF |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 6 | GPES_MONTHCD | Character(2) | VARCHAR2(2) NOT NULL |
Month
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 |
| 7 | 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% |
| 8 | 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. |
| 9 | GPES_RED_GEO | Character(1) | VARCHAR2(1) NOT NULL | Geographic Mobility reduction. |
| 10 | GPES_RED_WORK_EXT | Character(1) | VARCHAR2(1) NOT NULL | Work life Extension reduction. |
| 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_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 |
| 13 | ORIG_DEP_BENEF | Character(2) | VARCHAR2(2) NOT NULL | Original Dependent Beneficiary |
| 14 | 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. |
| 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_SS_CT_EE | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Employee Social Security contribution |
| 17 | GPES_TOT_REDUCTION | Number(16,3) | DECIMAL(15,3) NOT NULL | Total Reductions |
| 18 | GPES_REDUCTIONS | Number(16,2) | DECIMAL(15,2) NOT NULL | Taxes reductions |
| 19 | GPES_SALARY_WITHLD | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Salary Withholding. |
| 20 | GPES_SALARY_INCOME | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Salary Income. |