| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | I9HSINO | Incident Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | I9UKID | Unique Key ID (Internal) | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 3 | I9HSIMN | Incident Modification Number | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 4 | I9HSIMT | Incident Modification Type | Character | UDC (54HS MT) | 1 | 0 | Allow NULL? |
| 5 | I9MODDT | Modification Date | Date | Generic Edit | 6 | 0 | |
| 6 | I9HSIEC | Environmental Classification | String | UDC (54HS EC) | 3 | 0 | Allow NULL? |
| 7 | I9HSISEI | Severity of Environmental Impact | String | UDC (54HS SE) | 2 | 0 | Allow NULL? |
| 8 | I9HSIENS | Environmental Impact Status | String | UDC (54HS ES) | 2 | 0 | Allow NULL? |
| 9 | I9HSICP | Contractor Responsible for Product | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 10 | I9HSIPS | Product or Substance Spilled | String | UDC (54HS PS) | 6 | 0 | Allow NULL? |
| 11 | I9ITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 12 | I9DSC1 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 13 | I9HSIQS | Quantity Spilled / Released | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 14 | I9UOM | Unit of Measure as Input | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 15 | I9HSIRP | Remediation Party | String | Generic Edit | 40 | 0 | Allow NULL? |
| 16 | I9HSIEVC | Environmental Impact Comment | String | Generic Edit | 200 | 0 | Allow NULL? |
| 17 | I9HSIQT1 | Environment Quantity 1 | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 18 | I9HSIUM1 | Environment Unit of Measure 1 | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 19 | I9HSIQT2 | Environment Quantity 2 | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 20 | I9HSIUM2 | Environment Unit of Measure 2 | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 21 | I9HSIQT3 | Environment Quantity 3 | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 22 | I9HSIUM3 | Environment Unit of Measure 3 | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 23 | I9HSIV1 | Environment Category Code 1 | String | UDC (54HS V1) | 3 | 0 | Allow NULL? |
| 24 | I9HSIV2 | Environment Category Code 2 | String | UDC (54HS V2) | 3 | 0 | Allow NULL? |
| 25 | I9HSIV3 | Environment Category Code 3 | String | UDC (54HS V3) | 3 | 0 | Allow NULL? |
| 26 | I9HSIV4 | Environment Category Code 4 | String | UDC (54HS V4) | 3 | 0 | Allow NULL? |
| 27 | I9HSIV5 | Environment Category Code 5 | String | UDC (54HS V5) | 3 | 0 | Allow NULL? |
| 28 | I9URAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 29 | I9URCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 30 | I9URAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 31 | I9URDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 32 | I9URRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 33 | I9USER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 34 | I9UPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 35 | I9UPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 36 | I9JOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 37 | I9PID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
