STATELOCALITYR_TAX960XX(SQL Table) |
Index Back |
|---|---|
Temporary W2 Tax TableThis record is used to store descriptive information about a locality, the method used to calculate withholding taxes, local tax rates, and other data required for tax computation. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STATE |
Character(6) | VARCHAR2(6) NOT NULL | State |
| 2 | LOCALITY |
Character(10) | VARCHAR2(10) NOT NULL | Locality |
| 3 | W2_MAG_CODE | Character(5) | VARCHAR2(5) NOT NULL | W2 Magnetic Media Code |
| 4 | LOCALITY_NAME | Character(40) | VARCHAR2(40) NOT NULL | Locality Name |
| 5 | W2_MAG_MEDIA_NAME | Character(75) | VARCHAR2(75) NOT NULL | Field used for selected W2_Rotg_Agencies for W-2 Reporting. |
| 6 | WAGES | Signed Number(12,0) | DECIMAL(11) NOT NULL | Wages |
| 7 | TAXES | Signed Number(11,0) | DECIMAL(10) NOT NULL | Taxes |