GPES_NRP_SS1_VW

(SQL View)
 Index Back

SS Contribution Definition

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