Quality indicator for passport data (PDCI)
A free script database to measure quality passport data base on 35 MCPD descriptors (V.2).
The script use the methodology described by Theo van Hintum in his publication of 2011 about PDCI indicator.
The T-SQL function use the short name of MCPD descriptors as parameters, you can add this function in a view:
select Field1, Field2, dbo.FN_CalcPDCI(Field3,Field4,Field5,.....) as PDCI from PassportTable where crop='potato'
Special thanks to Theo van Hintum who provided the VBA source code version and CIP created the T-SQL version for MSSQL engine database.