| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 05A: OW HR & PR Foundation | ||||||||||
| 1 | F060116 | Employee Master Information | 6 | YA | MSTX | Marital Status - Tax | Character | UDC | 1 | 0 |
| 2 | F0601161 | Point-In-Time Employee Master | 8 | PT | MSTX | Marital Status - Tax | Character | UDC | 1 | 0 |
| 3 | F060116W | EE Master Request File | 6 | YA | MSTX | Marital Status - Tax | Character | UDC | 1 | 0 |
| 4 | F060116Z | Unedited Quick Hire Transaction File | 37 | SZ | MSTX | Marital Status - Tax | Character | UDC | 1 | 0 |
| 07: Payroll | ||||||||||
| 5 | F074001 | New Hire Reporting Workfile - OneWorld Only | 25 | NH | MSTX | Marital Status - Tax | Character | UDC | 1 | 0 |
| 08AD: ADP Integration | ||||||||||
| 6 | F05137 | ADP Employee Master Information | 30 | AD | MSTX | Marital Status - 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.
UDC 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 | A | Married Filing Jointly | ||
| 6 | B | Married Filing Joint-Both Work | ||
| 7 | C | Married Filing Joint-1 Working | N | |
| 8 | D | Married Filing Joint-Both Work | N | |
| 9 | E | Exempted | N | |
| 10 | F | Single | N | |
| 11 | H | Head Of Household | ||
| 12 | J | Married Filing Separately | ||
| 13 | K | Married FS on same return | Y | |
| 14 | L | Civil Union | Y | |
| 15 | M | Married | ||
| 16 | P | Single Federal - Married State | ||
| 17 | Q | Married Federal - Single State | ||
| 18 | S | Single |