PROCESS_INSTANCEOPRIDBUSINESS_UNITVENDOR_IDPrompt Table: SPR_SUPPLR_DIM
PROJ_ROLEPrompt Table: SPR_ROLE_DIM
SP_REQ_IDDefault Value: NEXT
SPR_SUPP_SD_TMP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: SPR_SUPPLR_DIM |
| 5 | PROJ_ROLE |
Character(15) | VARCHAR2(15) NOT NULL |
Project Role
Prompt Table: SPR_ROLE_DIM |
| 6 | SP_REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Service Request ID
Default Value: NEXT |
| 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 |
| 18 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |