| # |
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
|
| 2 |
GPAU_GRP_ENT |
Character(10) |
VARCHAR2(10) NOT NULL |
State Payroll Tax Group Entity
|
| 3 |
PAY_ENTITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Entity
|
| 4 |
GPAU_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
State Payroll Tax Year
|
| 5 |
GPAU_MONTH |
Number(2,0) |
SMALLINT NOT NULL |
State Payroll Tax processing Month
|
| 6 |
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
|
| 7 |
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
|
| 8 |
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.
|
| 9 |
GPAU_DESGNATED_DED |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
State Payroll Tax Designated Deduction
|
| 10 |
GPAU_STATE_SPT |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
State Payroll Tax, payroll tax payable per state
|
| 11 |
GPAU_SPT_REBATE |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
State Payroll Tax trainee rebate
|
| 12 |
GPAU_SPT_SURCHARGE |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
State Payroll Tax Threshold amount
|
| 13 |
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
|