| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 05A: PeopleSoft HR & PR Foundation | ||||||||||
| 1 | F060116Z | Unedited Quick Hire Transaction File | 176 | SZ | MSA | Marital Status - Actual | Character | UDC | 1 | 0 |
| 2 | F060120 | Employee Master Additional Information File | 2 | YA | MSA | Marital Status - Actual | Character | UDC | 1 | 0 |
| 08AD: ADP Integration | ||||||||||
| 3 | F05137 | ADP Employee Master Information | 62 | AD | MSA | Marital Status - Actual | 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 07 / MS (Marital Status Codes) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | Default value | N | ||
| 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 | CT: Married Filing Joint | N | |
| 8 | D | CT: Married Filing Joint | N | |
| 9 | E | Exempted | N | |
| 10 | F | CT: Single | N | |
| 11 | H | Head Of Household | ||
| 12 | J | Married Filing Separately | ||
| 13 | M | Married | ||
| 14 | P | Single Federal - Married State | ||
| 15 | Q | Married Federal - Single State | ||
| 16 | S | Single |