31:I[74874,["/_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"],"PdfViewer"] 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:T2188,

This reference describes the four MIS import tables Navigate provides, with the full column schema for each. Use these tables to bulk add and maintain learners, activities, employers and student groups.

tblActivities

Allows colleges to bulk add activities to Navigate.

LearnerUserName — varchar(150), required. The learner's username as stored in Navigate (tblUsers); must be valid or the row will fail.
ActivitySubType — varchar(255), required. Must match a valid sub type on your site or the row will fail.
ActivityName — varchar(255), required. The activity title/name.
ActivityDescription — varchar, unlimited, optional. The activity details/description.
EmployerActivity — bit, required. Specifies the activity type: TRUE for employer activity, otherwise enrichment.
Location — varchar(100), optional. Name of the location where the activity took place.
TownCity — varchar(50), optional. Town or city where the activity took place.
ActivityDate — date, required. The date of the activity.
HoursSpent — int, optional. Number of hours spent on the activity.
DateAdded — datetime, optional. Defaults to current date and time.
DateUpdated — datetime, optional. Typically set when updating an existing record.
DateProcessed — datetime, optional. Must be NULL for records to be picked up.
DateFailed — datetime, optional. Set by the import routine if the row fails; must be NULL to reprocess.
ErrorMessage — varchar, unlimited, optional. Set by the import routine if the row fails.
ImportID — int, optional. Identity column, automatically generated.
ActivityID — uniqueidentifier, optional. The unique identifier for the activity record.
DeleteActivity — bit, optional. Set to 1 (TRUE) to logically delete the activity record.

tblEmployers

Allows colleges to bulk add employers to Navigate.

EmployerName — varchar(255), required.
AddressLine1-3 — varchar(255), optional.
TownOrCity — varchar(100), optional.
County — varchar(100), optional.
Postcode — varchar(20), optional.
Telephone — varchar(50), optional.
EmailAddress — varchar(255), optional.
Compliant — bit, required. 0 = FALSE, 1 = TRUE.
ComplianceExpiryDate / ComplianceApprovalDate — date, optional.
HealthAndSafetyExpiryDate / HealthAndSafetyApprovalDate — date, optional.
HealthAndSafetyNotes — varchar(MAX), optional.
NavigateEmployerID — uniqueidentifier, optional. The Navigate EmployerID to update if you have it; otherwise we match on EmployerName and Postcode and write the EmployerID back once processed.
InternalEmployerReference — varchar(50), optional. Their internal employer reference.
ContactTitle — varchar(50), optional.
ContactFirstName / ContactSurname — varchar(100), optional.
ContactJobTitle — varchar(100), optional.
ContactEmail — varchar(255), optional.
ContactTelephone — varchar(50), optional.
Active — bit, required. 0 = FALSE, 1 = TRUE.
DateAdded — datetime, optional. Auto-populated on insert.
DateUpdated — datetime, optional. Typically set to GETDATE() when the record is updated.
DateProcessed — datetime, optional. Must be NULL for the record to be processed.
ImportID — int, optional. Auto-populated identity column.
NavigateEmployerContactID — uniqueidentifier, optional. The Navigate Employer Contact ID.
DateFailed — datetime, optional. Set by the import routine if the row fails.
ErrorMessage — varchar, unlimited, optional. Set by the import routine if the row fails.
InternalEmployerContactReference — varchar(50), optional. An internal reference for the employer contact.

tblStudentGroups

Allows colleges to create student groups. Useful when you have students that need to be attached to multiple groups.

StudentGroupName — varchar(255), required. This data must not be edited; editing creates a duplicate Student Group that can't be removed using SQL.
GroupOwnerUsername — varchar(255), required. Ensure this aligns with the username format in your system.
StudentUsername — varchar, required. Students must be live on the Navigate platform or an error will occur.
AddOrRemove — bit, required. Takes values A (Add) or R (Remove).
DateAdded — datetime, optional. Auto-populated on insert with the current timestamp.
DateUpdated — datetime, optional. Auto-updated on record modification.
DateProcessed — datetime, optional. Must be NULL for the record to be processed.
Outcome — varchar, optional. Any errors will be reported here.
ImportID — int, optional. Auto-populated identity column.
DeleteStudentGroup — bit, required. Set to 1 (TRUE) to logically delete the entire student group record.

tblUsers

Lists every learner that has a Navigate account, including their attributes 1-6. This is where MIS teams add or remove learners and edit existing learner records to be updated on Navigate. Example attributes include department, course, level, gender, ethnicity and SEND.

StudentNumber — varchar(225), required. Unique student identifier used across Navigate and imports.
StudentFirstName — varchar(225), required. Student's given/first name.
StudentSurname — varchar(225), required. Student's family/last name.
StudentEmail — varchar(225), required. College email address.
StudentUsername — varchar(225), required. Must match the email address; used for SSO.
TutorFirstName — varchar(225). Primary tutor's first name. Cannot be NULL.
TutorSurname — varchar(225). Primary tutor's last name. Cannot be NULL.
TutorEmail — varchar(225). Primary tutor's email address. Cannot be NULL.
Attribute1-6 — varchar(225), optional. Custom attribute fields (site-defined).
Attribute1-6Code — varchar(225), optional. Code corresponding to each attribute.
ExternalID — varchar(225), optional. External reference to link a record back to your system.
DateAdded — datetime, optional. Defaults to the current date/time when the record is created.
DateUpdated — datetime, optional. Updated when the record is modified.
DateProcessed — datetime, optional. Set to NULL to be processed; populated once the record has been picked up.
Active — bit, required. 1 = Active, 0 = Inactive.
ImportID — int, optional. Auto-populated identity column on import.
EHCPStatus — varchar(225), optional. Indicates if the student has an Education, Health & Care Plan. Must be ACTIVE, CLOSED, or left as NULL (no action).
DateFailed — datetime, optional. Populated if an import attempt failed.
ErrorMessage — varchar, unlimited, optional. Populated if the import fails, containing error details.

Source document attached below.

2e:[false,["$","div",null,{"className":"space-y-4","children":[["$","$L31",null,{"documentUrl":"/api/pdf-document?slug=navigate-mis-import-tables-column-schema-reference&role=staff","downloadUrl":"https://navigatehelp.attachments8.freshdesk.com/data/helpdesk/attachments/production/47427035026/original/MIS-Import-Tables-Guide-9c4353.pdf?response-content-type=application%2Fpdf&Expires=1791832843&Signature=fa0yWtKJGU9dh~GmeAyTtfia4Y6Of-8hQYt1Zc0waYeeE8x~7vjTmNqaKnZNaEO6NxfihuaXPY-MpSuvQjG6~DVkx-3pJxapKlbynI-iraZ7wM3l7ZC7s0W1C3~n-5ylXInZMm-f67yySvj12btXAlyjBl1ecMi-yS1LZk-Y3zSEiNofS-e6op~xrmeMsBg1QchfzTgwRpWvTQL7O9T7vB4ABvCsQulv5KSHHIbdPifkdl55f2i5~NIZN3ahqJoVBPS2J-SugqU7YMxX7t6H8jWTL~-4xWB21J3BN1PfWjraWM5vAVlFgSaU3JNbKNG9UKaA5mmkoihXccViAcjqaA__&Key-Pair-Id=APKAJ7JARUX3F6RQIXLA","label":"Technical reference"}],false]}],false,["$","div",null,{"className":"article-body","dangerouslySetInnerHTML":{"__html":"$32"}}]] 2f:["$","$L33",null,{"slug":"navigate-mis-import-tables-column-schema-reference","role":"staff"}] 30:["$","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"}]]}]}]