SPF_WO_PGC2_VW

(SQL View)
 Index Back

sPro Fluid Approval

sPro Fluid Approval

SELECT A.BUSINESS_UNIT , A.WORK_ORDER_ID , A.JOB_TITLE , A.PROJ_ROLE , ' ' , A.ROLE_TYPE , ' ' , A.SERVICE_METHOD , A.VENDOR_ID , ' ' , A1.VMS_SUPPLIER_ID , ' ' , A.PROVIDER_CONTACT , ' ' , A.WO_CONID , ' ' , A.SP_BILL_METHOD FROM PS_SPF_WORDERREC A , PS_SPF_WORDERREC_1 A1 WHERE A.BUSINESS_UNIT = A1.BUSINESS_UNIT AND A.WORK_ORDER_ID = A1.WORK_ORDER_ID

# 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 JOB_TITLE Character(50) VARCHAR2(50) NOT NULL Job Title
4 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
5 SP_PROJ_ROLE_DESCR Character(30) VARCHAR2(30) NOT NULL sPro Fluid Approval
6 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
APR=Approver
MGR=Manager
OPR=Operator
7 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
8 SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
D=Deliverable
M=Multi Resource
R=Resource
9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
10 VENDOR_NAME1 Character(40) VARCHAR2(40) NOT NULL Vendor Name1
11 VMS_SUPPLIER_ID Character(10) VARCHAR2(10) NOT NULL VMS Supplier ID
12 SP_VMS_DESCR Character(40) VARCHAR2(40) NOT NULL sPro Fluid Approval
13 PROVIDER_CONTACT Character(15) VARCHAR2(15) NOT NULL PROVIDER CONTACT
14 SP_PROVIDER_CNTCT Character(50) VARCHAR2(50) NOT NULL sPro Fluid Approval
15 WO_CONID Character(15) VARCHAR2(15) NOT NULL Service Provider's ID assigned on work order
16 SP_WO_CONID_DESCR Character(50) VARCHAR2(50) NOT NULL sPro Fluid Approval
17 SP_BILL_METHOD Character(1) VARCHAR2(1) NOT NULL Used in Service Based Workorders to identify the billing method.
F=Fixed Amount
M=Milestone
P=Percentage
R=Rate Based