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