SPF_WORDER_VW1

(SQL View)
 Index Back

workorder view record

workorder view record

SELECT A.BUSINESS_UNIT , A.WORK_ORDER_ID , A.SP_REQ_ID , A.LINE_NBR , A.PROJECT_ID , A.DEPTID , A.WO_CONID , A.START_DATE , A.LINKEDWORDER , A.WO_CLIID ,A.ENGAGEMENT_MNGR , ' ' , A.ROW_CREATE_USER , A.WO_STATUS , A.SP_ROUTE_TO , A.SP_WO_TYPE , A.PO_ID , A.SERVICE_METHOD , A.VENDOR_ID , A.ROW_CREATE_DATE , A.END_DATE , A.JOB_TITLE , A.CURRENCY_CD , A.POAMOUNT , B.WO_RATE , A.TEAM_ID , A.RECRUITER , A.SP_MSP_PERCENT , A.SP_VNDR_INTERNAL , A.PROVIDER_CONTACT , A.SP_SURVEY_ID , A.PROJ_ROLE , A.BUSINESS_UNIT_PC , A.ROLE_TYPE , A.LOCATION , A.SP_REP_ACT_START , A.WO_NAME , C.VMS_SUPPLIER_ID , C.MS_RATE , D.NAME , E.NAME , F.OPRDEFNDESC , V.NAME1 , A.MRSC_PARENT_WOID , A.SUB_LINE , A.SP_TRACK_RESRC FROM PS_SPF_WORDERREC A , PS_SPF_WO_PAYRATE B , PS_SPF_WORDERREC_1 C , PS_SPB_PERSON_TBL D , PS_SPB_PERSON_TBL E , PSOPRDEFN F , PS_VENDOR V , PS_SET_CNTRL_GROUP S WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WORK_ORDER_ID = B.WORK_ORDER_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.WORK_ORDER_ID = C.WORK_ORDER_ID AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_SPF_WO_PAYRATE B_ED WHERE B.BUSINESS_UNIT = B_ED.BUSINESS_UNIT AND B.WORK_ORDER_ID = B_ED.WORK_ORDER_ID AND B_ED.EFFDT <= %CurrentDateIn AND B_ED.EFF_STATUS='A' ) AND D.PERSON_ID = A.WO_CONID AND E.PERSON_ID = A.PROVIDER_CONTACT AND F.OPRID = A.ROW_CREATE_USER AND V.VENDOR_ID = A.VENDOR_ID AND A.BUSINESS_UNIT = S.SETCNTRLVALUE AND S.REC_GROUP_ID = 'FS_38' AND S.SETID = V.SETID

# 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_REQ_ID Character(10) VARCHAR2(10) NOT NULL Service Request ID
4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
5 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
6 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
7 WO_CONID Character(15) VARCHAR2(15) NOT NULL Service Provider's ID assigned on work order
8 START_DATE Date(10) DATE NOT NULL Start Date for Gen Standing PO
9 LINKEDWORDER Character(15) VARCHAR2(15) NOT NULL Linked Work Order

Prompt Table: SPF_LNKWO_VW

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

Prompt Table: REQUESTOR_TBL
Set Control Field: REQUESTOR_ID

11 ENGAGEMENT_MNGR Character(30) VARCHAR2(30) NOT NULL Engagement Manager

Prompt Table: REQUESTOR_TBL

12 INVAPPROVER Character(30) VARCHAR2(30) NOT NULL Invoice Approver

Prompt Table: SPF_INVAPRVR_VW

13 ROW_CREATE_USER Character(30) VARCHAR2(30) NOT NULL Row Added By
14 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
15 SP_ROUTE_TO Character(30) VARCHAR2(30) NOT NULL WorkOrder Approver Person.
16 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
17 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
18 SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
D=Deliverable
M=Multi Resource
R=Resource
19 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
20 ROW_CREATE_DATE DateTime(26) TIMESTAMP Row Creation Date Time
21 END_DATE Date(10) DATE End Date
22 JOB_TITLE Character(50) VARCHAR2(50) NOT NULL Job Title
23 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
24 POAMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Purchase Order / Work Order Amount
25 WO_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL WorkOrder Rate
26 TEAM_ID Character(15) VARCHAR2(15) NOT NULL Team ID
27 RECRUITER Character(15) VARCHAR2(15) NOT NULL Service Coordinator
28 SP_MSP_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL MSP percent
29 SP_VNDR_INTERNAL Character(1) VARCHAR2(1) NOT NULL Vendor Internal or External type
N=N
Y=Yes
30 PROVIDER_CONTACT Character(15) VARCHAR2(15) NOT NULL PROVIDER CONTACT
31 SP_SURVEY_ID Character(18) VARCHAR2(18) NOT NULL sPro Work Order Survey Identifier
32 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
33 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
34 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
APR=Approver
MGR=Manager
OPR=Operator
35 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
36 SP_REP_ACT_START Character(1) VARCHAR2(1) NOT NULL Y/N field to indicate if the replacement action started or not
C=Assign button clicked
E=Replacment Ended
N=Replacement Not Started
S=Replacement Started
X=Replacement Cancelled
37 WO_NAME Character(30) VARCHAR2(30) NOT NULL Work Order Name
38 VMS_SUPPLIER_ID Character(10) VARCHAR2(10) NOT NULL VMS Supplier ID
39 MS_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL Rate charged by either the Vendor Managed Service (VMS) Supplier or the Managed Service Provider (MSP) organization
40 NAME50 Character(50) VARCHAR2(50) NOT NULL name field of length 50
41 NAME50_2 Character(50) VARCHAR2(50) NOT NULL name field of length 50
42 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
43 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
44 MRSC_PARENT_WOID Character(15) VARCHAR2(15) NOT NULL Multi Resource Parent WOID
45 SUB_LINE Character(1) VARCHAR2(1) NOT NULL Sub Line
N=No
Y=Yes
46 SP_TRACK_RESRC Character(1) VARCHAR2(1) NOT NULL Track Resource
B=Default From Business Unit
N=No
Y=Yes