| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /AIF/ALERTS | List of all AIF alerts | 5 | ALERTID | External ID for an Alert | nvarchar | 5 | 0 | | |
2 | GRACALDETAILS | Alerts detailed Info | 2 | ALERTID | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | |
3 | GRACALHDR | Alerts Header Info | 2 | ALERTID | UUID of the GRC object (char32) | nvarchar | 32 | 0 | | |
TOPClinical System |
4 | N1MEALERT | i.s.h.med: Drug Alerts | 2 | ALERTID | Medication: Medication Message ID | nvarchar | 32 | 0 | | |
5 | N1MEALERTT | i.s.h.med: Medication; Drug Alert - Texts | 2 | ALERTID | Medication: Medication Message ID | nvarchar | 32 | 0 | | |
6 | N1MEALMOA | i.s.h.med: Medication: Assign Drug Alert to Medication Order | 4 | ALERTID | Medication: Medication Message ID | nvarchar | 32 | 0 | | |
TOPGRC Access Control Plug-In |
7 | /VIRSA/ALERTLIST | Compliance Calibrator Alert List | 2 | ALERTID | Char 20 | nvarchar | 20 | 0 | | |
TOPInteraction Center WebClient |
8 | CRMC_IC_ALERT | Alert table | 2 | ALERTID | Alert ID | nvarchar | 32 | 0 | | |
9 | CRMC_IC_ALERT_T | Text table for Alerts | 2 | ALERTID | Alert ID | nvarchar | 32 | 0 | | |
10 | CRMC_IC_AL_EVENT | Triggering and terminating events for alerts | 2 | ALERTID | Alert ID | nvarchar | 32 | 0 | | |
11 | CRMC_IC_AL_KEY | Table that maps alert ids to alert profiles | 3 | ALERTID | Alert ID | nvarchar | 32 | 0 | | |
12 | CRMC_IC_AL_PARAM | Alert parameters and values | 2 | ALERTID | Alert ID | nvarchar | 32 | 0 | | |
13 | CRMC_IC_AL_PLHDR | Alert message placeholders | 2 | ALERTID | Alert ID | nvarchar | 32 | 0 | | |
TOPOffice Suite Program |
14 | /OSP/T_ALERT_INF | Book keeping table for alert information in budget monitor | 6 | ALERTID | Primary Key ID for alert information table | nvarchar | 32 | 0 | | |
15 | /OSP/T_POSTING | To store the Book keeping info of critical posting alerts | 6 | ALERTID | Primary Key ID for alert information table | nvarchar | 32 | 0 | | |
16 | /OSP/T_VARIANCE | Book Keeping information about critical variance alerts | 6 | ALERTID | Primary Key ID for alert information table | nvarchar | 32 | 0 | | |
TOPTransport Management System |
17 | CTWFTARGET | Transport Proposal: Target Systems/Target Clients | 19 | ALERTID | CI: alert ID | nvarchar | 32 | 0 | | |
18 | TMSBUFCNT | TMS Manager: Total Number of Requests in Transport Buffer | 17 | ALERTID | Character field, length 32 | nvarchar | 32 | 0 | | |
19 | TMSQLASTWL | TMS QA: Worklist Timestamp | 4 | ALERTID | CI: alert ID | nvarchar | 32 | 0 | | |
20 | TMSQWL | TMS QA: Worklist | 22 | ALERTID | CI: alert ID | nvarchar | 32 | 0 | | |
21 | TMSQWLH | TMS QA: Worklist | 22 | ALERTID | CI: alert ID | nvarchar | 32 | 0 | | |