| Table Name: | contact_role |
| Table Number: | 270 |
| Group: | Customer Mgr |
| Description: | Contact role object; describes roles that contacts play at customer sites |
| Flags: | CACHEOBJIDS |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (16) | ||
| primary_site | LONG | int | DIRECT | Indicates whether the related site is where the contact is located; i.e., 1=true, 2=false | Search (10) | |||
| role_name | CHAR | varchar | 2 | 80 | Role of the contact at the site | Search (10) | ||
| update_stamp | CLK_TIME | datetime | 46 | ALLOW_NULL | Date/time of last update to the contact_role |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| contact_role2contact | MTO | contact | contact2contact_role | Contact for the contact role | Search (17) | ||
| doer2exch_log | OTM | exch_log | exch_log2contact_role | Exchange activities performed by an exchange partner | |||
| contact_role2gbst_elm | MTO | gbst_elm | contact_role2contact_role | Reserved; not used | |||
| con_role2lead | OTM | lead | lead2contact_role | Lead who were promoted to the related contact | |||
| con_role2lit_ship_req | OTM | lit_ship_req | lit_ship2contact_role | Literature requests sent to the contact role-this gives the site role context for the shipment | |||
| contact_role2site | MTO | site | site2contact_role | Site for the contact | Search (16) |
| Index Name | Fields | Flags |
|---|---|---|
| role_index | contact_role2contact:contact_role2site:role_name | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_contact_role2contact | contact_role2contact, objid, contact_role2site | nonclustered, unique located on PRIMARY |
| ind_contact_role2gbst_elm | contact_role2gbst_elm | nonclustered located on PRIMARY |
| ind_contact_role2site | contact_role2site | nonclustered located on PRIMARY |
| ind_update_stamp | update_stamp, objid | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| role_index | contact_role2contact, contact_role2site, role_name | nonclustered, unique located on PRIMARY |
| contact_role | |||