GPES_SS_RDTN_VW (SQL View)	Index Back
Control Methods for Reductions This view is used to retrieve the Control Methods defined in REDUCTN Code Tables. Each method returns a boolean and depending the value, the Reduction will be applied or not.

GPES_SS_RDTN_VW

(SQL View)

Control Methods for Reductions

This view is used to retrieve the Control Methods defined in REDUCTN Code Tables. Each method returns a boolean and depending the value, the Reduction will be applied or not.

SELECT XML_XLAT_VALUE , DESCR50 FROM PS_XML_XLATITEM WHERE XML_XLAT_CODE = 'REDUCTN' AND DESCR50 NOT LIKE '%Reserv%'

Related Language Record: GPES_RDT_LNG_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPES_BNF_AA_METHOD Character(8) VARCHAR2(8) NOT NULL Social Security benefit type

2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPES_BNF_AA_METHOD	Character(8)	VARCHAR2(8) NOT NULL	Social Security benefit type
2	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50