RBI_CASSET_VW

(SQL View)
Index Back

Covered Assets for Insurance

Covered assets for Insurance

SELECT FIN_ACCOUNT_ID , POLICY_TYPE , ASSET_ID , ASSET_TYPE , ASSET_DESCRIPTION FROM PS_RBI_COVER_ASSET WHERE ASSET_ID <> ' '

  • Parent record: RBF_INS_POLICY
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIN_ACCOUNT_ID Character(20) VARCHAR2(20) NOT NULL Financial Account Number
    2 POLICY_TYPE Character(3) VARCHAR2(3) NOT NULL policy type --------fsi
    AUT=Auto Insurance
    BOA=Boat Insurance
    CRP=Crop Insurance
    EQK=Earthquake insurance
    FLD=Flood Insurance
    HLT=Health
    HOM=Homeowner's Insurance
    LIF=Life
    REN=Renter's Insurance
    TIT=Title Insurance
    3 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identifier used in Contracts Integration
    4 ASSET_TYPE Character(4) VARCHAR2(4) NOT NULL Asset Type
    DRIV=Driver
    DWEL=Dwelling
    VEHI=Vehicle

    Prompt Table: RBI_ASSET_TYPE

    5 ASSET_DESCRIPTION Character(100) VARCHAR2(100) NOT NULL Asset Description