SPAT_HRA_TEO3

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	TIME_SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Sheet Unique Identifier (System Generated)
4	WORK_ORDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Order ID Prompt Table: SPA_TIME_WO2_VW
5	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
6	HISTORY_DTTM	DateTime(26)	TIMESTAMP	History Date/Time Default Value: %datetime
7	DATE_UNDER_RPT	Date(10)	DATE NOT NULL	Date Under Report
8	DATE_SEQ	Number(3,0)	SMALLINT NOT NULL	Date Sequence Default Value: 1
9	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code
10	SP_TIME_QTY	Signed Number(18,4)	DECIMAL(16,4) NOT NULL	Time Quantity
11	WO_RATE_EFFDT	Date(10)	DATE	WorkOrder Effective Dated Rate
12	TIME_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Time Amount
13	TIME_AMOUNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Time Amount Base Currency
14	WO_RATE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	WorkOrder Rate
15	WO_RATE_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	work order rate in the base currency
16	SP_PAY_RATE	Number(15,4)	DECIMAL(14,4) NOT NULL	pay rate
17	SP_PAY_RATE_BSE	Number(15,4)	DECIMAL(14,4) NOT NULL	pay rate in the base currency
18	SP_FIXED_COST	Number(15,4)	DECIMAL(14,4) NOT NULL	fixed costs
19	SP_FIXED_COST_BSE	Number(15,4)	DECIMAL(14,4) NOT NULL	fixed costs in the base currency
20	SP_VNDR_MARKUP	Number(15,4)	DECIMAL(14,4) NOT NULL	vendor markup
21	SP_VNDR_MARKUP_BSE	Number(15,4)	DECIMAL(14,4) NOT NULL	vendor markup in the base currency
22	SP_3RDPARTY_MARKUP	Number(15,4)	DECIMAL(14,4) NOT NULL	third party markup amount
23	SP_3RDPTY_MKUP_BSE	Number(15,4)	DECIMAL(14,4) NOT NULL	third party markup amount in the base currency
24	SP_3RDPARTY_VNDR	Character(40)	VARCHAR2(40) NOT NULL	the name of the 3rd party vendor used when bidding, part of the rate breakdown feature
25	SHIFT_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Shift Percent
26	ASSIGNMENT_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Assignment Percent
27	SPB_SHIFT_RT	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Shift Rate
28	SPB_SHIFT_RT_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Shift Rate Base
29	ASSIGNMENT_RT	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Assignment Rate
30	ASSIGNMENT_RT_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Assignment Rate Base
31	SP_PAY_RATE_SHFT	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Pay rate for shifts
32	SP_PAY_RATE_S_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	pay rate for shifts in the base currency
33	SP_PAY_RATE_ASSIGN	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Pay rate for assignments
34	SP_PAY_RATE_A_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	pay rate for assignments in the base currency
35	SP_FIXED_COST_SHFT	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	fixed costs for shifts
36	SP_FIXD_COST_S_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	fixed costs for shifts in the base currency
37	SP_FIXED_COST_ASGN	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	fixed costs for assignments
38	SP_FIXD_COST_A_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	fixed costs for assignments in the base currency
39	SP_VNDR_MARKUP_SHF	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	vendor markup for shifts
40	SP_VND_MRKUP_S_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	vendor markup for shifts in the base currency
41	SP_VNDR_MARKUP_ASN	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	vendor markup for assignments
42	SP_VND_MRKUP_A_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	vendor markup for assignments in the base currency
43	SP_3RDPRTY_MRKUP_S	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	third party markup amount for shifts
44	SP_3PTY_MKUP_S_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	third party markup amount for shifts in the base currency
45	SP_3RDPRTY_MRKUP_A	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	third party markup amount for assignments
46	SP_3PTY_MKUP_A_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	third party markup amount for assignments in the base currency
47	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.
48	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
49	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
50	SP_MSP_FEE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Managed Service Provider Fee
51	SP_MSP_FEE_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Managed Service Provider Fee (Base Currency)
52	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
53	MS_RATE_BSE	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
54	SP_MSP_PERCENT	Number(6,2)	DECIMAL(5,2) NOT NULL	MSP percent
55	SPA_INCR_PAYOUT	Character(1)	VARCHAR2(1) NOT NULL	Incremental Payout
56	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
57	CURRENCY_CD_SHFT	Character(3)	VARCHAR2(3) NOT NULL	Shift Currency
58	CURRENCY_CD_ASGN	Character(3)	VARCHAR2(3) NOT NULL	Assignment Currency
59	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
60	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code