FO_FUN_CAND_VW

(SQL View)
 Index Back

Candidate view

Staffing Front Office Recruiting Funnel Candidate view from FO_HISTORY

SELECT A.SO_ID , A.SO_LINE , A.CANDIDATE_ID , B.FIRST_NAME , B.LAST_NAME , A.EVENT_TYPE , A.FO_SUBEVENT , C.DESCR , A.FO_EVENT_STAT , A.FO_PROC_EVNT_ST , A.DATETIME_ADDED , A.START_TIME , A.HISTORY_ID FROM PS_FO_RF_ENTRY A , PS_FO_CANDIDATE_W B , PS_FO_EVENTS_SETUP C WHERE A.SO_LINE <> 0 AND B.CANDIDATE_ID = A.CANDIDATE_ID AND C.EVENT_TYPE = A.EVENT_TYPE AND EXISTS ( SELECT 'X' FROM PS_FO_SO_LINE_MTCH Q WHERE Q.FO_FUN_UCONS = 'Y' AND Q.SO_ID = A.SO_ID AND Q.SO_LINE = A.SO_LINE AND Q.CANDIDATE_ID = A.CANDIDATE_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
2 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
3 CANDIDATE_ID Character(11) VARCHAR2(11) NOT NULL Used as a general ID for anything from Employee id to other types of ID like asset and material.
4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
6 EVENT_TYPE Character(10) VARCHAR2(10) NOT NULL Event Type
7 FO_SUBEVENT Character(10) VARCHAR2(10) NOT NULL Staffing Front Office Recruiting Funnel SubEvent
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 FO_EVENT_STAT Character(1) VARCHAR2(1) NOT NULL Staffing Front Office Recruiting Funnel Event Status
C=Completed
I=In Progress
O=Pending
P=Partially complete
10 FO_PROC_EVNT_ST Character(1) VARCHAR2(1) NOT NULL Staffing Front Office Recruiting Funnel Process Event Status
C=Completed
I=In Progress
O=Pending
11 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
12 START_TIME Time(15) TIMESTAMP Start of Shift
13 HISTORY_ID Number(15,0) DECIMAL(15) NOT NULL History ID