| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05: Time Accounting and HRM Base |
1 | F05400 | Self-Service Process Flow Settings | 1 | PF | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
2 | F05420 | Workflow Approval Table | 13 | WA | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
3 | F05430 | ESS User Defined Text | 1 | UT | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
4 | F085590 | Disability and Veteran Status History Table | 13 | DS | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
5 | F085590W | Disability Status Work Table | 5 | DS | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
6 | F085605W | Veteran Status Work Table | 7 | VS | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
TOP08: Human Resources |
7 | F05401 | Self-Service Process Flow Director Text | 1 | DT | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
8 | F08336B | Dep/Ben X-Reference Tag Table | 6 | E2 | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
9 | F08338 | Primary Care Physician Table | 10 | E7 | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
10 | F085510 | Benefit Categories by Enrollment Events | 1 | ER | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
11 | F085515 | Workflow Process File | 4 | WP | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
12 | F085520 | Available Plans and Plan Options by Employee History Table | 12 | PH | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
13 | F085520W | Available Plans and Plan Options by Employee Work Table | 29 | AP | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
14 | F085528 | ESS History Table Cross Reference | 4 | ES | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
15 | F085536 | Dependent/Beneficiary X-Reference History Table | 11 | DH | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
16 | F085536W | Dependent/Beneficiary X-Reference Work Table | 11 | DB | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
17 | F085550 | Employee Self-Service Personal Information Options | 1 | IO | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
TOP08B: Benefits Administration |
18 | F08320WF | Available Plans and Plan Options by Employee Work Table | 24 | BV | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
19 | F08330B | Employee Enrollment Tag File | 5 | BT | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
20 | F08336WF | Dependent/Beneficiary X-Ref Work Table | 12 | BD | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
21 | F08500 | Enrollment Event Setup | 2 | ES | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
22 | F08510 | Benefit Categories by Enrollment Events | 1 | BC | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
23 | F085518 | Benefit Confirmation Statement Options | 1 | SO | EECD | Enrollment Event Code | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.