RBW_ASSET_LIAB (SQL Table)	Index Back
Asset or Liability This table stores assets and liabilities outside management for balance sheet.

RBW_ASSET_LIAB

(SQL Table)

Asset or Liability

This table stores assets and liabilities outside management for balance sheet.

Parent Record Of RBW_ASTLIB_OWN RBW_HOLDING

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ASSET_LIAB_ID Character(15) VARCHAR2(15) NOT NULL This is the primary key of the asset liability table
Default Value: NEXT

2 ASSET_CATEG_ID Character(15) VARCHAR2(15) NOT NULL This field is the primary key for Asset category table
Prompt Table: RBW_ASSET_CATEG

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

4 ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Event Status
N=Inactive
Y=Active
Y/N Table Edit
Default Value: Y

5 LINE_OF_BUS Character(30) VARCHAR2(30) NOT NULL Indicates the Lines of Business for assets/liabilities

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

7 BEGIN_DATE Date(10) DATE Begin Date

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

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

10 LAST_REFRESH_DTTM DateTime(26) TIMESTAMP last refresh datetime

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

12 FEE_BASIS Character(4) VARCHAR2(4) NOT NULL Time period by which fees are charged, such as monthly or annually
ANNU=Annually
MONT=Monthly

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

14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
Prompt Table: CURRENCY_CD_TBL

15 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

16 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

17 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

18 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

19 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.

20 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ASSET_LIAB_ID	Character(15)	VARCHAR2(15) NOT NULL	This is the primary key of the asset liability table Default Value: NEXT
2	ASSET_CATEG_ID	Character(15)	VARCHAR2(15) NOT NULL	This field is the primary key for Asset category table Prompt Table: RBW_ASSET_CATEG
3	REGISTRATION_NAME	Character(50)	VARCHAR2(50) NOT NULL	Registration Name --------> FSI Account
4	ACTIVE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Event Status N=Inactive Y=Active Y/N Table Edit Default Value: Y
5	LINE_OF_BUS	Character(30)	VARCHAR2(30) NOT NULL	Indicates the Lines of Business for assets/liabilities
6	WHERE_HELD	Character(50)	VARCHAR2(50) NOT NULL	Institution at which a certain asset is held
7	BEGIN_DATE	Date(10)	DATE	Begin Date
8	CUST_ACCT_NBR	Character(20)	VARCHAR2(20) NOT NULL	This is the Customer defined Account Number for a financial account
9	CURRENT_BALANCE	Signed Number(30,4)	DECIMAL(28,4) NOT NULL	this field is used to reflect Current Balance of a FSI account
10	LAST_REFRESH_DTTM	DateTime(26)	TIMESTAMP	last refresh datetime
11	YTD_FEE	Number(29,4)	DECIMAL(28,4) NOT NULL	Fees charged to a Client this year
12	FEE_BASIS	Character(4)	VARCHAR2(4) NOT NULL	Time period by which fees are charged, such as monthly or annually ANNU=Annually MONT=Monthly
13	LAST_YEAR_FEE	Number(29,4)	DECIMAL(28,4) NOT NULL	Fees charged to a Client during the last year
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value. Prompt Table: CURRENCY_CD_TBL
15	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
16	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
17	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
18	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
19	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.
20	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time