RD_HHLD_SRCH_VW (SQL View)	Index Back
Household Search View View used for Household configurable search.

RD_HHLD_SRCH_VW

(SQL View)

Household Search View

View used for Household configurable search.

SELECT HH.BO_ID , BN.BO_NAME_DISPLAY , HH.NET_WORTH , HH.HOLDING_AMOUNT , HH.YTD_FEE , HH.LAST_YEAR_FEE , HH.INDIRECT_AMOUNT , BC.CURRENCY_CD , HH.SYNCID FROM PS_RD_HOUSEHOLD HH , PS_BO_NAME BN , PS_BC BC WHERE HH.BO_ID = BN.BO_ID AND BN.PRIMARY_IND = 'Y' AND HH.BO_ID = BC.BO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

2 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

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

4 HOLDING_AMOUNT Signed Number(30,4) DECIMAL(28,4) NOT NULL Holding Amount of A Client in Wealth Management.

5 YTD_FEE Number(29,4) DECIMAL(28,4) NOT NULL Fees charged to a Client this year

6 LAST_YEAR_FEE Number(29,4) DECIMAL(28,4) NOT NULL Fees charged to a Client during the last year

7 INDIRECT_AMOUNT Signed Number(30,4) DECIMAL(28,4) NOT NULL Indirect Holdings of A Client in Wealth Management.

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

9 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
3	NET_WORTH	Signed Number(30,4)	DECIMAL(28,4) NOT NULL	Net Worth of A Client in Wealth Management,
4	HOLDING_AMOUNT	Signed Number(30,4)	DECIMAL(28,4) NOT NULL	Holding Amount of A Client in Wealth Management.
5	YTD_FEE	Number(29,4)	DECIMAL(28,4) NOT NULL	Fees charged to a Client this year
6	LAST_YEAR_FEE	Number(29,4)	DECIMAL(28,4) NOT NULL	Fees charged to a Client during the last year
7	INDIRECT_AMOUNT	Signed Number(30,4)	DECIMAL(28,4) NOT NULL	Indirect Holdings of A Client in Wealth Management.
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.
9	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.