| 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 | | |