FO_CAND_OO_VW2

(SQL View)
 Index Back

View For Candidate Overview

Staffing Front Office Recruiting Funnel View For Candidate Overview

SELECT A.CANDIDATE_ID , A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE , A.MATCH_LINE_NBR , A.CANDIDATE_TYPE , A.OFFER_RESULT , A.FIT_SCORE_QUA , A.FIT_SCORE_AVA , A.ASSIGNMENT_ID , B.FO_DESCR_CUREV , C.CUST_ID , B.ADDRESS1 , B.CITY , B.STATE , B.COUNTRY , B.FO_JOBTITLE , B.START_DATE FROM PS_FO_SO_LINE_MTCH A , PS_FO_CAN2_FUN_VW B , PS_RS_SO_HDR C WHERE A.FO_FUN_UCONS = 'Y' AND B.SO_ID = A.SO_ID AND B.SO_LINE = A.SO_LINE AND B.CANDIDATE_ID = A.CANDIDATE_ID AND C.SO_ID = A.SO_ID AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.SO_ID IN ( SELECT DISTINCT V.SO_ID FROM PS_FO_CAN_JOIN_VW V , PS_FO_RF_ENTRY A , PS_FO_CANDIDATE_W B , PS_FO_EVENTS_SETUP M , PS_FO_CUST_ADDR_VW C , PS_FO_RES_SUM_VW6 Y , PS_FO_RES_SUM_VW5 Z , PS_JOBCODE_TBL D , PS_FO_CNTCT_SR E , PS_SET_CNTRL_TBL F , PS_FO_CNTCT_SR G , PS_RS_SO_HDR H , PS_RS_SO_LINE I WHERE V.SO_ID = A.SO_ID AND V.SO_LINE = A.SO_LINE AND V.CANDIDATE_ID = A.CANDIDATE_ID AND V.EVENT_TYPE = A.EVENT_TYPE AND V.FO_SUBEVENT = A.FO_SUBEVENT AND V.FO_EVENT_STAT = A.FO_EVENT_STAT AND B.CANDIDATE_ID = A.CANDIDATE_ID AND M.EVENT_TYPE = A.EVENT_TYPE AND H.SO_ID = A.SO_ID AND C.CUST_ID = H.CUST_ID AND C.ADDRESS_SEQ_NUM = H.ADDRESS_SEQ_NUM AND C.SETID = F.SETID AND Y.SO_ID = A.SO_ID AND Y.SO_LINE = A.SO_LINE AND Z.SO_ID = A.SO_ID AND Z.SO_LINE = A.SO_LINE AND I.JOBCODE = D.JOBCODE AND I.BUSINESS_UNIT = F.SETCNTRLVALUE AND I.SO_ID = H.SO_ID AND I.SO_LINE = A.SO_LINE AND D.SETID = F.SETID AND H.MANAGER_CONTACT_ID = G.CONTACT_ID AND (I.MANAGER_CONTACT_ID = E.CONTACT_ID OR NOT EXISTS ( SELECT 'X' FROM PS_FO_CNTCT_SR O WHERE I.MANAGER_CONTACT_ID = O.CONTACT_ID)) 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) AND EXISTS ( SELECT 'X' FROM PS_FO_ORDR_SRCH_VW P WHERE P.BUSINESS_UNIT = I.BUSINESS_UNIT AND P.SO_ID = A.SO_ID AND P.FO_ORDER_STATUS = 'U'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 APPLID Character(11) VARCHAR2(11) NOT NULL External Job Applicant ID
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
4 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
5 MATCH_LINE_NBR Number(4,0) SMALLINT NOT NULL Match Line Number
6 CANDIDATE_TYPE Character(1) VARCHAR2(1) NOT NULL Candidate Type
A=Applicant
E=Employee
7 OFFER_RESULT Character(1) VARCHAR2(1) NOT NULL Confidential Order
C=Considering
D=Declined
E=Accepted
O=Other
S=Assigned
8 FIT_SCORE_QUA Signed Number(7,4) DECIMAL(5,4) NOT NULL Qualifications Fit Score
9 FIT_SCORE_AVA Signed Number(7,4) DECIMAL(5,4) NOT NULL Availability Fit Score
10 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID
11 FO_DESCR_CUREV Character(30) VARCHAR2(30) NOT NULL Staffing Front Office Recruiting Funnel Current Event Field
12 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
13 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
14 CITY Character(30) VARCHAR2(30) NOT NULL City
15 STATE Character(6) VARCHAR2(6) NOT NULL State
16 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
17 FO_JOBTITLE Character(9) VARCHAR2(9) NOT NULL Job Title Code
18 START_DATE Date(10) DATE Start Date for Gen Standing PO