You can accomplish this by using File 170 from the standard Mosaic Data Migration scripts.
The guidance has been updated to cover the loading of Worker references into the MO_SUBJECT_REFERENCES database table.
The required fields are:
WORKER_ID - the id of the worker and must already exist in Mosaic.
REFERENCE_TYPE_CODE - the Reference Type code for the Social Worker England Registration Number (in Configuration tools -> Reference data -> Worker reference types).
REFERENCE - the Social Worker England Registration Number.
START_DATE - system date/date of data load.
IS_VERIFIED - N
Hosted customers please raise a support case to request a one off load of this data or ask that this is carried out as part of your next Mosaic upgrade.
On premise customers, please raise a support case to request the download link for the Data Migration scripts compatible with your Mosaic version if you don't already have the required version.
The following queries can be used to compare the version of the migration procedures and the Mosaic schema version:
SQL Server
Select 'mosaic schema version: ', mosaic_schema_upgrader.current_schema_version()
union
SELECT 'Migration procedure version: ', substring(m.definition,charindex('* Version:', m.definition)+11,10)
FROM sys.sql_modules m
INNER JOIN
sys.objects o
ON m.object_id = o.object_id
WHERE lower(o.name) = lower('File_170_Subject_References')
Oracle
Select 'mosaic schema version: ', mosaic_schema_upgrader.current_schema_version()
from dual
union
SELECT 'Migration procedure version: ',replace(text, '* VERSION: ','')
from all_source src
where src.name = 'MOSAIC_MIGRATION'
and text like ' * VERSION: %'
and rownum = 1