RBI_LIMIT

(SQL Table)
Index Back

Limits for Insurance Policy

Limit table for Insurance Policy

  • 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 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identifier used in Contracts Integration

    Default Value: NEXT

    4 COVERAGE_ID Number(15,0) DECIMAL(15) NOT NULL Coverage ID

    Default Value: 999999999999999

    5 LIMIT_ID Number(15,0) DECIMAL(15) NOT NULL Limit ID

    Default Value: 999999999999999

    6 LIMIT_AMOUNT Signed Number(31,4) DECIMAL(29,4) NOT NULL Credit Card Limit Amount.....................................
    7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

    Prompt Table: CURRENCY_CD_TBL

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

    Prompt Table: RBI_XLAT_TBL

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

    Prompt Table: RBI_XLAT_TBL

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

    Prompt Table: RBI_XLAT_TBL

    11 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    12 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    13 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    14 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    15 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    16 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time