| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 05A: PeopleSoft 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 | Y | ||
| 2 | 0 | 0 | Y | |
| 3 | 1 | Married Filing Joint-1 Working | Y | |
| 4 | 3 | Married Optional | Y | |
| 5 | 4 | Married Optional None | Y | |
| 6 | 5 | Married FJ one spouse working | Y | |
| 7 | 6 | Married Filing Joint-Both Work | Y | |
| 8 | 7 | Married Filing Separately | Y | |
| 9 | 8 | Head Of Household | Y | |
| 10 | 9 | Single | Y | |
| 11 | A | Married Filing Jointly | Y | |
| 12 | B | Married Filing Joint-Both Work | Y | |
| 13 | C | Married Filing Joint-1 Working | Y | |
| 14 | D | Married Filing Joint-Both Work | Y | |
| 15 | E | Exempted | Y | |
| 16 | F | Single | Y | |
| 17 | G | Married/Domestic Filing Joint | Y | |
| 18 | H | Head Of Household | Y | |
| 19 | I | Certified Disabled | Y | |
| 20 | J | Married Filing Separately | Y | |
| 21 | K | Non-resident Military Spouse | Y | |
| 22 | L | Civil Union | Y | |
| 23 | M | Married Full | Y | |
| 24 | N | No State W4 Low Threshold | Y | |
| 25 | O | Married FS w/ exemption | Y | |
| 26 | P | No State W4 High Threshold | Y | |
| 27 | Q | Married Federal - Single State | Y | |
| 28 | R | Individual Full | Y | |
| 29 | S | Single | Y | |
| 30 | T | Married Half | Y | |
| 31 | U | Surviving Spouse | Y | |
| 32 | W | Qualifying Widow(er) | Y | |
| 33 | X | Individual or Married None | Y | |
| 34 | Y | Optional One Earner One Job | Y | |
| 35 | Z | Married/Domestic File Separate | Y |