EOQF_EVENT_IDEOQF_NOTIF_IDPrompt Table: EOQF_NOTIF_TBL
10=Pre Event
20=Questionnaire Event
30=Follow Up Event
40=Post Event
50=Adhoc
D=Daily
W=Weekly
1=1-Sunday
2=2-Monday
3=3-Tuesday
4=4-Wednesday
5=5-Thursday
6=6-Friday
7=7-Saturday
EOQF_NOTF_DTL_V(SQL View) |
Index Back |
|---|---|
Questionnaire EventQuestionnaire Event Framework |
| SELECT EOQF_EVENT_ID, EOQF_NOTIF_ID, EOQF_NOTF_TYPE, EOQF_START_DATE, EOQF_END_DATE, EOQF_RECURRENCE, EOQF_DAYCD FROM PS_EOQF_NOTF_DTL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOQF_EVENT_ID |
Character(30) | VARCHAR2(30) NOT NULL | Questionnaire Event Framework |
| 2 | EOQF_NOTIF_ID |
Character(50) | VARCHAR2(50) NOT NULL |
Notification ID for Questionnaire Framework
Prompt Table: EOQF_NOTIF_TBL |
| 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 | EOQF_START_DATE | Date(10) | DATE | Questionnaire Event Framework |
| 5 | EOQF_END_DATE | Date(10) | DATE | Questionnaire Event Framework |
| 6 | EOQF_RECURRENCE | Character(1) | VARCHAR2(1) NOT NULL |
Questionnaire Event Framework
D=Daily W=Weekly |
| 7 | EOQF_DAYCD | Character(1) | VARCHAR2(1) NOT NULL |
Questionnaire Event Framework
1=1-Sunday 2=2-Monday 3=3-Tuesday 4=4-Wednesday 5=5-Thursday 6=6-Friday 7=7-Saturday |