OPRIDBUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_SP_NONVW
VENDOR_IDDefault Value: SPR_ROSTER_FACT.VENDOR_ID
SPR_SUPPERSD_VW(SQL View) |
Index Back |
|---|
| SELECT A.OPRID ,A.BUSINESS_UNIT ,A.VENDOR_ID ,B.VENDOR_NAME_SHORT ,B.SP_SUPPLIER_NAME ,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_SUPPLR_DIM B WHERE A.BUSINESS_UNIT =B.BUSINESS_UNIT AND A.VENDOR_ID = B.VENDOR_ID GROUP BY A.OPRID,A.BUSINESS_UNIT ,A.VENDOR_ID ,B.VENDOR_NAME_SHORT ,B.SP_SUPPLIER_NAME |
| # | 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 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Default Value: SPR_ROSTER_FACT.VENDOR_ID |
| 4 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
| 5 | SP_SUPPLIER_NAME | Character(40) | VARCHAR2(40) NOT NULL | Supplier Name |
| 6 | SPR_CNT_REQSRC | Number(15,0) | DECIMAL(15) NOT NULL | Requirements Sourced |
| 7 | SPR_CNT_REQRSP | Number(15,0) | DECIMAL(15) NOT NULL | Reqs Responded to |
| 8 | SPR_CNT_CANDSUBMIT | Number(15,0) | DECIMAL(15) NOT NULL | Candidates Submitted |
| 9 | SPR_CNT_BD_REJECTS | Number(15,0) | DECIMAL(15) NOT NULL | Candidates Rejected |
| 10 | SPR_CNT_INTERVIEW | Number(15,0) | DECIMAL(15) NOT NULL | Candidates Interviewed |
| 11 | SPR_REQS_FILLED | Number(15,0) | DECIMAL(15) NOT NULL | Requirements Filled |
| 12 | SPR_POS_FILLED | Number(15,0) | DECIMAL(15) NOT NULL | Positions Filled |
| 13 | SPR_CNT_WO_REJECTS | Number(15,0) | DECIMAL(15) NOT NULL | Workorders Rejected |
| 14 | SPR_AVG_RSP_TM | Number(18,2) | DECIMAL(17,2) NOT NULL | Average Response Time |
| 15 | SPR_TIME_TO_FILL | Number(8,2) | DECIMAL(7,2) NOT NULL | Time to Fill |
| 16 | SPR_APPROVAL_TIME | Number(8,2) | DECIMAL(7,2) NOT NULL | SPR Invoice Approval Time |
| 17 | POAMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Purchase Order / Work Order Amount |