From ICISWiki

GRIMS main > GRIMS functionality > Seed Acquisition
Previous Next

---

Contents 1 Entering Seed Names using GRIMS 1.1 Overview 1.2 User interface form 1.3 User input fields 1.4 Use Case Definition 1.5 TABLE VIEW 1.6 Percentage of work completed

Entering Seed Names using GRIMS

Overview

This user interface (UI) enables the user to input the germplasm names in a tabular form. The column stands for the name types available in the ICIS meta data definition. The user must select a batch of seeds first before he can edit the names using this UI.

User interface form

User input fields

label	description
Batch ID	Genebank assigned identification number to a donated batch of samples (Format:BYYYY-XXX, where YYYY=current year, XXX-sequence number).
Temporary ID	Germplasm temporary identification number. ID being used to process unregistered Genebank accessions (Format:TXXXX-YYYY, where YYYY=current year, XXXX-sequence number).
Accession Number	Identification number assigned to germplasm which passed the screening. A germplasm that is part of the GRC collection.
Variety Name	Cultivar name
Species Name	The germplasm Latin name consisting of two words, the generic name and the species epithet.
Coll No	Name given by the collector.
Previous Name	(Still under discussion)
Donor Name	Foreign accession number or the name given by the other Genebank.
Donor Name	Foreign accession number or the name given by the other Genebank.
Donor Name	Foreign accession number or the name given by the other Genebank.
Cross	The name given to the selected parents based on particular genetic traits desired on the offspring.

Use Case Definition

Use Case	1.2.2 Enter Seed Names
Use Case Definition	This user interface (UI) enables the user to input the germplasm names in a tabular form. The column stands for the name types available in the ICIS meta data definition. The user must select a batch of seeds first before he can edit the names using this UI.
User Contacts
Actors	Genebank technician (GBT)
Location	Genebank
Priority	1
vAlign="top"| Typical Course of Events	Actor Action System Response Step 1: User specifies the batch/es of seeds Step 2: System retrieves the seed list that belong to the batch with all the seed names Step 3: USer inputs and saves the names Step 4: System stores the information Step 5: GBT requests for a prooflist Step 6: System outputs the prooflist
Assumption/s	Germplasm list already exists.
Pre-condition/s	Seed list has been imported from the SHU.
Post-condition/s	Names are stored with their corresponding name types.
Primary Pathway/s	Both pathways are treated equal.
Alternative Pathway/s	Input names using ICIS SetGen. Input names using the GUI.
Exception Pathway/s

TABLE VIEW

V_NAMES is a view of NAMES, and TBL_GENERATION tables which is used to retrieve all the name values of all name types of a specific germplasm.

CREATE OR REPLACE VIEW V_NAMES AS
SELECT
	A.GID,
	A.ACCNO,
	N1.NVAL NVAL_1,
	N2.NVAL NVAL_2,
	N3.NVAL NVAL_3,
	N4.NVAL NVAL_4,
	N5.NVAL NVAL_5,
	N6.NVAL NVAL_6,
	N7.NVAL NVAL_7,
	N8.NVAL NVAL_8,
	N9.NVAL NVAL_9,
	N10.NVAL NVAL_10,
	N11.NVAL NVAL_11,
	N12.NVAL NVAL_12,
	N13.NVAL NVAL_13,
	N14.NVAL NVAL_14
FROM
	TBL_GENERATION A,
	V_NAMES_1 N1,
	V_NAMES_2 N2,
	V_NAMES_3 N3,
	V_NAMES_4 N4,
	V_NAMES_5 N5,
	V_NAMES_6 N6,
	V_NAMES_7 N7,
	V_NAMES_8 N8,
	V_NAMES_9 N9,
	V_NAMES_10 N10,
	V_NAMES_11 N11,
	V_NAMES_12 N12,
	V_NAMES_13 N13,
	V_NAMES_13 N14

WHERE
	A.GID=N1.GID(+) AND 
	A.GID=N2.GID(+) AND 
	A.GID=N3.GID(+) AND 
	A.GID=N4.GID(+) AND 
	A.GID=N5.GID(+) AND 
	A.GID=N6.GID(+) AND 
	A.GID=N7.GID(+) AND 
	A.GID=N8.GID(+) AND 
	A.GID=N9.GID(+) AND 
	A.GID=N10.GID(+) AND 
	A.GID=N11.GID(+) AND 
	A.GID=N12.GID(+) AND 
	A.GID=N13.GID(+) AND 
	A.GID=N14.GID(+)
	AND A.GENERATION =0

Percentage of work completed

95% Complete

5% work remaining for report generation/ prooflist.