SPR_CONPERRR_VW

(SQL View)
 Index Back

SP Performance by Supplier

Detailed Service Provider Performance Analysis by Supplier

SELECT A.OPRID ,A.BUSINESS_UNIT ,A.PROJ_ROLE ,A.VENDOR_ID ,S.SP_SUPPLIER_NAME ,A.APPROVAL_OPRID ,A.PROJECT_ID ,A.DEPTID ,A.WO_CONID ,B.NAME ,C.NAME ,AVG(A.APPR_RATING_NUM ) ,' ' ,A.WORK_ORDER_ID FROM PS_SPR_CONPER_FACT A , PS_SPR_EMPLID_DIM B , PS_SPR_PERSON_DIM C ,PS_SPR_SUPPLR_DIM S WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.OPRID= A.APPROVAL_OPRID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND C.PERSON_ID = A.WO_CONID AND A.BUSINESS_UNIT = S.BUSINESS_UNIT AND A.VENDOR_ID = S.VENDOR_ID GROUP BY A.OPRID ,A.BUSINESS_UNIT ,A.VENDOR_ID ,A.APPROVAL_OPRID ,A.PROJECT_ID ,A.DEPTID ,A.PROJ_ROLE ,A.WO_CONID ,B.NAME ,S.SP_SUPPLIER_NAME,C.NAME,A.WORK_ORDER_ID

# 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 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 SP_SUPPLIER_NAME Character(40) VARCHAR2(40) NOT NULL Supplier Name
6 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.
7 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
8 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
9 WO_CONID Character(15) VARCHAR2(15) NOT NULL Service Provider's ID assigned on work order
10 SP_MANAGER_NAME Character(50) VARCHAR2(50) NOT NULL Requester Name
11 SP_CONTRACTOR_NAME Character(50) VARCHAR2(50) NOT NULL Service Provider
12 APPR_RATING_NUM Number(4,2) DECIMAL(3,2) NOT NULL Performance Rating
13 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
14 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID