|
Category: Social Media
|
Frequency: Monthly
|
Platform: SQL Server
|
Developer: IDS
|
Analyst: DMT
|
What Does It Do?
The OUD-DS3 best practice is for active individual constituent social media records to be of type ‘Personal’.
This integrity check identifies LinkedIn social media records that are missing a type so that the Personal type can be added.
How Is This Done?
This integrity check is run using a SQL Server view called [INTEGRITY_CHECKS].[dbo].[INTEGRITY_SOCIALMEDIA_Add Missing Account Type(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries LinkedIn records that do not have a type so that the value ‘Personal’ can be added.
Resources and References
DART Linkedin URL Best Practices and Audits - OUD, Integrated Data Services
S:\IDS\MES\SQL Scripts\DATA QUALITY\SOCIAL MEDIA
Snapshot GUID: BBDW.USR_DM_Cnst_Social_Media_Acct.USR_Cnst_Social_Media_Acct_Sys_Key