Vanilla, processed · Calculation Rules

Calculation Rules

rule_id	Applies to	Formula or rule	Inputs	Output	source_ids
calc_normalize_reference	Every inventory row	normalized_amount = lot_amount / net_packaged_processed_vanilla_kg × 1000	lot_amount; net_packaged_processed_vanilla_kg	amount per 1,000 kg reference flow	—
calc_accepted_fresh_pods	Receiving	accepted_fresh_pods_kg = received_fresh_pods_kg - rejected_fresh_pods_kg - vanilla_plant_debris_kg	received_fresh_pods_kg; rejected_fresh_pods_kg; vanilla_plant_debris_kg	accepted_fresh_pods_kg	—
calc_stage_water_loss	Killing, sweating, drying, conditioning	water_to_air_kg = input_mass_kg + water_input_kg - product_output_kg - solid_waste_kg - wastewater_or_condensate_kg; investigate and do not publish a negative residual.	stage input/output masses; water input; solid wastes; wastewater/condensate	water_to_air_kg	—
calc_net_packaged_product	Packaging	net_packaged_processed_vanilla_kg = gross_packed_lot_kg - sum(packaging_component_mass_kg)	gross packed mass; each packaging-component mass	net packaged processed vanilla mass	codex-rep25-sch-vanilla
calc_fresh_to_product_ratio	Whole route	fresh_to_product_ratio = accepted_fresh_pods_kg / net_packaged_processed_vanilla_kg	accepted fresh pods; net packaged product	kg/kg ratio	fao-vanilla-postharvest
calc_active_cleaning_chemical	Sanitation chemicals	active_chemical_kg = formulation_kg × supplier_declared_active_mass_fraction	formulation mass; active mass fraction	active NaOH or peracetic-acid mass	—
calc_dry_mass_allocation	Joint saleable cured products	allocation_share_i = product_i_kg × (1 - moisture_fraction_i) / sum(product_j_kg × (1 - moisture_fraction_j))	product masses; moisture fractions	dry-mass allocation shares	iso-14044-2006

Data Quality Requirements

requirement_id	Applies to	Requirement	Evidence
dq_identity	Reference product and intermediates	Preserve lot linkage from fresh pods to packaged product and declare species, origin, selected form, grade, moisture, and package configuration.	Receiving, process, laboratory, and packaging lot records
dq_temporal	Foreground inventory	Cover at least 12 consecutive months when production is year-round; for a shorter campaign, cover every lot and disclose campaign dates.	Dated raw records and production calendar
dq_technology	Killing, sweating, drying, conditioning, finishing	Report actual equipment and schedules; do not mix passive and controlled routes or mutually exclusive form processes into one unqualified average.	Equipment list, route gate, logger exports, batch sheets
dq_mass_balance	Every mass-transforming process	Reconcile measured inputs to product, waste, wastewater/condensate, and calculated water loss; investigate material residuals and disclose corrections.	Signed mass-balance worksheet and calibration evidence
dq_energy	Electricity	Prefer submeters; otherwise use verified equipment power × operating time and disclose allocation. Do not use a combined thermal-energy amount.	Meter export or equipment calculation worksheet
dq_atomicity	All inventory	One card equals one physical or chemical exchange. Any actually used fuel, steam, hot water, refrigerant, chemical, packaging component, waste, or emission absent from these representative cards must be added as a specific atomic exchange with blank UUID until verified.	Atomic-flow audit and purchase/emission records
dq_quality_test	Finished product	Use the declared method and species/form/class specification; preserve sample identity, result, wet/dry basis, method version, and laboratory.	Laboratory report and sampling chain of custody
dq_sources	External constraints	Preserve source id and retrieved reference; never use a search snippet as quantitative evidence.	Source register matching Section 11
dq_reasoned_estimate	Provisional ranges	Replace each reasoned_estimate with foreground or reviewed external evidence before using it as a publication-critical conformance interval; test both bounds when material.	Sensitivity worksheet and replacement status

9. Validation Rules

rule_id	Applies to	Rule	source_ids
validate_identity	Foreground package	Fail if PCR id, reference-flow UUID, species, selected product form, net reference mass, or production lot is missing or inconsistent.	unsd-cpc3-23928; codex-rep25-sch-vanilla
validate_route_chain	Process coverage	Fail unless receiving, hot-water killing, sweating, staged drying, conditioning, grading/form selection, packaging, and sanitation are represented for the lot.	fao-vanilla-postharvest; sanchez-2008-vanilla-killing
validate_form_gate	Conditional processes	Fail if more than one of cutting, grinding, or pod opening is active for the same reference output, or if the active process does not match selected_product_form.	codex-rep25-sch-vanilla; iso-5565-1-1999
validate_extraction_excluded	Boundary	Fail if ethanol, another extraction solvent, extract, oleoresin, isolated vanillin, or extraction residue is included as part of the reference route.	iso-5565-1-1999; uf-ifas-vanilla-production
validate_atomic_flows	Inventory	Fail any card whose selected flow combines more than one utility, fuel, refrigerant, material, chemical, packaging component, waste, wastewater, or emission.	—
validate_uuid_policy	UUID references	Fail if an inventory flow other than the Section 3 reference identity carries an unverified UUID; unresolved atomic flow names remain UUID-blank until exact Tiangong verification.	—
validate_mass_balance	Each process	Fail negative masses or unexplained duplicate counting; flag any material mass residual outside the facility's documented scale uncertainty.	—
validate_moisture_quality	Finished product	Fail if the declared moisture result is absent or checked against an averaged or wrong species/form/class requirement; for representative V. planifolia whole Class I, require 30–36% w/w.	codex-rep25-sch-vanilla
validate_pest_extraneous	Finished product	Require live-insect count and applicable extraneous-matter result; the cited Codex table sets live insects to zero for covered forms.	codex-rep25-sch-vanilla
validate_packaging	Packaging	Fail if gross and net product mass are conflated or if the active package configuration lacks component-level masses.	fao-vanilla-postharvest; codex-rep25-sch-vanilla
validate_used_utility_coverage	Utilities and direct emissions	Fail when operating or purchase records show a fuel, steam, refrigerant, cleaning chemical, or direct emission that has no specific atomic row and collection method.	iso-14044-2006
validate_source_closure	Evidence	Fail if a non-empty source id in a rule or card is absent from Section 11, or if a quantitative external range lacks its cited source.	—
validate_protocol_coverage	Collected/calculated rows	Fail if a collected_record or calculated_from_collection card lacks a matching collection protocol and required raw fields.	—

10. Published Dataset Profile

Field	Value
dataset_role	Foreground production data package for processed vanilla and its process/lifecyclemodel projections.
downstream_use	secondary_dataset; background_dataset after review and publication controls.
allowed_use	LCA of cured and mechanically finished vanilla in the declared species, form, grade, moisture, route, geography, period, and package configuration.
excluded_use	Vanilla extract, oleoresin, isolated or synthetic vanillin, unprocessed vanilla, an undeclared mixture of forms/routes, or comparative claims beyond the represented technology and geography.
required_metadata	PCR id/version; reference-flow UUID; species; origin and harvest facts; lot; selected form; grade; moisture/method; killing/sweating/drying/conditioning schedules; package BOM; allocation; geography; period; source ids; data gaps.
required_quality_disclosure	Foreground coverage; mass-balance closure; meter and scale calibration; laboratory methods; route-specific zero/not-applicable decisions; unresolved UUIDs; reasoned-estimate sensitivity; allocation sensitivity; exclusions.
update_trigger	New reviewed process/yield evidence; change in Codex or ISO vanilla specification; new killing/drying/form technology; package redesign; material change in energy, water, loss, moisture, or allocation; resolution of inventory UUIDs.

11. Data Sources

Source id	Type	Reference	Used for
unsd-cpc3-23928	official_guidance	United Nations Statistics Division, Draft CPC Version 3.0 Explanatory Notes, code 23928, pp. 109–110. https://unstats.un.org/unsd/classifications/Meetings/UNCEISC2024_2nd/Session7_Bk2_CPC3_Exp_Notes_1Nov2024.pdf (retrieved 2026-08-13)	Classification scope: processed forms included; unprocessed vanilla excluded.
codex-rep25-sch-vanilla	standard	Codex Alimentarius Commission, REP25/SCH, Appendix III, Standard for spices derived from dried or dehydrated fruits and berries—requirements for vanilla, pp. 24–29. https://www.fao.org/fao-who-codexalimentarius/sh-proxy/fr/?lnk=1&url=https%253A%252F%252Fworkspace.fao.org%252Fsites%252Fcodex%252FMeetings%252FCX-736-08%252F%25E2%2598%2585Final%252520report%252FREP25_SCHe.pdf (retrieved 2026-08-13)	Species and product styles; moisture/vanillin cells; extraneous matter and live insects; hygiene; package and label facts; analytical methods.
codex-cac49-vanilla-adoption	official_guidance	Codex Alimentarius, “CAC49 / New and revised science-based standards now added to the Codex Alimentarius,” 12 July 2026. https://www.fao.org/fao-who-codexalimentarius/news-and-events/news-details/en/c/1760016/ (retrieved 2026-08-13)	Confirms CAC49 adoption of the vanilla standard text.
iso-5565-1-1999	standard	ISO 5565-1:1999, Vanilla—Part 1: Specification. https://www.iso.org/standard/22116.html (retrieved 2026-08-13)	Covered pod/bulk/cut/powder forms and explicit exclusion of vanilla extracts.
fao-vanilla-postharvest	official_guidance	Food and Agriculture Organization of the United Nations, Vanilla: Post-harvest Operations. https://www.fao.org/fileadmin/user_upload/inpho/docs/Post_Harvest_Compendium_-_Vanilla.pdf (retrieved 2026-08-13)	Receiving, killing, sweating, sun/slow drying, conditioning, grading, packaging, monitoring, and 4.5:1–6:1 green-to-conditioned mass ratio.
uf-ifas-vanilla-production	extension_guidance	University of Florida IFAS Extension, Natural Vanilla Extract Production, EP656. https://ask.ifas.ufl.edu/publication/EP656 (retrieved 2026-08-13)	Curing-stage decomposition, representative conditions, grading/moisture context, conditioning/storage, and separation of later ethanol extraction.
sanchez-2008-vanilla-killing	literature	Sánchez, H. A. Zavaleta, K. N. Waliszewski, and V. Sánchez (2008), “The effect of killing conditions on the structural changes in vanilla pods during the curing process,” International Journal of Food Science & Technology 43(8):1452–1457. https://doi.org/10.1111/j.1365-2621.2007.01691.x	Four-phase curing chain, purpose of killing, hot-water schedules, and separation of killing from sweating/drying/conditioning.
budiastra-2025-vanilla-curing	literature	Budiastra, Nelwan, and Distriani (2025), “Improvement of cured vanilla pod qualities with a combination of advanced sweating and drying methods,” Jurnal Keteknikan Pertanian 13(1):147–161. https://doi.org/10.19028/jtep.013.1.147-161	Hot-water withering, sweating/drying route decomposition, moisture endpoint context, and technology-specific duration evidence.
iso-14044-2006	standard	ISO 14044:2006, Environmental management—Life cycle assessment—Requirements and guidelines (confirmed current in 2022; Amendments 1 and 2 noted by ISO). https://www.iso.org/standard/38498.html (retrieved 2026-08-13)	Goal/scope, inventory, allocation, data quality, reporting, and review framework.