
File structures for downloadable files |
|
Version 1.0 Produced 2010-04-30
File Structure - DLHE target population (POPDLHE)
Files are produced in XML and fixed length format.
| Field name | Description | Element name in XML output | Field length |
| Student.HUSID | HESA unique student identifier | HUSID | 13 |
| Student.SURNAME | Family name | SURNAME | 100 |
| Student.FNAMES | Forenames | FNAMES | 100 |
| Student.OWNSTU | Institution's own identifier for student | OWNSTU | 20 |
| Course.CTITLE | Course title | CTITLE | 255 |
| Course.COURSEID | Course identifier | COURSEID | 30 |
| XQMODE01 | Qualification mode of study (1=Full-time, 2=Part-time) | XQMODE01 | 1 |
| QualificationsAwarded.QUAL | Qualification awarded | QUAL1 | 3 |
| QualificationsAwarded.QUAL | Qualification awarded 1 | QUAL2 | 3 |
| XOBTND01 | DLHE Highest qualification obtained. The highest entry where more than one occurrence is returned of QualificationsAwarded.QUAL | XOBTND01 | 3 |
| XQLEV301 | Level of qualification obtained (1=PG, 2=UG) | XQLEV301 | 1 |
| HOMEEU | Home/ Other EU flag (1=Home, 2=Other EU) | HOMEEU | 1 |
| Course.TTCID | Teacher training course | TTCID | 1 |
| Instance.RCSTDNT | Research Council student | RCSTDNT | 2 |
| Instance.NUMHUS | Student Instance identifier | NUMHUS | 20 |
| CENSUS | Census (APR / JAN) | CENSUS | 3 |
| Instance.OWNINST | Institution's own instance identifier | OWNINST | 30 |
1If only one qualification exists the second qualification field will be blank
Download: XML Schema for DLHE target population (POPDLHE) file. Sample XML for DLHE target population (POPDLHE) file.
Example XML file:
<?xml version="1.0" encoding="utf-8"?> <DLHEREPORT> <DLHEROWS> <DLHEROW> <HUSID>0000029921792</HUSID> <SURNAME>BLOGGS</SURNAME> <FNAMES>JOE</FNAMES> <OWNSTU>120140/1/02</OWNSTU> <CTITLE>Aerospace Vehicle Design</CTITLE> <COURSEID>MSAVDFTC/1/A/AVDF 09758</COURSEID> <XQMODE01>1</XQMODE01> <QUAL1>M00</QUAL1> <QUAL2/> <XOBTND01>M00</XOBTND01> <XQLEV301>1</XQLEV301> <HOMEEU>1</HOMEEU> <TTCID>0</TTCID> <RCSTDNT>99</RCSTDNT> <NUMHUS>01</NUMHUS> <CENSUS>JAN</CENSUS> <OWNINST>A0201/7864234234778678</OWNINST> </DLHEROW> <DLHEROW> <HUSID>0000053312345</HUSID> <SURNAME>OTHER</SURNAME> <FNAMES>ANN</FNAMES> <OWNSTU>433102/1/02</OWNSTU> <CTITLE>Full-time MBA Programme</CTITLE> <COURSEID>MBFTMFTC/1/A/MBAF 09664</COURSEID> <XQMODE01>1</XQMODE01> <QUAL1>M00</QUAL1> <QUAL2/> <XOBTND01>M00</XOBTND01> <XQLEV301>1</XQLEV301> <HOMEEU>1</HOMEEU> <TTCID>0</TTCID> <RCSTDNT>99</RCSTDNT> <NUMHUS>01</NUMHUS> <CENSUS>APR</CENSUS> <OWNINST>A0201/786786/76778678</OWNINST> </DLHEROW> </DLHEROWS> </DLHEREPORT>Contact Institutional Liaison: liaison@hesa.ac.uk, tel 01242 211144