PTPN_CAT_REG(SQL Table) |
Index Back |
|---|---|
Notification Configuration |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(50) | VARCHAR2(50) NOT NULL | Notification Name | |
| 2 | PTPN_EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL |
Event Name
Prompt Table: PTPN_EVENTS_VW |
| 3 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 4 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 5 | PTPN_FUNC_CATEGORY | Character(30) | VARCHAR2(30) NOT NULL |
Functional Category
Prompt Table: PTPN_FUNCAT_DVW |
| 6 | PTPN_NOTIFICATION | Character(1) | VARCHAR2(1) NOT NULL |
In-App
Y/N Table Edit Default Value: Y |
| 7 | PTPN_DEF_NOTIF | Character(1) | VARCHAR2(1) NOT NULL |
Notification Window
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 8 | PTPN_EMAIL | Character(1) | VARCHAR2(1) NOT NULL |
Email Notification
Y/N Table Edit Default Value: N |
| 9 | PTPN_DEF_EMAIL | Character(1) | VARCHAR2(1) NOT NULL |
Email Notification
N=No Y=Yes Y/N Table Edit Default Value: N |
| 10 | PTPN_MESSAGE | Character(1) | VARCHAR2(1) NOT NULL |
Text Message
Y/N Table Edit Default Value: N |
| 11 | PTPN_DEF_TEXT | Character(1) | VARCHAR2(1) NOT NULL |
Text Message
N=No Y=Yes Y/N Table Edit Default Value: N |
| 12 | PTPN_WHATSAPP | Character(1) | VARCHAR2(1) NOT NULL |
Whatsapp
Y/N Table Edit Default Value: N |
| 13 | PTPN_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Personalization
N=No Y=Yes Y/N Table Edit Default Value: N |
| 14 | PTPN_MAND_NOTIF | Character(1) | VARCHAR2(1) NOT NULL |
MandatoryNotification
N=No Y=Yes Y/N Table Edit Default Value: N |