GPAU_HELPCAT_VW (SQL View)	Index Back
HELP Rates Category View This view will be used to display the HELP 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 HELP RATE, which is the bracket for HELP rates. The fields that will be extracted include Pin Num, Effective Date, Data of Key 1.

GPAU_HELPCAT_VW

(SQL View)

HELP Rates Category View

This view will be used to display the HELP 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 HELP RATE, which is the bracket for HELP rates. The fields that will be extracted include Pin Num, Effective Date, Data of Key 1.

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 HELP 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_HECS_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