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 | |
cty_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 | |
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 | |
status | contact | status | Status of contact; i.e., active/inactive/obsolete | |