SAP ABAP Table PAPBSGB_HESA_C (HESA Archive table for NISR Contract table)

Hierarchy

☛ SAP_HRCGB (Software Component) Sub component SAP_HRCGB of SAP_HR
   ⤷ PY-GB-PS (Application Component) Öffentlicher Dienst
     ⤷ P08P_HER (Package) HR Public Sector Great Britain (Higher Education)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PAPBSGB_HESA_C	Table Relationship Diagram
Short Description	HESA Archive table for NISR Contract table

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	HYEAR	☑	P08_YEAR	GJAHR	NUMC	4	0	Year
3	PERNR	☑	PERSNO	PERSNO	NUMC	8	0	Personnel number	*
4	SEQNR	☑	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
5	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
6	ATIME	☐	UZEIT	UZEIT	TIMS	6	0	Time
7	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
8	.INCLUDE	☐				0	0	HESA: NISR Contract record
9	RECID	☐	P08_HESA_RECID	NUMC5	NUMC	5	0	HESA: Record type indicator
10	INSTID	☐	P08_HESA_INSTID	P08_HESA_INSTID	CHAR	4	0	HESA: Institution ID	*
11	CAMPID	☐	P08_HESA_CAMPID	CHAR1	CHAR	1	0	HESA: Campus identifier
12	STAFFID	☐	P08_HESA_STAFFID	CHAR13	CHAR	13	0	HESA staff ID
13	CONTRACTID	☐	P08P_HESA_CONTID	P08P_HESA_CONTID	CHAR	20	0	HESA: Contract Identifier
14	TERMS	☐	P08P_HESA_NISR_TERMS	P08P_HESA_NISR_TERMS	NUMC	1	0	HESA: Terms of employment
15	MOE	☐	P08P_HESA_NISR_MOE	P08_HESA_NISR_MOE	NUMC	1	0	HESA: Mode of employment
16	PEMPFUN	☐	P08_HESA_PEMPFUN	P08_HESA_PEMPFUN	CHAR	1	0	HESA: Academic employment function
17	FTE	☐	P08P_HESA_FTE	CHAR5	CHAR	5	0	HESA: Full-time Equivalent in output format
18	TCHWLH	☐	P08_HESA_TCHWLH	P08_HESA_TCHWLH	CHAR	1	0	HESA: Teaching through the medium of Welsh
19	GRADE	☐	P08_HESA_GRADE	P08_HESA_GRADE	CHAR	2	0	HESA: Grade structure	T5GPBSH_GRA
20	SMPH	☐	P08P_HESA_NISR_SENPH	P08P_HESA_NISR_SENPH	CHAR	1	0	HESA: Senior management post holder
21	PSOS	☐	P08_HESA_PRSBS	P08_HESA_PSOS	CHAR	2	0	HESA: Principal source of basic salary	T5GPBSH_PSB
22	PSCAGI	☐	P08P_HESA_FTE	CHAR5	CHAR	5	0	HESA: Full-time Equivalent in output format
23	SSOS	☐	P08_HESA_SSOS	P08_HESA_SSOS	CHAR	2	0	HESA: Secondary source of basic salary	T5GPBSH_SSB
24	SALPOINT	☐	P08P_HESA_SALPOINT	CHAR3	CHAR	3	0	HESA: Salary point
25	SALARY	☐	P08P_HESA_SALREF	CHAR07	CHAR	7	0	HESA: Basic Salary at Reference Date
26	NHSJOINT	☐	P08P_CLIN_CTYPE	P08P_CLIN_CTYPE	CHAR	1	0	HESA: NHS Contract type	*
27	CGRADE	☐	P08P_CLIN_CGRADE	P08P_CLIN_CGRADE	CHAR	2	0	HESA: NHS contract grade (clinical)	T5GPBSC_CGR
28	SPECL	☐	P08_CLIN_SPECL	P08_CLIN_SPECL	CHAR	3	0	Clinical specialty	T5GPBSC_SPE
29	HEIJOINT	☐	P08_HESA_INSTID	P08_HESA_INSTID	CHAR	4	0	HESA: Institution ID	*
30	ACTUAL_BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
31	ACTUAL_ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
32	ACT01	☐	P08P_HESA_OCC	P08P_HESA_OCC	CHAR	2	0	HESA: Occupational categorie, activity code	T5GPBSH_OCC
33	CCE01	☐	P08_HESA_CCENTRE	P08_HESA_CCENTRE	CHAR	2	0	HESA: Cost centre ("HEFCE")	T5GPBSH_CCT2
34	CCP01	☐	P08P_HESA_FTE	CHAR5	CHAR	5	0	HESA: Full-time Equivalent in output format
35	ACT02	☐	P08P_HESA_OCC	P08P_HESA_OCC	CHAR	2	0	HESA: Occupational categorie, activity code	T5GPBSH_OCC
36	CCE02	☐	P08_HESA_CCENTRE	P08_HESA_CCENTRE	CHAR	2	0	HESA: Cost centre ("HEFCE")	T5GPBSH_CCT2
37	CCP02	☐	P08P_HESA_FTE	CHAR5	CHAR	5	0	HESA: Full-time Equivalent in output format
38	ACT03	☐	P08P_HESA_OCC	P08P_HESA_OCC	CHAR	2	0	HESA: Occupational categorie, activity code	T5GPBSH_OCC
39	CCE03	☐	P08_HESA_CCENTRE	P08_HESA_CCENTRE	CHAR	2	0	HESA: Cost centre ("HEFCE")	T5GPBSH_CCT2
40	CCP03	☐	P08P_HESA_FTE	CHAR5	CHAR	5	0	HESA: Full-time Equivalent in output format
41	GRADID	☐	P08_HESA_GRADID	P08_HESA_GRADID	CHAR	10	0	HESA: Grade identifier
42	CLINICAL	☐	P08P_CLIN_CLINICAL	P08P_HESA_CLINICAL	CHAR	1	0	HESA: Clinical Status
43	PROFE	☐	P08_HESA_PROFE	CHAR1	CHAR	1	0	HESA: Professor

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PAPBSGB_HESA_C	ACT01	T5GPBSH_OCC	OCCAT	REF	1	CN
2	PAPBSGB_HESA_C	ACT02	T5GPBSH_OCC	OCCAT	REF	1	CN
3	PAPBSGB_HESA_C	ACT03	T5GPBSH_OCC	OCCAT	REF	1	CN
4	PAPBSGB_HESA_C	CCE01	T5GPBSH_CCT2	CCENTRE	REF	1	CN
5	PAPBSGB_HESA_C	CCE02	T5GPBSH_CCT2	CCENTRE	REF	1	CN
6	PAPBSGB_HESA_C	CCE03	T5GPBSH_CCT2	CCENTRE	REF	1	CN
7	PAPBSGB_HESA_C	CGRADE	T5GPBSC_CGR	CGRADE	REF	1	CN
8	PAPBSGB_HESA_C	GRADE	T5GPBSH_GRA	GRADE	KEY	1	CN
9	PAPBSGB_HESA_C	PSOS	T5GPBSH_PSB	PSOS	REF	1	CN
10	PAPBSGB_HESA_C	SPECL	T5GPBSC_SPE	SPECL	REF	1	CN
11	PAPBSGB_HESA_C	SSOS	T5GPBSH_SSB	SSOS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	500