| role_objid | con_sp_role | objid | Con_sp_role internal record number | 3 (UNIQUE) |
| con_objid | contact | objid | Contact internal record number | |
| sp_objid | site_part | objid | Site_part internal record number | |
| con_first_name | contact | first_name | Contact's first name | |
| con_last_name | contact | last_name | Contact's last name | |
| con_phone | contact | phone | Contact's phone number which includes area code, number, and extension | |
| con_fax_number | contact | fax_number | Contact's fax number which includes area code, number, and extension | |
| con_e_mail | contact | e_mail | Contact's primary e-mail address | |
| role_name | con_sp_role | role_name | Name of the role | |
| focus_type | con_sp_role | focus_type | Object type ID of the role-player; i.e., 15=an installed part's role, 173=a business organization's role | |
| active | con_sp_role | active | Indicates whether the role is currently being used; i.e., 0=inactive, 1=active | |
| sp_instance_name | site_part | instance_name | Default is the concatination of part name, part number, and part revision. May be customized | |
| sp_serial_no | site_part | serial_no | Installed part serial number | |