People | Trainee Email Address Data Quality

vwPerson.RecordType definition;

Staff=trainee
Contact=trainer
Both=Trainee and Trainer
Admin=HEE admin

select status, recordtype, case when emailAddress is null then 'NULL' ELSE 'NOT NULL' end em, count(*) as rc
from [HEELIVE].[vwPerson]
group by status, recordtype, case when emailAddress is null then 'NULL' ELSE 'NOT NULL' end
order by 1,2

Person by Status & RecordTYpe by EmailAddress

status	recordtype	emailAddress	rc
Current	Admin	NOT NULL	5367
Current	Admin	NULL	981
Current	Both	NOT NULL	24137
Current	Both	NULL	4851
Current	Contact	NOT NULL	11134
Current	Contact	NULL	2941
Current	Staff	NOT NULL	56530
Current	Staff	NULL	3191

People | Trainee Email Address Data Quality

0 Comments