FO_CAN_FUN_VW

(SQL View)
 Index Back

First View for Candidate Summ.

Staffing Front Office Recruiting Funnel First View for Candidate Summary

SELECT DISTINCT A.SO_ID , A.SO_LINE , A.CANDIDATE_ID , B.FIRST_NAME , B.LAST_NAME , A.EVENT_TYPE , M.DESCR , A.FO_EVENT_STAT , A.FO_PROC_EVNT_ST , %Substring(G.NAME1,1,15) , %Substring(D.DESCR,1,9) , H.START_DATE , C.ADDRESS1 , C.CITY , C.STATE , C.COUNTRY , A.DATETIME_ADDED , A.START_TIME , A.HISTORY_ID FROM 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 A.SO_LINE <> 0 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 I.MANAGER_CONTACT_ID = E.CONTACT_ID AND H.MANAGER_CONTACT_ID = G.CONTACT_ID UNION SELECT DISTINCT A.SO_ID , A.SO_LINE , A.CANDIDATE_ID , B.FIRST_NAME , B.LAST_NAME , A.EVENT_TYPE , M.DESCR , A.FO_EVENT_STAT , A.FO_PROC_EVNT_ST , ' ' , %Substring(D.DESCR,1,9) , H.START_DATE , C.ADDRESS1 , C.CITY , C.STATE , C.COUNTRY , A.DATETIME_ADDED , A.START_TIME , A.HISTORY_ID FROM 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_SET_CNTRL_TBL F , PS_RS_SO_HDR H , PS_RS_SO_LINE I WHERE A.SO_LINE <> 0 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 NOT EXISTS ( SELECT 'X' FROM PS_FO_CNTCT_SR O WHERE I.MANAGER_CONTACT_ID = O.CONTACT_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 FO_CUR_EVENT Character(10) VARCHAR2(10) NOT NULL Staffing Front Office Recruiting Funnel Current Event
7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 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
9 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
10 CONTACT_ID2 Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
11 FO_JOBTITLE Character(9) VARCHAR2(9) NOT NULL Job Title Code
12 START_DATE Date(10) DATE Start Date for Gen Standing PO
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 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
18 START_TIME Time(15) TIMESTAMP Start of Shift
19 HISTORY_ID Number(15,0) DECIMAL(15) NOT NULL History ID