OPRIDEOQF_EVENT_IDEOQF_NOTF_TYPE10=Pre Event
20=Questionnaire Event
30=Follow Up Event
40=Post Event
50=Adhoc
LASTUPDDTTMPrompt Table: EOQF_NOTIF_TBL
EOQF_NOTIF_HIST(SQL Table) |
Index Back |
|---|---|
Questionnaire Event FrameworkQuestionnaire Event Framework |
| # | 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 | EOQF_EVENT_ID |
Character(30) | VARCHAR2(30) NOT NULL | Questionnaire Event Framework |
| 3 | EOQF_NOTF_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Questionnaire Event Framework
10=Pre Event 20=Questionnaire Event 30=Follow Up Event 40=Post Event 50=Adhoc |
| 4 | LASTUPDDTTM |
DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 5 | EOQF_NOTIF_ID | Character(30) | VARCHAR2(30) NOT NULL |
Notification ID for Questionnaire Framework
Prompt Table: EOQF_NOTIF_TBL |
| 6 | EOQF_EMAIL_SENT | DateTime(26) | TIMESTAMP | Email Notification |
| 7 | EOQF_ONLINE_SENT | DateTime(26) | TIMESTAMP | Online Notification |