GPES_CTZ_SUM_VW (SQL View)	Index Back
SS Contribution Definition This record stores Social Security contribution definition for each concept. Each contribution can be defined as a base percentage, or as a fixed amount. This record houses the employer and employee information.

GPES_CTZ_SUM_VW

(SQL View)

SS Contribution Definition

This record stores Social Security contribution definition for each concept. Each contribution can be defined as a base percentage, or as a fixed amount. This record houses the employer and employee information.

SELECT S.SCHEME_ID_ESP , S.CURRENCY_CD , S.EFFDT , B.CONTRIB_ID_ESP , S.EFF_STATUS , B.CONTRIB_TYPE_ESP , A.CONCEPT_ESP , A.EE_PERCENT_ESP , A.EE_RATE_ESP FROM PS_SOC_SEC_RGM_TBL S , PS_CTZ_DTA_ESP_TBL A , PS_RGM_CTZ_ESP_TBL B WHERE A.SCHEME_ID_ESP = S.SCHEME_ID_ESP AND A.CURRENCY_CD = S.CURRENCY_CD AND A.EFFDT = S.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 A.CONCEPT_ESP IN ('10', '40', '60')

# 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 NOT NULL Effective Date
Default Value: %date

4 CONTRIB_ID_ESP Character(5) VARCHAR2(5) NOT NULL Soc.Sec. Contribution ID - ESP

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

6 CONTRIB_TYPE_ESP Character(2) VARCHAR2(2) NOT NULL Soc.Sec. Contribution Type - ESP
10=Percentage
20=Rate

7 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

8 GPES_SS_EE_PCT Signed Number(11,6) DECIMAL(9,6) NOT NULL Social Security Employee Percentage. This field houses the percentage that has to be aplied to a particular base for contibuting to the Social Security. This information is from the Employee perspective.

9 GPES_SS_EE_CTA Signed Number(20,6) DECIMAL(18,6) NOT NULL Social Security Employee Rate This field houses the amount that has to be paid to Social Security contributions. This is a fixed number. This information is from Employee perspective.

#	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 NOT NULL	Effective Date Default Value: %date
4	CONTRIB_ID_ESP	Character(5)	VARCHAR2(5) NOT NULL	Soc.Sec. Contribution ID - ESP
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	CONTRIB_TYPE_ESP	Character(2)	VARCHAR2(2) NOT NULL	Soc.Sec. Contribution Type - ESP 10=Percentage 20=Rate
7	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
8	GPES_SS_EE_PCT	Signed Number(11,6)	DECIMAL(9,6) NOT NULL	Social Security Employee Percentage. This field houses the percentage that has to be aplied to a particular base for contibuting to the Social Security. This information is from the Employee perspective.
9	GPES_SS_EE_CTA	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Social Security Employee Rate This field houses the amount that has to be paid to Social Security contributions. This is a fixed number. This information is from Employee perspective.