RBI_DEDUCT_VW

(SQL View)
 Index Back

Deductible for Insurance

Deductible for Insurance Policy

SELECT FIN_ACCOUNT_ID , POLICY_TYPE , COVERAGE_ID , DEDUCTIBLE_ID , DEDUCTIBLE_AMT , CURRENCY_CD , DEDUCT_BASIS_CD , DEDUCTIBLE_TYPE_CD , DED_APPLIESTO_CD FROM PS_RBI_DEDUCTIBLE 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 DEDUCTIBLE_ID Number(15,0) DECIMAL(15) NOT NULL deductible Id
    5 DEDUCTIBLE_AMT Signed Number(30,4) DECIMAL(28,4) NOT NULL Insurance policy deductible
    6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

    Prompt Table: CURRENCY_CD_TBL

    7 DEDUCT_BASIS_CD Character(4) VARCHAR2(4) NOT NULL Deductible basis Code

    Prompt Table: RBI_XLAT_TBL

    8 DEDUCTIBLE_TYPE_CD Character(6) VARCHAR2(6) NOT NULL Deductible Code

    Prompt Table: RBI_XLAT_TBL

    9 DED_APPLIESTO_CD Character(8) VARCHAR2(8) NOT NULL Deductible Applies to Code

    Prompt Table: RBI_XLAT_TBL