RBF_INS_POLICY

(SQL Table)
 Index Back

Insurance Policy Account

This record is the financial account extension record for insurance policies

  • Parent record: RBF_FIN_ACCOUNT

    • # 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 POLICY_NAME Character(20) VARCHAR2(20) NOT NULL name of the policy
    4 AGENT_BO_ID Number(31,0) DECIMAL(31) NOT NULL Agent Business Object ID
    5 STATE Character(6) VARCHAR2(6) NOT NULL State
    6 INSURED_NAME Character(30) VARCHAR2(30) NOT NULL insured name
    7 PAYOR_NAME Character(30) VARCHAR2(30) NOT NULL name of the payor
    8 PAYMENT_TERMS Character(1) VARCHAR2(1) NOT NULL Installment Payment Terms
    M=Monthly
    Q=Quarterly
    S=Semi-yearly
    W=Weekly
    Y=Yearly
    9 PREMIUM_AMOUNT Signed Number(30,4) DECIMAL(28,4) NOT NULL Insurance premium Amount
    10 CARRIER_NAME Character(30) VARCHAR2(30) NOT NULL Carrier Name, ie a shipping company such as Fedex.
    11 DEDUCTIBLE_AMT Signed Number(30,4) DECIMAL(28,4) NOT NULL Insurance policy deductible
    12 BENEFICIARY_NAME Character(30) VARCHAR2(30) NOT NULL Name of Beneficiary
    13 POLICY_VERSION Character(4) VARCHAR2(4) NOT NULL Policy Version
    14 POLICY_STATUS Character(18) VARCHAR2(18) NOT NULL Policy Status

    Prompt Table: RBI_XLAT_TBL

    15 PRODUCT_CD Character(30) VARCHAR2(30) NOT NULL Product Code

    Prompt Table: RBI_XLAT_TBL

    16 NAIC_CD Character(18) VARCHAR2(18) NOT NULL NAIC Code
    17 LOB_CD Character(18) VARCHAR2(18) NOT NULL Line of Business Code

    Prompt Table: RBI_XLAT_TBL

    18 LOB_SUB_CD Character(30) VARCHAR2(30) NOT NULL Line of Business Sub Code

    Prompt Table: RBI_XLAT_TBL

    19 PRODUCER_CD Character(6) VARCHAR2(6) NOT NULL Producter Code
    20 BRANCH_CD Character(3) VARCHAR2(3) NOT NULL Branch Code
    21 TERM_DURATION Character(1) VARCHAR2(1) NOT NULL Contract Term Duration
    1=A - 15 days
    2=B - 1 Month
    3=C - 3 Months
    4=D - 6 Months
    5=E - 1 Year
    22 CONTRACTTERM_EFFDT Date(10) DATE Contract Term Effective date
    23 CONTRACTTERM_EXPDT Date(10) DATE Contract Term expiry date
    24 BILL_ACCT_NO Character(18) VARCHAR2(18) NOT NULL Bill Account NUmber
    25 BILLING_METHOD_CD Character(18) VARCHAR2(18) NOT NULL Billing Method Code

    Prompt Table: RBI_XLAT_TBL

    26 CURR_TERM_AMOUNT Signed Number(30,4) DECIMAL(28,4) NOT NULL Current Term Amount
    27 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

    Prompt Table: CURRENCY_CD_TBL

    28 CUST_SERVICING_CD Character(18) VARCHAR2(18) NOT NULL Customer Servicing Code

    Prompt Table: RBI_XLAT_TBL

    29 SIGNED_DT Date(10) DATE Date Signed
    30 GROUP_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
    31 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    32 LANGUAGE_SKILL Character(2) VARCHAR2(2) NOT NULL Spoken Language Code
    33 MAILING_RESP_CD Character(18) VARCHAR2(18) NOT NULL Mailing Responsibility Code

    Prompt Table: RBI_XLAT_TBL

    34 ORGIN_INCEPTION_DT Date(10) DATE Original Inception Date
    35 OTH_INS_COMPANY_CD Character(18) VARCHAR2(18) NOT NULL Used in Insurance, Other Insurance company codes for this policy.

    Prompt Table: RBI_XLAT_TBL

    36 PAYOR_CD Character(18) VARCHAR2(18) NOT NULL Payor Code

    Prompt Table: RBI_XLAT_TBL

    37 RATE_EFFDT Date(10) DATE Rate Effective Date
    38 RENEW_BILMETHOD_CD Character(18) VARCHAR2(18) NOT NULL Renewal Billing Method Code

    Prompt Table: RBI_XLAT_TBL

    39 RENEWAL_PAYOR_CD Character(18) VARCHAR2(18) NOT NULL Renewal Payor Code

    Prompt Table: RBI_XLAT_TBL

    40 SIGNEDBY_CD Character(18) VARCHAR2(18) NOT NULL Signed by Code

    Prompt Table: RBI_XLAT_TBL

    41 RENEWTERM_DURATION Character(1) VARCHAR2(1) NOT NULL Contract Term Duration
    1=15 days
    2=1 Month
    3=3 Months
    4=6 Months
    5=1 Year
    42 RENEWAL_TERM_EFFDT Date(10) DATE Renewal Term Effective Date
    43 RENEWAL_TERM_EXPDT Date(10) DATE Renewal Term Expiration Date
    44 TOTALPAID_LOSS_AMT Signed Number(30,4) DECIMAL(28,4) NOT NULL Total Paid Loss Amount
    45 TOTAL_NO_LOSSES Number(3,0) SMALLINT NOT NULL Total number of losses
    46 NO_YEARS_LOSS_INFO Number(2,0) SMALLINT NOT NULL Number of years of loss information to be captured in the first notice of loss.
    47 ASSET_CATEG_ID Character(15) VARCHAR2(15) NOT NULL This field is the primary key for Asset category table
    48 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    49 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    50 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    51 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    52 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.
    53 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time