| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP31B: Blend Management |
| 1 | F31B62 | Sample Search Work Table | 8 | SS | SMPSTS | Sample Status | String | UDC | 3 | 0 |
| 2 | F31BSPZ1 | Sample Transactions | 16 | ST | SMPSTS | Sample Status | String | UDC | 3 | 0 |
| TOP37: Quality Management |
| 3 | F3712 | Sample Detail | 7 | SD | SMPSTS | Sample Status | String | UDC | 3 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 31B / QA (Sample Status) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | Blank | Y | Y |
| 2 | 100 | Created | Y | N |
| 3 | 200 | Checked in | | N |
| 4 | 300 | Sent to lab | | N |
| 5 | 400 | Collected | | N |
| 6 | 997 | Completed | | Y |
| 7 | 998 | Completed after close | | Y |
| 8 | 999 | Cancelled | | Y |
