SPF_WO_SRC_VW (SQL View)	Index Back
Work Order Record Work Order Record

SPF_WO_SRC_VW

(SQL View)

Work Order Record

SELECT A.BUSINESS_UNIT ,A.WORK_ORDER_ID ,A.SEQNBR ,A.SP_REQ_ID ,A.LINE_NBR ,A.VENDOR_ID ,A.WO_CONID ,A.WO_CLIID ,A.ENGAGEMENT_MNGR ,A.WO_RATE ,A.CURRENCY_CD ,A.START_DATE ,A.END_DATE ,' ' ,A.TE_TEMPLATE_ID ,A.PO_ID ,A.POAMOUNT ,A.COMPUNIT ,A.INVOICE_AMOUNT ,A.DEPTID ,A.LINKEDWORDER ,A.PROJ_ROLE ,A.ROLE_TYPE ,A.WO_STATUS ,A.SP_BILL_AMOUNT ,A.SP_UTILIZATION ,A.OVERTIME_PERMITTED ,A.LOCATION ,A.ACCOUNT ,A.SP_ROUTE_TO ,A.SERVICE_METHOD ,A.SP_WO_TYPE ,A.SP_BILL_METHOD ,A.SP_CUR_BILL_AMT ,A.SP_PLOG_PERCNT ,A.SP_REASSIGN_WO_DT ,A.SP_WO_PO_STATUS ,A.SP_ATTACHMENT_ID ,A.ITM_SETID ,A.CATEGORY_ID ,A.JOB_TITLE ,A.VNDR_LOC ,A.WO_EXP_RATE ,A.WO_EXP_RATE_BSE ,A.WO_EXP_RATE_UOM ,A.SPF_EXPENSE_AMT ,A.SPF_EXP_AMT_BSE ,A.CURRENCY_CD_BASE ,A.WO_RATE_BSE ,A.WOAMOUNT_BSE ,A.SP_BILL_AMOUNT_BSE ,A.SP_BILL_EXP_AMT ,A.BILL_EXP_AMT_BSE ,A.SP_CUR_BILLAMT_BSE ,A.SP_CURBIL_EXP_AMT ,A.CURBIL_EXP_AMT_BSE ,A.INVOICE_AMOUNT_BSE ,A.INV_EXP_AMT ,A.INV_EXP_AMT_BSE ,A.RATE_MULT ,A.RATE_DIV ,A.RATE_EFFDT ,A.RT_TYPE ,A.DURATION ,A.DAYS_UOM ,A.FINAL_DTTM ,A.TIME_EXP_TOL_PER ,A.PROVIDER_CONTACT ,A.SP_EXTENDED_FLG ,A.SP_MSP_PERCENT ,A.ACT_END_DT ,A.TEAM_ID ,A.RECRUITER ,A.SP_VNDR_INTERNAL ,A.FIRSTDAY_CONTAC_ID ,A.HEALTH_CONTACT_ID ,A.SP_REPORT_TO_ID ,A.SP_SAFETY_YESNO ,A.SHIFT_ID ,A.BID_ID ,A.LINE_ROW ,A.ACT_START_DT ,A.SP_REP_ACT_START ,A.SP_SURVEY_ID ,A.SP_DSTRLST_ID ,A.SP_MANDATORY_FLG ,A.SP_AUTO_SUR_FLAG ,A.SP_TRACK_RESRC ,A.SP_TIME_REPORT_OPT ,A.WO_RS_STATUS ,A.SP_TOT_LABOR_AMT ,A.TOT_LABOR_AMT_BSE ,A.WO_NAME ,A.MRSC_PARENT_WOID ,A.SUB_LINE ,C.SPA_USE_EXPENSES ,B.SP_PAY_RATE ,B.SP_FIXED_COST ,B.SP_VNDR_MARKUP ,B.SP_3RDPARTY_MARKUP ,B.UNIT_OF_MEASURE ,C.MS_RATE ,C.WO_SOURCE_STATUS ,D.SPF_JOB_DESCRLONG , C.COMPETENCY_DESC FROM PS_SPF_WORDERREC A , PS_SPF_WO_PAYRATE B ,PS_SPF_WORDERREC_1 C ,PS_SPF_WORDERREC_2 D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WORK_ORDER_ID = B.WORK_ORDER_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.WORK_ORDER_ID = C.WORK_ORDER_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.WORK_ORDER_ID = D.WORK_ORDER_ID AND %EffdtCheck(SPF_WO_PAYRATE,B,%CurrentDateIn) AND B.EFF_STATUS ='A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

2 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
Default Value: NEXT

3 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number

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

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

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

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

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

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

10 WO_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL WorkOrder Rate

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

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

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

14 INVAPPROVER Character(30) VARCHAR2(30) NOT NULL Invoice Approver

15 TE_TEMPLATE_ID Character(8) VARCHAR2(8) NOT NULL Used to define a particular type of travel, i.e. company relocation, internal travel, etc. Determines what type of expenses and expenditure limits are associated with that particular type of travel. Established in the Structure Expenses system and chosen on the header panel of cash expense sheets.

16 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

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

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

19 INVOICE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount

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

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

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

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

24 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

25 SP_BILL_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Billable Amount

26 SP_UTILIZATION Number(3,0) SMALLINT NOT NULL Utilization%
Default Value: 100

27 OVERTIME_PERMITTED Character(1) VARCHAR2(1) NOT NULL Overtime Permitted
N=No
Y=Yes
Default Value: N

28 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

29 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

30 SP_ROUTE_TO Character(30) VARCHAR2(30) NOT NULL WorkOrder Approver Person.

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

32 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

33 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

34 SP_CUR_BILL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Used to store the current billed amount with respect to Reassign WorkOrders.

35 SP_PLOG_PERCNT Number(3,0) SMALLINT NOT NULL Used to define the progress log percentage completed if workorder is service based and billing type is percentage.

36 SP_REASSIGN_WO_DT DateTime(26) TIMESTAMP To keep track of the last date against which the Service Provider books the time. Used in implementing the Reassign WorkOrder functionality.

37 SP_WO_PO_STATUS Character(1) VARCHAR2(1) NOT NULL WorkOrder- Purchase Order generation processisng status flag
C=Completed
I=In Progress
S=Submitted

38 SP_ATTACHMENT_ID Number(15,0) DECIMAL(15) NOT NULL Attachment ID

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

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

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

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

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

44 WO_EXP_RATE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Expense Rate in base currency

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

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

47 SPF_EXP_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Total expense amount for base currency

48 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

49 WO_RATE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL work order rate in the base currency

50 WOAMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL PO amount in the base currency

51 SP_BILL_AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Time and Expense amount reported in the base currency

52 SP_BILL_EXP_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Billable Expense Amount

53 BILL_EXP_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Billed Expense Amount Base

54 SP_CUR_BILLAMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Billed Amount in the Base Amount

55 SP_CURBIL_EXP_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Current Billed Expense Amount

56 CURBIL_EXP_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Current Billed Expense Amount

57 INVOICE_AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount in Base Currency

58 INV_EXP_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Expense Amount

59 INV_EXP_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Expense Amount for Base Currency

60 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

61 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

62 RATE_EFFDT Date(10) DATE Rate Effective Date

63 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

64 DURATION Number(5,0) INTEGER NOT NULL Recurrence Duration

65 DAYS_UOM Character(3) VARCHAR2(3) NOT NULL the unit of measure for days

66 FINAL_DTTM DateTime(26) TIMESTAMP Finalize Date and Time

67 TIME_EXP_TOL_PER Number(3,0) SMALLINT NOT NULL Time & Expense Tolerance Percent

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

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

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

71 ACT_END_DT Date(10) DATE Activity End Date

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

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

74 SP_VNDR_INTERNAL Character(1) VARCHAR2(1) NOT NULL Vendor Internal or External type
N=N
Y=Yes
Default Value: N

75 FIRSTDAY_CONTAC_ID Character(15) VARCHAR2(15) NOT NULL Person ID - first day contact -

76 HEALTH_CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Person ID - Health and Safety contact -

77 SP_REPORT_TO_ID Character(15) VARCHAR2(15) NOT NULL Person ID - Report-to person

78 SP_SAFETY_YESNO Character(1) VARCHAR2(1) NOT NULL Safety equipment required?
Y/N Table Edit

79 SHIFT_ID Character(10) VARCHAR2(10) NOT NULL Shift ID

80 BID_ID Number(10,0) DECIMAL(10) NOT NULL Bid Id

81 LINE_ROW Number(5,0) INTEGER NOT NULL Line Row

82 ACT_START_DT Date(10) DATE Activity Start Date

83 SP_REP_ACT_START Character(1) VARCHAR2(1) NOT NULL Y/N field to indicate if the replacement action started or not
C=Assign button clicked
E=Replacment Ended
N=Replacement Not Started
S=Replacement Started
X=Replacement Cancelled
Default Value: N

84 SP_SURVEY_ID Character(18) VARCHAR2(18) NOT NULL sPro Work Order Survey Identifier

85 SP_DSTRLST_ID Character(18) VARCHAR2(18) NOT NULL Distribution List ID

86 SP_MANDATORY_FLG Character(1) VARCHAR2(1) NOT NULL Survey is mandatory for work order flag
N=No
Y=Yes
Default Value: N

87 SP_AUTO_SUR_FLAG Character(1) VARCHAR2(1) NOT NULL Automatically send Survey to distribution list role actions
N=No
Y=Yes
Default Value: N

88 SP_TRACK_RESRC Character(1) VARCHAR2(1) NOT NULL Track Resource
B=Default From Business Unit
N=No
Y=Yes
Default Value: N

89 SP_TIME_REPORT_OPT Character(1) VARCHAR2(1) NOT NULL Time Reporting Option
A=Actual Allocation
D=Default from Business Unit
P=Percent Allocation

90 WO_RS_STATUS Character(1) VARCHAR2(1) NOT NULL WorkOrder Response Status
P=Published
S=Submitted

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

92 TOT_LABOR_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Labout Amount

93 WO_NAME Character(30) VARCHAR2(30) NOT NULL Work Order Name

94 MRSC_PARENT_WOID Character(15) VARCHAR2(15) NOT NULL Multi Resource Parent WOID

95 SUB_LINE Character(1) VARCHAR2(1) NOT NULL Sub Line
N=No
Y=Yes
Default Value: N

96 SPA_USE_EXPENSES Character(1) VARCHAR2(1) NOT NULL Field to indicate if the expenses is allowed in the transcation or not.
D=Default from Business Unit
N=No
Y=Yes

97 SP_PAY_RATE Number(15,4) DECIMAL(14,4) NOT NULL pay rate

98 SP_FIXED_COST Number(15,4) DECIMAL(14,4) NOT NULL fixed costs

99 SP_VNDR_MARKUP Number(15,4) DECIMAL(14,4) NOT NULL vendor markup

100 SP_3RDPARTY_MARKUP Number(15,4) DECIMAL(14,4) NOT NULL third party markup amount

101 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

102 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

103 WO_SOURCE_STATUS Character(1) VARCHAR2(1) NOT NULL Work Order Sourcing Status
C=Closed
F=Filled
I=Sourcing Initiated
N=New
R=Ready for Sourcing
S=Sourced
X=Cancel

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

105 COMPETENCY_DESC Long Character CLOB Competencies Required

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
2	WORK_ORDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Order ID Default Value: NEXT
3	SEQNBR	Number(5,0)	INTEGER NOT NULL	Sequence Number
4	SP_REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Request ID
5	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
6	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
7	WO_CONID	Character(15)	VARCHAR2(15) NOT NULL	Service Provider's ID assigned on work order
8	WO_CLIID	Character(30)	VARCHAR2(30) NOT NULL	Requester
9	ENGAGEMENT_MNGR	Character(30)	VARCHAR2(30) NOT NULL	Engagement Manager
10	WO_RATE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	WorkOrder Rate
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	START_DATE	Date(10)	DATE NOT NULL	Start Date for Gen Standing PO Default Value: %date
13	END_DATE	Date(10)	DATE NOT NULL	End Date Default Value: %date
14	INVAPPROVER	Character(30)	VARCHAR2(30) NOT NULL	Invoice Approver
15	TE_TEMPLATE_ID	Character(8)	VARCHAR2(8) NOT NULL	Used to define a particular type of travel, i.e. company relocation, internal travel, etc. Determines what type of expenses and expenditure limits are associated with that particular type of travel. Established in the Structure Expenses system and chosen on the header panel of cash expense sheets.
16	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
17	POAMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Purchase Order / Work Order Amount
18	COMPUNIT	Character(3)	VARCHAR2(3) NOT NULL	Unit of Measure
19	INVOICE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
20	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
21	LINKEDWORDER	Character(15)	VARCHAR2(15) NOT NULL	Linked Work Order
22	PROJ_ROLE	Character(15)	VARCHAR2(15) NOT NULL	Project Role
23	ROLE_TYPE	Character(6)	VARCHAR2(6) NOT NULL	Service Type APR=Approver MGR=Manager OPR=Operator
24	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
25	SP_BILL_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Billable Amount
26	SP_UTILIZATION	Number(3,0)	SMALLINT NOT NULL	Utilization% Default Value: 100
27	OVERTIME_PERMITTED	Character(1)	VARCHAR2(1) NOT NULL	Overtime Permitted N=No Y=Yes Default Value: N
28	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
29	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
30	SP_ROUTE_TO	Character(30)	VARCHAR2(30) NOT NULL	WorkOrder Approver Person.
31	SERVICE_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Service Method D=Deliverable M=Multi Resource R=Resource
32	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
33	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
34	SP_CUR_BILL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Used to store the current billed amount with respect to Reassign WorkOrders.
35	SP_PLOG_PERCNT	Number(3,0)	SMALLINT NOT NULL	Used to define the progress log percentage completed if workorder is service based and billing type is percentage.
36	SP_REASSIGN_WO_DT	DateTime(26)	TIMESTAMP	To keep track of the last date against which the Service Provider books the time. Used in implementing the Reassign WorkOrder functionality.
37	SP_WO_PO_STATUS	Character(1)	VARCHAR2(1) NOT NULL	WorkOrder- Purchase Order generation processisng status flag C=Completed I=In Progress S=Submitted
38	SP_ATTACHMENT_ID	Number(15,0)	DECIMAL(15) NOT NULL	Attachment ID
39	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID
40	CATEGORY_ID	Character(5)	VARCHAR2(5) NOT NULL	Category ID
41	JOB_TITLE	Character(50)	VARCHAR2(50) NOT NULL	Job Title
42	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
43	WO_EXP_RATE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Expense Rate
44	WO_EXP_RATE_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Expense Rate in base currency
45	WO_EXP_RATE_UOM	Character(3)	VARCHAR2(3) NOT NULL	Expense Rate UOM
46	SPF_EXPENSE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total expense amount.
47	SPF_EXP_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total expense amount for base currency
48	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
49	WO_RATE_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	work order rate in the base currency
50	WOAMOUNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	PO amount in the base currency
51	SP_BILL_AMOUNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Time and Expense amount reported in the base currency
52	SP_BILL_EXP_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Billable Expense Amount
53	BILL_EXP_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Billed Expense Amount Base
54	SP_CUR_BILLAMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Billed Amount in the Base Amount
55	SP_CURBIL_EXP_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Current Billed Expense Amount
56	CURBIL_EXP_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Current Billed Expense Amount
57	INVOICE_AMOUNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount in Base Currency
58	INV_EXP_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Expense Amount
59	INV_EXP_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Expense Amount for Base Currency
60	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
61	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
62	RATE_EFFDT	Date(10)	DATE	Rate Effective Date
63	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
64	DURATION	Number(5,0)	INTEGER NOT NULL	Recurrence Duration
65	DAYS_UOM	Character(3)	VARCHAR2(3) NOT NULL	the unit of measure for days
66	FINAL_DTTM	DateTime(26)	TIMESTAMP	Finalize Date and Time
67	TIME_EXP_TOL_PER	Number(3,0)	SMALLINT NOT NULL	Time & Expense Tolerance Percent
68	PROVIDER_CONTACT	Character(15)	VARCHAR2(15) NOT NULL	PROVIDER CONTACT
69	SP_EXTENDED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Requisition has been extended.
70	SP_MSP_PERCENT	Number(6,2)	DECIMAL(5,2) NOT NULL	MSP percent
71	ACT_END_DT	Date(10)	DATE	Activity End Date
72	TEAM_ID	Character(15)	VARCHAR2(15) NOT NULL	Team ID
73	RECRUITER	Character(15)	VARCHAR2(15) NOT NULL	Service Coordinator
74	SP_VNDR_INTERNAL	Character(1)	VARCHAR2(1) NOT NULL	Vendor Internal or External type N=N Y=Yes Default Value: N
75	FIRSTDAY_CONTAC_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID - first day contact -
76	HEALTH_CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID - Health and Safety contact -
77	SP_REPORT_TO_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID - Report-to person
78	SP_SAFETY_YESNO	Character(1)	VARCHAR2(1) NOT NULL	Safety equipment required? Y/N Table Edit
79	SHIFT_ID	Character(10)	VARCHAR2(10) NOT NULL	Shift ID
80	BID_ID	Number(10,0)	DECIMAL(10) NOT NULL	Bid Id
81	LINE_ROW	Number(5,0)	INTEGER NOT NULL	Line Row
82	ACT_START_DT	Date(10)	DATE	Activity Start Date
83	SP_REP_ACT_START	Character(1)	VARCHAR2(1) NOT NULL	Y/N field to indicate if the replacement action started or not C=Assign button clicked E=Replacment Ended N=Replacement Not Started S=Replacement Started X=Replacement Cancelled Default Value: N
84	SP_SURVEY_ID	Character(18)	VARCHAR2(18) NOT NULL	sPro Work Order Survey Identifier
85	SP_DSTRLST_ID	Character(18)	VARCHAR2(18) NOT NULL	Distribution List ID
86	SP_MANDATORY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Survey is mandatory for work order flag N=No Y=Yes Default Value: N
87	SP_AUTO_SUR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Automatically send Survey to distribution list role actions N=No Y=Yes Default Value: N
88	SP_TRACK_RESRC	Character(1)	VARCHAR2(1) NOT NULL	Track Resource B=Default From Business Unit N=No Y=Yes Default Value: N
89	SP_TIME_REPORT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Time Reporting Option A=Actual Allocation D=Default from Business Unit P=Percent Allocation
90	WO_RS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	WorkOrder Response Status P=Published S=Submitted
91	SP_TOT_LABOR_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Labor Amount
92	TOT_LABOR_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Labout Amount
93	WO_NAME	Character(30)	VARCHAR2(30) NOT NULL	Work Order Name
94	MRSC_PARENT_WOID	Character(15)	VARCHAR2(15) NOT NULL	Multi Resource Parent WOID
95	SUB_LINE	Character(1)	VARCHAR2(1) NOT NULL	Sub Line N=No Y=Yes Default Value: N
96	SPA_USE_EXPENSES	Character(1)	VARCHAR2(1) NOT NULL	Field to indicate if the expenses is allowed in the transcation or not. D=Default from Business Unit N=No Y=Yes
97	SP_PAY_RATE	Number(15,4)	DECIMAL(14,4) NOT NULL	pay rate
98	SP_FIXED_COST	Number(15,4)	DECIMAL(14,4) NOT NULL	fixed costs
99	SP_VNDR_MARKUP	Number(15,4)	DECIMAL(14,4) NOT NULL	vendor markup
100	SP_3RDPARTY_MARKUP	Number(15,4)	DECIMAL(14,4) NOT NULL	third party markup amount
101	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
102	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
103	WO_SOURCE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Work Order Sourcing Status C=Closed F=Filled I=Sourcing Initiated N=New R=Ready for Sourcing S=Sourced X=Cancel
104	SPF_JOB_DESCRLONG	Long Character	CLOB	stores the job description for a sp requisition.
105	COMPETENCY_DESC	Long Character	CLOB	Competencies Required