Table 2. Field names, types, and descriptions for the Product Table t_Product.
| Field name | Data type | Description |
|---|---|---|
| ProductCode | Number | Database internal unique product ID |
| ProductName | Short Text | Full product name from NIPH records |
| ProductName_short | Short Text | Product name with medium/dose removed |
| ATC_code | Short Text | Full ATC Code |
| ProductDetails | Short Text | Additional medium/dose data from ProductName |
| ProductType | Short Text | Standardised medium: pill, fluid, etc. |
| PackageQuantityValue | Number | Quantity of medium per package (number of pills, L of fluid, etc.) |
| PackageQuantityUnit | Short Text | Unit of medium per package |
| NoOfAPI_PerProduct | Number | Number of APIs in a product |
NIPH, Norwegian Institute of Public Health; ATC, Anatomical Therapeutic Classification; API, Active Pharmaceutical Ingredient.