FO_EVT_LST_VW

(SQL View)
Index Back

Prompt for Event Type

Staffing Front Office Recruiting Funnel Prompt for Event Type from Event List

SELECT DISTINCT A.SETID , A.FO_EVENT_LST , A.EFFDT , A.SEQ_NBR , A.EVENT_TYPE , B.DESCR FROM PS_FO_EVENTS_LIST A , PS_FO_EVENTS_SETUP B WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_FO_EVENTS_LIST B WHERE B.SETID = A.SETID AND B.FO_EVENT_LST = A.FO_EVENT_LST) AND A.EFF_STATUS = 'A' AND B.EVENT = 'TMP' AND B.EVENT_TYPE = A.EVENT_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 FO_EVENT_LST Character(30) VARCHAR2(30) NOT NULL Staffing Front Office Recruiting Funnel Event List
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
5 EVENT_TYPE Character(10) VARCHAR2(10) NOT NULL Event Type

Prompt Table: FO_EVENTS_VW

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description