PTPN_CAT_REG(SQL Table) |
Index Back |
---|---|
Notification Configuration |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PTPN_CATEGORY_NAME | 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 |