S_OH_DN_Med_S ver 22.9.3
This table is an extension of the [Log] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| IRN | 22.9.3 | VarChar2(6) | IRN of the District. |
| Medicine | 22.9.3 | VarChar2(50) | What medicine is being procured or used, example: Glucagon, Inhalers, Epinepherine |
| Type | 22.9.3 | VarChar2(12) | What is being done with the medicine, usage, procurement, dosage, or error. |
| Quantity | 22.9.3 | Number(11,0) | Number of doses used, procured, given or had an error, must be whole numbers per state reporting |
| EffectiveDate | 22.9.3 | Date | Each Procurement/Used Date with the medicine in FY. |