GPAU_FL_VW (SQL View)	Index Back
Flood Levy Rates Category View This view will be used to display the Flood Levy rate's category whether it is Tax free threshold claimed or not This view retrieve the data from the tables GP_PIN, GP_BRACKET and GP_BRACKET_DTL. It extracts the records for the element TAX BR FL RATE, which is the bracket for FL rates. The fields that will be extracted include Pin Num, Effective Date, Data of Key 1.

GPAU_FL_VW

(SQL View)

Flood Levy Rates Category View

This view will be used to display the Flood Levy rate's category whether it is Tax free threshold claimed or not This view retrieve the data from the tables GP_PIN, GP_BRACKET and GP_BRACKET_DTL. It extracts the records for the element TAX BR FL RATE, which is the bracket for FL rates. The fields that will be extracted include Pin Num, Effective Date, Data of Key 1.

SELECT DISTINCT A.PIN_NUM , B.EFFDT , B.EFF_STATUS FROM PS_GP_PIN A , PS_GP_BRACKET B WHERE A.PIN_CODE = 'TAX BR FL RATE AUS' AND B.PIN_NUM = A.PIN_NUM

# 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

#	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	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A