BUSINESS_UNITPrompt Table: BUS_UNIT_TBL_SP
VENDOR_IDPrompt Table: SPR_SUPPLR_DIM
SPB_SUP_SCR_TBL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_SP |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: SPR_SUPPLR_DIM |
| 3 | SPB_TOTAL_REQ_SRC | Number(15,0) | DECIMAL(15) NOT NULL | Total Requisistions Sourced |
| 4 | SPB_TOTAL_REQ_RSP | Number(15,0) | DECIMAL(15) NOT NULL | Total Requisistions Responded |
| 5 | SPB_TOTAL_CAN_SUB | Number(15,0) | DECIMAL(15) NOT NULL | Total Candidates Submitted |
| 6 | SPB_TOTAL_INTERVW | Number(15,0) | DECIMAL(15) NOT NULL | Total Interviews |
| 7 | SPB_TOTAL_BD_REJ | Number(15,0) | DECIMAL(15) NOT NULL | Total Candidates Rejected |
| 8 | SPB_TOTAL_REQ_FIL | Number(15,0) | DECIMAL(15) NOT NULL | Total Requisitions Filled |
| 9 | SPB_TOTAL_POS_FIL | Number(15,0) | DECIMAL(15) NOT NULL | Total Positions Filled |
| 10 | SPB_TOTAL_PO_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Purchase Orders Amount |
| 11 | SPB_TOTAL_WO_REJ | Number(15,0) | DECIMAL(15) NOT NULL | Total WO Rejected |
| 12 | SPB_AVG_PRV_RATING | Number(4,2) | DECIMAL(3,2) NOT NULL | Average Provider Rating |
| 13 | SPB_AVG_RESP_TIME | Number(18,2) | DECIMAL(17,2) NOT NULL | Average Response Time |
| 14 | SPB_AVG_TIME_FILL | Number(18,2) | DECIMAL(17,2) NOT NULL | Average Time to Fill |
| 15 | SPB_AVG_INV_APR | Number(18,2) | DECIMAL(17,2) NOT NULL | Average Invoice Approval Time |
| 16 | SPB_AVG_FIL_BY_IVW | Number(18,2) | DECIMAL(17,2) NOT NULL | Reqs Filled by Interviews |
| 17 | SPB_AVG_POS_BY_IVW | Number(18,2) | DECIMAL(17,2) NOT NULL | Positions Filled by Interviews |
| 18 | SPB_AVG_REJ_BY_IVW | Number(18,2) | DECIMAL(17,2) NOT NULL | Rejections by Interviews |
| 19 | SPB_AVG_FIL_BY_RSP | Number(18,2) | DECIMAL(17,2) NOT NULL | Fills by Responses |
| 20 | SPB_AVG_INT_BY_RSP | Number(18,2) | DECIMAL(17,2) NOT NULL | Interviews by Responses |
| 21 | SPB_AVG_REJ_BY_RSP | Number(18,2) | DECIMAL(17,2) NOT NULL | Rejections by Responses |
| 22 | SPB_AVG_POS_BY_RSP | Number(18,2) | DECIMAL(17,2) NOT NULL | Positions Filled by Responses |
| 23 | SPB_AVG_SUB_BY_RSP | Number(18,2) | DECIMAL(17,2) NOT NULL | Submissions by Responses |
| 24 | SPB_AVG_WO_BY_RSP | Number(18,2) | DECIMAL(17,2) NOT NULL | Wo Reject by Responses |
| 25 | SPB_AVG_FIL_BY_SRC | Number(18,2) | DECIMAL(17,2) NOT NULL | Reqs Filled by Reqs Sourced |
| 26 | SPB_AVG_IVW_BY_SRC | Number(18,2) | DECIMAL(17,2) NOT NULL | Interviews by Reqs Sourced |
| 27 | SPB_AVG_POS_BY_SRC | Number(18,2) | DECIMAL(17,2) NOT NULL | Posistions by Reqs Sourced |
| 28 | SPB_AVG_RSP_BY_SRC | Number(18,2) | DECIMAL(17,2) NOT NULL | Reponses by Total Reqs Sourced |
| 29 | SPB_AVG_SUB_BY_SRC | Number(18,2) | DECIMAL(17,2) NOT NULL | Subittals by Total Reqs Source |
| 30 | SPB_AVG_REJ_BY_SRC | Number(18,2) | DECIMAL(17,2) NOT NULL | Rejections by Reqs Sourced |
| 31 | SPB_AVG_WO_BY_SRC | Number(18,2) | DECIMAL(17,2) NOT NULL | Wo Reject by Reqs Sourced |
| 32 | SPB_AVG_INT_BY_SUB | Number(18,2) | DECIMAL(17,2) NOT NULL | Interviews by Submissions |
| 33 | SPB_AVG_REJ_BY_SUB | Number(18,2) | DECIMAL(17,2) NOT NULL | Rejections by Submissions |
| 34 | SPB_AVG_REJ_BY_FIL | Number(18,2) | DECIMAL(17,2) NOT NULL | Rejections by Reqs Filled |
| 35 | SPB_AVG_SUB_BY_FIL | Number(18,2) | DECIMAL(17,2) NOT NULL | Submittals by Reqs Filled |
| 36 | SPB_AVG_WO_BY_FIL | Number(18,2) | DECIMAL(17,2) NOT NULL | WO Rejected by Reqs Filled |
| 37 | SPB_AVG_REJ_BY_POS | Number(18,2) | DECIMAL(17,2) NOT NULL | Rejections by Positions Filled |
| 38 | SPB_AVG_SUB_BY_POS | Number(18,2) | DECIMAL(17,2) NOT NULL | Submittals by Positions Filled |