08: Human Resources |
| Schema | Table | Prefix | Columns | Indexes | Description | Type | Report | Category |
---|
1 | 812 | F085536 | DH | 28 | 2 | Dependent/Beneficiary X-Reference History Table | Files | 08: Human Resources | |
Number | Description |
---|
1 | Evnt Emp Dep Plan Opt Esg (Primary/Unique) |
| Element | Alias | Description | Sequence |
---|
1 | EVET | Enrollment Event Type | Ascending | 2 | AN8 | Address Number | Ascending | 3 | PAN8 | Participant Address Number | Ascending | 4 | DBEN | Dependent/Beneficiary | Ascending | 5 | PLAN | Plan ID | Ascending | 6 | AOPT | Plan Additional Option | Ascending | 7 | ESIGN | E-Signature ID | Ascending |
|
2 | Event EE DB + A |
| Element | Alias | Description | Sequence |
---|
1 | EVET | Enrollment Event Type | Ascending | 2 | AN8 | Address Number | Ascending | 3 | DBEN | Dependent/Beneficiary | Ascending | 4 | PLAN | Plan ID | Ascending | 5 | AOPT | Plan Additional Option | Ascending | 6 | ESIGN | E-Signature ID | Ascending | 7 | NEWPERC | New Percentage - Beneficiary | Descending | 8 | NSECPERC | New Percentage - Secondary Beneficiary | Descending | 9 | PAN8 | Participant Address Number | Ascending |
|