GN 485 Consolidate NVT Contacts QUOTE v4 0 ns approved 22 05 2025
The document is a Version 4.0 change request (GN‑485) for the GRDC National Variety Trials (NVT) system, authored by Gerri Mills of Storyboard Multimedia and requested by Neale Sutton. It proposes the creation of a consolidated NVTContact data model to replace duplicated trial and company contact records. New tables (NVTContact, NVTContactContactType, NVTContactCompany, TrialNVTContact, CompanyNVTContact) and an additional ContactType record are defined, with detailed field specifications. The change includes a migration plan for existing contacts, UI wireframes for contact search, add, and edit screens, and extensive business rules covering permissions, validations, and UI behavior. Impacts on related modules (Trial Summary, Copy Trial Info, Data Import, QR‑code printing, Seed Requirements, On‑site Visit) are outlined, along with test case updates, regression testing, and user guide revisions. A quoted effort of 324 hours across development, testing, QA, and documentation is presented, and the request has been approved by GRDC on 22 May 2025.
Topics
Consolidated NVTContact Data Model and Schema Definition
Definition of new database tables (NVTContact, NVTContactContactType, NVTContactCompany, TrialNVTContact, CompanyNVTContact) with field lists, data types, and purpose of each column.
Business Justification and Expected Benefits
Explanation of current duplication problems, data integrity risks, efficiency gains, and access‑control improvements that motivate the new contacts table.
Migration Strategy for Existing Trial and Company Contacts
Process for consolidating duplicate contacts, required GRDC input to identify duplicates, and rules for handling company vs trial contacts during migration.
Contact Maintenance UI Wireframes and User Interaction Flow
Screenshots and descriptions of the NVT Contacts search page, add‑contact form, and edit dialogs, including field layout, dropdown behavior, and conditional visibility of permission fields.
Business Rules, Validations, and Permission Logic
Detailed rules governing contact creation, editing, deletion, mandatory fields, uniqueness checks, permission‑to‑publish handling, and company‑specific access restrictions.
Impact on Related Trial and Company Functions
How the new contact model propagates to trial summary grids, copy‑trial‑info, data import, QR‑code printing, seed‑requirements, and on‑site‑visit modules, with notes on required UI or data changes.
Testing, Regression, and User Guide Updates
Scope of test case modifications, regression testing plan to verify new contact type handling, and updates required for user documentation.
Project Quote, Resource Allocation, and Timeline
Breakdown of effort (324 hours) across development, testing, QA, user guide work, and deployment, plus validity period and warranty terms.