RBI_FNOL_VW (SQL View)	Index Back
FNOLS View View for the First Notice of Loss data

RBI_FNOL_VW

(SQL View)

FNOLS View

View for the First Notice of Loss data

SELECT A.TRANSACTION_NO , B.FIN_ACCOUNT_ID , A.ROW_ADDED_DTTM FROM PS_RBI_FNOL A , PS_RBF_FIN_ACCOUNT B WHERE A.FIN_ACCOUNT_ID = B.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.

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRANSACTION_NO	Character(15)	VARCHAR2(15) NOT NULL	Transaction table's primary key.
2	FIN_ACCOUNT_ID	Character(20)	VARCHAR2(20) NOT NULL	Financial Account Number
3	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.