1. Home
  2. Resources
  3. SAP Tables
  4. P08P_HESA_NISR_CONTRACT_DISP - HESA NISR contract record display format

SAP Table P08P_HESA_NISR_CONTRACT_DISP

HESA NISR contract record display format

P08P_HESA_NISR_CONTRACT_DISP (HESA NISR contract record display 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_NISR_CONTRACT_DISP to other SAP tables.

P08P_HESA_NISR_CONTRACT_DISP table fields

Field Data element Checktable Datatype Length Decimals
PERNR Personnel number PERSNO NUMC 8 0
ENAME Formatted Name of Employee or Applicant EMNAM CHAR 40 0
CATEGORY HESA Staff return category for NISR P08P_HESA_STAFF_CATEGORY CHAR 1 0
A Academic
C Clinical
P Professional
N Non-academic
T Atypical
ERROR HESA: flag for HESA validation error P08P_HESA_ERROR CHAR 1 0
X Yes
NULL No
RECID HESA: Record type indicator P08_HESA_RECID NUMC 5 0
INSTID HESA: Institution ID P08_HESA_INSTID CHAR 4 0
CAMPID HESA: Campus identifier P08_HESA_CAMPID CHAR 1 0
STAFFID HESA staff ID P08_HESA_STAFFID CHAR 13 0
CONTRACTID HESA: Contract Identifier P08P_HESA_CONTID CHAR 20 0
TERMS HESA: Terms of employment P08P_HESA_NISR_TERMS NUMC 1 0
1 Open-ended/Permanent
2 Fixed term contract
3 Atypical
MOE HESA: Mode of employment P08P_HESA_NISR_MOE NUMC 1 0
1 Full time
2 Full time, term-time
3 Part time
4 Part time, term-time
5 Atypical
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)
FTE HESA: Full-time Equivalent in output format P08P_HESA_FTE CHAR 5 0
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)
GRADE HESA: Grade structure P08_HESA_GRADE CHAR 2 0
SMPH HESA: Senior management post holder P08P_HESA_NISR_SENPH CHAR 1 0
1 Senior management post holder
2 Not a senior management post holder
X Not applicable
PSOS HESA: Principal source of basic salary P08_HESA_PRSBS CHAR 2 0
PSCAGI HESA: Full-time Equivalent in output format P08P_HESA_FTE CHAR 5 0
SSOS HESA: Secondary source of basic salary P08_HESA_SSOS CHAR 2 0
SALPOINT HESA: Salary point P08P_HESA_SALPOINT CHAR 3 0
SALARY HESA: Basic Salary at Reference Date P08P_HESA_SALREF CHAR 7 0
NHSJOINT HESA: NHS Contract type P08P_CLIN_CTYPE CHAR 1 0
0 No NHS contract
1 HEI and NHS Honorary contract
2 Separate HEI and NHS contracts
3 JointHEI/NHS contracts
X Not applicable
CGRADE HESA: NHS contract grade (clinical) P08P_CLIN_CGRADE T5GPBSC_CGR CHAR 2 0
SPECL Clinical specialty P08_CLIN_SPECL T5GPBSC_SPE CHAR 3 0
HEIJOINT HESA: Institution ID P08_HESA_INSTID CHAR 4 0
ACTUAL_BEGDA Start Date BEGDA DATS 8 0
ACTUAL_ENDDA End Date ENDDA DATS 8 0
ACT01 HESA: Occupational categorie, activity code P08P_HESA_OCC T5GPBSH_OCC CHAR 2 0
CCE01 HESA: Cost centre ("HEFCE") P08_HESA_CCENTRE T5GPBSH_CCT2 CHAR 2 0
CCP01 HESA: Full-time Equivalent in output format P08P_HESA_FTE CHAR 5 0
ACT02 HESA: Occupational categorie, activity code P08P_HESA_OCC T5GPBSH_OCC CHAR 2 0
CCE02 HESA: Cost centre ("HEFCE") P08_HESA_CCENTRE T5GPBSH_CCT2 CHAR 2 0
CCP02 HESA: Full-time Equivalent in output format P08P_HESA_FTE CHAR 5 0
ACT03 HESA: Occupational categorie, activity code P08P_HESA_OCC T5GPBSH_OCC CHAR 2 0
CCE03 HESA: Cost centre ("HEFCE") P08_HESA_CCENTRE T5GPBSH_CCT2 CHAR 2 0
CCP03 HESA: Full-time Equivalent in output format P08P_HESA_FTE CHAR 5 0
GRADID HESA: Grade identifier P08_HESA_GRADID CHAR 10 0
400 Clinical lecturer/researcher - not paid as consultant
410 Clinical senior lecturer/researcher - not paid as consultant
420 Consultant clinical academic - old contract.
430 Consultant clinical academic - new contract.
500 FE-linked grades.
510 NHS-linked grades.
520 Contract not graded.
900 Other.
CLINICAL HESA: Clinical Status P08P_CLIN_CLINICAL CHAR 1 0
0 Not Clinical academic
1 Clinical academic doctors and dentists
2 Clinical academic nurses and midwives
3 Clinical academic health professions
4 Other Clinical academic staff
PROFE HESA: Professor P08_HESA_PROFE CHAR 1 0

P08P_HESA_NISR_CONTRACT_DISP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
P08P_HESA_NISR_CONTRACT_DISP ACT01 SYST MANDT T5GPBSH_OCC HESA: Occupational categories MANDT
P08P_HESA_NISR_CONTRACT_DISP ACT01 P08P_HESA_NISR_CONTRACT_DISP ACT01 T5GPBSH_OCC HESA: Occupational categories OCCAT
P08P_HESA_NISR_CONTRACT_DISP ACT02 SYST MANDT T5GPBSH_OCC HESA: Occupational categories MANDT
P08P_HESA_NISR_CONTRACT_DISP ACT02 P08P_HESA_NISR_CONTRACT_DISP ACT02 T5GPBSH_OCC HESA: Occupational categories OCCAT
P08P_HESA_NISR_CONTRACT_DISP ACT03 P08P_HESA_NISR_CONTRACT_DISP ACT03 T5GPBSH_OCC HESA: Occupational categories OCCAT
P08P_HESA_NISR_CONTRACT_DISP ACT03 SYST MANDT T5GPBSH_OCC HESA: Occupational categories MANDT
P08P_HESA_NISR_CONTRACT_DISP CCE01 SYST MANDT T5GPBSH_CCT2 HESA: Cost centre (HEFCE) MANDT
P08P_HESA_NISR_CONTRACT_DISP CCE01 P08P_HESA_NISR_CONTRACT_DISP CCE01 T5GPBSH_CCT2 HESA: Cost centre (HEFCE) CCENTRE
P08P_HESA_NISR_CONTRACT_DISP CCE01 * T5GPBSH_CCT2 HESA: Cost centre (HEFCE) ENDDA
P08P_HESA_NISR_CONTRACT_DISP CCE02 SYST MANDT T5GPBSH_CCT2 HESA: Cost centre (HEFCE) MANDT
P08P_HESA_NISR_CONTRACT_DISP CCE02 P08P_HESA_NISR_CONTRACT_DISP CCE02 T5GPBSH_CCT2 HESA: Cost centre (HEFCE) CCENTRE
P08P_HESA_NISR_CONTRACT_DISP CCE02 * T5GPBSH_CCT2 HESA: Cost centre (HEFCE) ENDDA
P08P_HESA_NISR_CONTRACT_DISP CCE03 SYST MANDT T5GPBSH_CCT2 HESA: Cost centre (HEFCE) MANDT
P08P_HESA_NISR_CONTRACT_DISP CCE03 P08P_HESA_NISR_CONTRACT_DISP CCE03 T5GPBSH_CCT2 HESA: Cost centre (HEFCE) CCENTRE
P08P_HESA_NISR_CONTRACT_DISP CCE03 * T5GPBSH_CCT2 HESA: Cost centre (HEFCE) ENDDA
P08P_HESA_NISR_CONTRACT_DISP CGRADE SYST MANDT T5GPBSC_CGR Honorary NHS Status MANDT
P08P_HESA_NISR_CONTRACT_DISP CGRADE P08P_HESA_NISR_CONTRACT_DISP CGRADE T5GPBSC_CGR Honorary NHS Status CGRADE
P08P_HESA_NISR_CONTRACT_DISP CGRADE * T5GPBSC_CGR Honorary NHS Status ENDDA
P08P_HESA_NISR_CONTRACT_DISP SPECL SYST MANDT T5GPBSC_SPE Clinical Specialty MANDT
P08P_HESA_NISR_CONTRACT_DISP SPECL P08P_HESA_NISR_CONTRACT_DISP SPECL T5GPBSC_SPE Clinical Specialty SPECL