Activity
This ERD (see the following figure) illustrates how activities, contact calls, account calls, attendee calls, and meetings are managed. Every activity belongs to the employee creator and other employees assigned to the activity. Activities can be associated with one or more contacts and one account. Contact calls are associated with the employee creator and the contact, and can be associated with other employees who have been assigned, product details, samples, promotional items, and decision issues. Account calls are associated with the employee creator and an account, and can be associated with other employees who have been assigned, product details, and multiple attendee calls. Each attendee call is associated with the product details from the account call and one contact, and can be associated with samples, promotional items, and decision issues. Meetings include the employee who owns the meeting, the contacts invited to attend, the account where the meeting is taking place, and the product to be discussed at the meeting.

The following table lists the entities in this ERD and their corresponding tables.
Entity | Table |
---|---|
Account |
S_ORG_EXT, S_PARTY |
Activity |
S_EVT_ACT |
Contact |
S_CONTACT |
Employee |
S_EMP_PER, S_CONTACT, S_PARTY |
Indication |
S_PROD_APPLCTN |
Issue |
S_PROD_ISS |
Person |
S_CONTACT, S_PARTY |
Product |
S_PROD_INT |