SCC_NTFTPTMP_VW

(SQL View)
Index Back

Template Description View


SELECT DISTINCT A.SCC_NTF_CON_ID ,B.SCC_NTFREQ_TYPE ,B.SCC_NTFREQ_TMPLTID ,B.SCC_NTFREQ_TMPLT FROM PS_SCC_NTF_CON_TMP A , PS_SCC_NTF_SETUP B WHERE A.SCC_NTFREQ_TMPLTID = B.SCC_NTFREQ_TMPLTID AND B.SCC_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCC_NTF_CON_ID Character(40) VARCHAR2(40) NOT NULL Consumer ID
2 SCC_NTFREQ_TYPE Character(4) VARCHAR2(4) NOT NULL NotificationType
ALT=Alert Notification
EML=Email Notification
PSH=Push Notification
SMS=SMS Notification
WKL=Worklist Notification
3 SCC_NTFREQ_TMPLTID Character(40) VARCHAR2(40) NOT NULL Notification Template ID
4 SCC_NTFREQ_TMPLT Character(30) VARCHAR2(30) NOT NULL Template Name