RBW_SAV_HOLDING (SQL View)	Index Back
Savings Holding This view displays Savings holdings of a person in welath management

RBW_SAV_HOLDING

(SQL View)

Savings Holding

This view displays Savings holdings of a person in welath management

SELECT AST.ASSET_CATEG_ID ,AST.ASSET_TYPE2 ,ASSET_TYPE3 ,' ' ,OWN.FIN_ACCOUNT_ID , OWN.FIN_ACCOUNT_TYPE ,OWN.REGISTRATION_NAME ,OWN.WHERE_HELD ,OWN.BEGIN_DATE , BO_ID_OWNER , AVAIL_BALANCE ,OWN.CURRENCY_CD ,0 ,OWN.CUST_ACCT_NBR ,'Y' FROM PS_RBF_SAVING_ACCT SAV , PS_RBW_ASSET_CATEG AST , PS_RBF_FACT_SO_VW OWN WHERE OWN.FIN_ACCOUNT_ID = SAV.FIN_ACCOUNT_ID AND SAV.ASSET_CATEG_ID = AST.ASSET_CATEG_ID

# 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_TYPE2 Character(4) VARCHAR2(4) NOT NULL This is the asset type2 of the asset category table.

3 ASSET_TYPE3 Character(4) VARCHAR2(4) NOT NULL This is the asset type3 of the asset category table.

4 STOCK_SYMBOL Character(10) VARCHAR2(10) NOT NULL This field is used to store the Stock Symbol

5 FIN_ACCOUNT_ID Character(20) VARCHAR2(20) NOT NULL Financial Account Number

6 FIN_ACCOUNT_TYPE Character(3) VARCHAR2(3) NOT NULL Account type
CHK=Checking
CRE=Credit
INV=Investment
LON=Loan
POL=Insurance
SAV=Savings

7 REGISTRATION_NAME Character(50) VARCHAR2(50) NOT NULL Registration Name --------> FSI Account

8 WHERE_HELD Character(50) VARCHAR2(50) NOT NULL Institution at which a certain asset is held

9 BEGIN_DATE Date(10) DATE Begin Date

10 BO_ID_OWNER Number(31,0) DECIMAL(31) NOT NULL Financial Account Business Object ID

11 CURRENT_BALANCE Signed Number(30,4) DECIMAL(28,4) NOT NULL this field is used to reflect Current Balance of a FSI account

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

13 STOCK_QTY Number(21,4) DECIMAL(20,4) NOT NULL This field is used to define the quantity of stock that a client owns.

14 CUST_ACCT_NBR Character(20) VARCHAR2(20) NOT NULL This is the Customer defined Account Number for a financial account

15 YES_NO Character(1) VARCHAR2(1) NOT NULL Indicator flag -- Yes (Y) or No (N)
N=No
Y=Yes

#	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_TYPE2	Character(4)	VARCHAR2(4) NOT NULL	This is the asset type2 of the asset category table.
3	ASSET_TYPE3	Character(4)	VARCHAR2(4) NOT NULL	This is the asset type3 of the asset category table.
4	STOCK_SYMBOL	Character(10)	VARCHAR2(10) NOT NULL	This field is used to store the Stock Symbol
5	FIN_ACCOUNT_ID	Character(20)	VARCHAR2(20) NOT NULL	Financial Account Number
6	FIN_ACCOUNT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Account type CHK=Checking CRE=Credit INV=Investment LON=Loan POL=Insurance SAV=Savings
7	REGISTRATION_NAME	Character(50)	VARCHAR2(50) NOT NULL	Registration Name --------> FSI Account
8	WHERE_HELD	Character(50)	VARCHAR2(50) NOT NULL	Institution at which a certain asset is held
9	BEGIN_DATE	Date(10)	DATE	Begin Date
10	BO_ID_OWNER	Number(31,0)	DECIMAL(31) NOT NULL	Financial Account Business Object ID
11	CURRENT_BALANCE	Signed Number(30,4)	DECIMAL(28,4) NOT NULL	this field is used to reflect Current Balance of a FSI account
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.
13	STOCK_QTY	Number(21,4)	DECIMAL(20,4) NOT NULL	This field is used to define the quantity of stock that a client owns.
14	CUST_ACCT_NBR	Character(20)	VARCHAR2(20) NOT NULL	This is the Customer defined Account Number for a financial account
15	YES_NO	Character(1)	VARCHAR2(1) NOT NULL	Indicator flag -- Yes (Y) or No (N) N=No Y=Yes