33:I[51060,["/_next/static/immutable/chunks/3w2-tt8ecm9mz.js","/_next/static/immutable/chunks/2i9bgs6t6hfua.js","/_next/static/immutable/chunks/0z-q5l1xa28vs.js","/_next/static/immutable/chunks/0kwz_u4_tz_5s.js","/_next/static/immutable/chunks/41l3031ny9poo.js"],"Helpful"] 34:I[58681,["/_next/static/immutable/chunks/3w2-tt8ecm9mz.js","/_next/static/immutable/chunks/2i9bgs6t6hfua.js","/_next/static/immutable/chunks/0z-q5l1xa28vs.js","/_next/static/immutable/chunks/0kwz_u4_tz_5s.js","/_next/static/immutable/chunks/41l3031ny9poo.js"],"TableOfContents"] 35:I[26800,["/_next/static/immutable/chunks/3w2-tt8ecm9mz.js","/_next/static/immutable/chunks/2i9bgs6t6hfua.js","/_next/static/immutable/chunks/0z-q5l1xa28vs.js","/_next/static/immutable/chunks/0kwz_u4_tz_5s.js","/_next/static/immutable/chunks/41l3031ny9poo.js"],"TrendingSidebar"] 32:T18c2,

Template scripts for keeping ProSolution student data in sync with Navigate. Includes an Update script that pushes changed records through, and a Deactivate script that switches off accounts no longer present in the export.

What these scripts do

These are template scripts ([ProSolutionReports].[dbo].[Navigate_StudentUpdate]) which take data from the NavigateStudentsExport view. There are two scripts:

Update script: Compares student data within ProSolution with Navigate by converting specific columns into a hash value. If the hash values are different, this means a change has occurred in ProSolution, and the student is passed through as an update to the Navigate database, resetting the Date Processed field.
Deactivate script: If the student does not show up in the NavigateStudentsExport, this script deactivates their account on Navigate, should they be found in the Navigate database.

Version: 1.0 | Created by: Navigate | Created date: 22/03/25 (Initial Development).

Important notes

Replace [Insert your specific college schema here] with your specific college schema name.
The hash comparison uses MD5: if any of the listed columns change, the hash value differs and the update is triggered.
DateProcessed is reset to NULL on both update and deactivate — this is important.
To deactivate an account, Active is set to 0.

Update script

UPDATE DEST --Destination
SET
	[StudentNumber] =  src.[StudentNumber]
	,[StudentFirstName] = src.[StudentFirstName]
	,[StudentSurname]	= src.[StudentSurname]
	,[StudentEmail]		= src.[StudentEmail]
	,[StudentUsername]	= src.[StudentUsername]
	,[TutorFirstName]	= src.[TutorFirstName]
	,[TutorSurname]		= src.[TutorSurname]
	,[TutorEmail]		= src.[TutorEmail]
	,[Attribute1]		= src.[Attribute1]
	,[Attribute1Code]	= src.[Attribute1Code]
	,[Attribute2]		= src.[Attribute2]
	,[Attribute2Code]	= src.[Attribute2Code]
	,[Attribute3]		= src.[Attribute3]
	,[Attribute3Code]	= src.[Attribute3Code]
	,[Attribute4]		= src.[Attribute4]
	,[Attribute4Code]	= src.[Attribute4Code]
	,[Attribute5]		= src.[Attribute5]
	,[Attribute5Code]	= src.[Attribute5Code]
	,[Attribute6]		= src.[Attribute6]
	,[Attribute6Code]	= src.[Attribute6Code]
	,[ExternalID]		= src.[StudentNumber]
	,[DateUpdated]		= GETDATE()
	,[DateProcessed]	= NULL -- Reset the date process field. Important.
	,[Active]			= src.[Active]
	,[EHCPStatus]		= src.[EHCPStatus]
FROM [NAVIGATE].[Navigate_ExternalFeeds].[Insert your specific college schema here].[tblUsers] AS DEST --Destination
INNER JOIN (
	SELECT vSE.*
	FROM [NAVIGATE].[Navigate_ExternalFeeds].[Insert your specific college schema here].[tblUsers] as Nav --External Database
	LEFT JOIN [ProSolutionReports].[dbo].[vNavigateStudentsExport] as vSE
	ON -- Converts the below to MD5 hash as if any change to columns, the hash value is different and will trigger update.
	HashBytes('MD5', CONCAT(
				ISNULL(LTRIM(RTRIM(vSE.[StudentNumber])),'')
				,ISNULL(LTRIM(RTRIM(vSE.[StudentFirstName])),'')
				,ISNULL(LTRIM(RTRIM(vSE.[StudentSurname])),'')
				,ISNULL(LTRIM(RTRIM(vSE.[StudentEmail])),'')
				,ISNULL(LTRIM(RTRIM(vSE.[StudentUsername])),'')
				,ISNULL(LTRIM(RTRIM(vSE.[TutorFirstName])),'')
				,ISNULL(LTRIM(RTRIM(vSE.[TutorSurname])),'')
				,ISNULL(LTRIM(RTRIM(vSE.[TutorEmail])),'')
				,ISNULL(LTRIM(RTRIM(vSE.[Attribute1])),'')
				,ISNULL(LTRIM(RTRIM(vSE.[Attribute1Code])),'')
				,ISNULL(LTRIM(RTRIM(vSE.[Attribute1Code])),'')
				,ISNULL(LTRIM(RTRIM(vSE.[Attribute2])),'')
				,ISNULL(LTRIM(RTRIM(vSE.[Attribute2Code])),'')
				,ISNULL(LTRIM(RTRIM(vSE.[Attribute3])),'')
				,ISNULL(LTRIM(RTRIM(vSE.[Attribute3Code])),'')
				,ISNULL(LTRIM(RTRIM(vSE.[Attribute4])),'')
				,ISNULL(LTRIM(RTRIM(vSE.[Attribute4Code])),'')
				,ISNULL(LTRIM(RTRIM(vSE.[Attribute5])),'')
				,ISNULL(LTRIM(RTRIM(vSE.[Attribute5Code])),'')
				,ISNULL(LTRIM(RTRIM(vSE.[Attribute6])),'')
				,ISNULL(LTRIM(RTRIM(vSE.[Attribute6Code])),'')
				,ISNULL(LTRIM(RTRIM(CONVERT(varchar(10), vSE.[Active]))),'')
				,ISNULL(LTRIM(RTRIM(vSE.[EHCPStatus])),'')
				)) !=
	HashBytes('MD5', CONCAT(
				ISNULL(LTRIM(RTRIM(Nav.[StudentNumber])),'')
				,ISNULL(LTRIM(RTRIM(Nav.[StudentFirstName])),'')
				,ISNULL(LTRIM(RTRIM(Nav.[StudentSurname])),'')
				,ISNULL(LTRIM(RTRIM(Nav.[StudentEmail])),'')
				,ISNULL(LTRIM(RTRIM(Nav.[StudentUsername])),'')
				,ISNULL(LTRIM(RTRIM(Nav.[TutorFirstName])),'')
				,ISNULL(LTRIM(RTRIM(Nav.[TutorSurname])),'')
				,ISNULL(LTRIM(RTRIM(Nav.[TutorEmail])),'')
				,ISNULL(LTRIM(RTRIM(Nav.[Attribute1])),'')
				,ISNULL(LTRIM(RTRIM(Nav.[Attribute1Code])),'')
				,ISNULL(LTRIM(RTRIM(Nav.[Attribute1Code])),'')
				,ISNULL(LTRIM(RTRIM(Nav.[Attribute2])),'')
				,ISNULL(LTRIM(RTRIM(Nav.[Attribute2Code])),'')
				,ISNULL(LTRIM(RTRIM(Nav.[Attribute3])),'')
				,ISNULL(LTRIM(RTRIM(Nav.[Attribute3Code])),'')
				,ISNULL(LTRIM(RTRIM(Nav.[Attribute4])),'')
				,ISNULL(LTRIM(RTRIM(Nav.[Attribute4Code])),'')
				,ISNULL(LTRIM(RTRIM(Nav.[Attribute5])),'')
				,ISNULL(LTRIM(RTRIM(Nav.[Attribute5Code])),'')
				,ISNULL(LTRIM(RTRIM(Nav.[Attribute6])),'')
				,ISNULL(LTRIM(RTRIM(Nav.[Attribute6Code])),'')
				,ISNULL(LTRIM(RTRIM(CONVERT(varchar(10), Nav.[Active]))),'')
				,ISNULL(LTRIM(RTRIM(Nav.[EHCPStatus])),'')
				))
				AND vSE.[ExternalID] = Nav.[ExternalID]
				WHERE vSE.[ExternalID] IS NOT NULL -- Where student is stored in Navigate Table.
) src -- Source
ON src.[ExternalID] = DEST.[ExternalID]

Deactivate script

-- Deactivate Student Accounts
UPDATE Nav
SET
	 Nav.[DateProcessed] = null  -- Reset the date process field. Important.
	,NAV.[Active] = 0 -- Set to 0 to deactivate
FROM [NAVIGATE].[Navigate_ExternalFeeds].[Insert your specific college schema here].[tblUsers] as Nav
		LEFT JOIN [ProSolutionReports].[dbo].[vNavigateStudentsExport] as vSE
			ON vSE.[ExternalID] = Nav.[ExternalID]
WHERE
vSE.[ExternalID] IS NULL
AND NAV.[ExternalID] IS NOT NULL
AND NAV.[Active] = 1

Source document attached below.

2f:[false,["$","div",null,{"className":"space-y-4","children":[["$","a",null,{"href":"https://navigatehelp.freshdesk.com/support/solutions/articles/47001301394","target":"_blank","rel":"noopener noreferrer","className":"inline-flex items-center gap-2 px-5 py-2.5 text-white text-sm font-medium rounded-lg transition-colors","style":{"background":"#0F6E56"},"children":[["$","svg",null,{"width":20,"height":20,"viewBox":"0 0 24 24","fill":"none","stroke":"currentColor","strokeLinecap":"round","strokeLinejoin":"round","aria-hidden":true,"strokeWidth":2,"className":"$undefined","children":[["$","path",null,{"d":"M18 13v6a2 2 0 0 1-2 2H5a2 2 0 0 1-2-2V8a2 2 0 0 1 2-2h6"}],["$","polyline",null,{"points":"15 3 21 3 21 9"}],["$","line",null,{"x1":"10","y1":"14","x2":"21","y2":"3"}]]}],"Open / Download"]}],false]}],false,["$","div",null,{"className":"article-body","dangerouslySetInnerHTML":{"__html":"$32"}}]] 30:["$","$L33",null,{"slug":"prosolution-student-update-and-deactivate-script-templates","role":"staff"}] 31:["$","aside",null,{"className":"mt-12 lg:mt-0","children":["$","div",null,{"className":"lg:sticky lg:top-24 space-y-10","children":[["$","$L34",null,{}],["$","$L35",null,{"title":"You may also like","items":[{"id":"e249ed75-2e43-4659-8936-efcdba38d409","title":"Creating the SQL Server Agent Job for Student Export","slug":"creating-the-sql-server-agent-job-for-student-export","type":"guide","categorySlug":"mis-data","roles":["staff"],"tags":["Server_Agent_Job_Creation"],"media":"https://navigatehelp.freshdesk.com/support/solutions/articles/47001301353","thumbnail":"/category-artwork/2026-09-30/staff-mis-data.png","summary":"A SQL Server Agent script that creates a scheduled job to export student data to Navigate every night at midnight. The job runs the update and insert stored procedures in sequence. What the job does The script creates a SQL Server Agent job","videoGuide":false,"theme":"Students","popularity":0,"updatedAt":"2026-06-12T13:07:23Z"},{"id":"1cf98013-26e6-4fb0-93cb-5f6905478897","title":"MIS Guide: Connecting Your College MIS to Navigate via SQL","slug":"mis-guide-connecting-your-college-mis-to-navigate-via-sql","type":"pdf","categorySlug":"mis-data","roles":["staff"],"tags":["T Levels"],"media":"https://navigatehelp.freshdesk.com/support/solutions/articles/47001301367","thumbnail":"/category-artwork/2026-09-30/staff-mis-data.png","summary":"A complete guide for MIS and data teams (Pro Solution) on connecting your college MIS to Navigate via SQL, managing import tables, and building reports. Contents Connecting to SQL - whitelisting college IP, connecting college MIS to SQL, en","videoGuide":false,"theme":"SQL & integrations","popularity":0,"updatedAt":"2026-08-11T14:36:56Z"},{"id":"4e079ade-6fe1-4952-917a-a7a85c034f47","title":"Sample SQL Script for EBS","slug":"sample-sql-script-for-ebs","type":"form","categorySlug":"mis-data","roles":["staff"],"tags":["Sample SQL Script for EBS"],"media":"https://navigatehelp.freshdesk.com/support/solutions/articles/47001301414","thumbnail":"https://static.wixstatic.com/media/c23afe_34e50e9c8a8c4a8f9d9a20b0db9173f2~mv2.jpeg","summary":"This is a sample SQL script for colleges integrating EBS with Navigate. It shows how to build a feed of active learners and their tutors from EBS, and how a scheduled SQL job keeps the Navigate tblUsers table in sync each day. Key points Na","videoGuide":false,"theme":"SQL & integrations","displayFormat":"Script","popularity":0,"updatedAt":"2026-06-12T13:07:27Z"},{"id":"5a534349-fcc2-4de3-bc16-3cc86b6d653a","title":"Sample Linked Server Script","slug":"sample-linked-server-script","type":"form","categorySlug":"mis-data","roles":["staff"],"tags":["Sample Linked Server Script"],"media":"https://navigatehelp.freshdesk.com/support/solutions/articles/47001301368","thumbnail":"https://static.wixstatic.com/media/c23afe_a9ac0f51367a40a9b6f2ddb569c4e05a~mv2.jpeg","summary":"A sample SQL script for adding Navigate as a linked server, allowing your college MIS to connect to the Navigate external feeds database. Replace USERNAME_HERE and PASSWORD_HERE with your own connection credentials before running the script","videoGuide":false,"theme":"SQL & integrations","displayFormat":"Script","popularity":0,"updatedAt":"2026-06-12T13:07:24Z"},{"id":"6aa6403b-1cbf-47a5-b43b-50afd2b4a9b4","title":"ProSolution Student Export View (Template)","slug":"prosolution-student-export-view-template","type":"form","categorySlug":"mis-data","roles":["staff"],"tags":["StudentExport_View"],"media":"https://navigatehelp.freshdesk.com/support/solutions/articles/47001301415","thumbnail":"https://static.wixstatic.com/media/77f784_c5929cdc5fe843b29cccd604efce906a~mv2.png","summary":"This is a template Navigate view for colleges running ProSolution. It provides the basic student, tutor and attribute data required for Navigate's external database, and is intended as a starting point that you adapt to your own college's d","videoGuide":false,"theme":"Students","popularity":0,"updatedAt":"2026-06-12T13:07:27Z"}],"role":"staff"}]]}]}]