| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP05A: OW HR & PR Foundation |
| 1 | F060116 | Employee Master Information | 7 | YA | MSTI | Marital Status - State Tax | Character | UDC | 1 | 0 |
| 2 | F0601161 | Point-In-Time Employee Master | 9 | PT | MSTI | Marital Status - State Tax | Character | UDC | 1 | 0 |
| 3 | F060116W | EE Master Request File | 7 | YA | MSTI | Marital Status - State Tax | Character | UDC | 1 | 0 |
| 4 | F060116Z | Unedited Quick Hire Transaction File | 38 | SZ | MSTI | Marital Status - State Tax | Character | UDC | 1 | 0 |
| TOP08AD: ADP Integration |
| 5 | F05137 | ADP Employee Master Information | 33 | AD | MSTI | Marital Status - State Tax | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 06 / MS (Marital Status Codes) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | Default value | | |
| 2 | 1 | Married Filing Joint-1 Working | | |
| 3 | 2 | Single, less than 3 exemptions | | |
| 4 | 3 | Single, over 2 exemptions | | |
| 5 | 4 | Married Optional None | | Y |
| 6 | A | Married Filing Jointly | | |
| 7 | B | Married Filing Joint-Both Work | | |
| 8 | C | Married Filing Joint-1 Working | | N |
| 9 | D | Married Filing Joint-Both Work | | N |
| 10 | E | Exempted | | N |
| 11 | F | Single | | N |
| 12 | G | Married/Domestic Filing Joint | | Y |
| 13 | H | Head Of Household | | |
| 14 | J | Married Filing Separately | | |
| 15 | K | Married FS on same return | | Y |
| 16 | L | Civil Union | | Y |
| 17 | M | Married | | |
| 18 | O | Married FS w/ exemption | | Y |
| 19 | P | Single Federal - Married State | | |
| 20 | Q | Married Federal - Single State | | |
| 21 | S | Single | | |
| 22 | Y | Optional One Earner One Job | | Y |
| 23 | Z | Married/Domestic File Separate | | Y |
