SPF_WO_MAP_VW (SQL View)	Index Back
Approve Work Order User View Approve Work Order User View

SPF_WO_MAP_VW

(SQL View)

Approve Work Order User View

SELECT B.BUSINESS_UNIT , B.WORK_ORDER_ID , B.WO_NAME , B2.SPF_JOB_DESCRLONG , B.POAMOUNT , B.SP_TOT_LABOR_AMT , B.SP_TOT_LABOR_AMT , B.SPF_EXPENSE_AMT , B.WO_RATE , B.WO_EXP_RATE , B1.MS_RATE , 0 , B.SP_MSP_PERCENT , B.COMPUNIT , B.WO_EXP_RATE_UOM , B.CURRENCY_CD , B.SERVICE_METHOD , B.SP_BILL_METHOD , B.WO_STATUS , B.SP_WO_TYPE , B.ENGAGEMENT_MNGR , B.SP_REQ_ID , B.LINE_NBR , B.LINKEDWORDER , B.ITM_SETID , B.CATEGORY_ID , B.JOB_TITLE , B.VNDR_LOC , B.PROVIDER_CONTACT , B.WO_CONID , B.WO_CLIID , B.VENDOR_ID , B1.VMS_SUPPLIER_ID , B.PROJ_ROLE , B.ROLE_TYPE , B.SP_EXTENDED_FLG , B.ACT_START_DT , B.ROW_MODIFY_DATE , B.ROW_CREATE_DATE , B.DEPTID , B.START_DATE , B.END_DATE , B1.REG_REGION , B1.COMPANY , B1.BUSINESS_UNIT_HR , B1.JOBCODE , B1.ESTABID , B1.LABOR_AGREEMENT , B1.SP_HCM_DEFLT_ADMIN , U.EOAWSTEP_STATUS , U.OPRID , U.EOAWORIG_OPRID , %DatePart(U.EOAWDTTM_MODIFIED) , S.EOAWTHREAD_ID , X.EOAWTHREAD_STATUS , U.EOAWDTTM_COMPLETE , X.EOAWREQUESTOR_ID , X.EOAWDTTM_MODIFIED , S.EOAWPRCS_ID , S.EOAWDEFN_ID , S.EFFDT , S.EOAWSTEP_NBR , U.DTTM_CREATED , '2' FROM PS_SPF_WO_APR_XREF X , PS_SPF_WORDERREC B , PS_SPF_WORDERREC_1 B1 , PS_SPF_WORDERREC_2 B2 , PS_EOAW_STEPINST S , PS_EOAW_USERINST U WHERE B.BUSINESS_UNIT = X.BUSINESS_UNIT AND B.WORK_ORDER_ID = X.WORK_ORDER_ID AND B.BUSINESS_UNIT = B2.BUSINESS_UNIT AND B.WORK_ORDER_ID = B2.WORK_ORDER_ID AND B.BUSINESS_UNIT = B1.BUSINESS_UNIT AND B.WORK_ORDER_ID = B1.WORK_ORDER_ID AND X.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND X.EOAWDEFN_ID = S.EOAWDEFN_ID AND S.EOAWSTEP_INSTANCE = U.EOAWSTEP_INSTANCE

# 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_NAME Character(30) VARCHAR2(30) NOT NULL Work Order Name

4 SPF_JOB_DESCRLONG Long Character CLOB stores the job description for a sp requisition.

5 POAMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Purchase Order / Work Order Amount

6 SP_TOT_LABOR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Labor Amount

7 TOT_LOAD_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Loaded Amount

8 SPF_EXPENSE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total expense amount.

9 FULLY_LOADED_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL FULLY LOADED RATE

10 WO_EXP_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL Expense Rate

11 MS_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL Rate charged by either the Vendor Managed Service (VMS) Supplier or the Managed Service Provider (MSP) organization

12 SP_MSP_FEE Signed Number(28,3) DECIMAL(26,3) NOT NULL Managed Service Provider Fee

13 SP_MSP_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL MSP percent

14 COMPUNIT Character(3) VARCHAR2(3) NOT NULL Unit of Measure

15 WO_EXP_RATE_UOM Character(3) VARCHAR2(3) NOT NULL Expense Rate UOM

16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

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

18 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

19 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

20 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

21 ENGAGEMENT_MNGR Character(30) VARCHAR2(30) NOT NULL Engagement Manager

22 SP_REQ_ID Character(10) VARCHAR2(10) NOT NULL Service Request ID

23 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

24 LINKEDWORDER Character(15) VARCHAR2(15) NOT NULL Linked Work Order

25 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID

26 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

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

28 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

29 PROVIDER_CONTACT Character(15) VARCHAR2(15) NOT NULL PROVIDER CONTACT

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

31 WO_CLIID Character(30) VARCHAR2(30) NOT NULL Requester

32 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

33 VMS_SUPPLIER_ID Character(10) VARCHAR2(10) NOT NULL VMS Supplier ID

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

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

36 SP_EXTENDED_FLG Character(1) VARCHAR2(1) NOT NULL Requisition has been extended.

37 ACT_START_DT Date(10) DATE Activity Start Date

38 ROW_MODIFY_DATE DateTime(26) TIMESTAMP Modified Date Time

39 ROW_CREATE_DATE DateTime(26) TIMESTAMP Row Creation Date Time

40 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

41 START_DATE Date(10) DATE Start Date for Gen Standing PO

42 END_DATE Date(10) DATE End Date

43 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

44 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

45 BUSINESS_UNIT_HR Character(5) VARCHAR2(5) NOT NULL Business Unit HR

46 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

47 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

48 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

49 SP_HCM_DEFLT_ADMIN Character(30) VARCHAR2(30) NOT NULL Default HCM Administrator

50 EOAWSTEP_STATUS Character(1) VARCHAR2(1) NOT NULL Step Instance Status
A=Approved
B=Pushed back
C=Auto Approved
D=Denied
E=Administrator denied
F=Deleted
G=Bypassed
H=On Hold
I=No Action Taken
K=Skipped
L=Terminated
M=Administrator approved
N=Not Active
P=Pending
R=No longer in role
T=Terminated
U=Auto approved
X=Deleted
Z=Pending Denial

51 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

52 EOAWORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID

53 EOAWSTART_DT Date(10) DATE Start Date

54 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID

55 EOAWTHREAD_STATUS Character(1) VARCHAR2(1) NOT NULL Thread Status
A=Approved
C=Complete
D=Denied
E=Pending Denial
H=Hard Deny
I=Initial
N=Not Active
P=Pending
S=Awaiting Further Approvals
T=Terminated
W=Canceled
X=Suspended/Pending Denial

56 EOAWDTTM_COMPLETE DateTime(26) TIMESTAMP Date/Time Completed

57 EOAWREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

58 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified

59 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID

60 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID

61 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

62 EOAWSTEP_NBR Number(6,2) DECIMAL(5,2) NOT NULL Sequence number of step in its path

63 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created

64 PRIORITY_FLG Character(1) VARCHAR2(1) NOT NULL Priority Flag
1=High
2=Medium
3=Low

#	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_NAME	Character(30)	VARCHAR2(30) NOT NULL	Work Order Name
4	SPF_JOB_DESCRLONG	Long Character	CLOB	stores the job description for a sp requisition.
5	POAMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Purchase Order / Work Order Amount
6	SP_TOT_LABOR_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Labor Amount
7	TOT_LOAD_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Loaded Amount
8	SPF_EXPENSE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total expense amount.
9	FULLY_LOADED_RATE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	FULLY LOADED RATE
10	WO_EXP_RATE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Expense Rate
11	MS_RATE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Rate charged by either the Vendor Managed Service (VMS) Supplier or the Managed Service Provider (MSP) organization
12	SP_MSP_FEE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Managed Service Provider Fee
13	SP_MSP_PERCENT	Number(6,2)	DECIMAL(5,2) NOT NULL	MSP percent
14	COMPUNIT	Character(3)	VARCHAR2(3) NOT NULL	Unit of Measure
15	WO_EXP_RATE_UOM	Character(3)	VARCHAR2(3) NOT NULL	Expense Rate UOM
16	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
17	SERVICE_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Service Method D=Deliverable M=Multi Resource R=Resource
18	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
19	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
20	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
21	ENGAGEMENT_MNGR	Character(30)	VARCHAR2(30) NOT NULL	Engagement Manager
22	SP_REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Request ID
23	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
24	LINKEDWORDER	Character(15)	VARCHAR2(15) NOT NULL	Linked Work Order
25	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID
26	CATEGORY_ID	Character(5)	VARCHAR2(5) NOT NULL	Category ID
27	JOB_TITLE	Character(50)	VARCHAR2(50) NOT NULL	Job Title
28	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
29	PROVIDER_CONTACT	Character(15)	VARCHAR2(15) NOT NULL	PROVIDER CONTACT
30	WO_CONID	Character(15)	VARCHAR2(15) NOT NULL	Service Provider's ID assigned on work order
31	WO_CLIID	Character(30)	VARCHAR2(30) NOT NULL	Requester
32	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
33	VMS_SUPPLIER_ID	Character(10)	VARCHAR2(10) NOT NULL	VMS Supplier ID
34	PROJ_ROLE	Character(15)	VARCHAR2(15) NOT NULL	Project Role
35	ROLE_TYPE	Character(6)	VARCHAR2(6) NOT NULL	Service Type APR=Approver MGR=Manager OPR=Operator
36	SP_EXTENDED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Requisition has been extended.
37	ACT_START_DT	Date(10)	DATE	Activity Start Date
38	ROW_MODIFY_DATE	DateTime(26)	TIMESTAMP	Modified Date Time
39	ROW_CREATE_DATE	DateTime(26)	TIMESTAMP	Row Creation Date Time
40	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
41	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
42	END_DATE	Date(10)	DATE	End Date
43	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
44	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
45	BUSINESS_UNIT_HR	Character(5)	VARCHAR2(5) NOT NULL	Business Unit HR
46	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
47	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
48	LABOR_AGREEMENT	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement
49	SP_HCM_DEFLT_ADMIN	Character(30)	VARCHAR2(30) NOT NULL	Default HCM Administrator
50	EOAWSTEP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Step Instance Status A=Approved B=Pushed back C=Auto Approved D=Denied E=Administrator denied F=Deleted G=Bypassed H=On Hold I=No Action Taken K=Skipped L=Terminated M=Administrator approved N=Not Active P=Pending R=No longer in role T=Terminated U=Auto approved X=Deleted Z=Pending Denial
51	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
52	EOAWORIG_OPRID	Character(30)	VARCHAR2(30) NOT NULL	User ID
53	EOAWSTART_DT	Date(10)	DATE	Start Date
54	EOAWTHREAD_ID	Number(15,0)	DECIMAL(15) NOT NULL	Approval Framework Thread ID
55	EOAWTHREAD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Thread Status A=Approved C=Complete D=Denied E=Pending Denial H=Hard Deny I=Initial N=Not Active P=Pending S=Awaiting Further Approvals T=Terminated W=Canceled X=Suspended/Pending Denial
56	EOAWDTTM_COMPLETE	DateTime(26)	TIMESTAMP	Date/Time Completed
57	EOAWREQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id
58	EOAWDTTM_MODIFIED	DateTime(26)	TIMESTAMP	Datetime modified
59	EOAWPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID
60	EOAWDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Framework Definition ID
61	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
62	EOAWSTEP_NBR	Number(6,2)	DECIMAL(5,2) NOT NULL	Sequence number of step in its path
63	DTTM_CREATED	DateTime(26)	TIMESTAMP	Datetime Created
64	PRIORITY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Priority Flag 1=High 2=Medium 3=Low