GPES_NRP_SS2_VW(SQL View) |
Index Back |
|---|---|
SS Reduction DefinitionSS Reduction Definition, for non-rule packager export view |
| SELECT CONCEPT_ESP ,GPES_PIN_SS1_NUM + 50000000 ,GPES_PIN_SS5_NUM + 50000000 ,GPES_PIN_SS6_NUM + 50000000 ,GPES_PIN_SS7_NUM + 50000000 ,GPES_PIN_SS2_NUM + 50000000 ,GPES_PIN_SS3_NUM + 50000000 ,GPES_PIN_SS4_NUM + 50000000 FROM PS_GPES_SS_BNF_DEF |
| # | 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_SS1_NUM | Number(8,0) | INTEGER NOT NULL |
This field houses the Employer SS Accumulator Pin Number.
Prompt Table: %GP_EDIT_FLD6 |
| 3 | GPES_PIN_SS5_NUM | Number(8,0) | INTEGER NOT NULL |
This field houses the Employer SS Accumulator Pin Number.
Prompt Table: %GP_EDIT_FLD8 |
| 4 | GPES_PIN_SS6_NUM | Number(8,0) | INTEGER NOT NULL |
This field houses the Employer SS Accumulator Pin Number.
Prompt Table: %GP_EDIT_FLD9 |
| 5 | GPES_PIN_SS7_NUM | Number(8,0) | INTEGER NOT NULL |
Reduction Pin Number
Prompt Table: %GP_EDIT_FLD7 |
| 6 | GPES_PIN_SS2_NUM | Number(8,0) | INTEGER NOT NULL | This field houses the Employee SS Deduction Pin Number. |
| 7 | GPES_PIN_SS3_NUM | Number(8,0) | INTEGER NOT NULL | This field houses the Pin Number of the Social Security Contribution Base |
| 8 | GPES_PIN_SS4_NUM | Number(8,0) | INTEGER NOT NULL | This field houses the Employee SS Deduction Pin Number. |