SPF_WO_REQLN_VW

(SQL View)
 Index Back

WorkOrder Replacement View

WorkOrder Requisition line related Replacement View

SELECT A.BUSINESS_UNIT , A.SP_REQ_ID , A.LINE_NBR , A.WORK_ORDER_ID , A.VENDOR_ID , A.WO_CONID , A.CURRENCY_CD , B.WO_RATE , A.POAMOUNT , A.START_DATE , A.END_DATE , A.ACT_START_DT , A.ACT_END_DT , A.BUSINESS_UNIT_PC , A.PROJECT_ID , A.ROLE_TYPE , A.LOCATION , A.DEPTID , A.PROJ_ROLE , A.WO_CLIID , A.COMPUNIT , A.SP_MSP_PERCENT , A.JOB_TITLE , A.SERVICE_METHOD , A.WO_CLIID FROM PS_SPF_WORDERREC A , PS_SPF_WO_PAYRATE B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WORK_ORDER_ID = B.WORK_ORDER_ID AND A.SERVICE_METHOD = 'R' AND (A.WO_STATUS <> 'C' OR A.WO_STATUS <> 'N' OR A.WO_STATUS <> 'T') 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 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
6 WO_CONID Character(15) VARCHAR2(15) NOT NULL Service Provider's ID assigned on work order
7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
8 WO_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL WorkOrder Rate
9 POAMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Purchase Order / Work Order Amount
10 START_DATE Date(10) DATE Start Date for Gen Standing PO
11 END_DATE Date(10) DATE End Date
12 ACT_START_DT Date(10) DATE Activity Start Date
13 ACT_END_DT Date(10) DATE Activity End Date
14 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
15 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
16 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
APR=Approver
MGR=Manager
OPR=Operator
17 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
18 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
19 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
20 WO_CLIID Character(30) VARCHAR2(30) NOT NULL Requester
21 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
22 SP_MSP_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL MSP percent
23 JOB_TITLE Character(50) VARCHAR2(50) NOT NULL Job Title
24 SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
D=Deliverable
M=Multi Resource
R=Resource
25 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id