1. Home
  2. Resources
  3. SAP Tables
  4. P08P_HESA_CONTRACT - HESA: Individualised Staff Return Int. Internal/SAP format.

SAP Table P08P_HESA_CONTRACT

HESA: Individualised Staff Return Int. Internal/SAP format.

P08P_HESA_CONTRACT (HESA: Individualised Staff Return Int. Internal/SAP format.) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link P08P_HESA_CONTRACT to other SAP tables.

P08P_HESA_CONTRACT table fields

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

P08P_HESA_CONTRACT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
P08P_HESA_CONTRACT CCENTRE SY MANDT T5GPBSH_CCT HESA: Cost centre (HEFCE) MANDT
P08P_HESA_CONTRACT CCENTRE P08P_HESA_CONTRACT CCENTRE T5GPBSH_CCT HESA: Cost centre (HEFCE) CCENTRE
P08P_HESA_CONTRACT CCENTRE * T5GPBSH_CCT HESA: Cost centre (HEFCE) ENDDA
P08P_HESA_CONTRACT ETHNIC SY MANDT T5GPBSH_ETC HESA: Ethnicity codes MANDT
P08P_HESA_CONTRACT ETHNIC P08P_HESA_CONTRACT ETHNIC T5GPBSH_ETC HESA: Ethnicity codes ETHNIC
P08P_HESA_CONTRACT GRADE SY MANDT T5GPBSH_GRA HESA: Grade structure MANDT
P08P_HESA_CONTRACT GRADE P08P_HESA_CONTRACT GRADE T5GPBSH_GRA HESA: Grade structure GRADE