| objid | contact_role | objid | Contact_role internal record number | 3 (UNIQUE) |
| con_objid | contact | objid | Contact internal record number | |
| web_objid | web_user | objid | Web User 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 | |
| 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 | |
| site | site | name | Name of the site | |
| site_id | site | site_id | Site ID number assigned according to auto-numbering definition | |
| country_code | country | code | Country code used in telephone numbers for that country | |
| status | contact | status | Status of contact; i.e., active/inactive/obsolete | |
| login | web_user | login_name | Web User login name | |
| password | web_user | password | Web User password | |
| web_status | web_user | status | Status of web user | |
| user_key | web_user | user_key | System generated key value to locate WebSupport user | |
| passwd_chg | web_user | passwd_chg | Date/Time password was last changed | |