| 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 | |
| bus_org_objid | bus_org | objid | Bus Org internal record number | |
| org_id | bus_org | org_id | Business organization's ID number | |
| org_name | bus_org | name | Name of the organization | |
| org_type | bus_org | type | Business type; e.g., competitor, prospect, customer, etc., from a user-defined pop up | |
| salutation | contact | salutation | A form of address; e.g., Mr., Miss, Mrs | |
| tz_objid | time_zone | objid | Internal record number | |
| tz_name | time_zone | name | Time zone name | |
| site_status | site | status | | |
| x_no_alias | contact | x_no_alias | Is this contact a no alias one? | |
| x_objid_master | contact | x_objid_master | What is the master objid for this alias? | |
| x_res1 | site | x_res1 | Data Restriction field | |
| x_res2 | site | x_res2 | Data Restriction field | |
| x_res3 | site | x_res3 | Data Restriction field | |
| x_res4 | site | x_res4 | Data Restriction field | |
| x_res5 | site | x_res5 | Data Restriction field | |