...
vwPerson.RecordType definition;
- Staff=trainee
- Contact=trainer
- Both=Trainee and Trainer
- Admin=HEE admin
| Code Block | ||
|---|---|---|
| ||
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 |