ALERT_NOTIFY_IDPrompt Table: TL_NOTIFY_USRVW
A=Alert
B=Both
E=Email
Default Value: A
Prompt Table:
PSROLEDEFN
Set Control Field: ROLENAME
A=Alert
N=None
Default Value: N
TL_ALERT_NOTIFY(SQL Table) |
Index Back |
|---|---|
TL Alert Notifcation |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ALERT_NOTIFY_ID |
Character(10) | VARCHAR2(10) NOT NULL | Notification ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | EOAWUSER_LIST_ID | Character(30) | VARCHAR2(30) NOT NULL |
Identifies the user list to be used when creating the approval process.
Prompt Table: TL_NOTIFY_USRVW |
| 4 | ROUTE_NOTIFY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Notification Type
A=Alert B=Both E=Email Default Value: A |
| 5 | ADMIN_ROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
Rolename of Approval Workflow Administrator
Prompt Table:
PSROLEDEFN
|
| 6 | EMPL_NOTIFY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Notification Type
A=Alert N=None Default Value: N |