Editing Migrating Aiga records (section)

====Attachments====
<syntaxhighlight lang="sql" line>
select
	right(DocumentPath,len(DocumentPath)-12) as FileName,
	null as DisplayName,
	DocumentTypeID as ActivityId, --internal AIGA document type id
	n.ClientID as ClientId, --internal AIGA client id
	Comments as Notes

from vClientNotesDocuments n
join
vEpisodeContracts ec
on n.EpisodeContractID = ec.EpisodeContractID
join
vClients c
on n.ClientID = c.ClientID
join
vStaffMember s
on n.UserID = s.StaffMemberID

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

Note that the list of attachments this SQL provides should be consistent with the actual attachments corpus provided to Kotahi - ie, file names should match so they can be allocated to the right client and service.