| objid | usr_opp_role | objid | User internal record number | 3 (UNIQUE) |
| opp_objid | opportunity | objid | Opportunity internal record number | |
| user_objid | user | objid | User internal record number | |
| empl_objid | employee | objid | Employee internal record number | |
| con_objid | contact | objid | Contact internal record number | |
| role_name | usr_opp_role | role_name | User's opportunity team role name | |
| member_name | user | login_name | User login name | |
| opp_id | opportunity | id | ID of opportunity for which the user plays a role | |
| opp_name | opportunity | name | Name of opportunity for which the user plays a role | |
| empl_first_name | employee | first_name | If the user is an employee, the employee's first name | |
| empl_last_name | employee | last_name | If the user is an employee, the employee's last name | |
| empl_phone | employee | phone | If the user is an employee, the employee's phone number | |
| empl_fax | employee | fax | If the user is an employee, the employee's fax number which includes area code, number, and extension | |
| empl_beeper | employee | beeper | If the user is an employee, the employee's beeper number which includes area code and number | |
| empl_e_mail | employee | e_mail | If the user is an employee, the employee's e-mail address | |
| con_first_name | contact | first_name | If the user is a contact, the contact's first name | |
| con_last_name | contact | last_name | If the user is a contact, the contact's last name | |
| con_phone | contact | phone | If the user is a contact, the contact's phone number | |
| con_e_mail | contact | e_mail | Contact's primary e-mail address | |
| empl_title | employee | title | Employee's professional title | |
| empl_salutation | employee | salutation | Employee's form of address; e.g., Mr., Miss, Mrs | |
| con_title | contact | title | Contact's professional title | |
| con_salutation | contact | salutation | Contact's form of address; e.g., Mr., Miss, Mrs | |