RBI_FNOL_SRCH_V (SQL View)	Index Back
First Notice of Loss This record is used to capture FNOL transactions.

RBI_FNOL_SRCH_V

(SQL View)

First Notice of Loss

This record is used to capture FNOL transactions.

SELECT TRANSACTION_NO , A.FIN_ACCOUNT_ID , CUST_ACCT_NBR FROM PS_RBI_FNOL A , PS_RBF_FIN_ACCOUNT F WHERE A.FIN_ACCOUNT_ID = F.FIN_ACCOUNT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TRANSACTION_NO Character(15) VARCHAR2(15) NOT NULL Transaction table's primary key.
Default Value: NEXT

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRANSACTION_NO	Character(15)	VARCHAR2(15) NOT NULL	Transaction table's primary key. Default Value: NEXT
2	FIN_ACCOUNT_ID	Character(20)	VARCHAR2(20) NOT NULL	Financial Account Number
3	CUST_ACCT_NBR	Character(20)	VARCHAR2(20) NOT NULL	This is the Customer defined Account Number for a financial account