CAN_DED_BAL_VW (SQL View)	Index Back
EE CAN DED Bal -Vw This record is a view of the CAN_DED_BALANCE table and provides data to the level 1 scroll on the CAN Deductions Balance Adjustment Inquiry panel.

CAN_DED_BAL_VW

(SQL View)

EE CAN DED Bal -Vw

This record is a view of the CAN_DED_BALANCE table and provides data to the level 1 scroll on the CAN Deductions Balance Adjustment Inquiry panel.

select distinct emplid ,company ,balance_id ,balance_year ,wage_loss_plan ,province from PS_CAN_DED_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

#	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