| 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 | |
| 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 | |
| hours | contact | hours | Contact business working hours | |
| role_name | contact_role | role_name | Role name of contact | |
| primary_site | contact_role | primary_site | Indicates the site where the contact is located | |
| site | site | name | Site name | |
| 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 | |
| spec_consid | site | spec_consid | Check box which, when checked, specifies that site information is to be displayed automatically when new case is created | |
| country_code | country | code | Country code used in telephone numbers for that country | |
| address | address | address | Line 1 of address which includes street number, street name, office, building, or suite number, etc | |
| city | address | city | The city for the specified address | |
| state | address | state | The state for the specified address | |
| country | country | name | Name of the specific country | |
| zipcode | address | zipcode | The zip or other postal code for the specified address | |
| expertise_lev | contact | expertise_lev | Expertise level of the contact | |
| fax_number | contact | fax_number | Contact fax number which includes area code, number, and extension | |
| e_mail | contact | e_mail | Contact e-mail address | |
| mail_stop | contact | mail_stop | Contact internal company mail stop/location/building | |
| title | contact | title | Contact professional title | |
| region | site | region | Site region | |
| district | site | district | Site district | |
| notes | site | notes | Site notes used with special consideration flag | |
| site_typest | site | site_type | Mnemonic representation of the integer site type field | |
| address_2 | address | address_2 | Line 2 of address which typically includes office, building, or suite number, etc | |
| status | contact | status | Status of contact; i.e., active/inactive/obsolete | |
| site_alert | site | alert_ind | When set to 1, indicates there is an alert related to the site | |
| cnct_alert | contact | alert_ind | When set to 1, indicates there is an alert related to the contact | |
| contr_id | contract | id | Contract ID | |