2=User ID
3=Role Name
DISTIDPrompt Table: %EDITTABLE
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
PTIAAUALERT_TBL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DISTIDTYPE | Character(3) | VARCHAR2(3) NOT NULL |
Distribution ID Type
2=User ID 3=Role Name |
| 2 | DISTID |
Character(30) | VARCHAR2(30) NOT NULL |
Distribution ID
Prompt Table: %EDITTABLE |
| 3 | PTIAAAU_ALERT_STRT | Character(1) | VARCHAR2(1) NOT NULL |
On Initiation
Y/N Table Edit |
| 4 | PTIAAU_ALERT_END | Character(1) | VARCHAR2(1) NOT NULL |
On Success
Y/N Table Edit |
| 5 | PTIAAU_ALERT_FAIL | Character(1) | VARCHAR2(1) NOT NULL |
On Failure
Y/N Table Edit |