| ST_OTH_TAX_TBL(SQL Table) | Index Back | 
|---|---|
| State Special Tax Rate TableThis record is used to store contants required for payroll calculation of unemployment, disability, and certain other special state taxes. This table is maintained by PeopleSoft. | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(6) | VARCHAR2(6) NOT NULL | State | |
| 2 | Date(10) | DATE NOT NULL | Effective Date Default Value: %date | |
| 3 | Character(1) | VARCHAR2(1) NOT NULL | Tax Balance Class Default Value: U | |
| 4 | TAX_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Tax Calculation Type G=Percent of Taxable Gross N=Not Applicable U=Use ER Wage for EE Tax Default Value: G | 
| 5 | TAXGR_BASE | Character(1) | VARCHAR2(1) NOT NULL | Tax Gross Base D=Disability H=Withholding U=Unemployment Default Value: U | 
| 6 | TAX_RT | Signed Number(8,6) | DECIMAL(6,6) NOT NULL | Tax Rate (after form) | 
| 7 | MAX_GROSS | Number(8,0) | INTEGER NOT NULL | Maximum Gross | 
| 8 | MAXIMUM_TAX | Number(8,2) | DECIMAL(7,2) NOT NULL | Maximum Tax | 
| 9 | PERIOD_MAX | Character(1) | VARCHAR2(1) NOT NULL | Period Maximum Y/N Table Edit Default Value: N | 
| 10 | SELF_ADJ | Character(1) | VARCHAR2(1) NOT NULL | Self Adjust Y/N Table Edit Default Value: N | 
| 11 | EE_ER_TAX_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Employee / Employer / Both B=Empl and Emplr Tax E=Employee Tax Only M=Memo Tax Only R=Employer Tax Only Default Value: R | 
| 12 | TIPS_DELAY_WTHLD | Character(1) | VARCHAR2(1) NOT NULL | Delay Withholding of Taxes Y/N Table Edit Default Value: N |