Monitoring Send Progress

The Data Send works on a per-PID basic (compared to the Demographics Send which works on per UKRDCID).

Everytime all the data for a PID has been sent a file is created in the .responses/resume folder. This can be used to track the progress of the send.

The number of PIDs to be sent should correspond to the number of records in the following query.

SELECT COUNT(DISTINCT PID)
FROM
	extract.patientrecord
WHERE
	ukrdcid in (select ukrdcid from extract.vwe_pkb_members)
    AND
    sendingfacility = 'ABC123'
    AND
    sendingextract in ('UKRDC', 'PVMIG', 'PV')

The volume of messages to be sent will vary based on how much data they send, how long they’ve been participating in PV and whether or not they have transitioned to a UKRDC Feed.

The number of messages which have been successfully sent can be found in the .responses/success folder.

If you wanted to estimate the number of messages you could take a copy of the vwe_extract_pkb_updates View and remove all restrictions based on the eventcontrol date.