08: Human Resources |
| Schema | Table | Prefix | Columns | Indexes | Description | Type | Report | Category |
---|
1 | 812 | F085530W | CP | 30 | 3 | Employee Current/Pending Elections Work Table | Files | 08: Human Resources | |
Number | Description |
---|
1 | Emp Num Seq Num Ben Cat + (Primary/Unique) |
| Element | Alias | Description | Sequence |
---|
1 | AN8 | Address Number | Ascending | 2 | SEQ# | Sequence Number for View | Ascending | 3 | SBGR | Benefit Group Category | Ascending | 4 | PLAN | Plan ID | Ascending | 5 | AOPT | Plan Additional Option | Ascending | 6 | EFT | Date - Effective | Ascending |
|
2 | AN8 BCATCL SEQN SEQ# AOPT |
| Element | Alias | Description | Sequence |
---|
1 | AN8 | Address Number | Ascending | 2 | BCATCL | Benefit Category Classification | Ascending | 3 | SEQN | Sequence Number | Ascending | 4 | SEQ# | Sequence Number for View | Ascending | 5 | AOPT | Plan Additional Option | Ascending |
|
4 | AN8 EFT |
| Element | Alias | Description | Sequence |
---|
1 | AN8 | Address Number | Ascending | 2 | EFT | Date - Effective | Descending |
|