SPF_SRC_WO_VW

(SQL View)
 Index Back

workorder view record

workorder view record

SELECT A.BUSINESS_UNIT , A.SP_REQ_ID , A.LINE_NBR , A.WORK_ORDER_ID ,A.SEQNBR ,A.ROLE_TYPE ,A.BUSINESS_UNIT_PC , A.PROJECT_ID , A.DEPTID , A.WO_CONID , A.START_DATE , A.LINKEDWORDER , A.WO_CLIID , ' ' , 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 ,B.UNIT_OF_MEASURE , A.TEAM_ID , A.RECRUITER , A.SP_MSP_PERCENT , A.SP_VNDR_INTERNAL , A.PROVIDER_CONTACT , A.PROJ_ROLE ,A.SP_REP_ACT_START ,B.SP_PAY_RATE ,B.SP_FIXED_COST ,B.SP_VNDR_MARKUP ,B.SP_3RDPARTY_MARKUP ,A.SP_UTILIZATION ,C.SPA_USE_EXPENSES ,A.OVERTIME_PERMITTED ,A.LOCATION FROM PS_SPF_WORDERREC A , PS_SPF_WO_PAYRATE B ,PS_SPF_WORDERREC_1 C 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 %EffdtCheck(SPF_WO_PAYRATE,B,%CurrentDateIn) AND B.EFF_STATUS ='A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SP_REQ_ID Character(10) VARCHAR2(10) NOT NULL Service Request ID
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
5 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
6 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
APR=Approver
MGR=Manager
OPR=Operator
7 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
8 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
9 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
10 WO_CONID Character(15) VARCHAR2(15) NOT NULL Service Provider's ID assigned on work order
11 START_DATE Date(10) DATE Start Date for Gen Standing PO
12 LINKEDWORDER Character(15) VARCHAR2(15) NOT NULL Linked Work Order

Prompt Table: SPF_LNKWO_VW

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

Prompt Table: REQUESTOR_TBL
Set Control Field: REQUESTOR_ID

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

Prompt Table: SPF_INVAPRVR_VW

15 ROW_CREATE_USER Character(30) VARCHAR2(30) NOT NULL Row Added By
16 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
17 SP_ROUTE_TO Character(30) VARCHAR2(30) NOT NULL WorkOrder Approver Person.
18 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
19 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
20 SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
D=Deliverable
M=Multi Resource
R=Resource
21 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
22 ROW_CREATE_DATE DateTime(26) TIMESTAMP Row Creation Date Time
23 END_DATE Date(10) DATE End Date
24 JOB_TITLE Character(50) VARCHAR2(50) NOT NULL Job Title
25 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
26 POAMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Purchase Order / Work Order Amount
27 WO_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL WorkOrder Rate
28 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
29 TEAM_ID Character(15) VARCHAR2(15) NOT NULL Team ID
30 RECRUITER Character(15) VARCHAR2(15) NOT NULL Service Coordinator
31 SP_MSP_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL MSP percent
32 SP_VNDR_INTERNAL Character(1) VARCHAR2(1) NOT NULL Vendor Internal or External type
N=N
Y=Yes
33 PROVIDER_CONTACT Character(15) VARCHAR2(15) NOT NULL PROVIDER CONTACT
34 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
35 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
36 SP_PAY_RATE Number(15,4) DECIMAL(14,4) NOT NULL pay rate
37 SP_FIXED_COST Number(15,4) DECIMAL(14,4) NOT NULL fixed costs
38 SP_VNDR_MARKUP Number(15,4) DECIMAL(14,4) NOT NULL vendor markup
39 SP_3RDPARTY_MARKUP Number(15,4) DECIMAL(14,4) NOT NULL third party markup amount
40 SP_UTILIZATION Number(3,0) SMALLINT NOT NULL Utilization%
41 SPA_USE_EXPENSES Character(1) VARCHAR2(1) NOT NULL Field to indicate if the expenses is allowed in the transcation or not.
D=Default from Business Unit
N=No
Y=Yes
42 OVERTIME_PERMITTED Character(1) VARCHAR2(1) NOT NULL Overtime Permitted
N=No
Y=Yes
43 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code