08B: Benefits Administration |
| Schema | Table | Prefix | Columns | Indexes | Description | Type | Report | Category |
---|
1 | 910 | F06024 | YJ | 12 | 2 | Beneficiary/Co-owner File | Extra Features Files | 08B: Benefits Administration | Business Data |
2 | 910 | F08320 | BA | 67 | 2 | Benefits Plan Master | Master Files | 08B: Benefits Administration | Business Data |
3 | 910 | F083201 | B1 | 3 | 1 | Plan Master Text | Secondary Master Files | 08B: Benefits Administration | Business Data |
4 | 910 | F083202 | B5 | 19 | 2 | Plan Additional Options | Secondary Master Files | 08B: Benefits Administration | Business Data |
5 | 910 | F083202B | MD | 8 | 3 | Plan Additional Option Tag Table | Files | 08B: Benefits Administration | |
6 | 910 | F083203 | BG | 12 | 1 | Plan Master Rates | Master Files | 08B: Benefits Administration | Business Data |
7 | 910 | F08320B | PP | 12 | 2 | Plan/Plan Option Tag Table | Work Files | 08B: Benefits Administration | |
8 | 910 | F08320D | PD | 20 | 1 | Plan Master Tag Table | Files | 08B: Benefits Administration | |
9 | 910 | F08320WF | BV | 32 | 1 | Available Plans and Plan Options by Employee Work Table | Work Files | 08B: Benefits Administration | Business Data |
10 | 910 | F08320X | PX | 3 | 2 | Plan Name Conversion | Files | 08B: Benefits Administration | |
11 | 910 | F08321 | BE | 3 | 1 | Vesting Schedules | Constants Files | 08B: Benefits Administration | Business Data |
12 | 910 | F08330 | BG | 18 | 9 | Employee Enrollment | Transaction Files | 08B: Benefits Administration | Business Data |
13 | 910 | F08330B | BT | 14 | 1 | Employee Enrollment Tag File | Transaction Files | 08B: Benefits Administration | Business Data |
14 | 910 | F08330C | PC | 10 | 1 | Employee Enrollment Tag Table C | Files | 08B: Benefits Administration | |
15 | 910 | F08330WF | BR | 19 | 1 | Employee Current/Pending Elections Work Table | Work Files | 08B: Benefits Administration | Business Data |
16 | 910 | F08336 | BJ | 13 | 5 | Dep/Ben to Employee Plan X-Reference | Secondary Master Files | 08B: Benefits Administration | Business Data |
17 | 910 | F08336WF | BD | 23 | 2 | Dependent/Beneficiary X-Ref Work Table | Work Files | 08B: Benefits Administration | Business Data |
18 | 910 | F0833WF | WF | 154 | 2 | Benefit Statement Work file | Work Files | 08B: Benefits Administration | Business Data |
19 | 910 | F08345 | B3 | 2 | 1 | 401(k) Elections Setup | Extra Features Files | 08B: Benefits Administration | Business Data |
20 | 910 | F08346 | B4 | 6 | 1 | 401(K) Elections | Extra Features Files | 08B: Benefits Administration | Business Data |
21 | 910 | F08350 | BK | 5 | 3 | Categories within Benefit Groups | Secondary Master Files | 08B: Benefits Administration | Business Data |
22 | 910 | F08350B | I8 | 8 | 1 | Benefit Categories by Benefit Group Tag Table | Secondary Master Files | 08B: Benefits Administration | Business Data |
23 | 910 | F08351 | BU | 7 | 2 | Plans within Benefit Categories | Secondary Master Files | 08B: Benefits Administration | Business Data |
24 | 910 | F08351B | PC | 5 | 1 | Plans within Categories Tag Table | Secondary Master Files | 08B: Benefits Administration | Business Data |
25 | 910 | F08370 | B7 | 20 | 3 | Reimbursement Spending Acct - Balance File | Balance Files | 08B: Benefits Administration | Business Data |
26 | 910 | F08371 | B6 | 36 | 7 | Reimbursement Spending Account Claims File | Transaction Files | 08B: Benefits Administration | Business Data |
27 | 910 | F08372 | BM | 18 | 2 | FSA - Pay Instruction File | Extra Features Files | 08B: Benefits Administration | Business Data |
28 | 910 | F08380WF | BE | 23 | 1 | Batch Enrollment Work File | Work Files | 08B: Benefits Administration | Business Data |
29 | 910 | F08381WF | RC | 14 | 1 | Recalculate Plan Option Costs | Work Files | 08B: Benefits Administration | Business Data |
30 | 910 | F08390 | B9 | 16 | 1 | Eligibility | Constants Files | 08B: Benefits Administration | Business Data |
31 | 910 | F08392 | BF | 14 | 1 | Batch Enrollment Parameters | Constants Files | 08B: Benefits Administration | Business Data |
32 | 910 | F08395 | B8 | 14 | 1 | Enrollment Date Terms | Constants Files | 08B: Benefits Administration | Business Data |
33 | 910 | F08500 | ES | 12 | 1 | Enrollment Event Setup | Constants Files | 08B: Benefits Administration | Business Data |
34 | 910 | F08501 | HH | 29 | 2 | Employee Pension Activity Master | Master Files | 08B: Benefits Administration | Business Data |
35 | 910 | F08502 | HI | 28 | 2 | Pension Plan Activity Balance | Balance Files | 08B: Benefits Administration | Business Data |
36 | 910 | F08505 | BS | 9 | 1 | Benefit Self Service Constant | Files | 08B: Benefits Administration | Business Data |
37 | 910 | F08510 | BC | 8 | 1 | Benefit Categories by Enrollment Events | Constants Files | 08B: Benefits Administration | Business Data |
38 | 910 | F08511 | HJ | 8 | 1 | Employee Pension Activity Detail | Transaction Files | 08B: Benefits Administration | Business Data |
39 | 910 | F08515 | QB | 7 | 1 | Plan DBA/Enrollment DBA Cross Reference | Secondary Master Files | 08B: Benefits Administration | Business Data |
40 | 910 | F085201 | HK | 22 | 1 | Pension Plan Calculation Rules | Constants Files | 08B: Benefits Administration | Business Data |
41 | 910 | F085303W | W4 | 22 | 2 | IRS W-4 Form Work File | Files | 08B: Benefits Administration | |
42 | 910 | F085518 | SO | 24 | 1 | Benefit Confirmation Statement Options | Files | 08B: Benefits Administration | |
43 | 910 | F085573W | MM | 11 | 1 | Entered Benefit Amount/Rate Edits | Files | 08B: Benefits Administration | |
44 | 910 | F085574 | MI | 11 | 1 | Maximum Insurance Coverage Increase Amounts | Files | 08B: Benefits Administration | |
45 | 910 | F08593 | H7 | 7 | 1 | Retirement Rule Definition | Constants Files | 08B: Benefits Administration | Business Data |
46 | 910 | F08901 | HU | 29 | 2 | Participant file | Master Files | 08B: Benefits Administration | Business Data |
47 | 910 | F08911 | HV | 17 | 1 | Qualifying Event Information | Transaction Files | 08B: Benefits Administration | Business Data |
48 | 910 | F08912 | HB | 8 | 1 | Additional Qualifying Event | Transaction Files | 08B: Benefits Administration | Business Data |