RBW_NETWORTH_VW (SQL View)	Index Back
Net Worth View This view is used as a dummy view for displaying net worth summary

RBW_NETWORTH_VW

(SQL View)

Net Worth View

This view is used as a dummy view for displaying net worth summary

SELECT ' ' ,' ' , ' ' ,0 ,' ' FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ASSET_CATEG_ID Character(15) VARCHAR2(15) NOT NULL This field is the primary key for Asset category table

2 ASSET_TYPE1 Character(4) VARCHAR2(4) NOT NULL This is the asset type1 of the asset category table.

3 ASSET_LIAB_TYPE Character(1) VARCHAR2(1) NOT NULL This field defines whether this is an asset or a liability for a client.
A=Asset
L=Liability

4 NET_WORTH Signed Number(30,4) DECIMAL(28,4) NOT NULL Net Worth of A Client in Wealth Management,

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ASSET_CATEG_ID	Character(15)	VARCHAR2(15) NOT NULL	This field is the primary key for Asset category table
2	ASSET_TYPE1	Character(4)	VARCHAR2(4) NOT NULL	This is the asset type1 of the asset category table.
3	ASSET_LIAB_TYPE	Character(1)	VARCHAR2(1) NOT NULL	This field defines whether this is an asset or a liability for a client. A=Asset L=Liability
4	NET_WORTH	Signed Number(30,4)	DECIMAL(28,4) NOT NULL	Net Worth of A Client in Wealth Management,
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.