SETIDORDER_EVENT_GROUPORDER_EVENT_CDB=Both Career and Temp
C=Career
T=Temp
C=Current Date
E=End Date
G=Guarantee Date
S=Start Date
N=No
Y=Yes
A=Apply Online URL
C=Telephone Call
E=Email
P=In-Person
V=Verbal
W=In-Writing
1=High
2=Medium
3=Low
FO_ORDR_EVT_VW(SQL View) |
Index Back |
|---|
| SELECT A.SETID , A.ORDER_EVENT_GROUP , A.ORDER_EVENT_CD , A.ORDER_EVENT_DAYS , A.ORDER_TYPE2 , A.ORDER_EVENT_DATE , A.YESNO_DROPDOWN , A.CONTACT_METHOD , A.AGENDA_PRIORITY FROM PS_FO_ORDR_EVENT B , PS_FO_ORDR_EVT_DTL A WHERE A.SETID = B.SETID AND A.ORDER_EVENT_GROUP = B.ORDER_EVENT_GROUP AND B.DEFAULT_FLAG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | ORDER_EVENT_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Order Event Group |
| 3 | ORDER_EVENT_CD |
Character(10) | VARCHAR2(10) NOT NULL | Agenda Event Type |
| 4 | ORDER_EVENT_DAYS | Number(3,0) | SMALLINT NOT NULL | Agenda Event Days |
| 5 | ORDER_TYPE2 | Character(1) | VARCHAR2(1) NOT NULL |
Order Type
B=Both Career and Temp C=Career T=Temp |
| 6 | ORDER_EVENT_DATE | Character(1) | VARCHAR2(1) NOT NULL |
Agenda Event Date
C=Current Date E=End Date G=Guarantee Date S=Start Date |
| 7 | YESNO_DROPDOWN | Character(1) | VARCHAR2(1) NOT NULL |
This field is to be used on panels that require a drop-down list for a Yes/No choice, rather than a checkbox.
N=No Y=Yes |
| 8 | CONTACT_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Contact Method
A=Apply Online URL C=Telephone Call E=Email P=In-Person V=Verbal W=In-Writing |
| 9 | AGENDA_PRIORITY | Character(4) | VARCHAR2(4) NOT NULL |
Agenda Priority
1=High 2=Medium 3=Low |