VegBranch Loading Tables Overview -- Party Information (A)
Navigation between loading tables:
Party Information | Species List | Plot Data | Plot Normalized | Presence Data | Strata Cover Data | Stem Data | Stem Classes | Soil Data | Disturbance Data | Community Concept | Plot Communities | User Defined Metadata
Jump to a different part of this page: Field Descriptions | Example Data
Summary: | Information about the different people (parties) involved in your plots, projects, taxa, and classifications. |
Description: | Party data has a UserPartyCode which can then be used to identify any party in other loading tables. This code can be any combination of letters or numbers. Firstname plus lastname would make a good code if you have no codes already for parties. This table allows you to enter data about each party, such as names, organization, address, and phone number. |
Required in VegBranch: | Not required. VegBranch can generate this table from other tables (Plot Data and Plot Community Data) with the Party Form or Metadata Form. |
Represents VegBank Tables: | party, address (1), telephone (1) |
VegBranch can generate for you: | VegBranch can generate this table from the contrib fields in Plot Data (or Plot Normalized) and the InterpParty fields in Plot Communities. |
Questions: | Who participated in observing or classifying plots? Who are you? Information about them. |
Expertise Level: | basic |
Fields (Columns) in this table:
» Required fields; you should always fill in values for these: | ||
UserPartyCode text (255) |
A unique code that will refer to a party consistently throughout the loading process. Other loading tables will use this code to reference the party of this record. The code can be any combination of letters and numbers. If you don't have a code for parties, you could simply use the first name and the last name for a code. | |
» Best Practice fields: | ||
SurName text (50) |
Name shared in common to identify the members of a family, as distinguished from each member's given name. | |
OrganizationName Text (100) |
Name of an organization. | |
» Commonly used fields: | ||
GivenName text (50) |
One's first name. | |
orgPosition Text (50) |
Position of party within organization. | |
Email text (100) |
email address of party member | |
» Sometimes used fields: | ||
middleName Text (50) |
One's middle name or initial, if any. | |
contactInstructions Memo |
Instructions for contacting a party. | |
TelephoneNumber text (30) |
Telephone number. | |
TelephoneType text (20) |
This is the type of telephone: home, work, fax, cell, secretary, other. | |
deliveryPoint Text (200) |
Address line for the location: for example, Street name, box number, suite. | |
city Text (50) |
City of the location. | |
administrativeArea Text (50) |
State, province of the location. | |
postalCode Text (10) |
Zip code or other postal code. | |
country Text (50) |
Country of the physical address. | |
currentFlag Text (50) |
This flag signifies whether the address is the current address of the party. "True" is used for addresses that are current. | |
addressStartDate Date/Time |
The first database date on which the address/organization information applied (have a discrete date on which address is known to applied -- not necessarily the first date on which the address applied). | |
partyType text (40) |
The type of party this is. Person is the most common type. | |
» Internal VegBranch fields, please do not edit directly: | ||
Party_ID autoNumber |
Database generated identifier assigned to each unique party. | |
VegBankParty_ID Long Integer |
The Party_ID of this Party that has been migrated into VegBank module. | |
VegBankAccCode Text (100) |
Code that uniquely references the party corresponding to this record, allowing reference to this record for this version of this database. Better than a primary key, which is automatically generated by a database and not globally unique. VegBank Accession codes are only generated by VegBank, and therefore data integrity can be guaranteed, unlike with a primary key (number). |
Examples of this data table:
simple Party data example:
UserPartyCode | surName | middleName | givenName | organizationName | deliveryPoint | city | administrativeArea | postalCode | country | currentFlag | addressStartDate | TelephoneNumber | TelephoneType | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
gramling@somewhere.com | Gramling | Joel | UNC | gramling@somewhere.com | Chapel Hill | 27514 | TRUE | 555-1212 | Cell | |||||
Lee, Michael | Lee | Michael | mikelee@somwhere.com | |||||||||||
Lee Anne Jacobs | Jacobs | Anne | Lee | 567 Theissen St. | Thun | Bern | Switzerland | 4/2/2002 0:00 | 632/ 41 612 | Home |
Download this example as a .csv file