GPES_SS_CTZ_VW

(SQL View)
 Index Back

EE Contribution

This view retrieves the employee's contribution, as well as the percentage to be applied to the corresponding base, or fix rate. This information is used in Social Security formulas.

SELECT A.SCHEME_ID_ESP , A.CURRENCY_CD , A.EFFDT , A.CONTRIB_ID_ESP , B.CONCEPT_ESP , S.EFF_STATUS , A.SSN_EMPL_TYPE , A.CONTRIB_TYPE_ESP , B.EE_PERCENT_ESP , B.ER_PERCENT_ESP , B.EE_RATE_ESP , B.ER_RATE_ESP , C.GPES_PIN_SS3_NUM , C.GPES_PIN_SS1_NUM , C.GPES_PIN_SS2_NUM , C.GPES_PIN_SS4_NUM , C.GPES_PIN_SS5_NUM , C.GPES_PIN_SS6_NUM , C.GPES_PIN_SS7_NUM , C.GPES_PIN_SS8_NUM , C.GPES_PIN_SS0_NUM , C.GPES_PIN_SSA_NUM , C.GPES_PIN_SSB_NUM , C.GPES_PIN_SSE_NUM FROM PS_SOC_SEC_RGM_TBL S , PS_RGM_CTZ_ESP_TBL A , PS_CTZ_DTA_ESP_TBL B , PS_GPES_SS_CNT_BSE C WHERE S.SCHEME_ID_ESP = A.SCHEME_ID_ESP AND S.CURRENCY_CD = A.CURRENCY_CD AND S.EFFDT = A.EFFDT AND A.SCHEME_ID_ESP = B.SCHEME_ID_ESP AND A.CURRENCY_CD = B.CURRENCY_CD AND A.EFFDT = B.EFFDT AND A.CONTRIB_ID_ESP = B.CONTRIB_ID_ESP AND C.CONCEPT_ESP = B.CONCEPT_ESP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCHEME_ID_ESP Character(4) VARCHAR2(4) NOT NULL Scheme ID - ESP
2 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 CONTRIB_ID_ESP Character(5) VARCHAR2(5) NOT NULL Soc.Sec. Contribution ID - ESP
5 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
6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
7 SSN_EMPL_TYPE Character(3) VARCHAR2(3) NOT NULL Social Security Number Type
1=Regular
2=Apprenticeship
3=Training
8 CONTRIB_TYPE_ESP Character(2) VARCHAR2(2) NOT NULL Soc.Sec. Contribution Type - ESP
10=Percentage
20=Rate
9 EE_PERCENT_ESP Signed Number(11,6) DECIMAL(9,6) NOT NULL Employee Percentage - ESP
10 ER_PERCENT_ESP Signed Number(11,6) DECIMAL(9,6) NOT NULL Employer Percentage - ESP
11 EE_RATE_ESP Signed Number(20,6) DECIMAL(18,6) NOT NULL Employee Rate - ESP
12 ER_RATE_ESP Signed Number(20,6) DECIMAL(18,6) NOT NULL Employer Rate - ESP
13 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

14 GPES_PIN_SS1_NUM Number(8,0) INTEGER NOT NULL This field houses the Employer SS Accumulator Pin Number.

Prompt Table: %GP_EDIT_FLD6

15 GPES_PIN_SS2_NUM Number(8,0) INTEGER NOT NULL This field houses the Employee SS Deduction Pin Number.

Prompt Table: %GP_EDIT_FLD7

16 GPES_PIN_SS4_NUM Number(8,0) INTEGER NOT NULL This field houses the Employee SS Deduction Pin Number.

Prompt Table: %GP_EDIT_FLD8

17 GPES_PIN_SS5_NUM Number(8,0) INTEGER NOT NULL This field houses the Employer SS Accumulator Pin Number.
18 GPES_PIN_SS6_NUM Number(8,0) INTEGER NOT NULL This field houses the Employer SS Accumulator Pin Number.
19 GPES_PIN_SS7_NUM Number(8,0) INTEGER NOT NULL Reduction Pin Number
20 GPES_PIN_SS8_NUM Number(8,0) INTEGER NOT NULL Illness Base
21 GPES_PIN_SS0_NUM Number(8,0) INTEGER NOT NULL "Contributing by minimum base" base

Prompt Table: %GP_EDIT_FLD5

22 GPES_PIN_SSA_NUM Number(8,0) INTEGER NOT NULL Extended illness base
23 GPES_PIN_SSB_NUM Number(8,0) INTEGER NOT NULL Extended AT/EP base
24 GPES_PIN_SSE_NUM Number(8,0) INTEGER NOT NULL ERE contribution base