GPAU_SFSS_VW (SQL View)	Index Back
SFSS Rates View This view will be used to display the SFSS 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 SFSS RATE, which is the bracket for SFSS 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_SFSS_VW

(SQL View)

SFSS Rates View

This view will be used to display the SFSS 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 SFSS RATE, which is the bracket for SFSS 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 SFSS RATE AUS' AND B.PIN_NUM = A.PIN_NUM

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