DED_BAL_VW (SQL View)	Index Back
EE U.S. Deduction Balance View This record is a view of the DEDUCTION_BAL table and provides data to the level 1 scroll on the U.S. Deduction Balance Adjustment Inquiry pages.

DED_BAL_VW

(SQL View)

EE U.S. Deduction Balance View

This record is a view of the DEDUCTION_BAL table and provides data to the level 1 scroll on the U.S. Deduction Balance Adjustment Inquiry pages.

SELECT DISTINCT EMPLID , COMPANY , BALANCE_ID , BALANCE_YEAR FROM PS_DEDUCTION_BAL

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

#	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