SPF_WO_SUR_SRTV

(SQL View)
 Index Back

Work Order Survey View

Work Order Survey View

SELECT DISTINCT A.BUSINESS_UNIT , A.WORK_ORDER_ID , A.SP_SURVEY_ID , A.USERID , B.WO_CONID , B.PROVIDER_CONTACT , B.VENDOR_ID , A.SP_SUR_FILL_STATUS , B.WO_STATUS , B.WO_CLIID , B.ROW_CREATE_USER , B.ROW_CREATE_DATE , B.TEAM_ID , B.RECRUITER 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 AND B.WO_STATUS IN ('C','N','T','F') AND B.SP_SURVEY_ID <> ' ' AND A.NOTIFY_DATE IS NOT NULL

# 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

Prompt Table: SPF_WORDERREC

3 SP_SURVEY_ID Character(18) VARCHAR2(18) NOT NULL sPro Work Order Survey Identifier

Prompt Table: SP_SUR_DEFN

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

Prompt Table: PSOPRDEFN

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_USER Character(30) VARCHAR2(30) NOT NULL Row Added By
12 ROW_CREATE_DATE DateTime(26) TIMESTAMP Row Creation Date Time
13 TEAM_ID Character(15) VARCHAR2(15) NOT NULL Team ID
14 RECRUITER Character(15) VARCHAR2(15) NOT NULL Service Coordinator