PAYROLL_STATE_AUSPrompt Table: GPAU_STATES_VW
GPAU_SPT_SURCH_TYPCVD=COVID Debt Levy
MHL=Mental Health Levy
MHW=Mental Health and Wellbeing
PTS=Payroll Tax Surcharge
EFFDTA=Active
I=Inactive
GPAU_SPT_SC_HDR(SQL Table) |
Index Back |
|---|---|
State Payroll Surcharge HeaderParent record of records that hold thresholds, rates, etc that are dependent on State legislation. |
| # | 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 | 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 |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |