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

(SQL View)

FTB Rates View

This view will be used to display the FTB 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 FTB RATE, which is the bracket for FTB 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 A.PIN_NUM ,B.EFFDT ,B.EFF_STATUS ,B.PIN_KEY1_NUM ,B.PIN_VAL1_NUM FROM PS_GP_PIN A , PS_GP_BRACKET B WHERE A.PIN_CODE = 'TAX BR FTB RATE AUS' AND B.PIN_NUM = A.PIN_NUM

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

4 PIN_KEY1_NUM Number(8,0) INTEGER NOT NULL Bracket Key Element Number

5 PIN_VAL1_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number

#	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
4	PIN_KEY1_NUM	Number(8,0)	INTEGER NOT NULL	Bracket Key Element Number
5	PIN_VAL1_NUM	Number(8,0)	INTEGER NOT NULL	Bracket Value Element Number