GPAU_TX_SCL_DTL (SQL Table)	Index Back
Tax Scales - Australia Details This table records the tax rates that were provided by the ATO. It records the different weekly income ranges and the corresponding tax rate that should be applied. This is a child record of GPAU_TAX_SCALES. This will be owned and maintained by Peoplesoft Australia

GPAU_TX_SCL_DTL

(SQL Table)

Tax Scales - Australia Details

This table records the tax rates that were provided by the ATO. It records the different weekly income ranges and the corresponding tax rate that should be applied. This is a child record of GPAU_TAX_SCALES. This will be owned and maintained by Peoplesoft Australia

Parent record: GPAU_TAX_SCALES

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPAU_TAX_SCALE Character(3) VARCHAR2(3) NOT NULL This is used to identify the rates, thresholds, and other factors that will be used in the calculation of the payee's tax.
Default Value: GPAU_TAX_SCALES.GPAU_TAX_SCALE

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: GPAU_TAX_SCALES.EFFDT

3 GPAU_WK_EARN Number(8,0) INTEGER NOT NULL This is the weekly earnings that is used to determine the A pct and B amt to use in the tax calculation.

4 GPAU_A_PCT Number(5,4) DECIMAL(4,4) NOT NULL This is the percentage that will be used in the calculation of the payee's income tax.

5 GPAU_B_AMT Signed Number(9,4) DECIMAL(7,4) NOT NULL This field is used in the calculation of the payee's tax. The formula for tax amount is ax - b where, x is the weekly gross earnings, a is the column a rate, b is the column b amount.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPAU_TAX_SCALE	Character(3)	VARCHAR2(3) NOT NULL	This is used to identify the rates, thresholds, and other factors that will be used in the calculation of the payee's tax. Default Value: GPAU_TAX_SCALES.GPAU_TAX_SCALE
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: GPAU_TAX_SCALES.EFFDT
3	GPAU_WK_EARN	Number(8,0)	INTEGER NOT NULL	This is the weekly earnings that is used to determine the A pct and B amt to use in the tax calculation.
4	GPAU_A_PCT	Number(5,4)	DECIMAL(4,4) NOT NULL	This is the percentage that will be used in the calculation of the payee's income tax.
5	GPAU_B_AMT	Signed Number(9,4)	DECIMAL(7,4) NOT NULL	This field is used in the calculation of the payee's tax. The formula for tax amount is ax - b where, x is the weekly gross earnings, a is the column a rate, b is the column b amount.