GN 837 MET Datasets QUOTE v2 0 ns approved 08 05 2025
The document is a formal change request (v2.0) for the GRDC National Variety Trials (NVT) system, authored by Gerri Mills of Storyboard Multimedia on 6‑7 May 2025. It proposes adding a new "MET Dataset" field to the TrialType table and creating a supporting METDataset reference table to capture multi‑environment trial (MET) groupings. The business justification highlights the current lack of structured MET dataset association, limiting analysts' ability to locate and export trial data for MET analyses. Deliverables include the new database tables and columns, updated advanced search functionality, UI wireframes for trial type maintenance and search screens, and revised user guides. Risks focus on data inconsistency and continued inefficiency if not implemented. Detailed schema definitions list columns, data types, and initial data loads for numerous MET datasets across crops, series, and states. UI changes show wireframes with a MET Dataset dropdown, and business rules define filtering behavior. Test case and user guide impacts are noted, along with a resource quote totaling 86 hours across development, QA, testing, and documentation. The request received approval from GRDC on 8 May 2025.
Topics
Business Need for MET Dataset Integration in NVT System
Explanation of why the current system lacks a formal MET Dataset field and how this hampers analysts and biometricians in locating and exporting trial data for multi‑environment analyses.
Design and Implementation of METDataset Reference Table
Specification of the new METDataset table, including column definitions, data types, and an extensive initial data load covering crops, series, and states.
Schema Extension: Adding METDatasetID to TrialType
Details of the schema change to the existing TrialType table, adding a foreign key column METDatasetID to link trials with the METDataset reference table.
User Interface Enhancements: Trial Type Maintenance and Advanced Search
Wireframe mock‑ups and GUI impact descriptions for the trial type creation screen and the advanced trial search screen, introducing a MET Dataset dropdown and related filtering controls.