LIMRA Data Exchange Standards Community Support Forum

 View Only

  • 1.  ZIP code formatting

    Posted 08-01-2024 10:59

    Good morning! We have bumped into a hiccup lately with a couple partners regarding the formatting of the zip codes for US addresses. When the +4 of a zip code is provided, our system is currently functioning to send the zip as 00000-0000. However, we have some partners expecting to receive this as 000000000. We can accommodate this, but for the ease of streamlining, we would prefer to do it as a 100% solution. Would there be any expectation that some partners require the dash while other requires the dash to not be included. I was not seeing the field defined as a set type (presumably because of the need to accommodate Canadian postal codes. 

    Jacquelynn "Jac" Payne | HCM Carrier Liaison | She/Her

    Paycom


    #LDEx-BEM

    ------------------------------
    Jacquelynn Payne | HCM Carrier Liaison | She/Her
    Paycom
    7501 W. Memorial Road | Oklahoma City, OK 73142
    800.580.4505 ext. 13836
    Jacquelynn.payne@paycomonline.com
    ------------------------------


  • 2.  RE: ZIP code formatting

    Posted 08-05-2024 12:10

                       @Jacquelynn Payne

    I've added this to the support team's agenda this week. Anyone else who has experience with this issue is welcome to discuss how they are  handling zip + four zip codes as well. . 



    ------------------------------
    Michael J Grudgings
    Business Architect, Data Standards | LL Global, Inc.
    300 Day Hill Road, Windsor, CT, 06095
    t: (860) 298-3850 | mgrudgings@limra.com
    ------------------------------



  • 3.  RE: ZIP code formatting

    Posted 08-05-2024 14:37

    Hello!

    I would typically handle this type of formatting difference at an integration level (once per partner), as each system could have different requirements. We run into the same issue with other fields, (suffix, phone formatting, country code usage) etc. 



    ------------------------------
    Amanda Lund Anderson
    Director, Integrations Engineering
    Plansource
    UT
    ------------------------------

    Original Message


  • 4.  RE: ZIP code formatting

    Posted 08-07-2024 16:41

                 @Jacquelynn Payne,

    We talked about this on the support call today and the consensus is, that zip code formatting needs to be agreed upon at the time of integration with each individual trading partner. The expectation is that the agreed upon formatting will then be used for subsequent implementations with that trading partner. Each partner's database architecture is different, so one side or the other will usually have to make some accommodations here and there.



    ------------------------------
    Michael J Grudgings
    Business Architect, Data Standards | LL Global, Inc.
    300 Day Hill Road, Windsor, CT, 06095
    t: (860) 298-3850 | mgrudgings@limra.com
    ------------------------------

    Original Message