PAPBSGBH_13_P

HESA: Person table (2012/13 onwards) | #transactional | Component: null
Column Name Description
MANDT Client
HYEAR Year
PERNR Personnel Number
Column Name Description
Column Name Description
Column Name Description
AEDTM Last Changed On
ATIME Time
BIRTHDATE Date of Birth
DATEFHEI Date appointed at current higher education provider
DATELEFT HESA: Date left a HESA returnable appointment
YEAR_ENDDA Date
GOVSD HESA: Start Date of Governor Status
GOVED HESA: Actual End Date of Governor Status
GOVEE HESA: Expected End Date of Governor Status
Column Name Description
DISABLE HESA: Disability1 Show values
ECRSTAT HESA: Early career researcher status Show values
SEX Gender Key Show values
GOVNR HESA: Governor Show values
Column Name Description Domain name
UNAME Name of Person Who Changed Object USNAM
RECID HESA: Record type indicator NUMC5
UKPRN HESA: Institution Code CHAR8
STAFFID HESA staff ID CHAR13
OWNSTAFFID HESA: Own Internal Staff Identifier CHAR20
ABLWELSH HESA: Ability to teach through the medium of Welsh
ACTCHQUAL1 HESA: Academic teaching qualification
ACTCHQUAL2 HESA: Academic teaching qualification
ACTCHQUAL3 HESA: Academic teaching qualification
ACTCHQUAL4 HESA: Academic teaching qualification
ACTCHQUAL5 HESA: Academic teaching qualification
ACTCHQUAL6 HESA: Academic teaching qualification
ACTLEAVE HESA: Activity after leaving
CLINARD HESA: Clinical excellence award
CURACCDIS1 HESA: Code for Academic Discipline P08_HESA_ACD
CURACCDIS2 HESA: Code for Academic Discipline P08_HESA_ACD
ETHNIC HESA: Ethnicitiy code
GENDERID HESA: Gender Identity
HQHELD Highest Qualification Held
LOCLEAVE HESA: Location after leaving
NATION HESA: Nationality CHAR2
NATIOND1 HESA: National Identity
NATIOND2 HESA: National Identity
PARLEAVE HESA: Parental Leave
PREVEMP Previous Employment
PREVHEI HESA: Institution ID P08_HESA_INSTID
REFUOA2014 HESA: Unit of Assessment P08P_HESA_UOA
REGBODY1 HESA: Regulatory body (clinical)
REGBODY2 HESA: Regulatory body (clinical)
RELBLF HESA: Religion or Belief
RESAST HESA: Research Assistant
SEXORT HESA: Sexual Orientation
ORCID HESA: Open Researcher and Contributor ID CHAR16
CURACCDIS3 HESA: Code for Academic Discipline P08_HESA_ACD
PARLEAVE_2 HESA: Parental Leave
PARLEAVE_3 HESA: Parental Leave
GENRA HESA: Gender Reassignment CHAR1
SEXID HESA: Sexual Identification CHAR1
REFUOA2021 HESA: Unit of Assessment P08P_HESA_UOA
HECOS1 HESA: Higher Education Classification of Subjects NUMC6
HECOS2 HESA: Higher Education Classification of Subjects NUMC6
HECOS3 HESA: Higher Education Classification of Subjects NUMC6
HECOS4 HESA: Higher Education Classification of Subjects NUMC6
HECOS5 HESA: Higher Education Classification of Subjects NUMC6