CME Alert
This ERD (see the following figure) illustrates how credit and fraud alerts are managed for communications and utilities customers. A fraud alert is associated with an account. Profile attributes provide more information about the fraud threshold for an account. A credit alert is related to an account and a statement. Activities can be performed on both types of alerts.

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 |
Alert Attachment |
S_ALERT_ATT_CUT |
Alerts |
S_ALERT_CUT |
Asset |
S_ASSET |
Bill Transactions |
S_BILL_MAINT |
Billing Profile |
S_INV_PROF |
Energy Consumption |
S_USAGE |
Fraud Profile |
S_FRD_PROF_CUT |