Data Dictionary/Schema
Table 1 - STAFF Specification
Field |
Type |
Expected values |
Mandatory |
Institution |
String |
Your HESA institution code |
Yes |
HESAStaffIdentifier |
String |
<13 characters> |
Yes (for Cat A and B staff) |
InstitutionalStaffIdentifier |
String |
<24 characters> |
Yes |
UnitOfAssessment |
Integer |
1-67 |
Yes |
Unit, department, school or other location |
String |
<Unlimited> |
|
Title |
String |
<50 characters> |
|
First name |
String |
<100 characters> |
|
Other first-names |
String |
<500 characters> |
|
Initials |
String |
<50 characters> |
Yes |
LastName |
String |
<500 characters> |
Yes |
Alternative or prior surname(s) |
String |
<500 characters> |
|
Alias or 'known as' for publications |
String |
<100 characters> |
|
e-mail address |
String |
320 |
Yes |
Eligible for the 2008 RAE |
Boolean |
True/false |
Yes |
Submitted to 2008 RAE |
Boolean |
True/false |
Yes (for all RAE eligible staff) |
RAE staff category |
Character |
A, B, C, D |
Yes (for all RAE eligible staff) |
Early career researcher |
Boolean |
True/false |
Yes |
Start date (if started after 2001-01-01) |
Date |
2001-01-01 to 2007-10-31 |
Yes (if recruit) |
Prior institution (if started after 2001-01-01) |
String |
HESA institution code |
|
Leave date (if left before 2007-10-31) |
Date |
2001-01-01 to 2007-10-31 |
Yes (for Cat B and D) |
Destination institution |
String |
HESA institution code |
|
TABLE 2 - OUTPUT specification
Field |
Type |
For OutputType = 'D' |
Expected values |
RA2 field |
Mandatory |
Institution |
String |
|
HESA institution code (including campus code if applicable) |
Yes |
Y |
InstitutionalUniqueOutputId |
String |
|
<24 characters> |
Yes |
Y |
Year |
String |
|
2001-2007 |
Yes |
Y |
OutputType |
Character |
|
A-T, a-t |
Yes |
Y |
LongTitle |
Text |
Article Title |
Text |
Yes |
Y |
ShortTitle |
String |
Vol number / Edition |
<512 characters> |
Yes |
Y |
Pagination |
String |
pp |
<64 characters> |
Yes |
Y |
Publisher |
String |
FULL journal title |
<256 characters> |
Yes |
Y |
Editors |
String |
|
<256 characters> |
Yes |
|
ISBN |
String |
ISSN |
<24 characters> |
Yes |
|
PublicationDate |
Date |
M/Y or D |
2001-01-01to 2007-12-31 |
Yes |
|
DOI |
String |
|
<256 characters> |
Yes |
|
IsInterdisciplinary |
Boolean |
Default = no |
true/false |
Yes |
|
IsSensitive |
Boolean |
Default = no |
true/false |
Yes |
|
ListOfAllAuthors |
String |
|
<512 characters> |
No |
|
Indexed by Thomson Reuters (ISI)* |
Boolean |
|
true/false |
No |
|
Thomson unique identifier (UT or ISI_LOC)* |
String |
|
<15 characters> |
No |
|
Indexed by SCOPUS* |
Boolean |
|
true/false |
No |
|
SCOPUS author identifier* |
String |
|
N/K |
No |
|
SCOPUS article identifier* |
String |
|
N/K |
No |
|
* To be included if known
Table 3 - STAFF-OUTPUT (author) links
Record all outputs for each staff ID, record all staff IDs for each output
Field |
Type |
Expected values |
Mandatory |
HESA Institution Code |
String |
Your HESA instcode |
yes |
HESA Staff Identifier |
String |
<13 characters> |
Yes |
Institution Staff Identifier |
String |
<24 characters> |
|
Institution Unique output ID |
String |
<24 characters> |
Yes |


