Skip to main content
Unstructured Parent Company Data

When company names can't be standarized

Melisa Smith avatar
Written by Melisa Smith
Updated over 2 months ago

During onboarding, one of the processes your association will review is the concept of the Parent-Child relationship in Novi. Simply put, this means that you can have one record for ABC Company (for example), and staff records or other sub-companies underneath that record.

Most of the time, it makes sense to standardize company names to 1) have cleaner data and 2) utilize the benefits of the Parent-Child relationship in Novi.

What do we mean by standardized?

If you have data that looks like this:

  • ABC Company

  • ABC Co.

  • The ABC Company

Even though those may technically be the same company, there is no way for the system to know that, since the names are different.

This would end up being three separate company records in the system unless your team cleans these differentiations up prior to data import - OR - in certain circumstances, chooses to forgo the typical Parent Member field and uses an unstructured custom field instead.

What do we mean by unstructured?

By unstructured, we just mean that this info would come in as a plain text field, and not a dropdown for members to choose a company from a pre-existing list.

If you're considering using the custom field route, you'll want to discuss this with your onboarding specialist. In the meantime, review the list below for some implications of going the unstructured route:

What should be considered when choosing between structured and unstructured parent company data?

Before importing data, it's important to discuss the following considerations with your team. If you decide to use unstructured data (such as a plain text custom field), the points below will apply to your site.

(Please note that this list is not exhaustive, and there may be other considerations not mentioned.)

  • Your data will continue with the unstructured names spelled differently moving forward.

  • This makes reporting more of a challenge. You wouldn't be able to quickly see which members from a certain company are in the report.

  • Also, QuickBooks Online does not allow two members with the same name (unless they are connected to different parents). So two different people named John Smith would need to be differentiated in name, whether that's with a middle name or a - 1, - 2, etc. numbering system.

  • Individuals would not be able to see a dropdown list of their related team members during event registration.

  • Individuals would not be able to create invoices billed to their company.

  • As an admin, you would be able to see individual's transactions on their own records, but would not be able to view everyone's transactions quickly on the company level.

  • Likewise, a company's primary or billing contact would not be able to see/pay invoices for individuals, or add/remove people from their staff list.

  • On the member directory, the member preview badge would not show a company name (though it could be inside the actual profile).

  • Integration partners would need to be made aware that they wouldn't use the Parent Member field for this information.

Did this answer your question?