PRCSTYPEPRCSNAMEDISTIDPrompt Table: %EDITTABLE
DISTIDTYPE2=User ID
3=Role Name
PTPSNOTIFYTYPE1=EMail
2=Pop-up Notification
3=Notification Window
PRCSDEFNNOTIFY(SQL Table) |
Index Back |
|---|---|
Process Defn - NotificationThis table contains all users or users in roles that are to be notified based on the selected option as to when the person(s) need to be notified |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PRCSTYPE |
Character(30) | VARCHAR2(30) NOT NULL | Process Type |
| 2 | PRCSNAME |
Character(12) | VARCHAR2(12) NOT NULL | Process Name |
| 3 | DISTID |
Character(30) | VARCHAR2(30) NOT NULL |
Distribution ID
Prompt Table: %EDITTABLE |
| 4 | DISTIDTYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Distribution ID Type
2=User ID 3=Role Name |
| 5 | NOTIFYONERROR | Number(1,0) | SMALLINT NOT NULL | Notify On Error |
| 6 | NOTIFYONSUCCESS | Number(1,0) | SMALLINT NOT NULL | Notify On Success |
| 7 | NOTIFYDISABLED | Character(1) | VARCHAR2(1) NOT NULL | Notify Disabled |
| 8 | NOTIFYONWARNING | Number(1,0) | SMALLINT NOT NULL | Notify On Warning |
| 9 | PTPSNOTIFYTYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Type
1=EMail 2=Pop-up Notification 3=Notification Window |
| 10 | PTPSCANCEL | Number(2,0) | SMALLINT NOT NULL | On Cancel |
| 11 | PTPSDELETE | Number(2,0) | SMALLINT NOT NULL | On Delete |
| 12 | PTPSHOLD | Number(2,0) | SMALLINT NOT NULL | On Hold |
| 13 | PTPSQUEUED | Number(2,0) | SMALLINT NOT NULL | On Queued |
| 14 | PTPSINITIATED | Number(2,0) | SMALLINT NOT NULL | On Initiated |
| 15 | PTPSPROCESSING | Number(2,0) | SMALLINT NOT NULL | On Processing |
| 16 | PTPSCANCELLED | Number(2,0) | SMALLINT NOT NULL | On Cancelled |
| 17 | PTPSNOTSUCCESS | Number(2,0) | SMALLINT NOT NULL | On Not Success |
| 18 | PTPSASSIGNED | Number(2,0) | SMALLINT NOT NULL | On Assigned |
| 19 | PTPSPENDING | Number(2,0) | SMALLINT NOT NULL | On Pending |
| 20 | PTPSBLOCKED | Number(2,0) | SMALLINT NOT NULL | On Blocked |
| 21 | PTPSRESTART | Number(2,0) | SMALLINT NOT NULL | On Restart |