STATEPrompt Table: STATE_US_VW
LANGUAGE_CDEFFDTDefault Value: %date
STATE_TAX_LANG(SQL Table) |
Index Back |
|---|---|
State/Federal Tax TableThis record is used to identify the general type of withholding tax calculation employed by each jurisdiction and provides all the constants needed by the calculation routines for income tax withholding. This table is maintained by PeopleSoft. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | STATE |
Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_US_VW |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | SPECIAL_DESCR_1 | Character(15) | VARCHAR2(15) NOT NULL | Special Tax Amount Descr 1 |
| 5 | SPECIAL_DESCR_2 | Character(15) | VARCHAR2(15) NOT NULL | Special Tax Amount Descr 2 |
| 6 | SPECIAL_DESCR_3 | Character(15) | VARCHAR2(15) NOT NULL | Special Tax Amount Descr 3 |
| 7 | SPECIAL_DESCR_4 | Character(15) | VARCHAR2(15) NOT NULL | Special Tax Amount Descr 4 |
| 8 | SPECIAL_DESCR_5 | Character(15) | VARCHAR2(15) NOT NULL | Special Tax Amount Descr 5 |