| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | HPFY | Fiscal Year | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 2 | HPPOS | Position ID | String | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | HPMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 4 | HPDL01 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 5 | HPDL02 | Description 02 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 6 | HPEFTS | Date - Effective From | Date | Generic Edit | 6 | 0 | |
| 7 | HPEFST | Date - Effective Thru | Date | Generic Edit | 6 | 0 | |
| 8 | HPPSTC | Status - Budget | Character | UDC (08 PC) | 1 | 0 | Allow NULL? |
| 9 | HPCURB | Amount - Position Budget | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 10 | HPBFTE | Full Time Equivalents - Budgeted | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 11 | HPHRB | Hours - Budgeted Position | Numeric | Generic Edit | 11 | 0 | Allow NULL? |
| 12 | HPPMCU | Business Unit - Parent | String | Generic Edit | 12 | 0 | Allow NULL? |
| 13 | HPPPOS | Parent Position ID | String | Generic Edit | 8 | 0 | Allow NULL? |
| 14 | HPJBCD | Job Type (Craft) Code | String | UDC (06 G) | 6 | 0 | Allow NULL? |
| 15 | HPJBST | Job Step | String | UDC (06 GS) | 4 | 0 | Allow NULL? |
| 16 | HPSLOC | Salary Data Locality | String | UDC (06 SL) | 8 | 0 | Allow NULL? |
| 17 | HPPX01 | User Defined Code - Position 01 | String | UDC (08 P1) | 3 | 0 | Allow NULL? |
| 18 | HPPX02 | User Defined Code - Position 02 | String | UDC (08 P2) | 3 | 0 | Allow NULL? |
| 19 | HPPX03 | User Defined Code - Position 03 | String | UDC (08 P3) | 3 | 0 | Allow NULL? |
| 20 | HPPX04 | User Defined Code - Position 04 | String | UDC (08 P4) | 3 | 0 | Allow NULL? |
| 21 | HPPX05 | User Defined Code - Position 05 | String | UDC (08 P5) | 3 | 0 | Allow NULL? |
| 22 | HPUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 23 | HPPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | HPUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 25 | HPJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 26 | HPHMCU | Business Unit - Home | String | Generic Edit | 12 | 0 | Allow NULL? |
| 27 | HPTPOS | Position Type | String | Generic Edit | 3 | 0 | Allow NULL? |
| 28 | HPSPAM | Amount - Spending Authorization Level | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 29 | HPPBSD | Budget Status Date | Date | Generic Edit | 6 | 0 | |
| 30 | HPPSST | Position Status | Character | UDC (08 PL) | 1 | 0 | Allow NULL? |
| 31 | HPPSSD | Position Status Date | Date | Generic Edit | 6 | 0 | |
| 32 | HPHDCT | Headcount | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 33 | HPEFFB | Amount - Effective Budget | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 34 | HPEFHR | Hours - Effective Budget | Numeric | Generic Edit | 11 | 0 | Allow NULL? |
| 35 | HPFTEE | Full Time Equivalents | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
