08B: Benefits Administration |
| Schema | Table | Prefix | Columns | Indexes | Description | Type | Report | Category |
---|
1 | 812 | F08330 | BG | 18 | 9 | Employee Enrollment | Transaction Files | 08B: Benefits Administration | AS400 Coexistence Tables |
Number | Description |
---|
1 | Address Number Plan ID A+ (Primary/Unique) |
| Element | Alias | Description | Sequence |
---|
1 | AN8 | Address Number | Ascending | 2 | PLAN | Plan ID | Ascending | 3 | AOPT | Plan Additional Option | Ascending | 4 | EFT | Date - Effective | Ascending |
|
2 | Plan ID Dates Effect Rates |
| Element | Alias | Description | Sequence |
---|
1 | PLAN | Plan ID | Ascending | 2 | EFT | Date - Effective | Ascending |
|
3 | Plan ID Address Number A+ |
| Element | Alias | Description | Sequence |
---|
1 | PLAN | Plan ID | Ascending | 2 | AN8 | Address Number | Ascending | 3 | EFT | Date - Effective | Ascending |
|
4 | Plan ID Plan Additional Opt A+ |
| Element | Alias | Description | Sequence |
---|
1 | PLAN | Plan ID | Ascending | 2 | AOPT | Plan Additional Option | Ascending | 3 | EFT | Date - Effective | Ascending | 4 | AN8 | Address Number | Ascending |
|
5 | Plan ID Dates Effect Rates A+ |
| Element | Alias | Description | Sequence |
---|
1 | PLAN | Plan ID | Ascending | 2 | EFT | Date - Effective | Ascending | 3 | AN8 | Address Number | Ascending |
|
6 | Address Number Plan ID B+ |
| Element | Alias | Description | Sequence |
---|
1 | AN8 | Address Number | Ascending | 2 | EFT | Date - Effective | Ascending | 3 | PLAN | Plan ID | Ascending |
|
8 | Plan ID Address Number B+ |
| Element | Alias | Description | Sequence |
---|
1 | PLAN | Plan ID | Ascending | 2 | AN8 | Address Number | Ascending | 3 | EFT | Date - Effective | Descending |
|
9 | PlanId DateEffectRates |
| Element | Alias | Description | Sequence |
---|
1 | PLAN | Plan ID | Ascending | 2 | EFT | Date - Effective | Descending | 3 | AN8 | Address Number | Ascending |
|
10 | DateEffective PlanID A+ |
| Element | Alias | Description | Sequence |
---|
1 | EFT | Date - Effective | Descending | 2 | PLAN | Plan ID | Ascending | 3 | AN8 | Address Number | Ascending |
|