Editing Migrating Aiga records (section)

====Users====
<syntaxhighlight lang="sql" line>
select
	distinct 
	s.UserID,
	s.EmailAddress as Email,
	s.Firstname,
	s.Surname as LastName,
	case
		when s.enabled = 1 then 'TRUE' --yes these are strings, SQL server doesn't have an actual boolean type 🤣
		else 'FALSE'
	end as Active
from vClientNotesDocuments n
join
vEpisodeContracts ec
on n.EpisodeContractID = ec.EpisodeContractID
join
vClients c
on n.ClientID = c.ClientID
join
vSec_Users s
on n.UserID = s.UserID

where 
ec.ContractID in (
68 --TTA contract
)
and
ec.EpisodeContractEndDate is null  --active TTA clients only
and
n.DocumentPath is null --not an attachment
</syntaxhighlight>

Note that table <code>vSec_Users</code> should be used rather than the <code>vStaffMember</code> view because the view does not offer what we need here.