Assurant Insurance Integration

Assurant Insurance Integration

See the attached document for complete details. 

The Assurant Integration affords ASPIRE users the ability to export contract data to Assurant where the insurance coverage is confirmed or a premium is calculated.  Assurant then provides an import file back to the client to assess the current charges to the contract.  This cycle can occur at a minimum monthly, but as frequently as daily.  It will be at the clients discretion to run the processes.

The current design of the Assurant CDT Export file is to include one record per contract.  ASPIRE pulls the majority of the information from the Contract level.  The equipment cost in the CDT file is an Equipment level sum of all of the assets.  Any other asset level information in the main CDT file (Description, Type, etc) is pulled from the asset marked as ‘Primary’. 

Assurant does have a modification to their export, where a supplemental file is also created.  This contains the Serial numbers and description of ALL the assets on the contract.  The Supplemental file is placed in the same folder as the main export file but has ‘SUP’ appended to the end of the file name. 

When setting up the insurance integrations, on each Equipment Type, the Insurance Type must be indicated ( Property, Liability, or Property & Liability).  This indicator controls two things:  1) The number of Insurance Integration ‘Insurance Company’ records that are set up on the Insurance Integration tab in ASPIRE and 2)  The Insurance Type indicator in the CDT file (PI, LI or PLI).

When using the IDT Import file (Invoice Data Transfer), Assurant is sending back one billing record per contract in the import file (The one record is made up of up to 3 billing components:  Insurance, Sub Fee, Finance Fee).   There is no indicator to identify if the charges are related to Property or Liability insurance. 

If the BDT Import file is being used (Billing Data Transfer), a schedule billable is created for each insurance type, one for Property and one for Liability.  These schedule billable records are actually linked to the insurance.  The schedule billable record is set up for the remaining term of the contract and the number of schedule billable records that are set up depends on if there is property and liability insurance (2 schedule billable records) or just Property (one schedule billable). 

When the IDT file is imported with the insurance charges, the information is placed into the Follower table in the database. (yes, the table name is ‘Follower’ ). When the next invoice is generated for the contract payment, ASPIRE picks up any charges in the follower table for the contract and creates an invoice for those charges as well.

For the Insurance integration, the user will also receive a IDT Cancel file.  The cancel file is the same layout except that the values are negative, indicating that there are to be credits issued for the insurance charges on the contracts.  Keep in mind that these amounts could cover multiple insurance charges as well as partial credits.  Also, the credits could come in multiple files, meaning in this week’s file, the credit is for 90% of the contract’s insurance billings leaving a partial insurance charge and then next week, another credit is imported that credits the remaining 10% of those charges.

LTi recommends when using the IDT file, the equipment types only have Property Insurance indicated.  Why??  The main reason is that ASPIRE will only set up one insurance record for Property insurance.  If the equipment type is set to Property and Liability, Two records are set up and it’s harder to keep those two in sync.  Assurant should be able to determine the insurance type (Property and/or Liability) based on the Equipment type coming through in the CDT file.  Since we aren’t identifying what the insurance charge is for (Property or Liability insurance).  Only having one insurance record for Assurant makes it a little easier to manage. 

You will also notice, on the bottom of the Equipment Type setup screen, there is a ‘Vehicle’ checkbox.  What does this do you may ask???   In the CDT Export file, there is a node labeled ‘CONTRACT_TYPE’.  If the contract is a Loan, the value in this node is ‘F’ and if it’s a Lease, it is ‘L’.  If the ‘Vehicle’ checkbox is checked on the equipment type, the values switch to ‘VF’ for loan and ‘VL’ for Lease.

The addition of the PDT Export file, provides an XML file of the payments made to insurance transactions during the selected date range.  The file is transferred to Assurant for billing and tracking purposes.

Attached Document Table of Contents


Configuration

Prerequisites

Administration > Codes and Types

Administration > Billing > Transaction Code

Integration Configuration

Administration > Integrations > Insurance

File Processing

CDT Export File

Tasks > Insurance > Export 

Results:  Contract Explorer > Tasks > Insurance Tracking

IDT Import File

Tasks > Insurance > Import 

Contract Explorer > Billing > Scheduled Billables

PDT Export File

Tasks > Insurance > Export

Contract Modifications

Insurance Reports

Associated with the Assurant Integration



    • Related Articles

    • Insurance Integration Modules Video

      See linked videos for complete details.  The linked videos review details around the Insurance Integrations available for ASPIRE.  Click here for video 1 that covers the need for lease insurance and the standard Insurance functionality. A 5 minute ...
    • Great American Insurance Integration

      See the attached document for complete details.  The attached document outlines the setup and processing of Great American Insurance. Attached Document - Table of Contents Administration > Insurance       1.      Finance Company Level Configuration   ...
    • PTMS Integration

      The attachment provides layout file examples for the PTMS (Property Tax Management System) Export and Import files.   During export, all assets that fit the user-selected parameters will be exported into the file layout  outlined above.   When the ...
    • Add Insurance Information to a Contract

      Adding Insurance Information to a Contract 1.    Insurance policy information is added from the Contract Explorer area. 2.    Click on the Insurance Tracking option. 3.       To enter a new Insurance policy click on the New button in the toolbar. ...
    • OSG Integration Module

      See attached document for complete details.  The OSG Integration module enables the export of invoice information out of ASPIRE v5 into an XML file compatible with LTi’s vendor billing and invoicing partner, OSG Billing Services (“OSG”). OSG provides ...