GRIN-Global_data_dictionary
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTU
1
Code Groups & Values
2
AreaDataview NameOrderTable NameField NameTitleDescription
3
Accessionget_accessionThe accession dataview primarily displays the accession table which contains much of the accession's passport information.
4
get_accession0accessionaccession_idAccession IDaccession_id -- Accession table's primary key (PK) field. (Generated field; cannot be edited.)
5
get_accession1accessionaccession_number_part1Accession Prefixaccession_number_part1 -- Each accession has a unique identifier. Example: VIR 123456 REI. Each accession record's key consists of three fields: parts -1, -2 , and -3 (prefix, -number, and -suffix). The combination of the three fields must be unique. Part1 is required; -2 and -3 are optional
6
get_accession2accessionaccession_number_part2Accession Numberaccession_number_part2 -- 2nd part of the three fields used to identify the accession (optional). Must be numeric
7
get_accession3accessionaccession_number_part3Accession Suffixaccession_number_part3 -- record identifier's 3rd part (optional)
8
get_accession4accessiontaxonomy_species_idTaxontaxonomy_species_id -- Foreign key linking the accession record to its taxonomy parent (genus / species) via the taxonomy_species_lookup table
9
get_accession5accession_inv_nameplant_nameNameplant_name -- Plant name assigned to display in the accession dataview. (Sometimes referred to as the top name.) An accession or inventory may be known by multiple names and therefore may have multiple name records; however, only one name is listed in the accession dataview - the name whose plant_name_rank has the lowest value
10
get_accession6accession_sourcegeography_idOrigingeography_id -- Geography key field showing where the accession was collected, developed or donated (internal identifier generated by GRIN-Global, cannot be edited) - links to the geography table
11
get_accession7sitesite_idSite IDsite_id -- Table's primary key (PK) field auto-generated by GRIN-Global, cannot be edited. This filed will be filled when after the new accession record is saved. The site is derived from the site associated with the record owner.
12
get_accession8accessionis_coreIs Core?is_core -- Y/N flag indicating that the accession is part of a core subset, typically a subset of the entire collection (around 10%) encompassing approximately 90% of the entire collection's genetic diversity. Most crops with large numbers of accessions have a core collection and are usually developed by considering representative species, country of origin, and observation data (when available). What is considered an organization's core subset is dynamic – the definition may change as new data and accessions become available
13
get_accession9accessionis_backed_upIs Backed Up?is_backed_up -- A Y/N flag; indicates the accession is backed up at an alternate germplasm location(s)
14
get_accession10accessionbackup_location1_site_idBackup Location 1backup_location1_site_id -- Name or code of the first institute where a safety duplicate of the accession is maintained
15
get_accession11accessionbackup_location2_site_idBackup Location 2backup_location2_site_id -- Name or code of the second institute where a safety duplicate of the accession is maintained
16
get_accession12accessionstatus_codeStatusstatus_code -- Accession status. Must be a value in the ACCESSION_STATUS Code Group. Example: ACTIVE, INACTIVE
17
get_accession13accessionlife_form_codeLife Formlife_form_code -- Basic life form of the accession. Must be a value in the ACCESSION_LIFE_FORM Code Group. Examples: ANNUAL, SHRUB
18
get_accession14accessionimprovement_status_codeLevel Of Improvementimprovement_status_code -- The biological status of the accession. Must be a value in the IMPROVEMENT_LEVEL Code Group
19
get_accession15accessionreproductive_uniformity_codeReproductive Uniformityreproductive_uniformity_code -- Breeding system used to produce the accession. Primarily applied to cultivated and Breeding material. Must be a value in the REPRODUCTIVE_UNIFORMITY Code Group. Examples: HYBRID, PURELINE
20
get_accession16accessioninitial_received_form_codeInitial Material Typeinitial_received_form_code -- Type of propagule first received by the germplasm location. Must be a value in the GERMPLASM_FORM Code Group
21
get_accession17accessioninitial_received_date_codeInitial Received Date Formatinitial_received_date_code -- The format used for the accession initial received date. Must be one of the DATE_FORMAT Code Group values
22
get_accession18accessioninitial_received_dateInitial Received Dateinitial_received_date -- Date on which the accession entered the organization's germplasm collection. This date may be different from the date a particular site receives the accession, since the material may have been moved internally within the national system
23
get_accession19accessionis_web_visibleIs Web Visible?is_web_visible -- Y/N flag used to indicate if the accession will be visible on the public website
24
get_accession20accessionnoteNotenote -- General remarks about the accession; displays in the Narrative section on the Public Website AccessionDetail page
25
get_accession21accession_lookupaccession_id_stringAccession
26
get_accession22accessioncreated_dateCreated Datecreated_date -- Date when the record was initially inserted into the database
27
get_accession23accessioncreated_byCreated Bycreated_by -- Cooperator_ID of the person who created the record
28
get_accession24accessionmodified_dateModified Datemodified_date -- Date when the record was last updated
29
get_accession25accessionmodified_byModified Bymodified_by -- Cooperator_ID of the person who modified the record
30
get_accession26accessionowned_dateOwned Dateowned_date -- Date when the record became owned by the current owner
31
get_accession27accessionowned_byOwned Byowned_by -- Cooperator_ID of the current record owner
32
33
Accessionget_accession_actionThe accession_action dataview displays data pertaining to actions performed on an accession. Examples: HARVESTED, INACTIVATED, INCREASED, TRANSFERRED. Accession actions in GRIN (Classic) were created not only for actions done on an accession as a whole, but to keep information on how the accession was being handled, treated, documented, etc. It was also the first place where information was shown on the web at the curator’s discretion. The accession_action data evolved from the inactivation process where you could document that the accession died, include details, but not display the details to be public. The use of accessions_actions has also grown into a way to document the passport review process which is difficult to do in one sitting, but can be done over time. The actions can be used to indicate what has and has not been reviewed.
34
get_accession_action0accession_actionaccession_action_idAccession Action IDaccession_action_id -- The accession_action table's primary key (PK) field. (GRIN-Global generates this field; it cannot be edited.)
35
get_accession_action1accession_actionaccession_idAccessionaccession_id -- Links the accession_action record to its parent accession record via the accession_lookup table
36
get_accession_action2accession_actionaction_name_codeAction Nameaction_name_code -- Type of action taken on the accession. Must be a value in the ACCESSION_ACTION Code Group
37
get_accession_action3accession_actionstarted_date_codeStart Date Formatstarted_date_code -- Format of the started date. Must be a value in the DATE_FORMAT Code Group
38
get_accession_action4accession_actionstarted_dateStart Datestarted_date -- Date when the action was started
39
get_accession_action5accession_actioncompleted_date_codeCompleted Date Formatcompleted_date_code -- Format of the completed date. Must be a value in the DATE_FORMAT Code Group
40
get_accession_action6accession_actioncompleted_dateCompleted Datecompleted_date -- Date when the action was completed
41
get_accession_action7accession_actionis_web_visibleIs Web Visible?is_web_visible -- Y/N flag indicating whether this action should be displayed to public website users
42
get_accession_action8accession_actioncooperator_idCooperatorcooperator_id -- Links the accession_action record to a cooperator
43
get_accession_action9accession_actionmethod_idMethodmethod_id -- Links the accession_action record to the method table
44
get_accession_action10accession_actionnoteNotenote - General Remarks about the accession
45
get_accession_action11accessiontaxonomy_species_idTaxontaxonomy_species_id -- Foreign key linking the accession record to its taxonomy parent (genus / species) via the taxonomy_species_lookup table
46
get_accession_action12accession_actioncreated_dateCreated Datecreated_date -- Date when the record was initially inserted into the database
47
get_accession_action13accession_actioncreated_byCreated Bycreated_by -- Cooperator_ID of the person who created the record
48
get_accession_action14accession_actionmodified_dateModified Datemodified_date -- Date when the record was last updated
49
get_accession_action15accession_actionmodified_byModified Bymodified_by -- Cooperator_ID of the person who modified the record
50
get_accession_action16accession_actionowned_dateOwned Dateowned_date -- Date when the record became owned by the current owner
51
get_accession_action17accession_actionowned_byOwned Byowned_by -- Cooperator_ID of the current record owner
52
53
Accessionget_accession_citationThis dataview displays citations from the citation table associated with an accession record.
54
get_accession_citation0citationcitation_idCitation IDThe primary key (PK) field. (Auto-generated by GRIN-Global, cannot be edited.)
55
get_accession_citation1citationaccession_idAccessionaccession_id -- Accession key field; links the citation record to an accession record
56
get_accession_citation2citationtype_codeTypetype_code -- Must be a value in the CITATION_TYPE Code Group. Examples: FOOD, CPC, PESTICIDE, WEED
57
get_accession_citation3citationauthor_nameAuthor(s) Nameauthor_name -- The author(s) of the article or chapter of the citation. Examples R. R. Kalton, P.E. Lake
58
get_accession_citation4citationcitation_yearCitation Yearcitation_year -- Year when the citation was published or made available
59
get_accession_citation5citationtitleReference Titletitle -- Title of the citation article or chapter
60
get_accession_citation6citationcitation_titleCitation Titlecitation_title -- Title of the citation article or chapter
61
get_accession_citation7literatureabbreviationAbbreviated Literature Sourceabbreviation -- The short abbreviation of the reference
62
get_accession_citation8citationreferenceReferencereference -- Citation reference (volume, page, etc.) within the journal or book
63
get_accession_citation9citationliterature_idLiterature Sourceliterature_id -- Literature key field linking the citation record to a literature record
64
get_accession_citation10citationdoi_referenceDOI Referencedoi_reference -- Reference to the Digital Object Identifier (DOI) name, a standard naming system used for identifying content objects in the digital environment
65
get_accession_citation11citationurlURLurl -- Link to the journal article or book
66
get_accession_citation12citationdescriptionReference Descriptiondescription -- Citation description
67
get_accession_citation13citationnoteNotenote -- General comments
68
get_accession_citation14citationcreated_dateCreated Datecreated_date -- Date when the record was initially inserted into the database
69
get_accession_citation15citationcreated_byCreated Bycreated_by -- Cooperator_ID of the person who created the record
70
get_accession_citation16citationmodified_dateModified Datemodified_date -- Date when the record was last updated
71
get_accession_citation17citationmodified_byModified Bymodified_by -- Cooperator_ID of the person who modified the record
72
get_accession_citation18citationowned_dateOwned Dateowned_date -- Date when the record became owned by the current owner
73
get_accession_citation19citationowned_byOwned Byowned_by -- Cooperator_ID of the current record owner
74
75
Accession/
Inventory
get_accession_inv_annotationDataview displays fields from the accession_annotation table (verifications, official taxonomic name changes, reidentifications and received as) related to the taxonomic names for each accession.
76
get_accession_inv_annotation0accession_inv_annotationaccession_inv_annotation_idAccession Inventory Annotation IDaccession_inv_annotation_id -- Accession_inv_annotation table's primary key (PK) field. (Auto-generated by GRIN-Global, cannot be edited.)
77
get_accession_inv_annotation1inventoryaccession_idAccessionaccession_id -- Links the record to the accession table
78
get_accession_inv_annotation2accession_inv_annotationinventory_idInventoryinventory_id -- Field links the accession_annotation record to an inventory record via the inventory key field
79
get_accession_inv_annotation3accession_inv_annotationannotation_type_codeAnnotation Typeannotation_type_code -- The type of annotation. Must be a value in the ANNOTATION_TYPE Code Group.Examples: RE-INDENT, ID-CHECK, RECEIVED, NOM-CHANGED. NOM-CHANGED is used when the species has changed taxonomically. ID-CHECK used when someone has verified the nomenclature and wants to make a record of it. RE-IDENT: used when material comes in from a collection trip as one species (or even taxon) and when grown out the curator realizes it is something else. RECEIVED-AS: a record of what the accession was received as
80
get_accession_inv_annotation4accession_inv_annotationannotation_date_codeAnnotation Date Formatannotation_date_code -- The format used for the voucher date. Must be a DATE_FORMAT value in the Code Group
81
get_accession_inv_annotation5accession_inv_annotationannotation_dateAnnotation Dateannotation_date -- The date of the annotation re-identification or verification
82
get_accession_inv_annotation6accession_inv_annotationold_taxonomy_species_idIncorrect Taxonold_taxonomy_species_id -- When filled, indicates a taxonomy species key field that was previously used. Field cannot be edited - links to the taxonomy species table
83
get_accession_inv_annotation7accession_inv_annotationnew_taxonomy_species_idCorrect Taxonnew_taxonomy_species_id -- The species identifier of the correct taxonomic name which relates to the full taxon
84
get_accession_inv_annotation8accession_inv_annotationannotation_cooperator_idReidentification Cooperatorannotation_cooperator_id -- Field that links the accession_annotation record to its related parent accession record
85
get_accession_inv_annotation9accession_inv_annotationorder_request_idOrder Requestorder_request_id -- When selected, the order request key field links the annotation record to an order request record
86
get_accession_inv_annotation10accession_inv_annotationnoteNotenote -- General remarks about the annotation verification or re-identification
87
get_accession_inv_annotation11accession_inv_annotationcreated_dateCreated Datecreated_date -- Date when the record was initially inserted into the database
88
get_accession_inv_annotation12accession_inv_annotationcreated_byCreated Bycreated_by -- Cooperator_ID of the person who created the record
89
get_accession_inv_annotation13accession_inv_annotationmodified_dateModified Datemodified_date -- Date when the record was last updated
90
get_accession_inv_annotation14accession_inv_annotationmodified_byModified Bymodified_by -- Cooperator_ID of the person who modified the record
91
get_accession_inv_annotation15accession_inv_annotationowned_dateOwned Dateowned_date -- Date when the record became owned by the current owner
92
get_accession_inv_annotation16accession_inv_annotationowned_byOwned Byowned_by -- Cooperator_ID of the current record owner
93
94
Accession/
Inventory
get_accession_inv_attachDataview used to link images and documents to inventory. (Replaced version 1.0's inventory_attachments.)
95
get_accession_inv_attach0accession_inv_attachaccession_inv_attach_idAccession Inventory Attach IDaccession_inv_attach_id -- The accession_inv_attach table's primary key (PK) field auto-generated by GRIN-Global; it cannot be edited
96
get_accession_inv_attach1inventoryaccession_idAccessionaccession_id -- Links the record to the accession table
97
get_accession_inv_attach2accession_inv_attachinventory_idInventoryinventory_id -- The inventory key field that links the Inventory_attachment to an inventory record
98
get_accession_inv_attach3accession_inv_attachvirtual_pathImage Virtual Pathvirtual_path -- Pathname of the inventory attachment. A complete full URL is needed when a remote server is used
99
get_accession_inv_attach4accession_inv_attachthumbnail_virtual_pathThumbnail Virtual Paththumbnail_virtual_path -- Pathname of the inventory thumbnail attachment. A complete URL is needed when a remote server is used
100
get_accession_inv_attach5accession_inv_attachsort_orderSort Ordersort_order -- A field to indicate the sort order of inventory attachments
Loading...
Main menu