EVENT_TYPEFO_SUBEVENTFO_SBEVT_VW(SQL View) |
Index Back |
|---|---|
Prompt for SubeventStaffing Front Office Recruiting Funnel Prompt for SubEvent from Event List |
| SELECT DISTINCT A.FO_EVNT_PRCS , A.EVENT_TYPE , C.DESCR FROM PS_FO_EVENTS_PROC A , PS_FO_EVENTS_SETUP B , PS_FO_EVENTS_SETUP C WHERE B.FO_EVNT_PROC = 'Y' AND B.EVENT = 'TMP' AND A.FO_EVNT_PRCS = B.EVENT_TYPE AND C.EVENT = 'TMP' AND C.EVENT_TYPE = A.EVENT_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EVENT_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | Event Type |
| 2 | FO_SUBEVENT |
Character(10) | VARCHAR2(10) NOT NULL | Staffing Front Office Recruiting Funnel SubEvent |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |