FO_WC_PREMIUM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
3	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
4	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
5	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project/Grant
6	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
7	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
8	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
9	FO_WC_RATE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	For Pay/Bill GL WC Rate Type H=Per Hour P=Percentage
10	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
11	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
12	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
13	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
14	WORKED_HOURS	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Worked hours
15	EARNINGS	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Earnings
16	FO_COMP_EARNS	Number(18,2)	DECIMAL(17,2) NOT NULL	FO COMP EARNS
17	FO_WC_CODE	Character(4)	VARCHAR2(4) NOT NULL	Workers Comp Code
18	FO_MONO_STATE	Character(1)	VARCHAR2(1) NOT NULL	For Pay/Bill Monopolistic State
19	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	General Ledger Unit
20	FO_PREMIUM_AMT	Signed Number(22,5)	DECIMAL(20,5) NOT NULL	FO_PREMIUM_AMT
21	FO_WC_BASE_RT	Number(9,5)	DECIMAL(8,5) NOT NULL	For Pay/Bill GL WC Base rate
22	FO_WC_MOD	Number(7,3)	DECIMAL(6,3) NOT NULL	For Pay/Bill GL WC
23	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product
24	FO_GL_WC_EXP	Character(10)	VARCHAR2(10) NOT NULL	For Pay/Bill GL WC
25	FO_GL_WC_LIAB	Character(10)	VARCHAR2(10) NOT NULL	For Pay/Bill GL WC
26	FO_WC_JOBCODE_DESC	Character(30)	VARCHAR2(30) NOT NULL	FO_WC_JOBCODE_DESCR
27	FO_WC_CODE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	FO_WC_CODE_DESCR
28	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
29	BUSINESS_UNIT_HR	Character(5)	VARCHAR2(5) NOT NULL	Business Unit for HRMS