| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | HIAN8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | HIPLAN | Plan ID | String | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | HIYRA | Year - Pension Activity | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 4 | HIHRV | Hours - Vesting | Numeric | Generic Edit | 7 | 0 | Allow NULL? |
| 5 | HIYVS | Years - Vesting Service | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 6 | HIHRBN | Hours - Benefit | Numeric | Generic Edit | 7 | 0 | Allow NULL? |
| 7 | HIYBS | Years - Benefit Service | Numeric | Generic Edit | 7 | 4 | Allow NULL? |
| 8 | HISLR1 | Rate - Pension Salary 1 | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 9 | HISLR2 | Rate - Pension Salary 2 | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 10 | HISLR3 | Rate - Pension Salary 3 | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 11 | HISLR4 | Rate - Pension Salary 4 | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 12 | HISLR5 | Rate - Pension Salary 5 | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 13 | HIFAV1 | Rate - Final Average Pay 1 | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 14 | HIFAV2 | Rate - Final Average Pay 2 | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 15 | HIFAV3 | Rate - Final Average Pay 3 | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 16 | HIFAV4 | Rate - Final Average Pay 4 | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 17 | HIFAV5 | Rate - Final Average Pay 5 | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 18 | HIBEN1 | Rate - Calculated Benefit 1 | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 19 | HIBEN2 | Rate - Calculated Benefit 2 | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 20 | HIBEN3 | Rate - Calculated Benefit 3 | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 21 | HIBEN4 | Rate - Calculated Benefit 4 | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 22 | HIBEN5 | Rate - Calculated Benefit 5 | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 23 | HITPLN | Plan ID - Transfer To | String | Generic Edit | 8 | 0 | Allow NULL? |
| 24 | HICPBS | Prompt - Carry Prior Benefit Service Y/N | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 25 | HIUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 26 | HIPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 27 | HIUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 28 | HIJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |