SPR_SUPPERRS_VW

(SQL View)
 Index Back

Supplier Performance Role

Supplier Performance Role Summary

SELECT A.OPRID ,A.BUSINESS_UNIT ,A.PROJ_ROLE ,B.DESCR ,SUM(A.SPR_CNT_REQSRC) ,SUM(A.SPR_CNT_REQRSP) ,SUM(A.SPR_CNT_CANDSUBMIT) ,SUM(A.SPR_CNT_BD_REJECTS) ,SUM(A.SPR_CNT_INTERVIEW) ,SUM(A.SPR_REQS_FILLED) ,SUM(A.SPR_POS_FILLED) ,SUM(A.SPR_CNT_WO_REJECTS) ,AVG(A.SPR_AVG_RSP_TM) ,AVG(A.SPR_TIME_TO_FILL) ,AVG(A.SPR_APPROVAL_TIME) ,SUM(A.POAMOUNT) FROM PS_SPR_SUPP_S_FACT A , PS_SPR_ROLE_DIM B WHERE A.BUSINESS_UNIT =B.BUSINESS_UNIT AND A.PROJ_ROLE= B.PROJ_ROLE GROUP BY A.OPRID ,A.BUSINESS_UNIT ,A.PROJ_ROLE ,B.DESCR

# 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

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_SP_NONVW

3 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 SPR_CNT_REQSRC Number(15,0) DECIMAL(15) NOT NULL Requirements Sourced
6 SPR_CNT_REQRSP Number(15,0) DECIMAL(15) NOT NULL Reqs Responded to
7 SPR_CNT_CANDSUBMIT Number(15,0) DECIMAL(15) NOT NULL Candidates Submitted
8 SPR_CNT_BD_REJECTS Number(15,0) DECIMAL(15) NOT NULL Candidates Rejected
9 SPR_CNT_INTERVIEW Number(15,0) DECIMAL(15) NOT NULL Candidates Interviewed
10 SPR_REQS_FILLED Number(15,0) DECIMAL(15) NOT NULL Requirements Filled
11 SPR_POS_FILLED Number(15,0) DECIMAL(15) NOT NULL Positions Filled
12 SPR_CNT_WO_REJECTS Number(15,0) DECIMAL(15) NOT NULL Workorders Rejected
13 SPR_AVG_RSP_TM Number(18,2) DECIMAL(17,2) NOT NULL Average Response Time
14 SPR_TIME_TO_FILL Number(8,2) DECIMAL(7,2) NOT NULL Time to Fill
15 SPR_APPROVAL_TIME Number(8,2) DECIMAL(7,2) NOT NULL SPR Invoice Approval Time
16 POAMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Purchase Order / Work Order Amount