| Table Name: | alert |
| Table Number: | 95 |
| Group: | Customer Mgr |
| Description: | Hold alert information about a site, contact, or contract |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| active | LONG | tinyint | DIRECT | Indicates whether alert is active; i.e., 0=inactive, 1=active. In order to fire, an alert must be both effective and active | Search (3) | |||
| alert_text | CHAR | text | 23 | ALLOW_NULL | Text of the alert message | Search (3) | ||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| end_date | CLK_TIME | datetime | Last date the alert is effective | Search (3) | ||||
| hot | LONG | tinyint | DIRECT | Indicates whether alert is flagged as hot; i.e., 0=no, 1=yes | Search (3) | |||
| modify_stmp | CLK_TIME | datetime | 46 | ALLOW_NULL | Date/time of last update to the alert | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (3) | ||
| start_date | CLK_TIME | datetime | Date the alert becomes effective | Search (3) | ||||
| title | CHAR | varchar | 80 | The title of the alert | Search (3) | |||
| type | CHAR | varchar | 80 | The type of alert | Search (2) | |||
| x_active | LONG | tinyint | USER_DEFINED | Is this really active - ignore pre-defined active flag for find caller.i.e., 0=no, 1=yes | Search (1) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| alert2alert_to_other | OTM | alert_to_other | to_other2alert | Tables related to this alert | USER_DEFINED | ||
| alert2bus_org | MTO | bus_org | bus_org2alert | Account which is the subject of the alert | |||
| alert2contact | MTO | contact | contact2alert | Contact which is the subject of the alert | Search (1) | ||
| alert2contract | MTO | contract | contract2alert | Contract which is the subject of the alert | Search (1) | ||
| alert2lead | MTO | lead | lead2alert | Lead which is the subject of the alert | |||
| alert2opportunity | MTO | opportunity | opp2alert | Opportunity which is the subject of the alert | |||
| alert2site | MTO | site | site2alert | Site which is the subject of the alert | Search (1) | ||
| last_update2user | MTO | user | user2alert | The user that created or last modified the alert | Search (2) |
| Index Name | Fields | Flags |
|---|---|---|
| alert_ind | x_active |
| Index Name | Fields | Additional Information |
|---|---|---|
| alert_ind | x_active | nonclustered located on PRIMARY |
| ind_alert2bus_org | alert2bus_org | nonclustered located on PRIMARY |
| ind_alert2contact | alert2contact | nonclustered located on PRIMARY |
| ind_alert2contract | alert2contract | nonclustered located on PRIMARY |
| ind_alert2lead | alert2lead | nonclustered located on PRIMARY |
| ind_alert2opportunity | alert2opportunity | nonclustered located on PRIMARY |
| ind_alert2site | alert2site | nonclustered located on PRIMARY |
| ind_last_update2user | last_update2user | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 106 | alert2objects | alert, contact, contract, site, user |
| 4302 | alert_view | alert, alert_to_other |
| 5712 | alert2user | alert, user |
| alert | |||