GPAU_HECS_VW (SQL View)	Index Back
HECS Rates View This view will be used to display the HECS rates that PeopleSoft Australia has delivered with the product. This view retrieve the data from the tables GP_PIN and GP_BRACKET. It extracts the records for the element TAX BR HECS RATE, which is the bracket for HECS rates. The fields that will be extracted include Pin Num, Effective Date, Status, Pin Num of Key 1 and Pin Num of Value 1.

GPAU_HECS_VW

(SQL View)

HECS Rates View

This view will be used to display the HECS rates that PeopleSoft Australia has delivered with the product. This view retrieve the data from the tables GP_PIN and GP_BRACKET. It extracts the records for the element TAX BR HECS RATE, which is the bracket for HECS rates. The fields that will be extracted include Pin Num, Effective Date, Status, Pin Num of Key 1 and Pin Num of Value 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 HELP RATE AUS' AND B.PIN_NUM = A.PIN_NUM

Parent Record Of GPAU_HELPCAT_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 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