LCLWK_TXRCP_TBL(SQL Table) |
Index Back |
|---|---|
Work-work reciprocity rulesRules for dual work/work tax jurisdiction relationships. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  STATE_WORK |
Character(6) | VARCHAR2(6) NOT NULL |
State of Employment
Prompt Table: STATE_TAX_TBL |
| 2 | LOCALITY_WORK |
Character(10) | VARCHAR2(10) NOT NULL |
Locality of Employment
Prompt Table: LOCAL_TAX_WRKVW |
| 3 | OTHER_STATE |
Character(6) | VARCHAR2(6) NOT NULL |
State of Other Jurisdiction
Prompt Table: STATE_TAX_TBL |
| 4 | OTHER_LOCALITY |
Character(10) | VARCHAR2(10) NOT NULL |
Locality of Other Jurisdiction
Prompt Table: LOCAL_TAX_OTHVW |
| 5 | EFFDT | Date(10) | DATE NOT NULL | Effective Date |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 7 | REDUCE_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Reduce by x Percent |
| 8 | 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 |