Social Media

This ERD (see the following figure) illustrates how social media data is integrated with the Siebel application to generate service requests, leads, and loyalty credits. Loyalty credits can be defined for customers who post information in social media about a company's products or perform other activities that might result in customer adoption or increased market awareness of the product.

The following table lists the entities in this ERD and their corresponding tables.

Entity	Table
Employee/Agent	S_CONTACT, S_USER, S_EMP_PER, S_PARTY
Contact Social Media Profile	S_CON_SM_PROF
Contact Social Media Profile Attribute	S_CON_SM_ATTR
Lead	S_LEAD, S_SM_DATA_LEAD
Loyalty Transaction	S_LOY_TXN
Person	S_CONTACT, S_PARTY, S_SM_DTASRC_USR
Social Media Channel	S_SM_CHANNEL
Social Media Data	S_SM_DATA
Social Media Data Source	S_SM_DTA_SOURCE
Service Request	S_SRV_REQ