Check the data mapping between HESA and Register trainee teachers
Use the table to check how data maps between HESA and Register trainee teachers (Register) for the 2023 to 2024 academic year.
Where possible, these tables follow the same order as the CSV export and a trainee’s record in Register.
Register will check the URN (unique reference number) of each school to make sure it’s valid. If it’s not, this data will not import into Register.
| Register CSV column | Register field in the service | HESA field | More information |
|---|---|---|---|
| employing_school_urn | Employing school | SDEMPLOY (School Direct employing school) | – |
| lead_school_urn | Lead school | SDLEAD (School Direct lead school) | – |
| placement_one placement_two other_placements |
Placement details | PLMNTSCH (Placement school) | – |