| 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 | 2 | EH | PAN8 | Participant Address Number | Numeric | Generic Edit | 8 | 0 |
2 | F054101W | Employee Personal Profile Information Work Table | 2 | EP | PAN8 | Participant Address Number | Numeric | Generic Edit | 8 | 0 |
3 | F06107 | Employee Wage Attachment Rules | 27 | J$ | PAN8 | Participant Address Number | Numeric | Generic Edit | 8 | 0 |
TOP07: Payroll |
4 | F07107 | Employee Wage Attachment Rules | 32 | JW | PAN8 | Participant Address Number | Numeric | Generic Edit | 8 | 0 |
TOP08: Human Resources |
5 | F08336B | Dep/Ben X-Reference Tag Table | 2 | E2 | PAN8 | Participant Address Number | Numeric | Generic Edit | 8 | 0 |
6 | F085536 | Dependent/Beneficiary X-Reference History Table | 3 | DH | PAN8 | Participant Address Number | Numeric | Generic Edit | 8 | 0 |
7 | F085536W | Dependent/Beneficiary X-Reference Work Table | 3 | DB | PAN8 | Participant Address Number | Numeric | Generic Edit | 8 | 0 |
8 | F085537W | Current Dep/Ben X-Reference Work Table | 2 | XB | PAN8 | Participant Address Number | Numeric | Generic Edit | 8 | 0 |
TOP08B: Benefits Administration |
9 | F06024 | Beneficiary/Co-owner File | 4 | YJ | PAN8 | Participant Address Number | Numeric | Generic Edit | 8 | 0 |
10 | F08336 | Dep/Ben to Employee Plan X-Reference | 4 | BJ | PAN8 | Participant Address Number | Numeric | Generic Edit | 8 | 0 |
11 | F08336WF | Dependent/Beneficiary X-Ref Work Table | 3 | BD | PAN8 | Participant Address Number | Numeric | Generic Edit | 8 | 0 |
12 | F08371 | Reimbursement Spending Account Claims File | 11 | B6 | PAN8 | Participant Address Number | Numeric | Generic Edit | 8 | 0 |
13 | F08911 | Qualifying Event Information | 1 | HV | PAN8 | Participant Address Number | Numeric | Generic Edit | 8 | 0 |
14 | F08912 | Additional Qualifying Event | 1 | HB | PAN8 | Participant Address Number | Numeric | Generic Edit | 8 | 0 |
TOP08U: OW HR US |
15 | F08910 | COBRA Qualified Beneficiary File | 1 | J1 | PAN8 | Participant Address Number | Numeric | Generic Edit | 8 | 0 |
16 | F089101 | COBRA Subsequent Qualified Event Info. | 1 | J2 | PAN8 | Participant Address Number | Numeric | Generic Edit | 8 | 0 |
17 | F08920 | COBRA Coverage | 1 | JS | PAN8 | Participant Address Number | Numeric | Generic Edit | 8 | 0 |
18 | F08994 | COBRA Payment History | 1 | H1 | PAN8 | Participant Address Number | Numeric | Generic Edit | 8 | 0 |
19 | F08995 | COBRA Notification History | 1 | H2 | PAN8 | Participant Address Number | Numeric | Generic Edit | 8 | 0 |
20 | F08996 | COBRA Notice History | 1 | J3 | PAN8 | Participant Address Number | Numeric | Generic Edit | 8 | 0 |