SPF_WO_RSRC_VW(SQL View) |
Index Back |
|---|---|
Service Provider List WO ViewView of Service Providers for Deliverable based tracked resources |
| SELECT A.BUSINESS_UNIT , A.WORK_ORDER_ID , T.PERSON_ID , A.VENDOR_ID , A.WO_CONID , ' ' , A.DEPTID , A.WO_NAME , T.START_DATE , T.END_DATE , A.WO_STATUS , A.SP_TRACK_RESRC , T.SP_PREMISE_LOC , A.ROW_CREATE_DATE , T.COMMENTS_254 , A.SERVICE_METHOD , A.MRSC_PARENT_WOID , A.ROLE_TYPE , A.PROJ_ROLE FROM PS_SPF_WORDERREC A , PS_SPF_WO_TRK_RSRC T WHERE A.SERVICE_METHOD = 'D' AND A.SP_TRACK_RESRC = 'Y' AND T.BUSINESS_UNIT = A.BUSINESS_UNIT AND T.WORK_ORDER_ID = A.WORK_ORDER_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_SP_NONVW |
| 2 | WORK_ORDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 3 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 4 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 5 | WO_CONID | Character(15) | VARCHAR2(15) NOT NULL | Service Provider's ID assigned on work order |
| 6 | NAME50 | Character(50) | VARCHAR2(50) NOT NULL | name field of length 50 |
| 7 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 8 | WO_NAME | Character(30) | VARCHAR2(30) NOT NULL | Work Order Name |
| 9 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 10 | END_DATE | Date(10) | DATE | End Date |
| 11 | WO_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Work Order Status
A=Approved C=Closed D=Denied F=Finalize L=Released N=Canceled O=Open P=Pending Terminate S=Submitted T=Terminated |
| 12 | SP_TRACK_RESRC | Character(1) | VARCHAR2(1) NOT NULL |
Track Resource
B=Default From Business Unit N=No Y=Yes |
| 13 | SP_PREMISE_LOC | Character(1) | VARCHAR2(1) NOT NULL |
Premise Location
N=No Y=Yes |
| 14 | ROW_CREATE_DATE | DateTime(26) | TIMESTAMP | Row Creation Date Time |
| 15 | COMMENTS_254 | Character(254) | VARCHAR2(254) NOT NULL | EDI Comments |
| 16 | SERVICE_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Service Method
D=Deliverable M=Multi Resource R=Resource |
| 17 | MRSC_PARENT_WOID | Character(15) | VARCHAR2(15) NOT NULL | Multi Resource Parent WOID |
| 18 | ROLE_TYPE | Character(6) | VARCHAR2(6) NOT NULL |
Service Type
APR=Approver MGR=Manager OPR=Operator |
| 19 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL | Project Role |