GPAU_FLDTL_VW (SQL View)	Index Back
Flood Levy Rates Detail View This view will be used to display the Flood Levy rates that PeopleSoft Australia has delivered with the product. 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 FLRATE, which is the bracket for Flood Levy rates. The fields that will be extracted include Pin Num, Effective Date, Seq Num, Data of Key 1 and Data Num of Value 1.

GPAU_FLDTL_VW

(SQL View)

Flood Levy Rates Detail View

This view will be used to display the Flood Levy rates that PeopleSoft Australia has delivered with the product. 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 FLRATE, which is the bracket for Flood Levy rates. The fields that will be extracted include Pin Num, Effective Date, Seq Num, Data of Key 1 and Data Num of Value 1.

SELECT A.PIN_NUM ,B.EFFDT ,%Substring(C.DATA_KEY1,1,1) ,C.SEQ_NUM5 ,C.DATA_KEY2_DEC ,C.DATA_VAL1_DEC ,C.DATA_VAL2_DEC 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: GPAU_FLCAT_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

4 SEQ_NUM5 Number(5,0) INTEGER NOT NULL Sequence Number

5 DATA_KEY1_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL Data Key - Decimal

6 DATA_VAL1_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL Data Value - Decimal

7 DATA_VAL2_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL Data Value - Decimal

#	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
4	SEQ_NUM5	Number(5,0)	INTEGER NOT NULL	Sequence Number
5	DATA_KEY1_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Data Key - Decimal
6	DATA_VAL1_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Data Value - Decimal
7	DATA_VAL2_DEC	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Data Value - Decimal