| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | HNREQN | Number - Requisition | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | HNMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 3 | HNPOS | Position ID | String | Generic Edit | 8 | 0 | Allow NULL? |
| 4 | HNDL01 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 5 | HNFY | Fiscal Year | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 6 | HNREQD | Date - Requisitioned (Julian) | Date | Generic Edit | 6 | 0 | |
| 7 | HNREQ | Address Number - Requested By | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 8 | HNREQS | Status - Requisition | String | UDC (08 RS) | 2 | 0 | Allow NULL? |
| 9 | HNREQT | Type Requisition | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 10 | HNEXS | Amount - Expected Salary | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 11 | HNBFTE | Full Time Equivalents - Budgeted | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 12 | HNHRB | Hours - Budgeted Position | Numeric | Generic Edit | 11 | 0 | Allow NULL? |
| 13 | HNJBCD | Job Type (Craft) Code | String | UDC (06 G) | 6 | 0 | Allow NULL? |
| 14 | HNJBST | Job Step | String | UDC (06 GS) | 4 | 0 | Allow NULL? |
| 15 | HNPGRD | Pay Grade | String | Generic Edit | 6 | 0 | Allow NULL? |
| 16 | HNPGRS | Pay Grade Step | String | Generic Edit | 4 | 0 | Allow NULL? |
| 17 | HNSLOC | Salary Data Locality | String | UDC (06 SL) | 8 | 0 | Allow NULL? |
| 18 | HNSALY | Pay Class (H/S/P) | Character | UDC (05A PK) | 1 | 0 | Allow NULL? |
| 19 | HNEFTS | Date - Effective From | Date | Generic Edit | 6 | 0 | |
| 20 | HNEFST | Date - Effective Thru | Date | Generic Edit | 6 | 0 | |
| 21 | HNEFTB | Date - Beginning Effective | Date | Generic Edit | 6 | 0 | |
| 22 | HNFLSA | FLSA Exempt Y/N | Character | UDC (05 FL) | 1 | 0 | Allow NULL? |
| 23 | HNAPRV | Address Number - Approved by | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 24 | HNAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 25 | HNAPRD | Date - Approved (Julian) | Date | Generic Edit | 6 | 0 | |
| 26 | HNDL02 | Description 02 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 27 | HND240 | Description | String | Generic Edit | 240 | 0 | Allow NULL? |
| 28 | HNRX01 | Category Code - Requisition 01 | String | UDC (08 R1) | 3 | 0 | Allow NULL? |
| 29 | HNRX02 | Category Code - Requisition 02 | String | UDC (08 R2) | 3 | 0 | Allow NULL? |
| 30 | HNRX03 | Category Code - Requisition 03 | String | UDC (08 R3) | 3 | 0 | Allow NULL? |
| 31 | HNRX04 | Category Code - Requisition 04 | String | UDC (08 R4) | 3 | 0 | Allow NULL? |
| 32 | HNRX05 | Category Code - Requisition 05 | String | UDC (08 R5) | 3 | 0 | Allow NULL? |
| 33 | HNUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 34 | HNPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 35 | HNUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 36 | HNJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 37 | HNHMCU | Business Unit - Home | String | Generic Edit | 12 | 0 | Allow NULL? |
| 38 | HNRX06 | Category Code - Requisition 06 | String | UDC (08 R6) | 3 | 0 | Allow NULL? |
| 39 | HNRX07 | Category Code - Requisition 07 | String | UDC (08 R7) | 3 | 0 | Allow NULL? |
| 40 | HNRX08 | Category Code - Requisition 08 | String | UDC (08 R8) | 3 | 0 | Allow NULL? |
| 41 | HNRX09 | Category Code - Requisition 09 | String | UDC (08 R9) | 3 | 0 | Allow NULL? |
| 42 | HNRX10 | Category Code - Requisition 10 | String | UDC (08 R0) | 3 | 0 | Allow NULL? |
| 43 | HNEXS2 | Amount - Expected Salary | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 44 | HNHDCT | Headcount | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 45 | HNDTPF | Date Position Filled | Date | Generic Edit | 6 | 0 | |
| 46 | HNPSTP | No. of Pay Grade Steps | String | Generic Edit | 4 | 0 | Allow NULL? |
| 47 | HNFBDT | Fill By Date | Date | Generic Edit | 6 | 0 | |