FO_EVT_SUM3_VW

(SQL View)
 Index Back

Resource Request Summary

Staffing Front Office Recruiting Funnel Resource Request Summary

SELECT DISTINCT F.SETID , B.MANAGER_CONTACT_ID , B.BUSINESS_UNIT , A.SO_ID , A.SO_LINE , 0 , H.EVENT_TYPE , H.DESCR , A.QTY_INTEGER , Z.MATCH_LINE_NBR , I.FO_FUN_COMPL , I.FO_FUN_OUT , I.FO_FUN_IP , I.FO_FUN_PART , Y.MATCH_LINE_NBR , A.QTY_INTEGER - Y.MATCH_LINE_NBR , %Substring(D.DESCR,1,9) , B.START_DATE , C.ADDRESS1 , C.CITY , C.STATE , C.COUNTRY , A.REG_PAY_RATE , A.REG_BILL_RATE FROM PS_RS_SO_LINE A , PS_RS_SO_HDR B , PS_FO_CUST_ADDR_VW C , PS_FO_FUN_CAND_VW H , PS_FO_E2_CAND_VW I , PS_FO_RES_SUM_VW6 Y , PS_FO_RES_SUM_VW5 Z , PS_FO_JOBCD_CUR_VW D , PS_FO_CNTCT_SR E , PS_SET_CNTRL_TBL F , PS_FO_CNTCT_SR G WHERE Z.SO_ID = A.SO_ID AND Z.SO_LINE = A.SO_LINE AND Z.SO_ID = B.SO_ID AND A.SO_ID = B.SO_ID AND B.CUST_ID = C.CUST_ID AND C.ADDRESS_SEQ_NUM = B.ADDRESS_SEQ_NUM AND Y.SO_ID = A.SO_ID AND Y.SO_LINE = A.SO_LINE AND A.JOBCODE = D.JOBCODE AND A.BUSINESS_UNIT = F.SETCNTRLVALUE AND D.SETID = F.SETID AND A.MANAGER_CONTACT_ID = E.CONTACT_ID AND B.MANAGER_CONTACT_ID = G.CONTACT_ID AND H.SO_ID = A.SO_ID AND H.SO_LINE = A.SO_LINE AND I.SO_ID = A.SO_ID AND I.SO_LINE = A.SO_LINE AND I.EVENT_TYPE = H.EVENT_TYPE AND EXISTS ( SELECT 'X' FROM PS_FO_ORDR_SRCH_VW P WHERE P.BUSINESS_UNIT = A.BUSINESS_UNIT AND P.SO_ID = A.SO_ID AND P.FO_ORDER_STATUS = 'U') UNION SELECT DISTINCT F.SETID , B.MANAGER_CONTACT_ID , B.BUSINESS_UNIT , A.SO_ID , A.SO_LINE , 0 , H.EVENT_TYPE , H.DESCR , A.QTY_INTEGER , Z.MATCH_LINE_NBR , I.FO_FUN_COMPL , I.FO_FUN_OUT , I.FO_FUN_IP , I.FO_FUN_PART , Y.MATCH_LINE_NBR , A.QTY_INTEGER - Y.MATCH_LINE_NBR , D.DESCR , B.START_DATE , C.ADDRESS1 , C.CITY , C.STATE , C.COUNTRY , A.REG_PAY_RATE , A.REG_BILL_RATE FROM PS_RS_SO_LINE A , PS_RS_SO_HDR B , PS_FO_CUST_ADDR_VW C , PS_FO_FUN_CAND_VW H , PS_FO_E2_CAND_VW I , PS_FO_RES_SUM_VW6 Y , PS_FO_RES_SUM_VW5 Z , PS_FO_JOBCD_CUR_VW D , PS_SET_CNTRL_TBL F WHERE Z.SO_ID = A.SO_ID AND Z.SO_LINE = A.SO_LINE AND Z.SO_ID = B.SO_ID AND A.SO_ID = B.SO_ID AND B.CUST_ID = C.CUST_ID AND C.ADDRESS_SEQ_NUM = B.ADDRESS_SEQ_NUM AND Y.SO_ID = A.SO_ID AND Y.SO_LINE = A.SO_LINE AND A.JOBCODE = D.JOBCODE AND A.BUSINESS_UNIT = F.SETCNTRLVALUE AND D.SETID = F.SETID AND NOT EXISTS ( SELECT 'X' FROM PS_FO_CNTCT_SR X WHERE A.MANAGER_CONTACT_ID = X.CONTACT_ID) AND H.SO_ID = A.SO_ID AND H.SO_LINE = A.SO_LINE AND I.SO_ID = A.SO_ID AND I.SO_LINE = A.SO_LINE AND I.EVENT_TYPE = H.EVENT_TYPE AND EXISTS ( SELECT 'X' FROM PS_FO_ORDR_SRCH_VW P WHERE P.BUSINESS_UNIT = A.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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
5 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
6 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
7 EVENT_TYPE Character(10) VARCHAR2(10) NOT NULL Event Type
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 QTY_INTEGER Number(11,0) DECIMAL(11) NOT NULL Quantity Rounded to 0 Decimals
10 FO_FUN_CONS Number(9,0) DECIMAL(9) NOT NULL Staffing Front Office Recruiting Funnel Considering Field
11 FO_FUN_COMPL Number(3,0) SMALLINT NOT NULL Staffing Front Office Recruiting Funnel Completed Indicator
12 FO_FUN_OUT Number(9,0) DECIMAL(9) NOT NULL Staffing Front Office Recruiting Funnel Outstanding Indicator
13 FO_FUN_IP Number(9,0) DECIMAL(9) NOT NULL Staffing Front Office Recruiting Funnel In Progress Indicator
14 FO_FUN_PART Number(9,0) DECIMAL(9) NOT NULL Staffing Front Office Recruiting Funnel Partially Complete Indicator
15 FO_FUN_ASSG Number(9,0) DECIMAL(9) NOT NULL Staffing Front Office Recruiting Funnel Assigned Field
16 FO_FUN_NEED Number(11,0) DECIMAL(11) NOT NULL Staffing Front Office Recruiting Funnel Needed Field
17 FO_JOBTITLE Character(9) VARCHAR2(9) NOT NULL Job Title Code
18 START_DATE Date(10) DATE Start Date for Gen Standing PO
19 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
20 CITY Character(30) VARCHAR2(30) NOT NULL City
21 STATE Character(6) VARCHAR2(6) NOT NULL State
22 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
23 REG_PAY_RATE Number(19,6) DECIMAL(18,6) NOT NULL Pay Rate
24 REG_BILL_RATE Number(19,6) DECIMAL(18,6) NOT NULL Bill Rate