| objid | emp_ter_role | objid | emp_ter_role internal record number | 3 (UNIQUE) |
| role_name | emp_ter_role | role_name | The name of the role | |
| employee_no | employee | employee_no | Site ID number assigned according to auto-numbering definition | |
| last_name | employee | last_name | Employee's last name | |
| first_name | employee | first_name | Employee's first name | |
| terr_name | territory | name | Name of the territory | |
| end_date | territory | end_date | End date of the territory | |
| terr_id | territory | terr_id | ID of the territory | |
| phone | employee | phone | Employee's primary phone number which includes area code, number, and extension | |
| terr_objid | territory | objid | Territroy internal record number | |
| login_name | user | login_name | User login name | |
| fax | employee | fax | Employee's fax number which includes area code, number and extension | |
| beeper | employee | beeper | Employee's beeper number which includes area code and number | |
| e_mail | employee | e_mail | Employee's e-mail address | |
| empl_objid | employee | objid | Employee internal record number | |