GPAU_SPTRPT_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	GPAU_GRP_ENT	Character(10)	VARCHAR2(10) NOT NULL	State Payroll Tax Group Entity Prompt Table: GP_PYENT_OPR_VW
5	GPAU_TOT_GRP_EARN	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	State Payroll Tax, total earnings for the Group
6	GPAU_APPTN_DED	Character(1)	VARCHAR2(1) NOT NULL	State Payroll Tax Pay Entity Apportion Deduction field Y/N Table Edit Default Value: Y
7	GPAU_PER_START_DT	Date(10)	DATE	Used in State Payroll Tax when determining the start date of the processing period.
8	GPAU_NEXT_START_DT	Date(10)	DATE	Used in State Payroll Tax when determining the start date of the next calendar.
9	GPAU_YEAR	Number(4,0)	SMALLINT NOT NULL	State Payroll Tax Year
10	GPAU_MONTH	Number(2,0)	SMALLINT NOT NULL	State Payroll Tax processing Month
11	NUM_DAYS	Number(3,0)	SMALLINT NOT NULL	Number of Days
12	PAYROLL_STATE_AUS	Character(3)	VARCHAR2(3) NOT NULL	Sal Package - Payroll Tax State
13	GPAU_SPT_TAX_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	State Payroll Tax payroll tax percent
14	GPAU_THRESHOLD_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	State Payroll Tax threshold percent
15	GPAU_DED_LIM_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	State Payroll Tax Deduction Limit Amount
16	GPAU_THRESHOLD_AMT	Number(13,2)	DECIMAL(12,2) NOT NULL	State Payroll Tax Threshold amount
17	GPAU_MULTIPLIER	Number(2,0)	SMALLINT NOT NULL	State Payroll Tax multiplier for tax calculation
18	GPAU_DIVISOR	Number(2,0)	SMALLINT NOT NULL	State Payroll Tax divisor Default Value: 1
19	GPAU_SPT_MAX_DED	Signed Number(14,2)	DECIMAL(12,2) NOT NULL	State Payroll Tax maximum deduction
20	GPAU_SPT_AUS_WAGES	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	This field is used in State Payroll Tax report processing to hold the amount of wages to be paid by the entire group of Pay Entities.
21	GPAU_SPT_ST_WAGES	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	This field is used in State Payroll Tax report processing to hold the amount of wages to be paid by the Pay Entities within a State.
22	GPAU_SPT_NOTNL_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	This contains the State Notional Percent
23	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
24	GPAU_NUM_FT_EMP	Number(9,0)	DECIMAL(9) NOT NULL	State Payroll Tax number of full time employees within a Pay Entity within a State
25	GPAU_NUM_OTH_EMP	Number(9,0)	DECIMAL(9) NOT NULL	State Payroll Tax number of other than Full time employees in a Pay Entity in a State
26	GPAU_SPT_ST_GROSS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	This field is used in State Payroll Tax report processing to hold the amount of wages to be paid by a Pay Entity within a State.
27	GPAU_DESIGNATE	Character(1)	VARCHAR2(1) NOT NULL	State Payroll Tax designate flag Y/N Table Edit Default Value: Y
28	GPAU_DESGNATED_DED	Signed Number(14,2)	DECIMAL(12,2) NOT NULL	State Payroll Tax Designated Deduction
29	GPAU_STATE_SPT	Number(16,2)	DECIMAL(15,2) NOT NULL	State Payroll Tax, payroll tax payable per state
30	GPAU_SPT_REBATE	Number(9,3)	DECIMAL(8,3) NOT NULL	State Payroll Tax trainee rebate
31	GPAU_SPT_BASE_DT	Character(2)	VARCHAR2(2) NOT NULL	This field is used to determine the base date when running the SPT tax reporting process. 10=Pay End Date 20=Payment Date 30=Earlier of End/Payment Dates
32	GPAU_MAX_TAX_ERNS	Number(13,2)	DECIMAL(12,2) NOT NULL	State Payroll Tax Maximum taxable Earnings
33	GPAU_MIN_TAX_ERNS	Number(13,2)	DECIMAL(12,2) NOT NULL	Minimum Tax Earnings
34	GPAU_MIN_THRES_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	State Payroll Tax Threshold amount
35	GPAU_MAX_THRES_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	State Payroll Tax Threshold amount
36	GPAU_MIN_ADJ_THRES	Number(16,2)	DECIMAL(15,2) NOT NULL	State Payroll Tax Threshold amount
37	GPAU_MAX_ADJ_THRES	Number(16,2)	DECIMAL(15,2) NOT NULL	State Payroll Tax Threshold amount
38	GPAU_SPT_SC_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	State Payroll Tax threshold percent
39	GPAU_SPT_SURCHARGE	Number(16,2)	DECIMAL(15,2) NOT NULL	State Payroll Tax Threshold amount
40	GPAU_SPT_SURCH_TYP	Character(4)	VARCHAR2(4) NOT NULL	State Payroll Tax - Field to hold Surcharge Type value (VIC - CVD / VIC - MHW & QLD - MHL). Referred in 'Review Payroll Tax Rate' Page. CVD=COVID Debt Levy MHL=Mental Health Levy MHW=Mental Health and Wellbeing PTS=Payroll Tax Surcharge
41	GPAU_SPT_LEVY	Number(16,2)	DECIMAL(15,2) NOT NULL	State Payroll Tax - Field that holds calculated Surcharge amount for VIC - Covid Surcharge type