| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP54HS: Health & Safety Incident Mgt |
| 1 | F54HS01 | Incident Master | 46 | S1 | HSIDAR | Drug and Alcohol Result | String | UDC | 2 | 0 |
| 2 | F54HS01M | Incident Master Change History | 49 | I1 | HSIDAR | Drug and Alcohol Result | String | UDC | 2 | 0 |
| 3 | F54HS02 | Incident People | 36 | S2 | HSIDAR | Drug and Alcohol Result | String | UDC | 2 | 0 |
| 4 | F54HS02M | Incident People Change History | 39 | I2 | HSIDAR | Drug and Alcohol Result | String | UDC | 2 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 54HS / DR (Drug and Alcohol Result) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | Default | | N |
| 2 | 00 | Other | | N |
| 3 | 01 | Negative | | N |
| 4 | 02 | Positive - Alcohol | | N |
| 5 | 03 | Positive - Drugs | | N |
| 6 | 04 | Positive - Cannabis | | N |
| 7 | 05 | Positive - Multiple Substances | | N |
| 8 | 99 | Unknown | | N |
