FO_RES_SUM3_VW

(SQL View)
 Index Back

Resource Request Summary

Staffing Front Office Recruiting Funnel Resource Request Summary

SELECT F.SETID , B.MANAGER_CONTACT_ID , B.BUSINESS_UNIT , A.SO_ID , A.SO_LINE , A.QTY_INTEGER , Z.MATCH_LINE_NBR , Y.MATCH_LINE_NBR , A.QTY_INTEGER - Y.MATCH_LINE_NBR , %Substring(D.DESCR,1,9) , D.DESCR , A.START_DT , C.ADDRESS1 , C.CITY , C.STATE , C.COUNTRY , A.REG_PAY_RATE , A.REG_BILL_RATE , G.NAME1 , A.MANAGER_CONTACT_ID , E.NAME1 FROM PS_FO_CUST_ADDR_VW C , PS_FO_RES_SUM_VW6 Y , PS_FO_RES_SUM_VW5 Z , PS_FO_JOBCD_CUR_VW D , PS_SET_CNTRL_TBL F , PS_RS_SO_LINE A LEFT OUTER JOIN PS_FO_CNTCT_SR E ON E.CONTACT_ID = A.MANAGER_CONTACT_ID , PS_RS_SO_HDR B LEFT OUTER JOIN PS_FO_CNTCT_SR G ON B.MANAGER_CONTACT_ID = G.CONTACT_ID 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 C.SETID = F.SETID 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 (CASE WHEN E.CONTACT_ID IS NOT NULL THEN E.CONTACT_SETID ELSE ' ' END) = (CASE WHEN E.CONTACT_ID IS NOT NULL THEN F.SETID ELSE ' ' END) 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 MANAGER_CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Order Contact
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 QTY_INTEGER Number(11,0) DECIMAL(11) NOT NULL Quantity Rounded to 0 Decimals
7 FO_FUN_CONS Number(9,0) DECIMAL(9) NOT NULL Staffing Front Office Recruiting Funnel Considering Field
8 FO_FUN_ASSG Number(9,0) DECIMAL(9) NOT NULL Staffing Front Office Recruiting Funnel Assigned Field
9 FO_FUN_NEED Number(11,0) DECIMAL(11) NOT NULL Staffing Front Office Recruiting Funnel Needed Field
10 FO_JOBTITLE Character(9) VARCHAR2(9) NOT NULL Job Title Code
11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
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 REG_PAY_RATE Number(19,6) DECIMAL(18,6) NOT NULL Pay Rate
18 REG_BILL_RATE Number(19,6) DECIMAL(18,6) NOT NULL Bill Rate
19 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
20 CONTACT_ID2 Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
21 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2