Note: This illustrative table contains the minimal information currently required by the N.C. Division of Archives and History. See the Advanced Database Indexing section for comprehensive tables.
February, 1996
Table Name: Contacts
Notes: Native format is Microsoft Access 2.0. Data derived from table definitions.
FIELD NAME: FIELD DESCRIPTION
CID: Contact ID (unique to database)
MailLabel: Mailing label for individual or group
Pfx: Personal Title (e.g., "Ms.", "Mr." & "Mrs.") (optional)Person: Familiar Name (e.g. , "Buzz", "Jo Ann", "Bill and Virginia") (optional)
AlphaName: Last/Group Name (e.g., "Smith", "Smith & Wesson")
Soundex: Soundex Code (derived from AlphaName) (optional)
SortName: Look-up Name (e.g., "Smith, John")
City: City (derived from MailLabel)
ST: Two-character State code
Zip: Zip Code (5 or 9 digits) (optional)
Bphone: Business telephone (optional)
Ext: Phone extension (optional)
Fax: Fax telephone (optional)
Hphone: Home telephone (optional)
Courier: State of N.C. Courier Code (optional)
VendNum: Vendor Code (optional)
Internet: Internet address (optional)
Note: Note (searchable) (optional)
Stamp: Date Stamp—date entry made or last updated (IntFmt)
Contents | Annotated List of Fields