OPRIDBUSINESS_UNITVENDOR_IDPrompt Table: SPR_SUPPLR_DIM
PROJ_ROLEPrompt Table: SPR_ROLE_DIM
SPR_SUPPERSR_VW(SQL View) |
Index Back |
|---|
| SELECT S.OPRID ,S.BUSINESS_UNIT ,S.VENDOR_ID ,S.PROJ_ROLE ,R.DESCR ,S.SPR_CNT_REQSRC ,S.SPR_CNT_REQRSP ,S.SPR_CNT_CANDSUBMIT ,S.SPR_CNT_BD_REJECTS ,S.SPR_CNT_INTERVIEW ,S.SPR_REQS_FILLED ,S.SPR_POS_FILLED ,S.SPR_CNT_WO_REJECTS ,S.SPR_AVG_RSP_TM ,S.SPR_TIME_TO_FILL ,S.SPR_APPROVAL_TIME ,S.POAMOUNT FROM PS_SPR_SUPP_S_FACT S , PS_SPR_ROLE_DIM R WHERE S.BUSINESS_UNIT = R.BUSINESS_UNIT AND S.PROJ_ROLE = R.PROJ_ROLE |
| # | 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
Prompt Table: SPR_SUPPLR_DIM |
| 4 | PROJ_ROLE |
Character(15) | VARCHAR2(15) NOT NULL |
Project Role
Prompt Table: SPR_ROLE_DIM |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 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 |