objid | contact_role | objid | Contact_role internal record number | 3 (UNIQUE) |
con_objid | contact | objid | Contact internal record number | |
loc_objid | site | objid | Site internal record number | |
addr_objid | address | objid | Address internal record number | |
country_objid | country | objid | Country internal record number | |
first_name | contact | first_name | Contact first name | 15 |
last_name | contact | last_name | Contact last name | 14 |
phone | contact | phone | Contact phone number which includes area code, number, and extension | |
site | site | name | The name of the site | |
site_id | site | site_id | Site ID number assigned according to auto-numbering definition | |
site_type | site | type | Mnemonic representation of the integer site type field | |
site_typest | site | site_type | Mnemonic representation of the integer site type field | |
role_name | contact_role | role_name | Role of the contact at the site | |
primary_site | contact_role | primary_site | Indicates whether the related site is where the contact is located; i.e., 0=false, 1=true, default=0 | |
country_code | country | code | Country code used in telephone numbers for that country | |
country | country | name | Name of the specific country | |
city | address | city | The city for the specified address | |
state | address | state | The state for the specified address | |
status | contact | status | Status of contact; i.e., active/inactive/obsolete | |
salutation | contact | salutation | A form of address; e.g., Mr., Miss, Mrs | |