| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /AIF/ALERT_IDX | Standard index table for multiple recipients | 12 | ALERT_ID | External ID for an Alert | nvarchar | 5 | 0 | | |
| 2 | /CPD/PWSC_ALERT | Table to maintain Alert ID | 2 | ALERT_ID | Alert ID | nvarchar | 6 | 0 | | |
| 3 | /CPD/PWSC_ALERTT | Text Tablt for Alert ID | 2 | ALERT_ID | Alert ID | nvarchar | 6 | 0 | | |
| 4 | /CPD/PWSC_ALT_CO | Table to Define alert conditions | 3 | ALERT_ID | Alert ID | nvarchar | 6 | 0 | | |
| 5 | /CPD/PWSC_MP_ALT | table for mapping between Master project type and alert ID | 3 | ALERT_ID | Alert ID | nvarchar | 6 | 0 | | |
| 6 | /CPD/PWS_AGG_ALT | Alert Aggregation Data | 4 | ALERT_ID | Alert ID | nvarchar | 6 | 0 | | |
| 7 | /XLSO/ALERT | Alerts | 2 | ALERT_ID | UUID for Group Access Code | nvarchar | 22 | 0 | | |
| 8 | GHO_ALERT | Store Network Alerts | 2 | ALERT_ID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
| TOPFunds Management |
| 9 | PSBM_ALERT | PS Budget Monitoring Alerts | 4 | ALERT_ID | PS Budget Monitoring Alert ID | nvarchar | 10 | 0 | | |
| TOPPortal Content |
| 10 | ISTNLMORDERAL | Orders with Triggered Alerts | 6 | ALERT_ID | Alert ID | nvarchar | 32 | 0 | | |
| TOPPost Processing Framework |
| 11 | PPFTALMRU | PPF: Medium Alert (Runtime) | 11 | ALERT_ID | External ID for an Alert | nvarchar | 5 | 0 | | |
