SPF_WO_VW(SQL View) |
Index Back |
|---|---|
Work Order ViewWork Order View |
| SELECT A.BUSINESS_UNIT , A.WORK_ORDER_ID , A.WO_STATUS , A.SP_WO_TYPE , A.ROLE_TYPE , A.PROJ_ROLE , A.RECRUITER , A.TEAM_ID , A.START_DATE , A.END_DATE , A.VENDOR_ID , A.WO_CONID , A.PROVIDER_CONTACT , B.VMS_SUPPLIER_ID , B.VMS_LOCATION , A.ROW_CREATE_DATE , A.SERVICE_METHOD FROM PS_SPF_WORDERREC A , PS_SPF_WORDERREC_1 B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WORK_ORDER_ID = B.WORK_ORDER_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | WORK_ORDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 3 | 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 Default Value: O |
| 4 | SP_WO_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
WorkOrder Type classified as original, extension, reassign wo
E=Extension O=Original P=Replacement R=Reassign Work Order Default Value: O |
| 5 | ROLE_TYPE | Character(6) | VARCHAR2(6) NOT NULL |
Service Type
APR=Approver MGR=Manager OPR=Operator |
| 6 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL | Project Role |
| 7 | RECRUITER | Character(15) | VARCHAR2(15) NOT NULL | Service Coordinator |
| 8 | TEAM_ID | Character(15) | VARCHAR2(15) NOT NULL | Team ID |
| 9 | START_DATE | Date(10) | DATE NOT NULL |
Start Date for Gen Standing PO
Default Value: %date |
| 10 | END_DATE | Date(10) | DATE NOT NULL |
End Date
Default Value: %date |
| 11 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
%EDITTABLE4
|
| 12 | WO_CONID | Character(15) | VARCHAR2(15) NOT NULL | Service Provider's ID assigned on work order |
| 13 | PROVIDER_CONTACT | Character(15) | VARCHAR2(15) NOT NULL |
PROVIDER CONTACT
Prompt Table:
SPM_SPLRCNT_VW
|
| 14 | VMS_SUPPLIER_ID | Character(10) | VARCHAR2(10) NOT NULL | VMS Supplier ID |
| 15 | VMS_LOCATION | Character(10) | VARCHAR2(10) NOT NULL | VMS Location - This is the Vendor Managed Service Supplier's office location |
| 16 | ROW_CREATE_DATE | DateTime(26) | TIMESTAMP | Row Creation Date Time |
| 17 | SERVICE_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Service Method
D=Deliverable M=Multi Resource R=Resource |