SPF_WO_SUR_SRVW (SQL View)	Index Back
Work Order Survey Search View Used to return Work Orders that have surveys taken from the Work Order Survey User table entries

SPF_WO_SUR_SRVW

(SQL View)

Work Order Survey Search View

Used to return Work Orders that have surveys taken from the Work Order Survey User table entries

SELECT DISTINCT A.BUSINESS_UNIT , A.WORK_ORDER_ID , B.WO_STATUS , A.SP_SURVEY_ID FROM PS_SPF_WO_SUR_USR A , PS_SPF_WORDERREC B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.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
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_SP_NONVW
Set Control Field: BUSINESS_UNIT

2 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
Prompt Table: SPF_WO_SUR_VW

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

4 SP_SURVEY_ID Character(18) VARCHAR2(18) NOT NULL sPro Work Order Survey Identifier
Prompt Table: SP_SUR_NODF_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_SP_NONVW Set Control Field: BUSINESS_UNIT
2	WORK_ORDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Order ID Prompt Table: SPF_WO_SUR_VW
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
4	SP_SURVEY_ID	Character(18)	VARCHAR2(18) NOT NULL	sPro Work Order Survey Identifier Prompt Table: SP_SUR_NODF_VW