INS_EARNS_BAL (SQL Table)	Index Back
EE CAN UI Insurable Earns This record is created during payroll processing and tracks Canadian unemployment insurable earnings balances and related information for an employee by company, wage loss plan, UI period, and earnings end date.

INS_EARNS_BAL

(SQL Table)

EE CAN UI Insurable Earns

This record is created during payroll processing and tracks Canadian unemployment insurable earnings balances and related information for an employee by company, wage loss plan, UI period, and earnings end date.

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

3 WAGE_LOSS_PLAN Character(3) VARCHAR2(3) NOT NULL Wage Loss Replacement Plan
Prompt Table: WAGELS_PLAN_TBL

4 UI_PERIOD_DT Date(10) DATE NOT NULL EI Period Date

5 EARNS_END_DT Date(10) DATE NOT NULL Earnings End Date

6 UI_PERIODS_PER_YR Number(2,0) SMALLINT NOT NULL EI Pay Periods Per Year

7 UI_CALC_SEQ Number(3,0) SMALLINT NOT NULL EI Calculation Sequence

8 UI_USE_WKLY Character(1) VARCHAR2(1) NOT NULL EI Use Weekly Values
Y/N Table Edit

9 UI_EARNS_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL EI Current Earnings

10 UI_EQUIV_WEEKS_CUR Signed Number(6,2) DECIMAL(4,2) NOT NULL EI Current Equivalent Weeks

11 UI_EE_PREMIUM_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL EI Curr EE Prem

12 UI_ER_RT Number(6,4) DECIMAL(5,4) NOT NULL EI Employer Rate

13 UI_WKLY_EARNS Signed Number(12,2) DECIMAL(10,2) NOT NULL EI Weekly Earnings(No Limit)

14 UI_WKLY_HOURS Signed Number(7,2) DECIMAL(5,2) NOT NULL EI Weekly Hours

15 ROE_NBR Character(8) VARCHAR2(8) NOT NULL Internal ROE Number

16 INS_EARNS_AMENDED Character(1) VARCHAR2(1) NOT NULL Insurable Earnings Amended
A=Amended
N=Not Applicable
R=Amended and Reported

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
3	WAGE_LOSS_PLAN	Character(3)	VARCHAR2(3) NOT NULL	Wage Loss Replacement Plan Prompt Table: WAGELS_PLAN_TBL
4	UI_PERIOD_DT	Date(10)	DATE NOT NULL	EI Period Date
5	EARNS_END_DT	Date(10)	DATE NOT NULL	Earnings End Date
6	UI_PERIODS_PER_YR	Number(2,0)	SMALLINT NOT NULL	EI Pay Periods Per Year
7	UI_CALC_SEQ	Number(3,0)	SMALLINT NOT NULL	EI Calculation Sequence
8	UI_USE_WKLY	Character(1)	VARCHAR2(1) NOT NULL	EI Use Weekly Values Y/N Table Edit
9	UI_EARNS_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	EI Current Earnings
10	UI_EQUIV_WEEKS_CUR	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	EI Current Equivalent Weeks
11	UI_EE_PREMIUM_CUR	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	EI Curr EE Prem
12	UI_ER_RT	Number(6,4)	DECIMAL(5,4) NOT NULL	EI Employer Rate
13	UI_WKLY_EARNS	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	EI Weekly Earnings(No Limit)
14	UI_WKLY_HOURS	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	EI Weekly Hours
15	ROE_NBR	Character(8)	VARCHAR2(8) NOT NULL	Internal ROE Number
16	INS_EARNS_AMENDED	Character(1)	VARCHAR2(1) NOT NULL	Insurable Earnings Amended A=Amended N=Not Applicable R=Amended and Reported