OPRIDBUSINESS_UNITVENDOR_IDPrompt Table: SPR_SUPPLR_DIM
PROJ_ROLEPrompt Table: SPR_ROLE_DIM
SPR_SUPPRF_FACT(SQL Table) |
Index Back |
|---|
| # | 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 | 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_REQS_FILLED | Number(15,0) | DECIMAL(15) NOT NULL | Requirements Filled |
| 9 | SPR_POS_FILLED | Number(15,0) | DECIMAL(15) NOT NULL | Positions Filled |
| 10 | SPR_AVG_RSP_TM | Number(18,2) | DECIMAL(17,2) NOT NULL | Average Response Time |
| 11 | SPR_TIME_TO_FILL | Number(8,2) | DECIMAL(7,2) NOT NULL | Time to Fill |
| 12 | SPR_APPROVAL_TIME | Number(8,2) | DECIMAL(7,2) NOT NULL | SPR Invoice Approval Time |