Engage
This table provides a comprehensive reference for preparing your data correctly to ensure a smooth upload process.
Field Name | Required | Instructions | Example |
Student ID* | Yes | Unique identifier for each student | 122345 |
First Name | Yes | Student's first name | Alice |
Last Name | Yes | Student's last name | Brown |
Mobile Phone** | Yes | Student's mobile phone number | 0776554433 |
Email Address | Yes | Student's email address | |
Stage | Yes | Select from: Applied, Interviewing, Offered, Accepted, Enrolled, Inducted, Withdrawn | Applied |
Term | Yes | Use only: Autumn 2024 or Autumn 2025 | Autumn 2024 |
Curriculum Area | Yes | The area of study | Mathematics |
Course Title | Yes | The specific course title | Maths Level 3 |
Event Date*** | No | Date of the event (for WhatsApp messages) | 14/11/22 |
Event Time*** | No | Time of the event (for WhatsApp messages) | 16:00 |
Event Location*** | No | Location of the event (for WhatsApp messages) | Purlos Campus |
Event Link*** | No | Link related to the event (for WhatsApp messages) |
* Student Eligibility: All students must be:
Full-time new applicants
Age group: 16-18
New applicant (not progressing)
Enrolling for Autumn 2024
** Duplicates and De-duplication:
Data must include all data points as listed in the table above
No duplicate entries are allowed, especially for Student ID and Mobile Phone
While you should aim to avoid duplicate entries in your CSV file, our platform has a built-in de-duplication feature.
By default, we de-duplicate learners based on the Mobile Phone field.
Upon request, this can be changed to use the Student ID field or a combination of fields.
If multiple rows in the CSV have the same data in the de-duplication field(s), only one record will be retained in our system.
*** Event Fields: Event Date, Time, Location, and Link are used specifically for WhatsApp messages related to a particular event. They serve as merge fields in the message sent to the learner.
Destination
Field Name | Required | Instructions | Example |
Student ID* | Yes | Unique identifier for each student | 3242344 |
First Name | Yes | Student's first name | Alice |
Last Name | Yes | Student's last name | Brown |
Mobile Phone** | Yes | Student's mobile phone number | 0776554433 |
Email Address | Yes | Student's email address | |
Stage *** | Yes | Use only: Progressed External | Progressed External |
Term | Yes | Use only: Autumn 2023 | Autumn 2023 |
SSA Tier 1 Description | Yes | Sector Subject Area Tier 1 Description | Arts, Media & Publishing |
Curriculum Area | Yes | The area of study | Hair & Beauty |
Course Title | Yes | The specific course title | Hairdressing Level 3 |
Campus/College | Yes | Name of the campus or college | Purlos College |
Age Group | Yes | Age group of the student | 16-18 |
Funding Type | Yes | Type of funding for the student. Please choose from
| AEB |
Destination at Enrolment *** | Yes | Learner's Destination Code before starting the course |
|
Gender | Optional | Student's gender |
|
Ethnicity | Optional | Student's ethnicity |
|
High Needs | Optional | Indicates if the student has high needs |
|
* Student Eligibility**:
All students must be full-time or part-time
All students must be from the same academic year (2024/2025)
All students must have left college
** Data Requirements:
Data must include all data points as listed in the table above
No duplicate entries are allowed, especially for Student ID and Mobile Phone
While you should aim to avoid duplicate entries in your CSV file, our platform has a built-in de-duplication feature.
By default, we de-duplicate learners based on the Mobile Phone field.
Upon request, this can be changed to use the Student ID field or a combination of fields.
If multiple rows in the CSV have the same data in the de-duplication field(s), only one record will be retained in our system.
*** Important Notes:
The 'Stage' field should only use "Progressed Internal" or "Progressed External"
Progressed Internal: Known destinations of learners who have progressed internally
Progressed External: Unknown destinations of learners who have progressed externally
The 'Term' field should only use "Autumn 2023" or “Autumn 2024”
Ensure the 'Destination at Enrolment' field is filled with the Learner's Destination Code before starting the course