SCC_GE_NTFTM_VW

(SQL View)
 Index Back

EMS Notification Template View

Evaluation Management System Notification Framework Template View. Returns all Notification Templates defined for EMS.

SELECT A.SCC_NTFREQ_TMPLTID , B.SCC_NTFREQ_TMPLT , B.DESCR254 , B.SCC_STATUS , B.SCC_NTFREQ_TYPE FROM %Table(SCC_NTF_CON_TMP) A , %Table(SCC_NTF_SETUP) B WHERE A.SCC_NTF_CON_ID = 'SCC_NTF_CON_20130215180342' AND A.SCC_NTFREQ_TMPLTID = B.SCC_NTFREQ_TMPLTID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCC_NTFREQ_TMPLTID Character(40) VARCHAR2(40) NOT NULL Notification Template ID
2 SCC_NTFREQ_TMPLT Character(30) VARCHAR2(30) NOT NULL Template Name
3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
4 SCC_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction Status
A=Active
I=Inactive
5 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