| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | I7HSINO | Incident Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | I7UKID | Unique Key ID (Internal) | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 3 | I7HSIMN | Incident Modification Number | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 4 | I7HSIMT | Incident Modification Type | Character | UDC (54HS MT) | 1 | 0 | Allow NULL? |
| 5 | I7MODDT | Modification Date | Date | Generic Edit | 6 | 0 | |
| 6 | I7RCK7 | Line Number ID - 5.0 | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 7 | I7ISSUE | Problem Description | String | Generic Edit | 80 | 0 | Allow NULL? |
| 8 | I7DL01 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 9 | I7HSITT | Incident Task Type | String | UDC (54HS TT) | 2 | 0 | Allow NULL? |
| 10 | I7PRIOR | Issue Priority | String | UDC (17 PR) | 2 | 0 | Allow NULL? |
| 11 | I7CLST | Case Status Code | String | UDC (17 ST) | 3 | 0 | Allow NULL? |
| 12 | I7ANP | Address Number - Assigned To | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 13 | I7NAME | Name | String | Generic Edit | 30 | 0 | Allow NULL? |
| 14 | I7HSITBD | Task Beginning Date | Date | Generic Edit | 11 | 0 | |
| 15 | I7HSITED | Task Ending Date | Date | Generic Edit | 11 | 0 | |
| 16 | I7REM1 | Remark 1 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 17 | I7HSIT1 | Incident Task Category Code 1 | String | UDC (54HS T1) | 3 | 0 | Allow NULL? |
| 18 | I7HSIT2 | Incident Task Category Code 2 | String | UDC (54HS T2) | 3 | 0 | Allow NULL? |
| 19 | I7HSIT3 | Incident Task Category Code 3 | String | UDC (54HS T3) | 3 | 0 | Allow NULL? |
| 20 | I7HSIT4 | Incident Task Category Code 4 | String | UDC (54HS T4) | 3 | 0 | Allow NULL? |
| 21 | I7HSIT5 | Incident Task Category Code 5 | String | UDC (54HS T5) | 3 | 0 | Allow NULL? |
| 22 | I7URAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 23 | I7URCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 24 | I7URAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 25 | I7URDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 26 | I7URRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 27 | I7USER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 28 | I7UPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 29 | I7UPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 30 | I7JOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 31 | I7PID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 32 | I7HSIECD | Task Estimated Completion Date | Date | Generic Edit | 6 | 0 | |
| 33 | I7HSIACD | Task Actual Completed Date | Date | Generic Edit | 6 | 0 | |
| 34 | I7HSIT6 | Incident Task Category Code 6 | String | UDC (54HS T6) | 10 | 0 | Allow NULL? |
| 35 | I7HSIT7 | Incident Task Category Code 7 | String | UDC (54HS T7) | 10 | 0 | Allow NULL? |
| 36 | I7HSIT8 | Incident Task Category Code 8 | String | UDC (54HS T8) | 10 | 0 | Allow NULL? |
| 37 | I7HSIT9 | Incident Task Category Code 9 | String | UDC (54HS T9) | 10 | 0 | Allow NULL? |
| 38 | I7HSIT10 | Incident Task Category Code 10 | String | UDC (54HS T0) | 10 | 0 | Allow NULL? |
