Add Missing Type to Sites

What Does It Do?

The OUD-DS3 best practice is for all sites to have a type so that they can correctly be pulled into constructed site rollups.

This integrity check identifies sites without a type so that a type can be added. 

How Is This Done?

This integrity check is run using a SQL Server view called [INTEGRITY_CHECKS].[dbo].[IDS.V-INTEGRITY CHECK-SITE-Add Missing Type to Sites(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.

That view queries sites where the site type is blank. 

These will need to be manually reviewed against the UM site hierarchy, but the most common site type is Department.

Resources and References

S:\IDS\MES\SQL Scripts\DATA QUALITY\SITE\

Snapshot GUID: BBDW.DIM_Site.SiteSystemID