FundSvcs Community

Hello Everyone! I need to clean up international addresses in Raiser's Edge and was wondering if anyone who has done a similar project has any advice or success stories. I know we need to first establish our address formatting standards for each country and probably reconfigure some in RE. (We currently have addresses in about 130 countries.) And once everything is nice and clean, I'll want to do some training and auditing to try and keep it that way. If you've done any of this before, was there something that really worked well, or something that really didn't go as expected for you? Thank you all so much! Dania -- Dania Calandrino Data Integrity Specialist Department of Development Records The Art Institute of Chicago 111 S. Michigan Avenue Chicago, IL 60603 (e): dcalan@artic.edu

Aloha Dania, I haven't seen a reply come through yet, so I'll chime in. At my previous job I worked with RE for 11 years and had to tackle this exact same concern. As for RE: Under Configuration, in the International section, you’ll see five country address templates to choose from in the dropdown box for “Display available fields for this country.” (US, UK, Canada, Australia, and New Zealand). For any country that is not one of those, we almost always used UK. Someone may have mapped out a better usage for the country, but we found that UK worked best and you can also configure each of templates however you want. We configured the UK template to work for all European countries and other countries pretty well. Some countries will always have various address components that don’t play nicely, but you can enter those in the address lines. Remember that several nations have special characters in their alphabet such as (β, ϋ, é, etc.), so you’ll need to make a call on whether or not you want to use them or substitute with standard alphabet characters.. But as you mentioned before you begin entering, you may want to start a data entry procedures manual, and include a section on your standards for adding/updating international addresses. Then within that section break out standards by geographical regions. Several European countries share a format, as well as several South American countries, so it really doesn't need to be a country-by-country run down of standards. It’s been a while, but at the time we found that MelissaData has some helpful tools for global address verification. http://melissadata.com/eu/solutions/global-address-verification.htm As for free sites, Google Maps is an easy one to recommend. Before adding or changing international addresses, it’s a good idea to attempt to validate the address on Google Maps. Google Maps is not only comprehensive with many international addresses, it’s also clever at making sense from less than perfect addresses and it will often provide you with the full street name and postal code! Several countries have their own government associated postal address verification sites such as Royal Mail for the UK. to http://www.royalmail.com There are also free sites out there where companies and address wonks have generously donated their time to provide guidance such as Frank’s Compulsive Guide http://www.columbia.edu/~fdc/postal/ and BelightSoft http://www.belightsoft.com/products/resources/postal.php Hope this helps, aloha! Eric Eric F. Valdescaro AVP, Advancement Services University of Hawaii Foundation
Original Message----- From: Advancement Services Discussion List [mailto:FUNDSVCS@LISTSERV.FUNDSVCS.ORG] On Behalf Of Dania Calandrino Sent: Tuesday, January 29, 2019 1:00 PM To: FUNDSVCS@LISTSERV.FUNDSVCS.ORG Subject: [FUNDSVCS] International Addresses in RE Hello Everyone! I need to clean up international addresses in Raiser's Edge and was wondering if anyone who has done a similar project has any advice or success stories. I know we need to first establish our address formatting standards for each country and probably reconfigure some in RE. (We currently have addresses in about 130 countries.) And once everything is nice and clean, I'll want to do some training and auditing to try and keep it that way. If you've done any of this before, was there something that really worked well, or something that really didn't go as expected for you? Thank you all so much! Dania -- Dania Calandrino Data Integrity Specialist Department of Development Records The Art Institute of Chicago 111 S. Michigan Avenue Chicago, IL 60603 (e): dcalan@artic.edu<mailto:dcalan@artic.edu> This message (including any attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521. It is the property of the University of Hawaii Foundation. It may contain confidential information intended for a specific individual and purpose. If you are not the intended recipient, you must delete this message. You are hereby notified that any disclosure, copying, or distribution of this message is prohibited.

Hi Dania, We are a BBCRM shop, but I imagine address formats are fairly similar. Here are some websites that helped with our formatting: * http://www.upu.int/en/activities/addressing/postal-addressing-systems-in-member-countries.html * http://pe.usps.gov/text/imm/immctry.htm * http://www.columbia.edu/~fdc/postal/ (Frank’s Compulsive Guide to Postal Addresses) * https://en.wikipedia.org/wiki/ISO_3166-1 (ISO Standard) * http://statoids.com/ I used the first link to create the formats that are documented in the attached file. (Each country on that website has a detailed PDF regarding address format – it is quite comprehensive!) I prioritized formatting and cleanup by the number of addresses we had in a particular country. You may need to make some judgment calls on some of the formatting. For example: * Italy has 110 provinces, and the province abbreviation is required in the address. Compare this to how many Italian addresses you have to determine if it is worth it to load the provinces into a code table, or if it is better to include the province abbreviation in the City field (which requires data entry training/standards). This is also true of several other countries, such as Japan, Thailand, Spain, and even the counties of Ireland. * Per ISO standards, the UK is a country of its own, but it is comprised of 4 countries, which we wanted to query on. We coded the Country as United Kingdom, with 4 “States” – England, Northern Ireland, Scotland, and Wales. CRM also allows us to configure the label for the State field on the Address Add/Edit forms to say “UK Country” when United Kingdom is selected as the country. You can configure the address to show the “state” or not, but it is not required to show when mailing to the UK. We have not done a full cleanup yet, but the plan is to have several data checks that look at proper formatting, addresses that are missing required state/province/zip, etc. Kelli Crispin Business Analyst/Quality Assurance Specialist she/her/hers The University of North Carolina at Chapel Hill Office of University Development 208 W. Franklin Street Chapel Hill, NC 27516 P 919.962.2815 E kelli.crispin@unc.edu<mailto:kelli.crispin@unc.edu> [cid:image001.png@01D383E6.0AC22A10] CAMPAIGN.UNC.EDU<http://campaign.unc.edu/> From: Advancement Services Discussion List <FUNDSVCS@LISTSERV.FUNDSVCS.ORG> On Behalf Of Eric Valdescaro Sent: Wednesday, January 30, 2019 3:00 PM To: FUNDSVCS@LISTSERV.FUNDSVCS.ORG Subject: Re: [FUNDSVCS] International Addresses in RE Aloha Dania, I haven't seen a reply come through yet, so I'll chime in. At my previous job I worked with RE for 11 years and had to tackle this exact same concern. As for RE: Under Configuration, in the International section, you’ll see five country address templates to choose from in the dropdown box for “Display available fields for this country.” (US, UK, Canada, Australia, and New Zealand). For any country that is not one of those, we almost always used UK. Someone may have mapped out a better usage for the country, but we found that UK worked best and you can also configure each of templates however you want. We configured the UK template to work for all European countries and other countries pretty well. Some countries will always have various address components that don’t play nicely, but you can enter those in the address lines. Remember that several nations have special characters in their alphabet such as (β, ϋ, é, etc.), so you’ll need to make a call on whether or not you want to use them or substitute with standard alphabet characters.. But as you mentioned before you begin entering, you may want to start a data entry procedures manual, and include a section on your standards for adding/updating international addresses. Then within that section break out standards by geographical regions. Several European countries share a format, as well as several South American countries, so it really doesn't need to be a country-by-country run down of standards. It’s been a while, but at the time we found that MelissaData has some helpful tools for global address verification. http://melissadata.com/eu/solutions/global-address-verification.htm As for free sites, Google Maps is an easy one to recommend. Before adding or changing international addresses, it’s a good idea to attempt to validate the address on Google Maps. Google Maps is not only comprehensive with many international addresses, it’s also clever at making sense from less than perfect addresses and it will often provide you with the full street name and postal code! Several countries have their own government associated postal address verification sites such as Royal Mail for the UK. to http://www.royalmail.com There are also free sites out there where companies and address wonks have generously donated their time to provide guidance such as Frank’s Compulsive Guide http://www.columbia.edu/~fdc/postal/ and BelightSoft http://www.belightsoft.com/products/resources/postal.php Hope this helps, aloha! Eric Eric F. Valdescaro AVP, Advancement Services University of Hawaii Foundation
Original Message----- From: Advancement Services Discussion List [mailto:FUNDSVCS@LISTSERV.FUNDSVCS.ORG] On Behalf Of Dania Calandrino Sent: Tuesday, January 29, 2019 1:00 PM To: FUNDSVCS@LISTSERV.FUNDSVCS.ORG<mailto:FUNDSVCS@LISTSERV.FUNDSVCS.ORG> Subject: [FUNDSVCS] International Addresses in RE Hello Everyone! I need to clean up international addresses in Raiser's Edge and was wondering if anyone who has done a similar project has any advice or success stories. I know we need to first establish our address formatting standards for each country and probably reconfigure some in RE. (We currently have addresses in about 130 countries.) And once everything is nice and clean, I'll want to do some training and auditing to try and keep it that way. If you've done any of this before, was there something that really worked well, or something that really didn't go as expected for you? Thank you all so much! Dania -- Dania Calandrino Data Integrity Specialist Department of Development Records The Art Institute of Chicago 111 S. Michigan Avenue Chicago, IL 60603 (e): dcalan@artic.edu<mailto:dcalan@artic.edu> This message (including any attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521. It is the property of the University of Hawaii Foundation. It may contain confidential information intended for a specific individual and purpose. If you are not the intended recipient, you must delete this message. You are hereby notified that any disclosure, copying, or distribution of this message is prohibited.

Kelli and Eric Thank you so much for the helpful links. Two things I want to add/ask: 1. Has anyone found a way to deal (on a mass sweep basis) with South Korea changing their zip code format? 2. Does anyone have a good reference document or website for country codes that are also US area codes? We’re in a unique situation being on a homegrown database and as we move from a mainframe to Oracle/Azure, I’m trying to clean up where the mainframe has inferred that the first three digits of a phone number are the area code…..which is obviously not the case for international phone numbers. Right now we can’t query certain area codes/country codes that match unless we know that, for example, 972 is an area code in Texas but also the country code for Israel. Regards, Jessica Baker | Assistant Director of Data Quality and Strategy The University of Texas at Austin | TEXAS Development LCH 100 (F1000) | Austin, TX 78712 512-232-1729 | jbaker@austin.utexas.edu<mailto:jbaker@austin.utexas.edu> giving.utexas.edu [id:CA9C62C8-3A16-4EAD-B852-92D56B55BB22] Hook ‘em Horns! From: Advancement Services Discussion List <FUNDSVCS@LISTSERV.FUNDSVCS.ORG> On Behalf Of Crispin, Kelli Sent: Thursday, January 31, 2019 11:06 AM To: FUNDSVCS@LISTSERV.FUNDSVCS.ORG Subject: Re: [FUNDSVCS] International Addresses in RE Hi Dania, We are a BBCRM shop, but I imagine address formats are fairly similar. Here are some websites that helped with our formatting: * http://www.upu.int/en/activities/addressing/postal-addressing-systems-in-member-countries.html * http://pe.usps.gov/text/imm/immctry.htm * http://www.columbia.edu/~fdc/postal/ (Frank’s Compulsive Guide to Postal Addresses) * https://en.wikipedia.org/wiki/ISO_3166-1 (ISO Standard) * http://statoids.com/ I used the first link to create the formats that are documented in the attached file. (Each country on that website has a detailed PDF regarding address format – it is quite comprehensive!) I prioritized formatting and cleanup by the number of addresses we had in a particular country. You may need to make some judgment calls on some of the formatting. For example: * Italy has 110 provinces, and the province abbreviation is required in the address. Compare this to how many Italian addresses you have to determine if it is worth it to load the provinces into a code table, or if it is better to include the province abbreviation in the City field (which requires data entry training/standards). This is also true of several other countries, such as Japan, Thailand, Spain, and even the counties of Ireland. * Per ISO standards, the UK is a country of its own, but it is comprised of 4 countries, which we wanted to query on. We coded the Country as United Kingdom, with 4 “States” – England, Northern Ireland, Scotland, and Wales. CRM also allows us to configure the label for the State field on the Address Add/Edit forms to say “UK Country” when United Kingdom is selected as the country. You can configure the address to show the “state” or not, but it is not required to show when mailing to the UK. We have not done a full cleanup yet, but the plan is to have several data checks that look at proper formatting, addresses that are missing required state/province/zip, etc. Kelli Crispin Business Analyst/Quality Assurance Specialist she/her/hers The University of North Carolina at Chapel Hill Office of University Development 208 W. Franklin Street Chapel Hill, NC 27516 P 919.962.2815 E kelli.crispin@unc.edu<mailto:kelli.crispin@unc.edu> [cid:image001.png@01D383E6.0AC22A10] CAMPAIGN.UNC.EDU<http://campaign.unc.edu/> From: Advancement Services Discussion List <FUNDSVCS@LISTSERV.FUNDSVCS.ORG<mailto:FUNDSVCS@LISTSERV.FUNDSVCS.ORG>> On Behalf Of Eric Valdescaro Sent: Wednesday, January 30, 2019 3:00 PM To: FUNDSVCS@LISTSERV.FUNDSVCS.ORG<mailto:FUNDSVCS@LISTSERV.FUNDSVCS.ORG> Subject: Re: [FUNDSVCS] International Addresses in RE Aloha Dania, I haven't seen a reply come through yet, so I'll chime in. At my previous job I worked with RE for 11 years and had to tackle this exact same concern. As for RE: Under Configuration, in the International section, you’ll see five country address templates to choose from in the dropdown box for “Display available fields for this country.” (US, UK, Canada, Australia, and New Zealand). For any country that is not one of those, we almost always used UK. Someone may have mapped out a better usage for the country, but we found that UK worked best and you can also configure each of templates however you want. We configured the UK template to work for all European countries and other countries pretty well. Some countries will always have various address components that don’t play nicely, but you can enter those in the address lines. Remember that several nations have special characters in their alphabet such as (β, ϋ, é, etc.), so you’ll need to make a call on whether or not you want to use them or substitute with standard alphabet characters.. But as you mentioned before you begin entering, you may want to start a data entry procedures manual, and include a section on your standards for adding/updating international addresses. Then within that section break out standards by geographical regions. Several European countries share a format, as well as several South American countries, so it really doesn't need to be a country-by-country run down of standards. It’s been a while, but at the time we found that MelissaData has some helpful tools for global address verification. http://melissadata.com/eu/solutions/global-address-verification.htm As for free sites, Google Maps is an easy one to recommend. Before adding or changing international addresses, it’s a good idea to attempt to validate the address on Google Maps. Google Maps is not only comprehensive with many international addresses, it’s also clever at making sense from less than perfect addresses and it will often provide you with the full street name and postal code! Several countries have their own government associated postal address verification sites such as Royal Mail for the UK. to http://www.royalmail.com There are also free sites out there where companies and address wonks have generously donated their time to provide guidance such as Frank’s Compulsive Guide http://www.columbia.edu/~fdc/postal/ and BelightSoft http://www.belightsoft.com/products/resources/postal.php Hope this helps, aloha! Eric Eric F. Valdescaro AVP, Advancement Services University of Hawaii Foundation
Original Message----- From: Advancement Services Discussion List [mailto:FUNDSVCS@LISTSERV.FUNDSVCS.ORG] On Behalf Of Dania Calandrino Sent: Tuesday, January 29, 2019 1:00 PM To: FUNDSVCS@LISTSERV.FUNDSVCS.ORG<mailto:FUNDSVCS@LISTSERV.FUNDSVCS.ORG> Subject: [FUNDSVCS] International Addresses in RE Hello Everyone! I need to clean up international addresses in Raiser's Edge and was wondering if anyone who has done a similar project has any advice or success stories. I know we need to first establish our address formatting standards for each country and probably reconfigure some in RE. (We currently have addresses in about 130 countries.) And once everything is nice and clean, I'll want to do some training and auditing to try and keep it that way. If you've done any of this before, was there something that really worked well, or something that really didn't go as expected for you? Thank you all so much! Dania -- Dania Calandrino Data Integrity Specialist Department of Development Records The Art Institute of Chicago 111 S. Michigan Avenue Chicago, IL 60603 (e): dcalan@artic.edu<mailto:dcalan@artic.edu> This message (including any attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521. It is the property of the University of Hawaii Foundation. It may contain confidential information intended for a specific individual and purpose. If you are not the intended recipient, you must delete this message. You are hereby notified that any disclosure, copying, or distribution of this message is prohibited.

Jessica, For question 2: If it helps – the two sites that I use for administrative data (phones) are: https://www.allareacodes.com/ (Canadian and US area codes + prefix) & https://countrycode.org/ I haven’t run across the type of reference document that you are asking about, but between the two sites above, it wouldn’t be that hard to construct. Christopher Amherst Assistant Director of Advancement Information Systems Development and Alumni Relations P 585.475.2959 F 585.475.7004 [RIT]<http://www.rit.edu/> Rochester Institute of Technology 116 Lomb Memorial Drive, USC 03401/Rochester, NY 14623 [RIT]<https://www.rit.edu/alumni/signature/> Connect with us: [RIT] <http://www.facebook.com/RIT.Alumni> [RIT] <https://twitter.com/RIT_Alumni> [RIT] <http://www.linkedin.com/groups?gid=72797> CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information. From: Advancement Services Discussion List [mailto:FUNDSVCS@LISTSERV.FUNDSVCS.ORG] On Behalf Of Baker, Jessica Sent: Thursday, August 08, 2019 10:08 AM To: FUNDSVCS@LISTSERV.FUNDSVCS.ORG Subject: Re: [FUNDSVCS] International Addresses in RE Kelli and Eric Thank you so much for the helpful links. Two things I want to add/ask: 1. Has anyone found a way to deal (on a mass sweep basis) with South Korea changing their zip code format? 2. Does anyone have a good reference document or website for country codes that are also US area codes? We’re in a unique situation being on a homegrown database and as we move from a mainframe to Oracle/Azure, I’m trying to clean up where the mainframe has inferred that the first three digits of a phone number are the area code…..which is obviously not the case for international phone numbers. Right now we can’t query certain area codes/country codes that match unless we know that, for example, 972 is an area code in Texas but also the country code for Israel. Regards, Jessica Baker | Assistant Director of Data Quality and Strategy The University of Texas at Austin | TEXAS Development LCH 100 (F1000) | Austin, TX 78712 512-232-1729 | jbaker@austin.utexas.edu<mailto:jbaker@austin.utexas.edu> giving.utexas.edu [id:CA9C62C8-3A16-4EAD-B852-92D56B55BB22] Hook ‘em Horns! From: Advancement Services Discussion List <FUNDSVCS@LISTSERV.FUNDSVCS.ORG<mailto:FUNDSVCS@LISTSERV.FUNDSVCS.ORG>> On Behalf Of Crispin, Kelli Sent: Thursday, January 31, 2019 11:06 AM To: FUNDSVCS@LISTSERV.FUNDSVCS.ORG<mailto:FUNDSVCS@LISTSERV.FUNDSVCS.ORG> Subject: Re: [FUNDSVCS] International Addresses in RE Hi Dania, We are a BBCRM shop, but I imagine address formats are fairly similar. Here are some websites that helped with our formatting: · http://www.upu.int/en/activities/addressing/postal-addressing-systems-in-member-countries.html · http://pe.usps.gov/text/imm/immctry.htm · http://www.columbia.edu/~fdc/postal/ (Frank’s Compulsive Guide to Postal Addresses) · https://en.wikipedia.org/wiki/ISO_3166-1 (ISO Standard) · http://statoids.com/ I used the first link to create the formats that are documented in the attached file. (Each country on that website has a detailed PDF regarding address format – it is quite comprehensive!) I prioritized formatting and cleanup by the number of addresses we had in a particular country. You may need to make some judgment calls on some of the formatting. For example: * Italy has 110 provinces, and the province abbreviation is required in the address. Compare this to how many Italian addresses you have to determine if it is worth it to load the provinces into a code table, or if it is better to include the province abbreviation in the City field (which requires data entry training/standards). This is also true of several other countries, such as Japan, Thailand, Spain, and even the counties of Ireland. * Per ISO standards, the UK is a country of its own, but it is comprised of 4 countries, which we wanted to query on. We coded the Country as United Kingdom, with 4 “States” – England, Northern Ireland, Scotland, and Wales. CRM also allows us to configure the label for the State field on the Address Add/Edit forms to say “UK Country” when United Kingdom is selected as the country. You can configure the address to show the “state” or not, but it is not required to show when mailing to the UK. We have not done a full cleanup yet, but the plan is to have several data checks that look at proper formatting, addresses that are missing required state/province/zip, etc. Kelli Crispin Business Analyst/Quality Assurance Specialist she/her/hers The University of North Carolina at Chapel Hill Office of University Development 208 W. Franklin Street Chapel Hill, NC 27516 P 919.962.2815 E kelli.crispin@unc.edu<mailto:kelli.crispin@unc.edu> [cid:image001.png@01D383E6.0AC22A10] CAMPAIGN.UNC.EDU<http://campaign.unc.edu/> From: Advancement Services Discussion List <FUNDSVCS@LISTSERV.FUNDSVCS.ORG<mailto:FUNDSVCS@LISTSERV.FUNDSVCS.ORG>> On Behalf Of Eric Valdescaro Sent: Wednesday, January 30, 2019 3:00 PM To: FUNDSVCS@LISTSERV.FUNDSVCS.ORG<mailto:FUNDSVCS@LISTSERV.FUNDSVCS.ORG> Subject: Re: [FUNDSVCS] International Addresses in RE Aloha Dania, I haven't seen a reply come through yet, so I'll chime in. At my previous job I worked with RE for 11 years and had to tackle this exact same concern. As for RE: Under Configuration, in the International section, you’ll see five country address templates to choose from in the dropdown box for “Display available fields for this country.” (US, UK, Canada, Australia, and New Zealand). For any country that is not one of those, we almost always used UK. Someone may have mapped out a better usage for the country, but we found that UK worked best and you can also configure each of templates however you want. We configured the UK template to work for all European countries and other countries pretty well. Some countries will always have various address components that don’t play nicely, but you can enter those in the address lines. Remember that several nations have special characters in their alphabet such as (β, ϋ, é, etc.), so you’ll need to make a call on whether or not you want to use them or substitute with standard alphabet characters.. But as you mentioned before you begin entering, you may want to start a data entry procedures manual, and include a section on your standards for adding/updating international addresses. Then within that section break out standards by geographical regions. Several European countries share a format, as well as several South American countries, so it really doesn't need to be a country-by-country run down of standards. It’s been a while, but at the time we found that MelissaData has some helpful tools for global address verification. http://melissadata.com/eu/solutions/global-address-verification.htm As for free sites, Google Maps is an easy one to recommend. Before adding or changing international addresses, it’s a good idea to attempt to validate the address on Google Maps. Google Maps is not only comprehensive with many international addresses, it’s also clever at making sense from less than perfect addresses and it will often provide you with the full street name and postal code! Several countries have their own government associated postal address verification sites such as Royal Mail for the UK. to http://www.royalmail.com There are also free sites out there where companies and address wonks have generously donated their time to provide guidance such as Frank’s Compulsive Guide http://www.columbia.edu/~fdc/postal/ and BelightSoft http://www.belightsoft.com/products/resources/postal.php Hope this helps, aloha! Eric Eric F. Valdescaro AVP, Advancement Services University of Hawaii Foundation
Original Message----- From: Advancement Services Discussion List [mailto:FUNDSVCS@LISTSERV.FUNDSVCS.ORG] On Behalf Of Dania Calandrino Sent: Tuesday, January 29, 2019 1:00 PM To: FUNDSVCS@LISTSERV.FUNDSVCS.ORG<mailto:FUNDSVCS@LISTSERV.FUNDSVCS.ORG> Subject: [FUNDSVCS] International Addresses in RE Hello Everyone! I need to clean up international addresses in Raiser's Edge and was wondering if anyone who has done a similar project has any advice or success stories. I know we need to first establish our address formatting standards for each country and probably reconfigure some in RE. (We currently have addresses in about 130 countries.) And once everything is nice and clean, I'll want to do some training and auditing to try and keep it that way. If you've done any of this before, was there something that really worked well, or something that really didn't go as expected for you? Thank you all so much! Dania -- Dania Calandrino Data Integrity Specialist Department of Development Records The Art Institute of Chicago 111 S. Michigan Avenue Chicago, IL 60603 (e): dcalan@artic.edu<mailto:dcalan@artic.edu> This message (including any attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521. It is the property of the University of Hawaii Foundation. It may contain confidential information intended for a specific individual and purpose. If you are not the intended recipient, you must delete this message. You are hereby notified that any disclosure, copying, or distribution of this message is prohibited.