CAN_ERN_BAL_VW (SQL View)	Index Back
EE CAN ERN Bal -Vw This record is a view of the CAN_ERN_BALANCE table and provides data to the level 1 scroll on the CAN Earnings Balance Adjustment and CAN Special Earnings Adjustment Inquiry panels.

CAN_ERN_BAL_VW

(SQL View)

EE CAN ERN Bal -Vw

This record is a view of the CAN_ERN_BALANCE table and provides data to the level 1 scroll on the CAN Earnings Balance Adjustment and CAN Special Earnings Adjustment Inquiry panels.

SELECT DISTINCT emplid ,company ,balance_id ,balance_year ,wage_loss_plan ,province ,empl_rcd FROM PS_CAN_ERN_BALANCE

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 BALANCE_ID Character(2) VARCHAR2(2) NOT NULL Balance ID
Prompt Table: BALANCE_ID_TBL

4 BALANCE_YEAR Number(4,0) SMALLINT NOT NULL Balances for Year
Prompt Table: BALANCE_YR_VW

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

6 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province

7 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

#	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	BALANCE_ID	Character(2)	VARCHAR2(2) NOT NULL	Balance ID Prompt Table: BALANCE_ID_TBL
4	BALANCE_YEAR	Number(4,0)	SMALLINT NOT NULL	Balances for Year Prompt Table: BALANCE_YR_VW
5	WAGE_LOSS_PLAN	Character(3)	VARCHAR2(3) NOT NULL	Wage Loss Replacement Plan Prompt Table: WAGELS_PLAN_TBL
6	PROVINCE	Character(6)	VARCHAR2(6) NOT NULL	Province
7	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr