core_company table - Normalized Company Mapping Tab

[NPatel21]

Hi,

Can someone explain to me what it means when the company is normalized?

Is there a particular job that normalises the company in the table?

See attachment as an example

What is the best way to keep this table tidy and to avoid any duplicates?

Thank you

[Narsing1 · Accepted solution]

When you install Data services Normalization plugin and run through with the guided setup, it downloads the Normalized company names from servicenow repository. Once you complete all the related steps from the guided setup, it marks the Normalization flag to either true/false based on the common name.

Example

Normalized company name = Microsoft Corporation

Core Company  has "Microsoft", "Microsoft Corporation"

It marks Microsoft Corporation as Normalized and update all the references where ever using the "Microsoft" as "Microsoft Corporation"

To your other query, how to avoid duplicate, once you install this plugin, it automatically controls all unwanted Company / Manufacturer names not to show in any other references.  You may see the unwanted companies only in core_company table, but it is of no use and can be deleted over a period of time.  

Thanks,

Narsing

[iamkurt]

@Narsing1 - How do we check if the data normalization plugin has been installed?

[NeenaPatel]

Hi @iamkurt 

You can check via the plugin store - System Upgrades View: Plugin Installation History | ServiceNow Production . 

Above link is pre prod.

The plugin name is com.glide.data_services_canonicalization.client

If you search for this plugin in the store you will see the below if installed. 

Thanks

Neena

[Narsing1]

Hi @iamkurt - On the filter navigator, you can type "Data services" and you will see like this.

Thanks,

Narsing