GPES_NRP_SS1_VW(SQL View) |
Index Back |
|---|---|
SS Contribution DefinitionSS Contribution Definition, for non-rule packager export view |
| SELECT CONCEPT_ESP ,GPES_PIN_SS3_NUM + 50000000 ,GPES_PIN_SS1_NUM + 50000000 ,GPES_PIN_SS2_NUM + 50000000 ,GPES_PIN_SS4_NUM + 50000000 ,GPES_PIN_SS5_NUM + 50000000 ,GPES_PIN_SS6_NUM + 50000000 ,GPES_PIN_SS7_NUM + 50000000 ,GPES_PIN_SS8_NUM + 50000000 ,GPES_PIN_SS0_NUM + 50000000 ,GPES_PIN_SSA_NUM + 50000000 ,GPES_PIN_SSB_NUM + 50000000 ,GPES_PIN_SSE_NUM + 50000000 FROM PS_GPES_SS_CNT_BSE |
| # | 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 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 |
| 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. |
| 7 | GPES_PIN_SS6_NUM | Number(8,0) | INTEGER NOT NULL | This field houses the Employer SS Accumulator Pin Number. |
| 8 | GPES_PIN_SS7_NUM | Number(8,0) | INTEGER NOT NULL | Reduction Pin Number |
| 9 | GPES_PIN_SS8_NUM | Number(8,0) | INTEGER NOT NULL | Illness Base |
| 10 | GPES_PIN_SS0_NUM | Number(8,0) | INTEGER NOT NULL | "Contributing by minimum base" base |
| 11 | GPES_PIN_SSA_NUM | Number(8,0) | INTEGER NOT NULL | Extended illness base |
| 12 | GPES_PIN_SSB_NUM | Number(8,0) | INTEGER NOT NULL | Extended AT/EP base |
| 13 | GPES_PIN_SSE_NUM | Number(8,0) | INTEGER NOT NULL | ERE contribution base |