GPES_NRP_SS1_AD

(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 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_SS3_NUM Number(8,0) INTEGER NOT NULL This field houses the Pin Number of the Social Security Contribution Base
4 GPES_PIN_SS1_NUM Number(8,0) INTEGER NOT NULL This field houses the Employer SS Accumulator Pin Number.
5 GPES_PIN_SS2_NUM Number(8,0) INTEGER NOT NULL This field houses the Employee SS Deduction Pin Number.
6 GPES_PIN_SS4_NUM Number(8,0) INTEGER NOT NULL This field houses the Employee SS Deduction Pin Number.
7 GPES_PIN_SS5_NUM Number(8,0) INTEGER NOT NULL This field houses the Employer SS Accumulator Pin Number.
8 GPES_PIN_SS6_NUM Number(8,0) INTEGER NOT NULL This field houses the Employer SS Accumulator Pin Number.
9 GPES_PIN_SS7_NUM Number(8,0) INTEGER NOT NULL Reduction Pin Number
10 GPES_PIN_SS8_NUM Number(8,0) INTEGER NOT NULL Illness Base
11 GPES_PIN_SS0_NUM Number(8,0) INTEGER NOT NULL "Contributing by minimum base" base
12 GPES_PIN_SSA_NUM Number(8,0) INTEGER NOT NULL Extended illness base
13 GPES_PIN_SSB_NUM Number(8,0) INTEGER NOT NULL Extended AT/EP base
14 GPES_PIN_SSE_NUM Number(8,0) INTEGER NOT NULL ERE contribution base