Address

top

addr_type
job_title
institution
department
street_addr1
street_addr2
mail_stop
city
state
zip
country_cde
formatted_addr
valid_addr_fg
elec_addr_type
elec_address

Addresses are ways to locate or contact Agents. There are both physical addresses and electronic addresses, and various types of each of these. Electronic addresses include phone numbers, e-mail addresses, and web pages. As well as being informational, addresses are used in extensively in transactions such as loans, permits, and accessions. Any one Agent may have any number of addresses of either type. Addresses that are being used in transactions cannot be deleted or changed. This is in order to retain them against the possibility that a missing item was actually shipped to the incorrect address, and thereby facilitate any attempt to trace the shipment.

addr . addr_type VARCHAR(25) not null ctaddr_type

Address Type: The kind of physical address, or how the address is used. The vocabulary is controlled by ctaddr_type.

addr . job_title VARCHAR(60) null


Job Title: The professional title of the Agent at this address. Examples might include:

  • Curator of Exhibits
  • Professor of Botany
  • Insect Collection Manager

The Agent is usually a person, but not necessarily. An address for an Agent of the type organization might include an anonymous position. For example, and address for “Alaska Department of Fish and Game” might include the title, “Regional Biologist.”

addr . institution VARCHAR(255) null


Institution: The name of the institution where the agent is employed, if applicable. Examples might include:

  • American Museum of Natural History
  • University of California at Berkeley
  • National Institute of Standards and Technology
addr . department VARCHAR(255) null


Department: The name of a division within in the Institution where the agent is employed, if applicable. Examples might include:

  • Paleontology Division
  • Department of Biology
  • Rabies/Virology Unit
addr . street_addr1 VARCHAR(255) not null


Street Address 1: Usually a street name preceded by a numbered location on that street. Examples might include:

  • 907 Yukon Drive
  • Central Park W. at 47th Street
addr . street_addr2 VARCHAR(255) null


Street Address 2: An extension of Street Address1, or an alternative local delivery point. Examples might include:

  • P. O. Box 123456
  • Suite 33-B
addr . mail_stop VARCHAR(20) null


Mail Stop: In some sources a Mail Stop is defined as the last four digits of an extended Zip Code. {There is no reason why such a value would not work hyphenated to to the the five-digit U.S. Zip Codes. Should we retain this data field?}

addr . city VARCHAR(60) not null


City: The name of the city or town in which the address is located. Examples might include:

  • Philadelphia
  • Toronto
  • Nairobi
addr . state VARCHAR(20) not null


State: The name of the division of a country within which the address occurs. Examples might include:

  • California
  • Sonora
  • Ontario
addr . zip VARCHAR(10) not null


Postal Code: A code assigned to a location by the postal system of the country in which the address is located. In the U.S., this would be a Zip Code, either in the five-digit form or the extended 5-plus-4-digit form. Examples might include:

  • 99775
  • 99775-6960
  • M5S 2C6
  • 199034
addr . country_cde VARCHAR(50) null


Country: The name of the country in which the address is located. Examples might include:

  • Finland
  • United States
  • Cuba
addr . formatted_addr VARCHAR(510) null


Formatted Address: This is the address formatted for printing into reports such as invoices and mailing labels. It is automatically created by concatenating values from the standard data fields above.

addr . addr_remarks VARCHAR(255) null


Remarks: Any necessary explanation of the address. Examples might include:

  • Sabbatical address during academic year 04/05.
  • Not valid for Federal Express deliveries.
  • Jones uses home address in June and July.
addr . valid_addr_fg NUMBER not null


Valid?: A flag indicating whether or not the address is still valid. Invalid (old, or corrected) addresses are maintained against the possibility that they might be needed to resolve a lost shipment.

electronic_address . address_type VARCHAR2(30) not null ctelectronic_addr_type


Electronic Address Type: The kind of electronic address. Vocabulary is controlled by ctelectronic_addr_type.

electronic_address . address VARCHAR2(255) not null


Electronic Address: The value for the electronic address. Examples might include: