SCC_NTFREQ_TMPLTIDALT=Alert Notification
EML=Email Notification
PSH=Push Notification
SMS=SMS Notification
WKL=Worklist Notification
A=Active
I=Inactive
SCC_NTF_SETUPPT(SQL View) |
Index Back |
|---|---|
Notification Setup ViewNotification Template Setup View |
| SELECT SCC_NTFREQ_TMPLTID , SCC_NTFREQ_TMPLT , DESCR254 , SCC_NTFREQ_TYPE , SCC_STATUS FROM %Table(SCC_NTF_SETUP) |
| # | 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_NTFREQ_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
NotificationType
ALT=Alert Notification EML=Email Notification PSH=Push Notification SMS=SMS Notification WKL=Worklist Notification |
| 5 | SCC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Template Status
A=Active I=Inactive |