SPR_CONPERVR_VW

(SQL View)
Index Back

SP Performance by Supplier

Detailed Service Provider Performance Analysis by Supplier

SELECT A.OPRID ,A.BUSINESS_UNIT ,A.VENDOR_ID ,A.APPROVAL_OPRID ,A.PROJECT_ID ,A.DEPTID ,A.PROJ_ROLE ,R.DESCR ,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_ROLE_DIM R 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 = R.BUSINESS_UNIT AND A.PROJ_ROLE = R.PROJ_ROLE 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,R.DESCR ,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 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
4 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.
5 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
6 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
7 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
8 SP_PROJECT_DESCR Character(30) VARCHAR2(30) NOT NULL Project Description
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