GPES_SS_BNF_DTA (SQL Table)	Index Back
SS Reduction Percentages GPES_SS_BNF_DTA is child of GPES_SS_BNF. This table houses the reduction percentages and the valid time frame.

GPES_SS_BNF_DTA

(SQL Table)

SS Reduction Percentages

GPES_SS_BNF_DTA is child of GPES_SS_BNF. This table houses the reduction percentages and the valid time frame.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 REDUCTION_ID_ESP Character(3) VARCHAR2(3) NOT NULL Reduction ID

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 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

4 GPES_SS_BONIF_FROM Number(3,0) SMALLINT NOT NULL This field houses the month number to where the reduction takes place.

5 GPES_SS_BONIF_TO Number(3,0) SMALLINT NOT NULL This field houses the month number from where the reduction takes place.

6 GPES_SS_BONIF_PCT Signed Number(11,6) DECIMAL(9,6) NOT NULL Reduction Percentage. This field houses the percentage that has to be applied to a particular base for Social Security Reduction.

7 GPES_SS_BONIF_AMT Number(10,2) DECIMAL(9,2) NOT NULL Reduction Annual Amount

8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REDUCTION_ID_ESP	Character(3)	VARCHAR2(3) NOT NULL	Reduction ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	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
4	GPES_SS_BONIF_FROM	Number(3,0)	SMALLINT NOT NULL	This field houses the month number to where the reduction takes place.
5	GPES_SS_BONIF_TO	Number(3,0)	SMALLINT NOT NULL	This field houses the month number from where the reduction takes place.
6	GPES_SS_BONIF_PCT	Signed Number(11,6)	DECIMAL(9,6) NOT NULL	Reduction Percentage. This field houses the percentage that has to be applied to a particular base for Social Security Reduction.
7	GPES_SS_BONIF_AMT	Number(10,2)	DECIMAL(9,2) NOT NULL	Reduction Annual Amount
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL