PTPN_CATEGORY_NAMEPTPN_NODENAMEUSERIDPrompt Table: PTPN_EVENTS_VW
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
N=No
Y=Yes
N=No
Y=Yes
PTPN_CAT_USRPRE(SQL Table) |
Index Back |
|---|---|
Notification Personalization |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTPN_CATEGORY_NAME |
Character(50) | VARCHAR2(50) NOT NULL | Notification Name |
| 2 | PTPN_NODENAME |
Character(30) | VARCHAR2(30) NOT NULL | Node Name |
| 3 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 4 | PTPN_EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL |
Event Name
Prompt Table: PTPN_EVENTS_VW |
| 5 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 6 | PTPN_NOTIFICATION | Character(1) | VARCHAR2(1) NOT NULL |
In-App
Y/N Table Edit Default Value: N |
| 7 | PTPN_EMAIL | Character(1) | VARCHAR2(1) NOT NULL |
Email Notification
Y/N Table Edit Default Value: N |
| 8 | PTPN_MESSAGE | Character(1) | VARCHAR2(1) NOT NULL |
Text Message
Y/N Table Edit Default Value: N |
| 9 | PTPN_WHATSAPP | Character(1) | VARCHAR2(1) NOT NULL |
Whatsapp
Y/N Table Edit Default Value: N |
| 10 | PTPN_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Personalization
N=No Y=Yes |
| 11 | PTPN_MAND_NOTIF | Character(1) | VARCHAR2(1) NOT NULL |
MandatoryNotification
N=No Y=Yes |