ACCOUNT_TOT_VW (SQL View)	Index Back
Account Total View Sum of Account balance for a Business Unit and Emplid

ACCOUNT_TOT_VW

(SQL View)

Account Total View

Sum of Account balance for a Business Unit and Emplid

select a.business_unit ,a.emplid ,sum(a.account_balance) from PS_ACCOUNT_SF a where a.include_in_balance <> 'N' group by a.business_unit ,a.emplid

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 ACCOUNT_BALANCE Signed Number(18,2) DECIMAL(16,2) NOT NULL Account Balance

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	ACCOUNT_BALANCE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Account Balance