SPF_WOREC_VW (SQL View)	Index Back
Work Order View Work Order View

SPF_WOREC_VW

(SQL View)

Work Order View

SELECT A.BUSINESS_UNIT , A.WORK_ORDER_ID , A.WO_STATUS , A.SP_WO_TYPE , A.ROLE_TYPE , A.PROJ_ROLE , A.JOB_TITLE , A.RECRUITER , A.TEAM_ID , A.START_DATE , A.END_DATE , A.VENDOR_ID , A.WO_CONID , A.PROVIDER_CONTACT , A.ROW_CREATE_DATE , A.SERVICE_METHOD FROM PS_SPF_WORDERREC A

# 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 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
Default Value: O

4 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
Default Value: O

5 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
APR=Approver
MGR=Manager
OPR=Operator

6 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

7 JOB_TITLE Character(50) VARCHAR2(50) NOT NULL Job Title

8 RECRUITER Character(15) VARCHAR2(15) NOT NULL Service Coordinator

9 TEAM_ID Character(15) VARCHAR2(15) NOT NULL Team ID

10 START_DATE Date(10) DATE NOT NULL Start Date for Gen Standing PO
Default Value: %date

11 END_DATE Date(10) DATE NOT NULL End Date
Default Value: %date

12 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Prompt Table: %EDITTABLE4
Set Control Field: BUSINESS_UNIT

13 WO_CONID Character(15) VARCHAR2(15) NOT NULL Service Provider's ID assigned on work order

14 PROVIDER_CONTACT Character(15) VARCHAR2(15) NOT NULL PROVIDER CONTACT
Prompt Table: SPM_SPLRCNT_VW
Set Control Field: BUSINESS_UNIT

15 ROW_CREATE_DATE DateTime(26) TIMESTAMP Row Creation Date Time

16 SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
D=Deliverable
M=Multi Resource
R=Resource

#	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	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 Default Value: O
4	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 Default Value: O
5	ROLE_TYPE	Character(6)	VARCHAR2(6) NOT NULL	Service Type APR=Approver MGR=Manager OPR=Operator
6	PROJ_ROLE	Character(15)	VARCHAR2(15) NOT NULL	Project Role
7	JOB_TITLE	Character(50)	VARCHAR2(50) NOT NULL	Job Title
8	RECRUITER	Character(15)	VARCHAR2(15) NOT NULL	Service Coordinator
9	TEAM_ID	Character(15)	VARCHAR2(15) NOT NULL	Team ID
10	START_DATE	Date(10)	DATE NOT NULL	Start Date for Gen Standing PO Default Value: %date
11	END_DATE	Date(10)	DATE NOT NULL	End Date Default Value: %date
12	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: %EDITTABLE4 Set Control Field: BUSINESS_UNIT
13	WO_CONID	Character(15)	VARCHAR2(15) NOT NULL	Service Provider's ID assigned on work order
14	PROVIDER_CONTACT	Character(15)	VARCHAR2(15) NOT NULL	PROVIDER CONTACT Prompt Table: SPM_SPLRCNT_VW Set Control Field: BUSINESS_UNIT
15	ROW_CREATE_DATE	DateTime(26)	TIMESTAMP	Row Creation Date Time
16	SERVICE_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Service Method D=Deliverable M=Multi Resource R=Resource