PAPBSGB_HESA_C

HESA Archive table for NISR Contract table | #transactional | Component: null

🔑 Keys (4)
💰 Amounts
∑ Quantities
📅 Dates (4)
☰ Categorical (3)
Other (19)
🔗 Relations (11)

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
ACTUAL_BEGDA	Start Date
ACTUAL_ENDDA	End Date

Column Name	Description
TERMS	HESA: Terms of employment	Show values
SMPH	HESA: Senior management post holder	Show values
GRADID	HESA: Grade identifier	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
CAMPID	HESA: Campus identifier	CHAR1
STAFFID	HESA staff ID	CHAR13
CONTRACTID	HESA: Contract Identifier	P08P_HESA_CONTID
MOE	HESA: Mode of employment
PEMPFUN	HESA: Academic employment function
FTE	HESA: Full-time Equivalent in output format	CHAR5
TCHWLH	HESA: Teaching through the medium of Welsh
PSCAGI	HESA: Full-time Equivalent in output format	CHAR5
SALPOINT	HESA: Salary point	CHAR3
SALARY	HESA: Basic Salary at Reference Date	CHAR07
HEIJOINT	HESA: Institution ID	P08_HESA_INSTID
CCP01	HESA: Full-time Equivalent in output format	CHAR5
CCP02	HESA: Full-time Equivalent in output format	CHAR5
CCP03	HESA: Full-time Equivalent in output format	CHAR5
CLINICAL	HESA: Clinical Status
PROFE	HESA: Professor	CHAR1

Master Data Relations \| to Other Relations ↓	Join Conditions
Activity code HESA: Occupational categorie, activity code Client	`PAPBSGB_HESA_C.ACT01 == T5GPBSH_OCC.OCCAT` `PAPBSGB_HESA_C.MANDT == T5GPBSH_OCC.MANDT`
Activity code HESA: Occupational categorie, activity code Client	`PAPBSGB_HESA_C.ACT02 == T5GPBSH_OCC.OCCAT` `PAPBSGB_HESA_C.MANDT == T5GPBSH_OCC.MANDT`
Activity code HESA: Occupational categorie, activity code Client	`PAPBSGB_HESA_C.ACT03 == T5GPBSH_OCC.OCCAT` `PAPBSGB_HESA_C.MANDT == T5GPBSH_OCC.MANDT`
Grade HESA: Grade structure Client	`PAPBSGB_HESA_C.GRADE == T5GPBSH_GRA.GRADE` `PAPBSGB_HESA_C.MANDT == T5GPBSH_GRA.MANDT`
Clinical speciality	`PAPBSGB_HESA_C.MANDT == T5GPBSC_SPE.MANDT` `PAPBSGB_HESA_C.SPECL == T5GPBSC_SPE.SPECL`

Other Relations \| to Master Data Relations ↑	Join Conditions
HESA: Cost centre ("HEFCE") HESA: Cost centre ("HEFCE") Client ?	`PAPBSGB_HESA_C.CCE01 == T5GPBSH_CCT2.CCENTRE` `PAPBSGB_HESA_C.MANDT == T5GPBSH_CCT2.MANDT` `PAPBSGB_HESA_C.[column in domain "ENDDA"] == T5GPBSH_CCT2.ENDDA`
Cost centre HESA: Cost centre ("HEFCE") Client ?	`PAPBSGB_HESA_C.CCE02 == T5GPBSH_CCT2.CCENTRE` `PAPBSGB_HESA_C.MANDT == T5GPBSH_CCT2.MANDT` `PAPBSGB_HESA_C.[column in domain "ENDDA"] == T5GPBSH_CCT2.ENDDA`
Cost centre HESA: Cost centre ("HEFCE") Client ?	`PAPBSGB_HESA_C.CCE03 == T5GPBSH_CCT2.CCENTRE` `PAPBSGB_HESA_C.MANDT == T5GPBSH_CCT2.MANDT` `PAPBSGB_HESA_C.[column in domain "ENDDA"] == T5GPBSH_CCT2.ENDDA`
Contract grade ? Client HESA: NHS contract grade (clinical)	`PAPBSGB_HESA_C.[column in domain "ENDDA"] == T5GPBSC_CGR.ENDDA` `PAPBSGB_HESA_C.MANDT == T5GPBSC_CGR.MANDT` `PAPBSGB_HESA_C.CGRADE == T5GPBSC_CGR.CGRADE`
Principal source of basic salary HESA: Principal source of basic salary Client ?	`PAPBSGB_HESA_C.PSOS == T5GPBSH_PSB.PSOS` `PAPBSGB_HESA_C.MANDT == T5GPBSH_PSB.MANDT` `PAPBSGB_HESA_C.[column in domain "ENDDA"] == T5GPBSH_PSB.ENDDA`
Secondary source of basic salary ? HESA: Secondary source of basic salary	`PAPBSGB_HESA_C.MANDT == T5GPBSH_SSB.MANDT` `PAPBSGB_HESA_C.[column in domain "ENDDA"] == T5GPBSH_SSB.ENDDA` `PAPBSGB_HESA_C.SSOS == T5GPBSH_SSB.SSOS`