GPAU_TAX_SCALES (SQL Table)	Index Back
Tax Scales - Australia This table will be used to record the tax scales that were provided by the Australian Taxation Office (ATO) as part of the tax legislation in Australia. The table records the different components that are used in the calculation of the Medicare levy adjustment that a payee can have to decrease the withholding amount that it has to pay. Such components include different thresholds, multipliers, divisors, and factors. It also include the medicare levy rate that will be applied. This table is effective dated and is owned and maintained by Peoplesoft Australia

GPAU_TAX_SCALES

(SQL Table)

Tax Scales - Australia

This table will be used to record the tax scales that were provided by the Australian Taxation Office (ATO) as part of the tax legislation in Australia. The table records the different components that are used in the calculation of the Medicare levy adjustment that a payee can have to decrease the withholding amount that it has to pay. Such components include different thresholds, multipliers, divisors, and factors. It also include the medicare levy rate that will be applied. This table is effective dated and is owned and maintained by Peoplesoft Australia

Related Language Record: GPAU_TXSCL_LANG

Parent Record Of GPAU_TX_SCL_DTL

# 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.

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 GPAU_WK_THRES Number(6,0) INTEGER NOT NULL This is the weekly earnings threshold that is used for the calculation of the payee's Medicate Levy Adjustments.

6 GPAU_WK_S_IN_THRES Number(6,0) INTEGER NOT NULL This is the weekly earnings shade-in threshold that is used in the calculation of the payee's Medicare Levy Adjustment

7 GPAU_M_LEVY_THRES Number(6,0) INTEGER NOT NULL This is the Medicare Levy family threshold amount that is used in the calculation of the payee's Medicare Levy Adjustments.

8 GPAU_WFT_DIVISOR Number(6,3) DECIMAL(5,3) NOT NULL This is the weekly family threshold divisor which is used for the calculation of the payee's Medicare Levy Adjustments

9 GPAU_ADDL_CHILD Number(6,0) INTEGER NOT NULL This is the additional threshold that a payee is entitled for each additional child. This is used in the calculation of the payee's Medicare Levy Adjustments.

10 GPAU_SOP_MLTPLR Number(3,2) DECIMAL(2,2) NOT NULL This is the Shading Out Point multiplier that is used in the calculation of the payee's Medicare Levy adjustments.

11 GPAU_SOP_DIVISOR Number(6,4) DECIMAL(5,4) NOT NULL This is the Shading Out Point divisor that is used in the calculation of the payee's Medicare Levy adjustments.

12 GPAU_WLA_FACTOR Number(6,2) DECIMAL(5,2) NOT NULL This is the Weekly Levy Adjustment factor that is used in the calculation of the payee's Medicare Levy adjustments.

13 GPAU_M_LEVY_RT Number(6,4) DECIMAL(5,4) NOT NULL This is the Medicare Levy rate that is used in the calculation of the payee's tax.

#	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.
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	GPAU_WK_THRES	Number(6,0)	INTEGER NOT NULL	This is the weekly earnings threshold that is used for the calculation of the payee's Medicate Levy Adjustments.
6	GPAU_WK_S_IN_THRES	Number(6,0)	INTEGER NOT NULL	This is the weekly earnings shade-in threshold that is used in the calculation of the payee's Medicare Levy Adjustment
7	GPAU_M_LEVY_THRES	Number(6,0)	INTEGER NOT NULL	This is the Medicare Levy family threshold amount that is used in the calculation of the payee's Medicare Levy Adjustments.
8	GPAU_WFT_DIVISOR	Number(6,3)	DECIMAL(5,3) NOT NULL	This is the weekly family threshold divisor which is used for the calculation of the payee's Medicare Levy Adjustments
9	GPAU_ADDL_CHILD	Number(6,0)	INTEGER NOT NULL	This is the additional threshold that a payee is entitled for each additional child. This is used in the calculation of the payee's Medicare Levy Adjustments.
10	GPAU_SOP_MLTPLR	Number(3,2)	DECIMAL(2,2) NOT NULL	This is the Shading Out Point multiplier that is used in the calculation of the payee's Medicare Levy adjustments.
11	GPAU_SOP_DIVISOR	Number(6,4)	DECIMAL(5,4) NOT NULL	This is the Shading Out Point divisor that is used in the calculation of the payee's Medicare Levy adjustments.
12	GPAU_WLA_FACTOR	Number(6,2)	DECIMAL(5,2) NOT NULL	This is the Weekly Levy Adjustment factor that is used in the calculation of the payee's Medicare Levy adjustments.
13	GPAU_M_LEVY_RT	Number(6,4)	DECIMAL(5,4) NOT NULL	This is the Medicare Levy rate that is used in the calculation of the payee's tax.