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
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.

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

13 GPES_PIN_SSE_NUM Number(8,0) INTEGER NOT NULL ERE contribution base

Prompt Table: %GP_EDIT_FLD5