SPF_WO_PGC1_VW

(SQL View)
Index Back

sPro Fluid Approval

sPro Fluid Approval

SELECT A.BUSINESS_UNIT , A.WORK_ORDER_ID , ' ' , A.WO_NAME , A.SP_WO_TYPE , A.START_DATE , ' ' , A.END_DATE , ' ' , A.DEPTID , ' ' , A.WO_CLIID , ' ' , A.ENGAGEMENT_MNGR , ' ' , B.SPF_JOB_DESCRLONG FROM PS_SPF_WORDERREC A , PS_SPF_WORDERREC_2 B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WORK_ORDER_ID = B.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 BU_DESCR Character(30) VARCHAR2(30) NOT NULL Business unit description.
4 WO_NAME Character(30) VARCHAR2(30) NOT NULL Work Order Name
5 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
6 START_DATE Date(10) DATE Start Date for Gen Standing PO
7 SP_START_DATE Character(30) VARCHAR2(30) NOT NULL sPro Fluid Approval
8 END_DATE Date(10) DATE End Date
9 SP_END_DATE Character(30) VARCHAR2(30) NOT NULL sPro Fluid Approval
10 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
11 DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department ID Description
12 WO_CLIID Character(30) VARCHAR2(30) NOT NULL Requester
13 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
14 ENGAGEMENT_MNGR Character(30) VARCHAR2(30) NOT NULL Engagement Manager
15 SP_ENGAGEMENT_MGR Character(30) VARCHAR2(30) NOT NULL Engagement Manager
16 SPF_JOB_DESCRLONG Long Character CLOB stores the job description for a sp requisition.