| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP05: Time Accounting and HRM Base |
| 1 | F054101 | Employee Personal Profile Information History Table | 33 | EH | RELA | Dependent/Beneficiary Relationship | Character | UDC | 1 | 0 |
| 2 | F054101W | Employee Personal Profile Information Work Table | 29 | EP | RELA | Dependent/Beneficiary Relationship | Character | UDC | 1 | 0 |
| TOP08: Human Resources |
| 3 | F085500 | Allowed Dependent Relations Per Plan | 3 | AD | RELA | Dependent/Beneficiary Relationship | Character | UDC | 1 | 0 |
| 4 | F085536 | Dependent/Beneficiary X-Reference History Table | 6 | DH | RELA | Dependent/Beneficiary Relationship | Character | UDC | 1 | 0 |
| 5 | F085536W | Dependent/Beneficiary X-Reference Work Table | 6 | DB | RELA | Dependent/Beneficiary Relationship | Character | UDC | 1 | 0 |
| 6 | F085537W | Current Dep/Ben X-Reference Work Table | 5 | XB | RELA | Dependent/Beneficiary Relationship | Character | UDC | 1 | 0 |
| TOP08B: Benefits Administration |
| 7 | F08336 | Dep/Ben to Employee Plan X-Reference | 5 | BJ | RELA | Dependent/Beneficiary Relationship | Character | UDC | 1 | 0 |
| 8 | F08336WF | Dependent/Beneficiary X-Ref Work Table | 6 | BD | RELA | Dependent/Beneficiary Relationship | 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 08 / RL (Relationship) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | B | Sibling | A | N |
| 2 | C | Child | A | N |
| 3 | D | Domestic Partner | A | N |
| 4 | E | Employee | | Y |
| 5 | F | Foster/Step Child | A | N |
| 6 | G | Grandparent | A | N |
| 7 | L | Separated Spouse | A | N |
| 8 | O | Other | B | N |
| 9 | P | Parent | A | N |
| 10 | S | Spouse | A | N |
| 11 | W | Widow(er) | | |
| 12 | X | Ex-Spouse | D | N |
