SPR_CONLOSOR_VW

(SQL View)
 Index Back

sPro Length of Stay by PO

sPro Length of Stay by PO View

SELECT A.OPRID ,A.BUSINESS_UNIT ,A.PO_ID ,A.VENDOR_ID ,A.WO_CONID ,A.WORK_ORDER_ID ,B.SP_SUPPLIER_NAME ,C.NAME ,A.START_DATE ,A.PROJECTED_END_DATE ,A.END_DATE ,AVG(A.LENGTH_OF_STAY) ,AVG(A.EX_DURATION_DAYS) FROM PS_SPR_LOSTAY_FACT A , PS_SPR_SUPPLR_DIM B , PS_SPR_PERSON_DIM C WHERE A.BUSINESS_UNIT =B.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.VENDOR_ID = B.VENDOR_ID AND C.PERSON_ID = A.WO_CONID GROUP BY A.OPRID ,A.BUSINESS_UNIT ,A.PO_ID ,A.VENDOR_ID ,A.WO_CONID ,C.NAME ,B.SP_SUPPLIER_NAME ,A.WORK_ORDER_ID ,A.START_DATE ,A.PROJECTED_END_DATE ,A.END_DATE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 WO_CONID Character(15) VARCHAR2(15) NOT NULL Service Provider's ID assigned on work order
6 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
7 SP_SUPPLIER_NAME Character(40) VARCHAR2(40) NOT NULL Supplier Name
8 SP_CONTRACTOR_NAME Character(50) VARCHAR2(50) NOT NULL Service Provider
9 START_DATE Date(10) DATE Start Date for Gen Standing PO
10 PROJECTED_END_DATE Date(10) DATE Projected End Date of Length of Stay Analysis
11 END_DATE Date(10) DATE End Date
12 LENGTH_OF_STAY Number(5,0) INTEGER NOT NULL Length of Stay in Days
13 EX_DURATION_DAYS Signed Number(6,0) DECIMAL(5) NOT NULL Excess Duration for Length of Stay