32:I[25609,["/_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"],"PdfSetViewer"] 34: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"] 35: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"] 36: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"] 2e:["$","span","The TbleUsers Schema (Download)",{"className":"inline-flex h-[22px] shrink-0 items-center gap-1.5 whitespace-nowrap rounded-[6px] px-2 text-xs font-medium border border-line bg-surface-alt text-charcoal-soft","children":"The TbleUsers Schema (Download)"}] 33:T84da,

This reference describes the Navigate export views available for MIS reporting. Each view summarises a different area of student, employer and placement data, with its purpose and the columns it returns.

Each export view below lists its key columns with their data type and a description of what each column holds. The full column list, lengths and required flags are in the attached document. Custom student attributes (StudentAttribute1 to StudentAttribute6) appear across most views.

Export_ActivitiesAggregated

Provides a summarised, aggregated view of a student's enrichment and employer engagement activities, useful for reporting on overall activity levels.

NavigateUserID (uniqueidentifier) – Unique identifier for the student user in Navigate.
StudentNumber (varchar) – Unique student identifier (from tblUsers).
StudentActive (bit) – Indicates if the student is currently active (1 = Active, 0 = Inactive).
TotalNumberOfActivities (int) – Total number of all activities (Enrichment + Employer Engagement) logged for the student.
TotalNumberOfHours (decimal (10,2)) – Total hours spent on all activities logged for the student.
EnrichmentActivities (int) – Total number of Enrichment activities logged.
EnrichmentHours (decimal (10,2)) – Total hours spent on Enrichment activities.
EmployerEngagementActivities (int) – Total number of Employer Engagement activities logged.
EmployerEngagementHours (decimal (10,2)) – Total hours spent on Employer Engagement activities.
CurrentYear_TotalNumberOfActivities (int) – Total number of activities logged in the current academic year.
CurrentYear_TotalNumberOfHours (decimal (10,2)) – Total hours spent on activities in the current academic year.
CurrentYear_EnrichmentActivities (int) – Total number of Enrichment activities logged in the current academic year.
CurrentYear_EnrichmentHours (decimal (10,2)) – Total hours spent on Enrichment activities in the current academic year.
CurrentYear_EnrichmentHoursTarget (decimal (10,2)) – The target number of Enrichment hours for the current academic year.
CurrentYear_EmployerEngagementActivities (int) – Total number of Employer Engagement activities logged in the current academic year.
CurrentYear_EmployerEngagementHours (decimal (10,2)) – Total hours spent on Employer Engagement activities in the current academic year.
CurrentYear_EmployerEngagementHoursTarget (decimal (10,2)) – The target number of Employer Engagement hours for the current academic year.
StudentAttribute1 (varchar) – Student's Custom Attribute 1.
StudentAttribute2 (varchar) – Student's Custom Attribute 2.
StudentAttribute3 (varchar) – Student's Custom Attribute 3.
StudentAttribute4 (varchar) – Student's Custom Attribute 4.
StudentAttribute5 (varchar) – Student's Custom Attribute 5.
StudentAttribute6 (varchar) – Student's Custom Attribute 6.

Export_ActivitiesDetailed

Provides a record-by-record export of all student activities logged in Navigate, including detailed feedback and Compass/Gatsby benchmark results.

NavigateUserID (uniqueidentifier) – Unique identifier for the student user in Navigate.
StudentNumber (varchar) – Unique student identifier (from tblUsers).
StudentActive (bit) – Indicates if the student is currently active.
TutorFirstName (varchar) – First name of the student's Primary Tutor.
TutorLastName (varchar) – Last name of the student's Primary Tutor.
EmployerOrNonEmployer (varchar) – Categorises the activity (e.g., 'Employer' or 'Non-Employer').
ActivityType (varchar) – The high-level type of activity.
ActivityTitle (varchar) – The name/title of the activity.
StudentFoundUseful (varchar) – Student's feedback on how useful the activity was.
ActivityDateTime (datetime) – The date and time the activity took place.
Location (varchar) – The location where the activity took place.
HoursAttended (decimal (10,2)) – The number of hours the student attended.
SkillsDeveloped (varchar) – Notes on the skills the student developed.
StudentAttribute1 (varchar) – Student's Custom Attribute 1.
StudentAttribute2 (varchar) – Student's Custom Attribute 2.
StudentAttribute3 (varchar) – Student's Custom Attribute 3.
StudentAttribute4 (varchar) – Student's Custom Attribute 4.
StudentAttribute5 (varchar) – Student's Custom Attribute 5.
StudentAttribute6 (varchar) – Student's Custom Attribute 6.
ActivityID (uniqueidentifier) – Unique identifier for the activity record.
DateAdded (datetime) – Date the activity record was added to the system. Compass Question.
Compass Question 1.1 (int) – Response to Compass/Gatsby Question 1.1, through to Question 8.2 (one column per Compass question).
Benchmark 1 (bit) – Gatsby Benchmark 1 status, through to Benchmark 8 (one column per Gatsby Benchmark; 1 = Met, 0 = Not Met).

Export_AssessmentResults

Details the results of specific skills assessments completed by a student, providing scores for various competencies.

NavigateUserID (uniqueidentifier) – Unique identifier for the student user in Navigate.
StudentNumber (varchar) – Unique student identifier (from tblUsers).
StudentActive (bit) – Indicates if the student is currently active.
DateOfAssessment (date) – The date the assessment was completed.
Leadership (int) – Score achieved for the Leadership competency.
Enterprising (int) – Score achieved for the Enterprising competency.
Creativity (int) – Score achieved for the Creativity competency.
Confidence (int) – Score achieved for the Confidence competency.
Communication (int) – Score achieved for the Communication competency.
Collaboration (int) – Score achieved for the Collaboration competency. Time.
Time Management (int) – Score achieved for the Time Management competency. Staying.
Staying Positive (int) – Score achieved for the Staying Positive competency. Building.
Building Relationships (int) – Score achieved for the Building Relationships competency.
Teamwork (int) – Score achieved for the Teamwork competency. Speaking &.
Listening (int) – Score achieved for the Speaking & Listening competency. Being.
Being Independent (int) – Score achieved for the Being Independent competency. Problem.
Problem Solving (int) – Score achieved for the Problem Solving competency. Careers.
Careers Skills (int) – Score achieved for the Careers.
Financial Skills (int) – Score achieved for the Financial.
Digital Skills (int) – Score achieved for the Digital Skills competency. Critical.
Critical Thinking (int) – Score achieved for the Critical Thinking competency. Aiming.
Aiming High (int) – Score achieved for the Aiming High competency. Physical.
Physical Health (int) – Score achieved for the Physical Health competency. Customer.
Customer Service (int) – Score achieved for the Customer Service competency. Community and Social.
Social Action (int) – Score achieved for the Community and Social Action competency.
Resilience (int) – Score achieved for the Resilience competency. Online.
Online Relationships (int) – Score achieved for the Online Relationships competency. Managing.
Managing Stress (int) – Score achieved for the Managing Stress competency.
StudentAttribute1 (varchar) – Student's Custom Attribute 1.
StudentAttribute6 (varchar) – Student's Custom Attribute 6.
UserAssessmentID (uniqueidentifier) – Unique identifier for the completed assessment record.

Export_AssessmentsAggregated

Provides a summary of a student's assessment activity, including the number of completed assessments and the date of the most recent one.

NavigateUserID (uniqueidentifier) – Unique identifier for the student user in Navigate.
StudentNumber (varchar) – Unique student identifier (from tblUsers).
StudentActive (bit) – Indicates if the student is currently active.
NumberOfCompletedAssessments (int) – Total number of assessments completed by the student.
DateOfLastCompletedAssessment (date) – The date the most recent assessment was completed.
StudentAttribute1 (varchar) – Student's Custom Attribute 1.
StudentAttribute6 (varchar) – Student's Custom Attribute 6.

Export_Employers

Provides a detailed list of all employers, including their contact information and compliance status.

EmployerID (uniqueidentifier) – Unique identifier for the employer.
EmployerName (varchar) – Name of the employer.
AddressLine1 (varchar) – Employer's address line 1.
AddressLine2 (varchar) – Employer's address line 2.
AddressLine3 (varchar) – Employer's address line 3.
Town (varchar) – Employer's town or city.
County (varchar) – Employer's county.
Postcode (varchar) – Employer's postcode.
EmployerType (varchar) – Categorisation of the employer.
EmployerStatus (varchar) – Current status of the employer record.
EmployerInternalID (varchar) – The employer's internal reference code.
NumberOfContacts (int) – Total number of contacts associated with the employer.
NumberOfPlacements (int) – Total number of work placements conducted with this employer.
NextPlacement (date) – Date of the next scheduled placement with this employer.
ComplianceStatus (varchar) – Overall compliance status (e.g., Compliant, Non-Compliant).
ComplianceExpiryDate (date) – Date the compliance check expires.
ComplianceApprovalDate (date) – Date the compliance was approved.
HealthAndSafetyExpiryDate (date) – Date the Health & Safety check expires.
HealthAndSafetyApprovalDate (date) – Date the Health & Safety check was approved.
DateAdded (datetime) – Date the employer record was added.

Export_GatsbyBenchmarks

Exports the student's current attainment levels against the Gatsby Benchmarks, derived from their responses to the Compass questions.

NavigateUserID (uniqueidentifier) – Unique identifier for the student user in Navigate.
StudentNumber (varchar) – Unique student identifier (from tblUsers).
StudentActive (bit) – Indicates if the student is currently active.
TutorFirstName (varchar) – First name of the student's Primary Tutor.
TutorLastName (varchar) – Last name of the student's Primary Tutor. Compass Question.
Compass Question 1.1 (int) – Response to Compass/Gatsby Question 1.1, through to Question 8.2 (one column per Compass question).
Benchmark 1 (bit) – Gatsby Benchmark 1 status, through to Benchmark 8 (one column per Gatsby Benchmark; 1 = Met, 0 = Not Met).

Export_StaffUsers

Provides a list of all staff users registered in the Navigate system.

NavigateUserID (uniqueidentifier) – Unique identifier for the staff user in Navigate.
Forename (varchar) – Staff member's first name.
Surname (varchar) – Staff member's last name.
EmailAddress (varchar) – Staff member's email address.
JobTitle (varchar) – Staff member's job title.
DateLastLoggedIn (datetime) – The date and time the staff user last accessed the system.
Active (bit) – Indicates if the staff account is currently active (1 = Active, 0 = Inactive).

Export_TargetsAggregated

Presents a summarised view of a student's academic and personal targets, detailing overall progress.

NavigateUserID (uniqueidentifier) – Unique identifier for the student user in Navigate.
StudentNumber (varchar) – Unique student identifier (from tblUsers).
StudentActive (bit) – Indicates if the student is currently active.
TotalNumberOfTargets (int) – Total number of targets set for the student.
TargetsCompleted (int) – Number of targets successfully completed.
TargetsOutstanding (int) – Number of targets that are yet to be completed.
TargetsLate (int) – Number of targets completed or still outstanding past their due date.
StudentAttribute1 (varchar) – Student's Custom Attribute 1.
StudentAttribute6 (varchar) – Student's Custom Attribute 6.

Export_TargetsDetailed

Provides a record-by-record export of all targets set for students/staff, including completion and approval details.

NavigateUserID (uniqueidentifier) – Unique identifier for the student user in Navigate.
StudentNumber (varchar) – Unique student identifier (from tblUsers).
StudentActive (bit) – Indicates if the student is currently active.
TutorFirstName (varchar) – First name of the student's Primary Tutor.
TutorLastName (varchar) – Last name of the student's Primary Tutor.
TargetDueDate (date) – The date the target is due.
TargetName (varchar) – The title or name of the target.
TargetType (varchar) – The category or type of the target.
TargetStatus (varchar) – The current status of the target (e.g., Completed, Outstanding).
TargetOwnerFirstName (varchar) – First name of the staff member who owns the target.
TargetOwnerLastName (varchar) – Last name of the staff member who owns the target.
TargetCompletedDate (date) – The date the target was completed.
RequiresApproval (bit) – Indicates if the target requires staff approval to be marked as complete.
ApprovedDateTime (datetime) – Date and time the target was approved.
ApprovedByUserFirstName (varchar) – First name of the staff member who approved the target.
ApprovedByUserLastName (varchar) – Last name of the staff member who approved the target.
RejecetedDateTime (datetime) – Date and time the target was rejected (if applicable).
RejectedNotes (varchar) – Notes explaining why the target was rejected.
RejectedByUserFirstName (varchar) – First name of the staff member who rejected the target.
RejectedByUserLastName (varchar) – Last name of the staff member who rejected the target.
AssociatedActivities (int) – Number of activities linked to the target.
TotalActivityHours (decimal (10,2)) – Total hours of activities linked to the target.
StudentAttribute1 (varchar) – Student's Custom Attribute 1.
StudentAttribute6 (varchar) – Student's Custom Attribute 6.
TargetID (uniqueidentifier) – Unique identifier for the target record.

Export_WorkPlacementEmployerFeedback

Contains the feedback provided by the employer following the completion of a work placement.

PlacementID (uniqueidentifier) – Unique identifier for the work placement.
StudentNumber (varchar) – Unique student identifier.
EmployerName (varchar) – Name of the employer.
EmployerContactFirstName (varchar) – First name of the employer contact.
EmployerContactLastName (varchar) – Last name of the employer contact.
CoordinatorFirstName (varchar) – First name of the placement coordinator.
CoordinatorLastName (varchar) – Last name of the placement coordinator.
TutorFirstName (varchar) – First name of the student's Tutor.
TutorLastName (varchar) – Last name of the student's Tutor.
PlacementStartDate (date) – The start date of the placement.
PlacementEndDate (date) – The end date of the placement.
FeedbackReceivedDate (date) – The date the feedback was submitted by the employer.
PunctualityAndTimeKeeping (int) – Employer rating for Punctuality and Time Keeping.
PunctualityAndTimeKeepingNotes (varchar) – Employer's notes on Punctuality and Time Keeping.
RecommendToOthers (bit) – Employer would recommend offering placements to other students.
RecommendToOthersNotes (varchar) – Employer's notes on recommending to others.

Export_WorkPlacementsAggregated

Provides a summarised, aggregated view of a student's work placement history and hours.

NavigateUserID (uniqueidentifier) – Unique identifier for the student user in Navigate.
StudentNumber (varchar) – Unique student identifier.
StudentActive (bit) – Indicates if the student is currently active.
StudentPlacementStatus (varchar) – The student's overall placement status (e.g., Placed, Not Placed).
LatestPlacementStatus (varchar) – The status of the student's most recent placement.
TotalNumberOfPlacements (int) – Total number of placements recorded for the student.
TotalPlannedHours (decimal (10,2)) – Sum of all planned hours across all placements.
TotalScheduledHours (decimal (10,2)) – Sum of all scheduled hours across all placements.
TotalEmployerConfirmedHours (decimal (10,2)) – Sum of all hours confirmed by employers.
TotalStudentLoggedHours (decimal (10,2)) – Sum of all hours logged by the student.
TotalNumberOfJournalEntries (int) – Total number of journal entries related to placements.
TotalNumberOfPlacementsCompleted (int) – Total number of placements marked as complete.
CurrentYear_TotalNumberOfPlacements (int) – Total placements in the current academic year.
CurrentYear_EmployerConfirmedPlacementHoursTarget (decimal (10,2)) – Target hours to be confirmed by employers for placements in the current academic year.
CurrentYear_StudentConfirmedPlacementHoursTarget (decimal (10,2)) – Target hours to be confirmed by students for placements in the current academic year.
CurrentYear_TotalPlannedHours (decimal (10,2)) – Sum of all planned hours across all placements.
CurrentYear_TotalScheduledHours (decimal (10,2)) – Sum of all planned hours across all placements.
CurrentYear_TotalEmployerConfirmedHours (decimal (10,2)) – Sum of all planned hours across all placements.
CurrentYear_TotalStudentLoggedHours (decimal (10,2)) – Sum of all planned hours across all placements.
CurrentYear_TotalNumberOfJournalEntries (int) – Total number of journal entries related to placements.
CurrentYear_TotalNumberOfPlacementsCompleted (int) – Total completed placements in the current academic year.
StudentAttribute1 (varchar) – Student's Custom Attribute 1.
StudentAttribute6 (varchar) – Student's Custom Attribute 6.
ReasonForPlacementStatus (varchar) – Notes explaining the latest placement status.

Export_WorkPlacementsDaily

Details the scheduled and confirmed hours for each day of a student's work placement.

PlacementID (uniqueidentifier) – Unique identifier for the work placement.
NavigateUserID (uniqueidentifier) – Unique identifier for the student user.
StudentNumber (varchar) – Unique student identifier.
StudentActive (bit) – Indicates if the student is currently active.
PlacementStatus (varchar) – The current status of the placement.
TutorFirstName (varchar) – First name of the student's Tutor.
EmployerPostCode (varchar) – Employer's postcode.
PlacementType (varchar) – The type of placement.
LocationType (varchar) – Where the placement is taking place (e.g., In person, Virtual).
PlacementDayDate (date) – The date of the specific placement day.
PlacementDayStartTime (time) – The scheduled start time for the day.
PlacementDayEndTime (time) – The scheduled end time for the day.
PlacementDayScheduledHours (decimal (10,2)) – Scheduled hours for this specific day.
PlacementDayStudentConfirmedHours (decimal (10,2)) – Hours confirmed by the student for this day.
PlacementDayEmployerConfirmedHours (decimal (10,2)) – Hours confirmed by the employer for this day.
DailyNonFundableBreakTime (decimal (10,2)) – Non-fundable break time taken on this day.
DailyFundableTravelTime (decimal (10,2)) – Fundable travel time for this day.
TotalPlannedHours (decimal (10,2)) – Total planned hours for the overall placement.
TotalScheduledHours (decimal (10,2)) – Total scheduled hours for the overall placement.
ScheduledHoursToDate (decimal (10,2)) – Cumulative scheduled hours up to this date.
EmployerConfirmedHoursToDate (decimal (10,2)) – Cumulative employer confirmed hours up to this date.
StudentConfirmedHoursToDate (decimal (10,2)) – Cumulative student confirmed hours up to this date.
Completed (bit) – Indicates if the day is marked as completed (1 = Yes, 0 = No).
EmployerAttendanceConfirmation (bit) – Indicates if the employer has confirmed attendance for the day.
DateSignedOff (datetime) – Date the placement day was signed off.
SignedOffByFirstName (varchar) – First name of the person who signed off the placement day.
SignedOffByLastName (varchar) – Last name of the person who signed off the placement day.
StudentAttribute1 (varchar) – Student's Custom Attribute 1.
StudentAttribute6 (varchar) – Student's Custom Attribute 6.

Export_WorkPlacementsDetailed

Provides a full, detailed record for each work placement, including all associated metadata, compliance checks, and review dates.

PlacementID (uniqueidentifier) – Unique identifier for the work placement.
NavigateUserID (uniqueidentifier) – Unique identifier for the student user.
StudentNumber (varchar) – Unique student identifier.
StudentActive (bit) – Indicates if the student is currently active.
TutorFirstName (varchar) – First name of the student's Tutor.
TutorLastName (varchar) – Last name of the student's Tutor.
CoordinatorFirstName (varchar) – First name of the placement coordinator.
CoordinatorLastName (varchar) – Last name of the placement coordinator.
EmployerInternalReference (varchar) – The employer's internal reference code.
EmployerID (uniqueidentifier) – Unique identifier for the employer.
EmployerName (varchar) – Name of the employer.
EmployerAddressLine1 (varchar) – Employer's address line 1.
EmployerTown (varchar) – Employer's town.
EmployerPostCode (varchar) – Employer's postcode.
EmployerComplianceApprovalDate (date) – Date the employer compliance was approved.
EmployerCompliant (bit) – Indicates if the employer is marked as compliant.
EmployerContactTitle (varchar) – Title of the primary employer contact.
EmployerContactPhoneNumber (varchar) – Phone number of the primary employer contact.
PlacementStatus (varchar) – The current status of the placement.
PlacementType (varchar) – The type of placement.
LocationType (varchar) – Where the placement is taking place.
PlacementCreated (datetime) – Date the placement record was created.
InternalApprovalDate (date) – Date the placement was internally approved.
EmployerApprovalDate (date) – Date the placement was approved by the employer.
StartDate (date) – Scheduled start date of the placement.
EndDate (date) – Scheduled end date of the placement.
EmployerComplianceAnnexG (date) – Date Annex G of Employer Compliance was completed.
PlacementAgreementAnnexE (date) – Date Annex E of the Placement Agreement was completed.
InductionChecklist (date) – Date the Induction Checklist was completed.
InitialReview (date) – Date the Initial Review took place.
MidPointReview (date) – Date the Mid-Point Review took place.
FinalReviewAnnexHCompletionDeclaration (date) – Date the Final Review/Annex H Completion Declaration was completed.
DailyNonWorkingTime (decimal (10,2)) – Total daily non-working/break time for the placement.
PlannedHours (decimal (10,2)) – Total planned hours for the placement.
ScheduledHours (decimal (10,2)) – Total scheduled hours for the placement.
ScheduledHoursToDate (decimal (10,2)) – Cumulative scheduled hours up to the export date.
AuthorisedAbsenceHours (decimal (10,2)) – Total authorised absence hours.
EmployerConfirmedHours (decimal (10,2)) – Total hours confirmed by the employer.
StudentLoggedHours (decimal (10,2)) – Total hours logged by the student.
StudentJournalEntries (int) – Total number of student journal entries.
Completed (bit) – Indicates if the placement is marked as fully completed.
DateSignedOff (datetime) – Date the placement was signed off.
SignedOffByFirstName (varchar) – First name of the person who signed off the placement.
SignedOffByLastName (varchar) – Last name of the person who signed off the placement.
EmployerFeedbackReceived (bit) – Indicates if employer feedback has been received.
StudentFeedbackRecieved (bit) – Indicates if student feedback has been received.
StudentAttribute1 (varchar) – Student's Custom Attribute 1.
StudentAttribute6 (varchar) – Student's Custom Attribute 6.

Export_WorkPlacementStudentFeedback

Contains the feedback provided by the student following the completion of a work placement.

PlacementID (uniqueidentifier) – Unique identifier for the work placement.
StudentNumber (varchar) – Unique student identifier.
EmployerName (varchar) – Name of the employer.
EmployerContactFirstName (varchar) – First name of the employer contact.
EmployerContactLastName (varchar) – Last name of the employer contact.
CoordinatorFirstName (varchar) – First name of the placement coordinator.
CoordinatorLastName (varchar) – Last name of the placement coordinator.
TutorFirstName (varchar) – First name of the student's Tutor.
TutorLastName (varchar) – Last name of the student's Tutor.
PlacementStartDate (date) – The start date of the placement.
PlacementEndDate (date) – The end date of the placement.
FeedbackReceivedDate (date) – The date the feedback was submitted by the student.
PlacementExperience (int) – Student rating of the overall placement experience.
PlacementExperienceNotes (varchar) – Student's notes on the placement experience.
DevelopSkills (int) – Student rating of whether the placement helped develop skills.
DevelopSkillsNotes (varchar) – Student's notes on skills development.
SupportFromCollegeDuring (int) – Student rating of support from the college during the placement.
SupportFromCollegeDuringNotes (varchar) – Student's notes on college support during.
SupportFromCollegeBefore (int) – Student rating of support from the college before the placement.
SupportFromCollegeBeforeNotes (varchar) – Student's notes on college support before.
SupportFromEmployer (int) – Student rating of support from the employer.
SupportFromEmployerNotes (varchar) – Student's notes on employer support.
TrainingBefore (int) – Student rating of pre-placement training.
TrainingBeforeNotes (varchar) – Student's notes on pre-placement training.
PlacementTasks (int) – Student rating of the tasks performed.
PlacementTasksNotes (varchar) – Student's notes on placement tasks.
RecommendtoOthers (bit) – Student would recommend the placement to others.
RecommendtoOthersNotes (varchar) – Student's notes on recommending the placement.

Source document attached below.

2f:[false,["$","div",null,{"className":"space-y-4","children":[["$","$L32",null,{"links":[{"id":"47427032969","name":"The-TbleUsers-Schema-64f403","fileType":"pdf","href":"https://navigatehelp.freshdesk.com/helpdesk/attachments/47427032969"},{"id":"47427032970","name":"File 2","fileType":"file","href":"https://navigatehelp.freshdesk.com/helpdesk/attachments/47427032970"}],"documentBaseUrl":"/api/pdf-document?slug=navigate-export-views-schema-reference&role=staff","label":"Technical reference"}],false]}],false,["$","div",null,{"className":"article-body","dangerouslySetInnerHTML":{"__html":"$33"}}]] 30:["$","$L34",null,{"slug":"navigate-export-views-schema-reference","role":"staff"}] 31:["$","aside",null,{"className":"mt-12 lg:mt-0","children":["$","div",null,{"className":"lg:sticky lg:top-24 space-y-10","children":[["$","$L35",null,{}],["$","$L36",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"}]]}]}]