A close-up view of a yellow rotary telephone.
Data Governance, SQL Scripting, The Museum System

Standardizing your Constituent Phone Numbers

Did you ever notice that American and Canadian phone numbers are both prefaced with the international calling code of “1”? This is because twenty countries, primarily in North America and the Caribbean, participate in the North American Numbering Plan (NANP). Let’s examine how these numbers are structured, establish standards for data entry and then apply …

Data Governance, SQL Scripting, The Museum System

Improving the Quality of your Constituent Addresses

Since we do not tend to include the country name when addressing domestic mail, users tend to forget to enter this into the Constituent address. Having the country specified can enable you to perform certain queries, such as what is the geographic distribution for outgoing loans in a given year, and enables better formatting of …