FO_ORDR_EVT_DTL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL.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
Prompt Table: FO_EVENT_DST_VW |
| 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 |