@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:
Sent: 08-05-2024 14:37
From: Amanda Lund Anderson
Subject: ZIP code formatting
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:
Sent: 08-05-2024 12:10
From: Michael Grudgings
Subject: ZIP code formatting
@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
Original Message:
Sent: 08-01-2024 10:59
From: Jacquelynn Payne
Subject: ZIP code formatting
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
------------------------------