|
|
| Legend: |
| Primary key columns |
| Columns with indexes |
| Implied relationships |
| Excluded column relationships |
| < n > number of related tables |
|
|
| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| NOTIFY_DTL_NUMBER |
number |
8 |
|
|
|
|
|
| NOTIFY_DTL_TYPE |
varchar2 |
80 |
√ |
|
null |
|
|
| NDM_NOTIFY_TYPE_CD |
number |
8 |
|
|
|
|
|
| PRIORITY_DESC |
varchar2 |
255 |
√ |
|
null |
|
|
| VISUAL_ALERT_YN |
varchar2 |
1 |
√ |
|
null |
|
|
| SENDER |
varchar2 |
61 |
√ |
|
null |
|
|
| CREATOR_DATE |
date |
7 |
√ |
|
null |
|
|
| NOTIFY_DTL_INFO |
varchar2 |
80 |
√ |
|
null |
|
|
| NOTES |
varchar2 |
4000 |
√ |
|
null |
|
|
| AUDIO_ALERT_YN |
varchar2 |
1 |
√ |
|
null |
|
|
| NOTIFY_DTL_ROLE |
varchar2 |
30 |
√ |
|
null |
|
|
| NOTIFY_DTL_USER_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| AGENCY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| SUB_CATEGORY |
varchar2 |
255 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT ND.NOTIFY_DTL_NUMBER,
ND.NOTIFY_DTL_TYPE AS NOTIFY_DTL_TYPE,
ND.NDM_NOTIFY_TYPE_CD AS NDM_NOTIFY_TYPE_CD,
NP.PRIORITY_DESC AS PRIORITY_DESC,
NP.VISUAL_ALERT_YN,
P.LNAME || ' ' || P.FNAME || '' || P.MNAME AS SENDER,
ND.CREATOR_DATE,
ND.NOTIFY_DTL_INFO AS NOTIFY_DTL_INFO,
ND.NOTES,
NP.AUDIO_ALERT_YN AS AUDIO_ALERT_YN,
ND.NOTIFY_DTL_ROLE,
ND.NOTIFY_DTL_USER_ID,
ND.AGENCY_CODE,
ND.SUB_CATEGORY
FROM NOTIFICATION_DETAILS ND,
NOTIFY_PRIORITY_CODES NP,
IJIS_USER_PROFILES P
WHERE ND.NOTIFY_DTL_PRIORITY_NUM = NP.PRIORITY_CODE(+)
AND ND.CREATOR_ID = P.LOGIN_ID(+)
AND NOT EXISTS
(SELECT NDDA.NOTIFY_DTL_NUMBER
FROM NOTIFY_DETAIL_DISABLE_ALERTS NDDA
WHERE NDDA.NOTIFY_DTL_NUMBER = ND.NOTIFY_DTL_NUMBER)
Possibly Referenced Tables/Views:
