GPAU_SPT_SCHED

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAYROLL_STATE_AUS	Character(3)	VARCHAR2(3) NOT NULL	Sal Package - Payroll Tax State Prompt Table: GPAU_STATES_VW
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	GPAU_ST_TAX_FREQ	Character(2)	VARCHAR2(2) NOT NULL	State Payroll Tax tax payment frequency 10=Monthly 20=Yearly Default Value: 10
4	NUM_DAYS	Number(3,0)	SMALLINT NOT NULL	Number of Days Default Value: 0
5	GPAU_MIN_TAX_ERNS	Number(13,2)	DECIMAL(12,2) NOT NULL	Minimum Tax Earnings
6	GPAU_MAX_TAX_ERNS	Number(13,2)	DECIMAL(12,2) NOT NULL	State Payroll Tax Maximum taxable Earnings
7	GPAU_SPT_TAX_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	State Payroll Tax payroll tax percent
8	GPAU_THRESHOLD_PCT	Number(7,3)	DECIMAL(6,3) NOT NULL	State Payroll Tax threshold percent
9	GPAU_DED_LIM_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	State Payroll Tax Deduction Limit Amount
10	GPAU_THRESHOLD_AMT	Number(13,2)	DECIMAL(12,2) NOT NULL	State Payroll Tax Threshold amount
11	GPAU_MULTIPLIER	Number(2,0)	SMALLINT NOT NULL	State Payroll Tax multiplier for tax calculation
12	GPAU_DIVISOR	Number(2,0)	SMALLINT NOT NULL	State Payroll Tax divisor Default Value: 1