SP_BUSINESS_UNITSP_REQ_IDSP_LINE_NBRSP_SPC_REQ_STATUSC=Closed
F=Filled
P=Pending
S=Sourced
BUSINESS_UNITREQ_IDLINE_NBRD=Deliverable
M=Multi Resource
R=Resource
SPF_SPC_SSR_VW(SQL View) |
Index Back |
|---|---|
Sourcing Provider contact vw |
| SELECT SP_BUSINESS_UNIT ,SP_REQ_ID ,SP_LINE_NBR ,SP_SPC_REQ_STATUS ,BUSINESS_UNIT ,REQ_ID ,LINE_NBR , VENDOR_ID ,VNDR_LOC ,CONTACT , SPC_OWNER ,SOURCE_DATE ,SUBMITAL_LIMIT ,SUBMITAL_NUMBER ,VENDOR_SETID ,RECRUITER ,PROJECT_ID , PROJ_ROLE ,ROW_CREATE_USER , SP_NUM_OF_POSITION ,SERVICE_METHOD ,MAX(SEQUENCE2) FROM PS_SPF_SPC_SR_VW GROUP BY SP_BUSINESS_UNIT , SP_REQ_ID , SP_LINE_NBR , SP_SPC_REQ_STATUS , BUSINESS_UNIT , REQ_ID , LINE_NBR , VENDOR_ID , VNDR_LOC ,CONTACT ,SPC_OWNER , SUBMITAL_LIMIT , SUBMITAL_NUMBER ,SOURCE_DATE , VENDOR_SETID , RECRUITER , PROJECT_ID , PROJ_ROLE ,SP_NUM_OF_POSITION , ROW_CREATE_USER ,ROW_CREATE_USER ,SERVICE_METHOD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SP_BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Service Procurement Business Unit |
| 2 | SP_REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL | Service Request ID |
| 3 | SP_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number field |
| 4 | SP_SPC_REQ_STATUS |
Character(4) | VARCHAR2(4) NOT NULL |
Requisition Status for Service Provider Contact
C=Closed F=Filled P=Pending S=Sourced |
| 5 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 7 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 8 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 9 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 10 | CONTACT | Character(15) | VARCHAR2(15) NOT NULL | Provider Contact |
| 11 | SPC_OWNER | Character(15) | VARCHAR2(15) NOT NULL | Owner |
| 12 | SOURCE_DATE | Date(10) | DATE | Source Date |
| 13 | SUBMITAL_LIMIT | Number(2,0) | SMALLINT NOT NULL | Submittal Limit |
| 14 | SUBMITAL_NUMBER | Number(4,0) | SMALLINT NOT NULL | Number of Times Submitted |
| 15 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 16 | RECRUITER | Character(15) | VARCHAR2(15) NOT NULL | Service Coordinator |
| 17 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 18 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL | Project Role |
| 19 | ROW_CREATE_USER | Character(30) | VARCHAR2(30) NOT NULL | Row Added By |
| 20 | SP_NUM_OF_POSITION | Number(5,0) | INTEGER NOT NULL | Number of Positions |
| 21 | SERVICE_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Service Method
D=Deliverable M=Multi Resource R=Resource |
| 22 | SEQUENCE2 | Number(6,0) | INTEGER NOT NULL | Sequence |