You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The attribute measured_compound_derivation_type (can be renamed if necessary) is likely to be an important part of the MIFC standard, denoting of a value is analytical, calculated, inferred/estimated, sourced from literature, labelled data, etc. As such I think it should be a required field.
See the FDC SR legacy csv export'sfood_nutrient_derivation.csv file with a longer list of possibilities (79). Some of those could probably be broken up with extra additional supporting fields to capture other metadata. For example we may want to have another source field (e.g. measured_compound_derivation_source) for if the data was from literature or external source to say where it was from doi or name of institution perhaps? Other metadata fields like specific retention factors uses/not used for concentration adjustments).
For the moment the enumeration could look something like the following:
analytical
calculated (break this down into from other foods and from a linear regression etc)
literature sourced (this could also just be analytical or another type which is sourced from elsewhere)
inferred/estimated (from ingredient list/recipe, foods physical composition, another/similar foods etc)
label claim
assumed zero
Could also break it down to have a field from if the measured_compound value is original or if it's externally sourced. Not sure how that would fit with calculated/inferred values. Much more to be done here. Could use additional expertise.
The text was updated successfully, but these errors were encountered:
In order to accommodate food label data, component_derivation_type should probably be a required field and be used to differentiate analytical data from label claims, or other things like calculated values etc.
Example from the USDA MAFCL special interest iodine database, we encounter examples of borrowed data from another institution/organization.
This is maybe similar to literature sourced, perhaps this can be captured with an additional enum value here such as externally sourced data record. Or possibly this might require a new MIFC slot for compound_analytical_organization_name?
The attribute
measured_compound_derivation_type
(can be renamed if necessary) is likely to be an important part of the MIFC standard, denoting of a value is analytical, calculated, inferred/estimated, sourced from literature, labelled data, etc. As such I think it should be a required field.See the FDC SR legacy csv export's
food_nutrient_derivation.csv
file with a longer list of possibilities (79). Some of those could probably be broken up with extra additional supporting fields to capture other metadata. For example we may want to have another source field (e.g.measured_compound_derivation_source
) for if the data was from literature or external source to say where it was from doi or name of institution perhaps? Other metadata fields like specific retention factors uses/not used for concentration adjustments).For the moment the enumeration could look something like the following:
Could also break it down to have a field from if the measured_compound value is original or if it's externally sourced. Not sure how that would fit with calculated/inferred values. Much more to be done here. Could use additional expertise.
The text was updated successfully, but these errors were encountered: