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.