GPAU_SPT_SC_RT(SQL Table) |
Index Back |
|---|---|
State Payroll Surchag ScheduleThis table holds Australian State Payroll Tax payment frequency, thresholds, and other State specific information. |
| # | 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 | GPAU_MIN_THRES_AMT |
Number(16,2) | DECIMAL(15,2) NOT NULL | State Payroll Tax Threshold amount |
| 5 | GPAU_MAX_THRES_AMT |
Number(16,2) | DECIMAL(15,2) NOT NULL | State Payroll Tax Threshold amount |
| 6 | 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 |
| 7 | GPAU_MIN_ADJ_THRES | Number(16,2) | DECIMAL(15,2) NOT NULL | State Payroll Tax Threshold amount |
| 8 | GPAU_MAX_ADJ_THRES | Number(16,2) | DECIMAL(15,2) NOT NULL | State Payroll Tax Threshold amount |
| 9 | GPAU_SPT_SC_PCT | Number(7,3) | DECIMAL(6,3) NOT NULL | State Payroll Tax threshold percent |