| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP08: Human Resources |
1 | F08338B | Primary Care Physician Tag Table | 6 | PT | PCPVST | PCP Visited Previously | Character | UDC | 1 | 0 |
2 | F085520 | Available Plans and Plan Options by Employee History Table | 14 | PH | PCPVST | PCP Visited Previously | Character | UDC | 1 | 0 |
3 | F085520W | Available Plans and Plan Options by Employee Work Table | 36 | AP | PCPVST | PCP Visited Previously | Character | UDC | 1 | 0 |
4 | F085530W | Employee Current/Pending Elections Work Table | 14 | CP | PCPVST | PCP Visited Previously | Character | UDC | 1 | 0 |
5 | F085536 | Dependent/Beneficiary X-Reference History Table | 18 | DH | PCPVST | PCP Visited Previously | Character | UDC | 1 | 0 |
6 | F085536W | Dependent/Beneficiary X-Reference Work Table | 18 | DB | PCPVST | PCP Visited Previously | Character | UDC | 1 | 0 |
7 | F085537W | Current Dep/Ben X-Reference Work Table | 15 | XB | PCPVST | PCP Visited Previously | Character | UDC | 1 | 0 |
TOP08B: Benefits Administration |
8 | F08330C | Employee Enrollment Tag Table C | 5 | PC | PCPVST | PCP Visited Previously | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.