Table 3. Field names, types, and descriptions from the API per Product Table t_Product_API.

Field Name	Data Type	Description
ProductCode	Number	Database internal unique product ID
API_name	Short Text
StrengthValue	Number	Original strength information from NIPH (not standardised)
StrengthUnit	Short Text	Original strength information from NIPH (not standardised)
API_ConcentrationPerItemValue	Number	Converted API strength value (with standardised unit if possible)
API_ConcentrationPerItemUnit	Short Text	Standardised API strength unit (if possible)
API_AmountPerPackageValue	Number	Calculated API amount value (with standardised unit if possible)
API_AmountPerPackageUnit	Short Text	Standardised API amount unit (if possible)
Comment	Short Text
Exclude	Short Text	Yes (if record should be excluded from extraction)

NIPH, Norwegian Institute of Public Health; API, Active Pharmaceutical Ingredient.