GPES_SS_CNT_BSE(SQL Table) |
Index Back |
|---|---|
SS Contribution Definition.For each defined contribution, this record stores the base, the employer accumulator and the employee deduction pin number that has to be used for the Social Security calculations. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CONCEPT_ESP |
Character(2) | VARCHAR2(2) NOT NULL |
Social Security contribution concept
10=Common Contingency 20=Temporal Disability 30=Permanent Disability D & S 40=Professional Training 50=FOGASA 60=Unemployment 70=Structural Overtime 80=Non Structural Overtime |
| 2 | GPES_PIN_SS3_NUM | Number(8,0) | INTEGER NOT NULL |
This field houses the Pin Number of the Social Security Contribution Base
Prompt Table: %GP_EDIT_FLD5 |
| 3 | GPES_PIN_SS1_NUM | Number(8,0) | INTEGER NOT NULL |
This field houses the Employer SS Accumulator Pin Number.
Prompt Table: %GP_EDIT_FLD6 |
| 4 | GPES_PIN_SS2_NUM | Number(8,0) | INTEGER NOT NULL |
This field houses the Employee SS Deduction Pin Number.
Prompt Table: %GP_EDIT_FLD7 |
| 5 | GPES_PIN_SS4_NUM | Number(8,0) | INTEGER NOT NULL |
This field houses the Employee SS Deduction Pin Number.
Prompt Table: %GP_EDIT_FLD8 |
| 6 | GPES_PIN_SS5_NUM | Number(8,0) | INTEGER NOT NULL |
This field houses the Employer SS Accumulator Pin Number.
Prompt Table: %GP_EDIT_FLD5 |
| 7 | GPES_PIN_SS6_NUM | Number(8,0) | INTEGER NOT NULL |
This field houses the Employer SS Accumulator Pin Number.
Prompt Table: %GP_EDIT_FLD8 |
| 8 | GPES_PIN_SS7_NUM | Number(8,0) | INTEGER NOT NULL |
Reduction Pin Number
Prompt Table: %GP_EDIT_FLD7 |
| 9 | GPES_PIN_SS8_NUM | Number(8,0) | INTEGER NOT NULL |
Illness Base
Prompt Table: %GP_EDIT_FLD5 |
| 10 | GPES_PIN_SS0_NUM | Number(8,0) | INTEGER NOT NULL |
"Contributing by minimum base" base
Prompt Table: %GP_EDIT_FLD5 |
| 11 | GPES_PIN_SSA_NUM | Number(8,0) | INTEGER NOT NULL |
Extended illness base
Prompt Table: %GP_EDIT_FLD5 |
| 12 | GPES_PIN_SSB_NUM | Number(8,0) | INTEGER NOT NULL |
Extended AT/EP base
Prompt Table: %GP_EDIT_FLD5 |