RBI_CLAIMFNL_VW (SQL View)	Index Back
extract FNOLs for a claim This view is used to populate the grid This helps identify all the FNOLs assigned to the claim

RBI_CLAIMFNL_VW

(SQL View)

extract FNOLs for a claim

This view is used to populate the grid This helps identify all the FNOLs assigned to the claim

SELECT B.TRANSACTION_NO , B.CLAIM_NUMBER , B.ROW_ADDED_DTTM FROM PS_RBI_CLAIM_HDR A ,PS_RBI_CLAIM_FNOL B WHERE A.CLAIM_NUMBER = B.CLAIM_NUMBER

# 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 CLAIM_NUMBER Character(15) VARCHAR2(15) NOT NULL Insurance Claim 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	CLAIM_NUMBER	Character(15)	VARCHAR2(15) NOT NULL	Insurance Claim Number
3	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.