SAP ABAP Table P08P_HESA_NISR_CONTRACT (HESA: NISR Contract record)

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	INTTAB	Structure
Structure	P08P_HESA_NISR_CONTRACT	Table Relationship Diagram
Short Description	HESA: NISR Contract record

Delivery and Maintenance

Pool/cluster
Delivery Class
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	RECID	☐	P08_HESA_RECID	NUMC5	NUMC	5	0	HESA: Record type indicator
2	INSTID	☐	P08_HESA_INSTID	P08_HESA_INSTID	CHAR	4	0	HESA: Institution ID	*
3	CAMPID	☐	P08_HESA_CAMPID	CHAR1	CHAR	1	0	HESA: Campus identifier
4	STAFFID	☐	P08_HESA_STAFFID	CHAR13	CHAR	13	0	HESA staff ID
5	CONTRACTID	☐	P08P_HESA_CONTID	P08P_HESA_CONTID	CHAR	20	0	HESA: Contract Identifier
6	TERMS	☐	P08P_HESA_NISR_TERMS	P08P_HESA_NISR_TERMS	NUMC	1	0	HESA: Terms of employment
7	MOE	☐	P08P_HESA_NISR_MOE	P08_HESA_NISR_MOE	NUMC	1	0	HESA: Mode of employment
8	PEMPFUN	☐	P08_HESA_PEMPFUN	P08_HESA_PEMPFUN	CHAR	1	0	HESA: Academic employment function
9	FTE	☐	P08P_HESA_FTE	CHAR5	CHAR	5	0	HESA: Full-time Equivalent in output format
10	TCHWLH	☐	P08_HESA_TCHWLH	P08_HESA_TCHWLH	CHAR	1	0	HESA: Teaching through the medium of Welsh
11	GRADE	☐	P08_HESA_GRADE	P08_HESA_GRADE	CHAR	2	0	HESA: Grade structure	T5GPBSH_GRA
12	SMPH	☐	P08P_HESA_NISR_SENPH	P08P_HESA_NISR_SENPH	CHAR	1	0	HESA: Senior management post holder
13	PSOS	☐	P08_HESA_PRSBS	P08_HESA_PSOS	CHAR	2	0	HESA: Principal source of basic salary	T5GPBSH_PSB
14	PSCAGI	☐	P08P_HESA_FTE	CHAR5	CHAR	5	0	HESA: Full-time Equivalent in output format
15	SSOS	☐	P08_HESA_SSOS	P08_HESA_SSOS	CHAR	2	0	HESA: Secondary source of basic salary	T5GPBSH_SSB
16	SALPOINT	☐	P08P_HESA_SALPOINT	CHAR3	CHAR	3	0	HESA: Salary point
17	SALARY	☐	P08P_HESA_SALREF	CHAR07	CHAR	7	0	HESA: Basic Salary at Reference Date
18	NHSJOINT	☐	P08P_CLIN_CTYPE	P08P_CLIN_CTYPE	CHAR	1	0	HESA: NHS Contract type
19	CGRADE	☐	P08P_CLIN_CGRADE	P08P_CLIN_CGRADE	CHAR	2	0	HESA: NHS contract grade (clinical)	T5GPBSC_CGR
20	SPECL	☐	P08_CLIN_SPECL	P08_CLIN_SPECL	CHAR	3	0	Clinical specialty	T5GPBSC_SPE
21	HEIJOINT	☐	P08_HESA_INSTID	P08_HESA_INSTID	CHAR	4	0	HESA: Institution ID	*
22	ACTUAL_BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
23	ACTUAL_ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
24	ACT01	☐	P08P_HESA_OCC	P08P_HESA_OCC	CHAR	2	0	HESA: Occupational categorie, activity code	T5GPBSH_OCC
25	CCE01	☐	P08_HESA_CCENTRE	P08_HESA_CCENTRE	CHAR	2	0	HESA: Cost centre ("HEFCE")	T5GPBSH_CCT2
26	CCP01	☐	P08P_HESA_FTE	CHAR5	CHAR	5	0	HESA: Full-time Equivalent in output format
27	ACT02	☐	P08P_HESA_OCC	P08P_HESA_OCC	CHAR	2	0	HESA: Occupational categorie, activity code	T5GPBSH_OCC
28	CCE02	☐	P08_HESA_CCENTRE	P08_HESA_CCENTRE	CHAR	2	0	HESA: Cost centre ("HEFCE")	T5GPBSH_CCT2
29	CCP02	☐	P08P_HESA_FTE	CHAR5	CHAR	5	0	HESA: Full-time Equivalent in output format
30	ACT03	☐	P08P_HESA_OCC	P08P_HESA_OCC	CHAR	2	0	HESA: Occupational categorie, activity code	T5GPBSH_OCC
31	CCE03	☐	P08_HESA_CCENTRE	P08_HESA_CCENTRE	CHAR	2	0	HESA: Cost centre ("HEFCE")	T5GPBSH_CCT2
32	CCP03	☐	P08P_HESA_FTE	CHAR5	CHAR	5	0	HESA: Full-time Equivalent in output format
33	GRADID	☐	P08_HESA_GRADID	P08_HESA_GRADID	CHAR	10	0	HESA: Grade identifier
34	CLINICAL	☐	P08P_CLIN_CLINICAL	P08P_HESA_CLINICAL	CHAR	1	0	HESA: Clinical Status
35	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	P08P_HESA_NISR_CONTRACT	ACT01	T5GPBSH_OCC	OCCAT	REF	1	CN
2	P08P_HESA_NISR_CONTRACT	ACT02	T5GPBSH_OCC	OCCAT	REF	1	CN
3	P08P_HESA_NISR_CONTRACT	ACT03	T5GPBSH_OCC	OCCAT	REF	1	CN
4	P08P_HESA_NISR_CONTRACT	CCE01	T5GPBSH_CCT2	CCENTRE	REF	1	CN
5	P08P_HESA_NISR_CONTRACT	CCE02	T5GPBSH_CCT2	CCENTRE	REF	1	CN
6	P08P_HESA_NISR_CONTRACT	CCE03	T5GPBSH_CCT2	CCENTRE	REF	1	CN
7	P08P_HESA_NISR_CONTRACT	CGRADE	T5GPBSC_CGR	CGRADE	REF	1	CN
8	P08P_HESA_NISR_CONTRACT	GRADE	T5GPBSH_GRA	GRADE	KEY	1	CN
9	P08P_HESA_NISR_CONTRACT	PSOS	T5GPBSH_PSB	PSOS	REF	1	CN
10	P08P_HESA_NISR_CONTRACT	SPECL	T5GPBSC_SPE	SPECL	REF	1	CN
11	P08P_HESA_NISR_CONTRACT	SSOS	T5GPBSH_SSB	SSOS	REF	1	CN

History

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