GP_PKG_IDCONCEPT_ESP10=Common Contingency
15=Intergen. Equity Mechanism
20=Temporal Disability
30=Permanent Disability D & S
40=Professional Training
50=FOGASA
60=Unemployment
70=Force Majeure Overtime
80=Ordinary Overtime
GPES_NRP_SS2_AD(SQL Table) |
Index Back |
|---|---|
SS Reduction CalculationFor each defined contribution, this record stores the base, the SS reduction and INEM reduction pin number that has to be used for Social Security calculations. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | CONCEPT_ESP |
Character(2) | VARCHAR2(2) NOT NULL |
Social Security contribution concept
10=Common Contingency 15=Intergen. Equity Mechanism 20=Temporal Disability 30=Permanent Disability D & S 40=Professional Training 50=FOGASA 60=Unemployment 70=Force Majeure Overtime 80=Ordinary Overtime |
| 3 | GPES_PIN_SS1_NUM | Number(8,0) | INTEGER NOT NULL | This field houses the Employer SS Accumulator Pin Number. |
| 4 | GPES_PIN_SS5_NUM | Number(8,0) | INTEGER NOT NULL | This field houses the Employer SS Accumulator Pin Number. |
| 5 | GPES_PIN_SS6_NUM | Number(8,0) | INTEGER NOT NULL | This field houses the Employer SS Accumulator Pin Number. |
| 6 | GPES_PIN_SS7_NUM | Number(8,0) | INTEGER NOT NULL | Reduction Pin Number |
| 7 | GPES_PIN_SS2_NUM | Number(8,0) | INTEGER NOT NULL | This field houses the Employee SS Deduction Pin Number. |
| 8 | GPES_PIN_SS3_NUM | Number(8,0) | INTEGER NOT NULL | This field houses the Pin Number of the Social Security Contribution Base |
| 9 | GPES_PIN_SS4_NUM | Number(8,0) | INTEGER NOT NULL | This field houses the Employee SS Deduction Pin Number. |
| 10 | GPES_PIN_SSE_NUM | Number(8,0) | INTEGER NOT NULL | ERE contribution base |