SAP table P08P_HESA_CONTRACT (HESA: Individualised Staff Return Int. Internal/SAP format.)

Field Description Data Type Length Decimals Checktable Data Element
CAMPID HESA: Campus identifier CHAR 1 0 P08_HESA_CAMPID
STAFFID HESA staff ID CHAR 13 0 P08_HESA_STAFFID
BIRTHDTE Date of Birth DATS 8 0 GBDAT
GENDER HESA: Gender code CHAR 1 0 P08_HESA_GENDER
F Female
M Male
X Unknown
TERMS HESA: Terms of employment NUMC 1 0 P08_HESA_TERMS
MOE HESA: Mode of employment NUMC 1 0 P08_HESA_MOE
1 Full time
2 Part time
3 Hourly paid/casual staff
9 Other
PEMPFUN HESA: Academic employment function CHAR 1 0 P08_HESA_PEMPFUN
PERACA HESA: Percentage time academic DEC 5 2 P08_HESA_PERACA
FTE HESA: Staff FTE DEC 5 2 P08_HESA_FTE
CCENTRE HESA: Cost centre ("HEFCE") CHAR 2 0 T5GPBSH_CCT P08_HESA_CCENTRE
NATION HESA: Nationality code CHAR 4 0 P08_HESA_NATION
ETHNIC HESA: Ethnicitiy code NUMC 2 0 T5GPBSH_ETC P08_HESA_ETHNIC
DISABLE HESA: Disabled CHAR 1 0 P08_HESA_DISABLE
1 Not known to be disabled
2 Disabled but not registered
3 Registered disabled
8 Information not provided
DATEHEI Date appointed at current higher education provider DATS 8 0 P08_HESA_DATEHEI
QUALHELD HESA: Highest academic qualification NUMC 2 0 P08_HESA_QUAL_OLD
ACCDIS HESA: Academic discipline CHAR 6 0 P08_HESA_ACCDIS
PROFQHLD HESA: Professional qualification held NUMC 1 0 P08_HESA_PROFQHLD
1 No Professional qualification held
2 Professional qualification held
9 Not known
RESACT HESA: Active in the 1996/2001 Research Assessment Exercise CHAR 1 0 P08P_HESA_RESACT_ALL
ABLWELSH HESA: Ability to teach through the medium of Welsh CHAR 1 0 P08_HESA_ABLWELSH
TCHWLH HESA: Teaching through the medium of Welsh CHAR 1 0 P08_HESA_TCHWLH
CLINSTAT HESA: Clinical status NUMC 1 0 P08_HESA_CLINSTAT
1 Staff not on clinical rates (and not medically qualified)
2 Staff not on clinical rates (although medically qualified)
3 Staff on clinical rates not holding honorary contr. with NHS
4 Staff on clinical rates holding honorary contracts with NHS
NHSJOINT HESA: NHS joint appointment. NUMC 1 0 P08_HESA_NHSJOINT
1 Not an NHS joint appointment
2 NHS joint appointment (A + B appointment)
GRADE HESA: Grade structure CHAR 2 0 T5GPBSH_GRA P08_HESA_GRADE
PSOS HESA: Principal source of basic salary NUMC 2 0 P08_HESA_PRSBS_OLD
PSCAGI HESA: Proportion of basic pay charged against general income DEC 5 2 P08_HESA_PSCAGI
SSOS HESA: Secondary source of basic salary NUMC 2 0 P08_HESA_SSOS_OLD
SALPOINT HESA: Salary point NUMC 2 0 P08_HESA_SALPOINT
SALARY HESA: Current Salary at reference day reported CURR 15 2 P08_HESA_SALARY
EMPPREYR HESA: Previous Employment NUMC 2 0 P08_HESA_EMPPREYR_OLD
DATELHEI HESA: Date left a HESA returnable appointment DATS 8 0 P08_HESA_DATELHEI
DEST HESA: Destination on leaving NUMC 2 0 P08_HESA_DEST_OLD
SENPH HESA: Senior management post holder CHAR 1 0 P08_HESA_SENPH_SCREEN
SREAD HESA: Reader CHAR 1 0 P08_HESA_READER_SCREEN
APPCONT HESA: Appointment identifier CHAR 1 0 P08_HESA_APPCONT
UOA HESA: Unit of Assessment CHAR 3 0 P08P_HESA_UOA

P08P_HESA_CONTRACT foreign key relationships

Table Field Check Table Check Field
0 P08P_HESA_CONTRACT CCENTRE T5GPBSH_CCT HESA: Cost centre (HEFCE) MANDT
0 P08P_HESA_CONTRACT CCENTRE T5GPBSH_CCT HESA: Cost centre (HEFCE) CCENTRE
0 P08P_HESA_CONTRACT CCENTRE T5GPBSH_CCT HESA: Cost centre (HEFCE) ENDDA
1 P08P_HESA_CONTRACT ETHNIC T5GPBSH_ETC HESA: Ethnicity codes MANDT
1 P08P_HESA_CONTRACT ETHNIC T5GPBSH_ETC HESA: Ethnicity codes ETHNIC
0 P08P_HESA_CONTRACT GRADE T5GPBSH_GRA HESA: Grade structure MANDT
0 P08P_HESA_CONTRACT GRADE T5GPBSH_GRA HESA: Grade structure GRADE