GPAU_FLCAT_VW

(SQL View)

SELECT DISTINCT A.PIN_NUM ,B.EFFDT ,%Substring(C.DATA_KEY1,1,1) FROM PS_GP_PIN A , PS_GP_BRACKET B , PS_GP_BRACKET_DTL C WHERE A.PIN_CODE = 'TAX BR FL RATE AUS' AND B.PIN_NUM = A.PIN_NUM AND C.PIN_NUM = B.PIN_NUM AND C.EFFDT = B.EFFDT AND C.DATA_KEY1 <> 'NA'

Parent Record Of GPAU_FLDTL_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 GPAU_TXFRE_CLAIMED Character(1) VARCHAR2(1) NOT NULL Tax free treshold claimed

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	GPAU_TXFRE_CLAIMED	Character(1)	VARCHAR2(1) NOT NULL	Tax free treshold claimed