Re-Queue Questionnaires for Sending Upstream

Creation date: 8/27/2026 3:45 PM Updated: 8/27/2026 3:45 PM

Step 1: Use the following query to receive the commands needed to requeue questionnaires (update CompletedDate and AssignedToPatientID)

select 'exec [Equicare].[usp_RequeueOutboundQuestionnaire] @PtAssignedQuestionnaireId = ' + CAST(PtAssignedQuestionnaireID AS NVARCHAR(60))

FROM Equicare.UT_PtAssignedQuestionnaire where CompletedDate >= '2026-08-20 00:00:00.090' and AssignedToPatientID='PatientID'

Step 2: Execute all lines in the output of the query to re-queue and send