As a 360 giving staff member
I want to see how many mandatory, recommended & optional fields have been included
So I can check completeness of the data
3/4 parts of completeness for a field:
field is present in the data
proportion of rows with a non-null value
proportion of rows with a valid value (matching regex? Correct type mapping?)
(for some fields: value is externally validated against list)
Example of 3/4: For currency field, check in part 3 would be that the value is 3 characters long and only has alpha characters (regex [A-Z]{3}). For part 4 it would check that each code actually exists in the ISO 4217 list
As a 360 giving staff member I want to see how many mandatory, recommended & optional fields have been included So I can check completeness of the data
3/4 parts of completeness for a field:
Example of 3/4: For currency field, check in part 3 would be that the value is 3 characters long and only has alpha characters (regex
[A-Z]{3}). For part 4 it would check that each code actually exists in the ISO 4217 list