SPF_WO_PGC4_VW

(SQL View)
 Index Back

sPro Fluid Approval

sPro Fluid Approval

SELECT A.BUSINESS_UNIT , A.WORK_ORDER_ID , A.SP_REQ_ID , A.LINE_NBR , ' ' , B.REG_REGION , ' ' , B.COMPANY , ' ' , B.BUSINESS_UNIT_HR , ' ' , B.JOBCODE , ' ' , B.ESTABID , ' ' , B.LABOR_AGREEMENT , ' ' , B.SP_HCM_DEFLT_ADMIN , ' ' FROM PS_SPF_WORDERREC A , PS_SPF_WORDERREC_1 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 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 REQ_NAME Character(30) VARCHAR2(30) NOT NULL Requisition Name
6 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
7 SP_REGION_DESCR Character(50) VARCHAR2(50) NOT NULL sPro Fluid Approval
8 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
9 SP_COMPANY_DESCR Character(50) VARCHAR2(50) NOT NULL sPro Fluid Approval
10 BUSINESS_UNIT_HR Character(5) VARCHAR2(5) NOT NULL Business Unit HR
11 SP_BU_HR_DESCR Character(30) VARCHAR2(30) NOT NULL sPro Fluid Approval
12 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
13 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Jobcode Description
14 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
15 SP_ESTABID_DESCR Character(30) VARCHAR2(30) NOT NULL sPro Fluid Approval
16 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement
17 AGREEMENT Character(30) VARCHAR2(30) NOT NULL Agreement
18 SP_HCM_DEFLT_ADMIN Character(30) VARCHAR2(30) NOT NULL Default HCM Administrator
19 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user