Login | Datasets | Logout
Jump to... Home PLOT search PLANT search COMMUNITY search Simple search Manage datasets Tutorial About FAQ ------- Site map VegBranch Data dictionary ERD

131010

VegBank Data Dictionary: Field Details

Search for a VegBank Field (enter a word, field name, etc.):    <<Hide search Match any word Match whole words only Search for VegBank Field >>

Search VegBank Tables Here

Table (DB Name)	referenceContributor
Table	Reference Contributor
Field	Reference
DB Field Name	reference_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	reference.reference_ID
List?	no
Notes	n/a
Definition	Foreign key into the reference table to indicate which reference is referenced by this alternate identifier.

 

Table (DB Name)	referenceContributor
Table	Reference Contributor
Field	Reference Party
DB Field Name	referenceParty_ID
Req'd?	required
Data Type	Integer
Misc Flag	FK
References	referenceParty.referenceParty_ID
List?	no
Notes	n/a
Definition	Foreign key into the referenceParty table to indicate which person contributed.

 

Table (DB Name)	referenceContributor
Table	Reference Contributor
Field	Role Type
DB Field Name	roleType
Req'd?	no
Data Type	varchar (250)
Misc Flag	n/a
References	n/a
List?	closed
Notes	n/a
Definition	Use this field to describe the role the party played with respect to the resource. Some potential roles include technician, reviewer, principal investigator, and many others.
closed List of Values: Value Description Sorting Author     CustodianSteward     Editor     Originator     Performer     Recipient

 

Table (DB Name)	referenceContributor
Table	Reference Contributor
Field	Position
DB Field Name	position
Req'd?	no
Data Type	Integer
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Numerical order in which this contributor's name should be in the order of contributors, if applicable. Examples: 1 [for the first author], 2, [for the second author], etc.

 

Table (DB Name)	referenceParty
Table	Reference Party
Field	ID
DB Field Name	referenceParty_ID
Req'd?	required
Data Type	serial
Misc Flag	PK
References	n/a
List?	no
Notes	n/a
Definition	Primary key for the referenceParty table.

 

Table (DB Name)	referenceParty
Table	Reference Party
Field	Reference Party Type
DB Field Name	type
Req'd?	no
Data Type	varchar (250)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	Type of Party this record refers to: usually person or institution. Type determines rules for which fields must be completed.

 

Table (DB Name)	referenceParty
Table	Reference Party
Field	Position Name
DB Field Name	positionName
Req'd?	no
Data Type	varchar (250)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	This field is intended to be used instead of a particular person or full organization name. If the associated person that holds the role changes frequently, then Position Name would be used for consistency. Note that this field, used in conjunction with 'organizationName' and 'individualName' make up a single logical originator. Because of this, an originator with only the individualName of 'Joe Smith' is NOT the same as an originator with the name of 'Joe Smith' and the organizationName of 'NSF'. Also, the positionName should not be used in conjunction with individualName unless only that individual at that position would be considered an originator for the data package. If a positionName is used in conjunction with an organizationName, then that implies that any person who currently occupies said positionName at organizationName is the originator of the data package. Example(s): Niwot Ridge Data Manager

 

Table (DB Name)	referenceParty
Table	Reference Party
Field	Salutation
DB Field Name	salutation
Req'd?	no
Data Type	varchar (250)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The salutation field is used in addressing an individual with a particular title, such as Dr., Ms., Mrs., Mr., etc.

 

Table (DB Name)	referenceParty
Table	Reference Party
Field	Given Name
DB Field Name	givenName
Req'd?	no
Data Type	varchar (250)
Misc Flag	n/a
References	n/a
List?	no
Notes	All names except surname
Definition	The given name field is used for the all names, except the surname, of the individual associated with the resource. Possible usages include: first name and middle name, first name and middle initials, first name, etc. Example(s): Jo, Jo R., Jo R.W., John Robert Peter

 

Table (DB Name)	referenceParty
Table	Reference Party
Field	Surname
DB Field Name	surname
Req'd?	no
Data Type	varchar (250)
Misc Flag	n/a
References	n/a
List?	no
Notes	n/a
Definition	The surname field is used for the last name of the individual associated with the resource.