PAPBSGBH_13_C

HESA: Contract table (2012/13 onwards) | #transactional | Component: null
Column Name Description
MANDT Client
HYEAR Year
PERNR Personnel Number
SEQNR Number of Infotype Record With Same Key
Column Name Description
Column Name Description
Column Name Description
AEDTM Last Changed On
ATIME Time
ENDCON HESA: End Date of Contract
STARTCON HESA: Start Date of Contract
YEAR_ENDDA Date
Column Name Description
NHSCON HESA: NHS Contract type Show values
TERMS HESA: Terms of employment Show values
ZEROH HESA: Zero Hours Contract Show values
ECRSTAT HESA: Early career researcher status 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
CONTID HESA: Contract Identifier P08P_HESA_CONTID
OWNCONTID HESA: Contract Identifier P08P_HESA_CONTID
ACEMPFUN HESA: Academic employment function
CAMPID HESA: Campus identifier CHAR1
CLINICAL HESA: Clinical Status
CLINSUB1 HESA: Clinical sub-specialty
CLINSUB2 HESA: Clinical sub-specialty
CLINSUB3 HESA: Clinical sub-specialty
CONFTE HESA: Full-time Equivalent in output format CHAR5
HEIJOINT HESA: Institution Code CHAR8
HSPEC1 Clinical specialty
HSPEC2 Clinical specialty
HSPEC3 Clinical specialty
LEVELS HESA: UCEA or XpertHR defined level of the contract
MOEMP HESA: Mode of employment
NHSCONGR HESA: NHS contract grade (clinical)
PSCAG HESA: Proportion of basic salary charged against gen. income CHAR5
RESCON HESA: Reason for end of contract
SALREF HESA: Basic Salary at Reference Date CHAR07
SOBS1 HESA: Principal source of basic salary
SOBS2 HESA: Principal source of basic salary
SOBS3 HESA: Principal source of basic salary
SPOINT HESA: Salary point CHAR3
TCHWLH HESA: Teaching through the medium of Welsh
ACTSOC1 HESA: SOC 2010 code (2012/13 onwards)
CCENTRE1 HESA: Cost Centre (2012/13 onwards)
CCPROP1 HESA: Proportion in cost centre DEC3_2
ACTSOC2 HESA: SOC 2010 code (2012/13 onwards)
CCENTRE2 HESA: Cost Centre (2012/13 onwards)
CCPROP2 HESA: Proportion in cost centre DEC3_2
ACTSOC3 HESA: SOC 2010 code (2012/13 onwards)
CCENTRE3 HESA: Cost Centre (2012/13 onwards)
CCPROP3 HESA: Proportion in cost centre DEC3_2
RESAST HESA: Research Assistant
ACTSOC4 HESA: SOC 2010 code (2012/13 onwards)
CCENTRE4 HESA: Cost Centre (2012/13 onwards)
CCPROP4 HESA: Proportion in cost centre DEC3_2
ACTSOC5 HESA: SOC 2010 code (2012/13 onwards)
CCENTRE5 HESA: Cost Centre (2012/13 onwards)
CCPROP5 HESA: Proportion in cost centre DEC3_2
ACTSOC6 HESA: SOC 2010 code (2012/13 onwards)
CCENTRE6 HESA: Cost Centre (2012/13 onwards)
CCPROP6 HESA: Proportion in cost centre DEC3_2
APPRT HESA: Apprenticeship/Level CHAR1
HRLYP HESA: Hourly Paid Contract CHAR1
SIGRES HESA: Significant Responsibility CHAR1
REFFTE HESA: REF FTE CHAR3