WRK_INS_EARNS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
3	PAY_END_DT	Date(10)	DATE NOT NULL	Pay Period End Date Prompt Table: PAY_CALENDAR
4	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ? Y/N Table Edit
5	PAGE_NUM	Number(4,0)	SMALLINT NOT NULL	Page #
6	LINE_NUM	Number(2,0)	SMALLINT NOT NULL	Line #
7	SEPCHK	Number(1,0)	SMALLINT NOT NULL	Separate check number.
8	UI_PERIOD_DT	Date(10)	DATE NOT NULL	EI Period Date
9	EARNS_END_DT	Date(10)	DATE NOT NULL	Earnings End Date
10	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
11	WAGE_LOSS_PLAN	Character(3)	VARCHAR2(3) NOT NULL	Wage Loss Replacement Plan
12	UI_PERIODS_PER_YR	Number(2,0)	SMALLINT NOT NULL	EI Pay Periods Per Year
13	UI_CALC_SEQ	Number(3,0)	SMALLINT NOT NULL	EI Calculation Sequence
14	UI_USE_WKLY	Character(1)	VARCHAR2(1) NOT NULL	EI Use Weekly Values Y/N Table Edit
15	UI_EARNS_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	EI Current Earnings
16	UI_EQUIV_WEEKS_CUR	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	EI Current Equivalent Weeks
17	UI_EE_PREMIUM_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	EI Curr EE Prem
18	UI_ER_RT	Number(6,4)	DECIMAL(5,4) NOT NULL	EI Employer Rate
19	UI_WKLY_EARNS	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	EI Weekly Earnings(No Limit)
20	UI_WKLY_HOURS	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	EI Weekly Hours
21	UI_WKLY_EARNS_CHQ	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	EI Weekly Earnings - Cheque
22	UI_WKLY_HOURS_CHQ	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	EI Weekly Hours - Cheque
23	UI_EE_PREMIUM_CHQ	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	EI Employee Premium - Cheque
24	UI_EQUIV_WEEKS_CHQ	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	EI Equivalent Weeks - Cheque