PAPBSGB_HESA_P

HESA: Archive table for NISR Person table | #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
DATEHEI Date appointed at current higher education provider
DATELHEI HESA: Date left a HESA returnable appointment
Column Name Description
GENDER HESA: Gender code Show values
DISABLE HESA: Disabled Show values
DISABLE1 HESA: Disability1 Show values
DISABLE2 HESA: Disability2 Show values
Column Name Description Domain name
UNAME Name of Person Who Changed Object USNAM
RECID HESA: Record type indicator NUMC5
INSTID HESA: Institution ID P08_HESA_INSTID
STAFFID HESA staff ID CHAR13
NATION HESA: Nationality code P08_HESA_NATION
NATID1 HESA: National Identity (Wales only) P08P_HESA_NATID
NATID2 HESA: National Identity (Wales only) P08P_HESA_NATID
PREVHEI HESA: Institution ID P08_HESA_INSTID
ABLWELSH HESA: Ability to teach through the medium of Welsh
RESACT HESA: Active in 2001 Research Assessment Exercise P08P_HESA_RESACT2001
UOA HESA: Unit of Assessment P08P_HESA_UOA
TOTSAL HESA: Total monies paid NUM07
Master Data Relations | to Other Relations ↓ Join Conditions
Academic discipline
  • HESA: Code for Academic Discipline
  • Client
Academic disciplines
  • HESA: Code for Academic Discipline
  • Client
Ethnicity
Other Relations | to Master Data Relations ↑ Join Conditions
HESA: Destination on leaving
  • ?
  • Client
  • HESA: Destination on leaving
Previous employment
  • ?
  • Client
  • Previous Employment
Highest qualification held
  • Highest Qualification Held
  • ?
Regulatory body
  • ?
  • Client
  • HESA: Regulatory body (clinical)