RBI_ISSCLAIM_VW

(SQL View)
 Index Back

relate claim and issue

First Notice of Loss Claim and Issue View

SELECT A.CLAIM_NUMBER , A.TRANSACTION_NO ,B.CLAIM_STATUS ,B.FIN_ACCOUNT_ID ,B.DESCR FROM PS_RBI_CLAIM_FNOL A ,PS_RBI_CLAIM_HDR B WHERE A.CLAIM_NUMBER = B.CLAIM_NUMBER

  • Related Language Record: RBI_ISSCLAIM_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CLAIM_NUMBER Character(15) VARCHAR2(15) NOT NULL Insurance Claim Number
    2 TRANSACTION_NO Character(15) VARCHAR2(15) NOT NULL Transaction table's primary key.
    3 CLAIM_STATUS Character(4) VARCHAR2(4) NOT NULL Categories for Case Status. These drive processing.

    Prompt Table: RBI_CLAIM_STATS

    4 FIN_ACCOUNT_ID Character(20) VARCHAR2(20) NOT NULL Financial Account Number
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description