SPF_WO_SUR_OPVW (SQL View)	Index Back
Work Order Survey Operator Vw Work Orders that are closed, cancelled, terminated or finalized that could have associated Surveys for this operator as a requester, assigned to, wo creator, approver.

SPF_WO_SUR_OPVW

(SQL View)

Work Order Survey Operator Vw

Work Orders that are closed, cancelled, terminated or finalized that could have associated Surveys for this operator as a requester, assigned to, wo creator, approver.

SELECT A.BUSINESS_UNIT , A.WORK_ORDER_ID , A.SP_SURVEY_ID , A.USERID , C.WO_CONID , C.PROVIDER_CONTACT , C.VENDOR_ID , A.SP_SUR_FILL_STATUS , C.WO_STATUS , C.WO_CLIID , C.ROW_CREATE_DATE , C.ROW_CREATE_USER , C.SP_ROUTE_TO FROM PS_SPF_WO_SUR_USR A , PS_SPF_WORDERREC C WHERE C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.WORK_ORDER_ID = A.WORK_ORDER_ID AND (C.WO_CLIID = %OperatorId OR C.ROW_CREATE_USER = %OperatorId OR (C.SP_ROUTE_TO = %OperatorId AND C.WO_STATUS IN ('S')) OR A.WORK_ORDER_ID IN ( SELECT B.WORK_ORDER_ID FROM PS_SPF_TASK_CHKLST B WHERE B.ASSIGNED_TO = %OperatorId AND 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 SP_SURVEY_ID Character(18) VARCHAR2(18) NOT NULL sPro Work Order Survey Identifier

4 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

5 WO_CONID Character(15) VARCHAR2(15) NOT NULL Service Provider's ID assigned on work order

6 PROVIDER_CONTACT Character(15) VARCHAR2(15) NOT NULL PROVIDER CONTACT

7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

8 SP_SUR_FILL_STATUS Character(1) VARCHAR2(1) NOT NULL Survey Completion Status
C=Cancelled
D=Completed
I=In Process
N=Not Started

9 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

10 WO_CLIID Character(30) VARCHAR2(30) NOT NULL Requester

11 ROW_CREATE_DATE DateTime(26) TIMESTAMP Row Creation Date Time

12 ROW_CREATE_USER Character(30) VARCHAR2(30) NOT NULL Row Added By

13 SP_ROUTE_TO Character(30) VARCHAR2(30) NOT NULL WorkOrder Approver Person.

#	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	SP_SURVEY_ID	Character(18)	VARCHAR2(18) NOT NULL	sPro Work Order Survey Identifier
4	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
5	WO_CONID	Character(15)	VARCHAR2(15) NOT NULL	Service Provider's ID assigned on work order
6	PROVIDER_CONTACT	Character(15)	VARCHAR2(15) NOT NULL	PROVIDER CONTACT
7	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
8	SP_SUR_FILL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Survey Completion Status C=Cancelled D=Completed I=In Process N=Not Started
9	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
10	WO_CLIID	Character(30)	VARCHAR2(30) NOT NULL	Requester
11	ROW_CREATE_DATE	DateTime(26)	TIMESTAMP	Row Creation Date Time
12	ROW_CREATE_USER	Character(30)	VARCHAR2(30) NOT NULL	Row Added By
13	SP_ROUTE_TO	Character(30)	VARCHAR2(30) NOT NULL	WorkOrder Approver Person.