Go to previous topic
Go to next topic
Last Post 03/01/2020 1:06 PM by  Bill Ianni
Interface with Insurance Carriers
 8 Replies
Author Messages
DD
ERP Systems Analyst
Private
New Member
(7 points)
New Member
Posts:3


Send Message:

--
02/19/2020 11:32 AM

    Has anyone successfully accomplished exporting data from Lawson and importing into an insurance carrier portal?  We would like to find a solution that will replace entering in Lawson and then entering the same information on each insurance carriers website.

    Karen Sheridan
    Private
    Private
    Veteran Member
    (350 points)
    Veteran Member
    Posts:132


    Send Message:

    --
    02/19/2020 11:44 AM

    We interface data from Lawson to all of our Insurance Carriers.  We use a combination of Cobol programs and IPA depending on the vendor.  Each vendor's requirements are different, so you'd need their specifications.

    Karen

     

    DD
    ERP Systems Analyst
    Private
    New Member
    (7 points)
    New Member
    Posts:3


    Send Message:

    --
    02/19/2020 11:53 AM
    Do you use any form of EDI?
    FireGeek21
    Private
    Private
    Veteran Member
    (184 points)
    Veteran Member
    Posts:80


    Send Message:

    --
    02/19/2020 11:53 AM
    I have used IPA to create .CBS,. text, and other vendor required formats. Pretty easy to do.

    Tammy
    FireGeek21
    Private
    Private
    Veteran Member
    (184 points)
    Veteran Member
    Posts:80


    Send Message:

    --
    02/19/2020 11:53 AM
    I have used IPA to create .CBS,. text, and other vendor required formats. Pretty easy to do.

    Tammy
    Beate Hughes-Brown
    Sr Lawson HR Analyst
    Feld Entertainment Inc
    Advanced Member
    (66 points)
    Advanced Member
    Posts:26


    Send Message:

    --
    02/19/2020 11:57 AM
    We too use IPA. Run a query then reformat to vendor needs. For some vendors the file is emailed to the benefits team who audits and drops into the portal. For other benefits the file goes over using SFTP.
    John Henley
    Private
    Private
    Senior Member
    (9785 points)
    Senior Member
    Posts:3279


    Send Message:

    --
    02/19/2020 12:41 PM
    There are a bunch of ways to accomplish these interfaces. For the sake of discussion, I assume you're still on S3 HR and not yet on Landmark GHR. The best solution IMO is to use BN106 output and a transformation tool (it used to be called Mercator) to create EDI/HIPAA 834 files which is a (almost) universal standard. My understanding is that the carriers charge more for these, but I think you will save money in the development since they come almost out-of-the-box from Lawson, and usually require just minor tweaking. You can also use custom COBOL, IPA, etc. to create files that meet each carriers unique/proprietary formats. I have even created some that are CSV extracts using Crystal Reports. Most of the time, however, these solutions are costly in terms of development and maintenance (e.g. each year adds new wrinkles) and you have to build in logic for handling new hires, terminations, COBRA, etc. etc.
    Thanks for using the LawsonGuru.com forums!
    John
    DD
    ERP Systems Analyst
    Private
    New Member
    (7 points)
    New Member
    Posts:3


    Send Message:

    --
    02/21/2020 11:43 AM
    Thank you for all this great information. After sharing I was asked to reach out again and inquire if you used a consultant to get this going and if so, who?
    Bill Ianni
    Private
    Private
    Veteran Member
    (318 points)
    Veteran Member
    Posts:106


    Send Message:

    --
    03/01/2020 1:06 PM
    I’ve done the EDI for Delta, Cigna and United Health in 2011 through a BN 106 file. You’ll need the formatting requirements from your carriers.


    ---