EOQF_NOTIF_TBL(SQL Table) |
Index Back |
|---|---|
Notification DefinitionQuestionnaire Event Notification table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Notification ID for Questionnaire Framework | |
| 2 | EOQF_DESCR | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 3 | EOQF_ONL_NOTIF_MSG | Character(100) | VARCHAR2(100) NOT NULL | Online Notification Message |
| 4 | EOQF_ONL_NOTIF_OVR | Character(1) | VARCHAR2(1) NOT NULL |
Allow override
Y/N Table Edit |
| 5 | EOQF_NOTIF_SUBJECT | Character(100) | VARCHAR2(100) NOT NULL | Notification Email Subject |
| 6 | EOQF_NOTIF_SUB_OVR | Character(1) | VARCHAR2(1) NOT NULL |
Notification Subject Override
Y/N Table Edit |
| 7 | EOQF_EMAIL_BODY | Long Character | CLOB | Email Notification Body |
| 8 | EOQF_EMAIL_MSG_OVR | Character(1) | VARCHAR2(1) NOT NULL |
To controls the field editable in event designer
Y/N Table Edit |