Table slot9.WORLD.TSTA.NOTIFICATION_DEF_MASTERS
This table defines the behavior of a notification and is a template used when creating a notification
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 Comments
NOTIFY_TYPE_CD number 8
CASE_LOG.NOTIFY_TYPE_CD CASELG_NDM_FK R
ERROR_CODE_NOTIFICATIONS.NOTIFY_TYPE_CD ECN_NDM_FK R
INCIDENT_NOTIFY_HISTORY.NOTIFY_TYPE_CD INH_NDM_FK R
INCIDENT_ROUTES.NOTIFY_TYPE_CODE INCRTE_NDM_FK R
NOTIFICATION_DETAILS.NDM_NOTIFY_TYPE_CD NDTL_NDM_FK R
NOTIFICATION_TYPES.NOTIFY_TYPE_CD NOTYP_NDM_FK R
NOTIFY_ROLES.NOTIFY_TYPE_CD NR_NDM_FK R
SUBSCRIPTION_TYPE_CODES.NOTIFY_TYPE_CD SUBTYPCD_NDM_FK R
USER_SCREEN_MISC_NOTES.NOTIFY_TYPE_CD USR_SCRNMN_NDM_FK R
NOTIFY_PRIORITY number 1
NOTIFY_PRIORITY_CODES.PRIORITY_CODE NDM_NPC2_FK R
NOTIFY_DESCRIPTION varchar2 80  √  null
NOTIFY_USER_DEL_FLG varchar2 1  √  null
NOTIFY_INDIV_CD varchar2 2  √  null
NOTIFY_ACTIVE_MODULE varchar2 255  √  null
NOTIFY_COMMENT varchar2 250  √  null
QUERY_ONLY_FLG varchar2 1  √  null
DEFAULT_FLOW_NAME varchar2 40  √  null
ENABLED varchar2 1 'Y' Yes or No Fields
GLOBAL_VAR_1 varchar2 60  √  null
GLOBAL_VAR_2 varchar2 60  √  null
GLOBAL_VAR_3 varchar2 60  √  null
GLOBAL_VAR_4 varchar2 60  √  null
GLOBAL_VAR_5 varchar2 60  √  null
INFO_FLAG varchar2 1 'N'
IGNORE_AGENCY_FILTER varchar2 1  √  'N' Ignore Agency Filter
EMAIL_ENABLED varchar2 1 'N' A flag indicating if an email notification is required along with the standard notification for a specific notification.
JRD_AGENCY_TYPE varchar2 30  √  null
EJS_CODES.CODE NDM_JRD_AGENCY_TYP_EJS_CODE_FK R
The code to identify an jurisdiction agency type.
AUDIT_ACTION varchar2 1  √  'N' Yes or No Fields
AUDIT_CREATION varchar2 1  √  'N' Yes or No Fields
WORKGROUP_RESTRICT varchar2 1  √  'N'
JRD_AGENCY_TYPE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE NDM_JRD_AGENCY_TYP_EJS_CODE_FK R
REC_ID number 0  √  null
AUDIT_ENABLED_FLAG varchar2 1  √  'N' Whether or not actions or deletions of this notification type are audited

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
AUDIT_ENABLED_FLAG IN ('Y', 'N') CK_NDM_AUD_ENAB_FLG
AUDIT_ACTION IN ('Y', 'N') CK_NDM_AUDIT_ACTION
AUDIT_CREATION IN ('Y', 'N') CK_NDM_AUDIT_CREATION
EMAIL_ENABLED IN ('Y', 'N') CK_NDM_EMAIL_ENABLED
IGNORE_AGENCY_FILTER IN ('Y', 'N') CK_NDM_IGNORE_AGENCY_FILTER
"EMAIL_ENABLED" IS NOT NULL NDM_EMAIL_ENABLED_NN
"ENABLED" IS NOT NULL NDM_ENABLED_NN
"INFO_FLAG" IS NOT NULL NDM_INFO_FLAG_NN
"NOTIFY_PRIORITY" IS NOT NULL NDM_NOTIFY_PRIORITY_NN
"NOTIFY_TYPE_CD" IS NOT NULL NDM_NOTIFY_TYPE_CD_NN

Indexes:
Column(s) Type Sort Constraint Name
NOTIFY_TYPE_CD Primary key Asc NDM_PK
JRD_AGENCY_TYPE Performance Asc NDM_JATC_FK_I
JRD_AGENCY_TYPE_TYPE + JRD_AGENCY_TYPE Performance Asc/Asc NDM_JRD_AGENCY_TYP_EJS_CODE_I
NOTIFY_PRIORITY Performance Asc NDM_NPC2_FK_I

Close relationships  within of separation: