RBI_LIMIT_VW

(SQL View)
 Index Back

Limits for Insurance Policy VW

Limits for Insurance Policy

SELECT FIN_ACCOUNT_ID , POLICY_TYPE , COVERAGE_ID , LIMIT_ID , LIMIT_AMOUNT , CURRENCY_CD , LIMIT_BASIS_CD , VALUATION_CD , LIMIT_APPLIESTO_CD FROM PS_RBI_LIMIT WHERE ASSET_ID = ' '

  • Parent record: RBI_COVERAGE

    • # 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 COVERAGE_ID Number(15,0) DECIMAL(15) NOT NULL Coverage ID
    4 LIMIT_ID Number(15,0) DECIMAL(15) NOT NULL Limit ID
    5 LIMIT_AMOUNT Signed Number(31,4) DECIMAL(29,4) NOT NULL Credit Card Limit Amount.....................................
    6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

    Prompt Table: CURRENCY_CD_TBL

    7 LIMIT_BASIS_CD Character(10) VARCHAR2(10) NOT NULL limit basis code

    Prompt Table: RBI_XLAT_TBL

    8 VALUATION_CD Character(18) VARCHAR2(18) NOT NULL Valuation code

    Prompt Table: RBI_XLAT_TBL

    9 LIMIT_APPLIESTO_CD Character(15) VARCHAR2(15) NOT NULL Limit Applies to code

    Prompt Table: RBI_XLAT_TBL