PT_WF_NOTFY_USR(SQL Table) |
Index Back |
|---|---|
Workflow Notification AddressContains information about a user as a recipient of a workflow notification |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 3 | EMAIL_TO | Character(254) | VARCHAR2(254) NOT NULL | EMAIL_TO |
| 4 | OPRALIASTYPE | Character(3) | VARCHAR2(3) NOT NULL | User ID Type |
| 5 | EMAIL_USER_SW | Character(1) | VARCHAR2(1) NOT NULL |
Used to determine if the user gets workflow email generated
Y/N Table Edit |
| 6 | WORKLIST_USER_SW | Character(1) | VARCHAR2(1) NOT NULL |
Used to determine if the user gets a worklist generated
Y/N Table Edit |
| 7 | WF_RECIPIENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Recipient Type |
| 8 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |