GPUS_NEWDED_VW (SQL View)	Index Back
New Deductions View New deductions view which are required for job.

GPUS_NEWDED_VW

(SQL View)

New Deductions View

New deductions view which are required for job.

SELECT A.PIN_NUM ,A.PIN_MBR_NUM ,D.PIN_NM ,C.CALC_RULE ,D.PIN_CUSTOM5 FROM PS_GP_ACM_MBR A ,PS_GP_PIN B , PS_GP_ERN_DED C , PS_GP_PIN D WHERE A.ENTRY_TYPE_ELEM = 'DD0' AND A.PIN_NUM = B.PIN_NUM AND A.PIN_MBR_NUM = C.PIN_NUM AND C.PIN_NUM = D.PIN_NUM AND B.PIN_CODE = 'GRN AC FLVYSETUP N USA' AND D.PIN_CUSTOM4 = 'REQ' AND A.PIN_MBR_NUM NOT IN ( SELECT DISTINCT PIN_NUM FROM PS_GPUS_GRN_FTX_WA)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

2 PIN_MBR_NUM Number(8,0) INTEGER NOT NULL Element number field

3 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field

4 CALC_RULE Character(2) VARCHAR2(2) NOT NULL Function Library field
AM=Amount
PB=Base * Percent
RP=Unit * Rate * Percent
RU=Unit * Rate

5 PIN_CUSTOM5 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM5

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
2	PIN_MBR_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
3	PIN_NM	Character(18)	VARCHAR2(18) NOT NULL	Element Name field
4	CALC_RULE	Character(2)	VARCHAR2(2) NOT NULL	Function Library field AM=Amount PB=Base * Percent RP=Unit * Rate * Percent RU=Unit * Rate
5	PIN_CUSTOM5	Character(20)	VARCHAR2(20) NOT NULL	PIN_CUSTOM5