STTAX_RECIP_TBL(SQL Table) |
Index Back |
|---|---|
State Reciprocity RulesThis record defines the rules used during payroll calculation to determine withholding liability when an employee lives in one state and works in another. This is a PeopleSoft-maintained table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  STATE_RESIDENCE |
Character(6) | VARCHAR2(6) NOT NULL |
State of Residence
Prompt Table: STATE_TAX_TBL |
| 2 | STATE_WORK |
Character(6) | VARCHAR2(6) NOT NULL |
State of Employment
Prompt Table: STATE_TAX_TBL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | RECIPROCITY_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Reciprocity Rule
B=Withhold-Both C=Withhold higher of work or res G=Calc Res W/H; Factor Res W/H % K=Calc Wk W/H; Reduce by Res W/H N=Reduce Ttl Wages;Calc Res W/H O=Withhold for wk locality only R=Calc Res W/H;Reduce by Wk W/H S=Special- MD works in DE W=Taxed Res; No W/H Wk X=Red Res W/H by Wk subj to Res Default Value: B |
| 6 | SUT_CREDIT | Character(1) | VARCHAR2(1) NOT NULL |
SUT Credit
Y/N Table Edit Default Value: Y |