| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP08: Human Resources |
1 | F085520 | Available Plans and Plan Options by Employee History Table | 13 | PH | DBEN | Dependent/Beneficiary | Character | UDC | 1 | 0 |
2 | F085520W | Available Plans and Plan Options by Employee Work Table | 10 | AP | DBEN | Dependent/Beneficiary | Character | UDC | 1 | 0 |
3 | F085530W | Employee Current/Pending Elections Work Table | 12 | CP | DBEN | Dependent/Beneficiary | Character | UDC | 1 | 0 |
4 | F085536 | Dependent/Beneficiary X-Reference History Table | 5 | DH | DBEN | Dependent/Beneficiary | Character | UDC | 1 | 0 |
5 | F085536W | Dependent/Beneficiary X-Reference Work Table | 5 | DB | DBEN | Dependent/Beneficiary | Character | UDC | 1 | 0 |
6 | F085537W | Current Dep/Ben X-Reference Work Table | 4 | XB | DBEN | Dependent/Beneficiary | Character | UDC | 1 | 0 |
TOP08B: Benefits Administration |
7 | F08320WF | Available Plans and Plan Options by Employee Work Table | 9 | BV | DBEN | Dependent/Beneficiary | Character | UDC | 1 | 0 |
8 | F08330WF | Employee Current/Pending Elections Work Table | 12 | BR | DBEN | Dependent/Beneficiary | Character | UDC | 1 | 0 |
9 | F08336 | Dep/Ben to Employee Plan X-Reference | 6 | BJ | DBEN | Dependent/Beneficiary | Character | UDC | 1 | 0 |
10 | F08336WF | Dependent/Beneficiary X-Ref Work Table | 5 | BD | DBEN | Dependent/Beneficiary | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.