GPUS_FLVYPIN_VW (SQL View)	Index Back
Fed Levy Pin View Federal Tax Levy Pin View

GPUS_FLVYPIN_VW

(SQL View)

Fed Levy Pin View

Federal Tax Levy Pin View

SELECT DISTINCT PIN_NUM , CALC_RULE 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 CALC_RULE Character(2) VARCHAR2(2) NOT NULL Function Library field
AM=Amount
PB=Base * Percent
RP=Unit * Rate * Percent
RU=Unit * Rate

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
2	CALC_RULE	Character(2)	VARCHAR2(2) NOT NULL	Function Library field AM=Amount PB=Base * Percent RP=Unit * Rate * Percent RU=Unit * Rate