SAP ABAP Table P08P_HESA_CONTRACT (HESA: Individualised Staff Return Int. Internal/SAP format.)

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_CONTRACT	Table Relationship Diagram
Short Description	HESA: Individualised Staff Return Int. Internal/SAP format.

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	CAMPID	☐	P08_HESA_CAMPID	CHAR1	CHAR	1	0	HESA: Campus identifier
2	STAFFID	☐	P08_HESA_STAFFID	CHAR13	CHAR	13	0	HESA staff ID
3	BIRTHDTE	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
4	GENDER	☐	P08_HESA_GENDER	P08_HESA_GENDER	CHAR	1	0	HESA: Gender code
5	TERMS	☐	P08_HESA_TERMS	P08_HESA_TERMS	NUMC	1	0	HESA: Terms of employment
6	MOE	☐	P08_HESA_MOE	P08_HESA_MOE	NUMC	1	0	HESA: Mode of employment
7	PEMPFUN	☐	P08_HESA_PEMPFUN	P08_HESA_PEMPFUN	CHAR	1	0	HESA: Academic employment function
8	PERACA	☐	P08_HESA_PERACA	DEC3_2	DEC	5	2	HESA: Percentage time academic
9	FTE	☐	P08_HESA_FTE	DEC3_2	DEC	5	2	HESA: Staff FTE
10	CCENTRE	☐	P08_HESA_CCENTRE	P08_HESA_CCENTRE	CHAR	2	0	HESA: Cost centre ("HEFCE")	T5GPBSH_CCT
11	NATION	☐	P08_HESA_NATION	P08_HESA_NATION	CHAR	4	0	HESA: Nationality code
12	ETHNIC	☐	P08_HESA_ETHNIC	P08_HESA_ETHNIC	NUMC	2	0	HESA: Ethnicitiy code	T5GPBSH_ETC
13	DISABLE	☐	P08_HESA_DISABLE	P08_HESA_DISABLE	CHAR	1	0	HESA: Disabled
14	DATEHEI	☐	P08_HESA_DATEHEI	DATUM	DATS	8	0	HESA: Date entered current service
15	QUALHELD	☐	P08_HESA_QUAL_OLD	NUMC2	NUMC	2	0	HESA: Highest academic qualification
16	ACCDIS	☐	P08_HESA_ACCDIS	CHAR6	CHAR	6	0	HESA: Academic discipline
17	PROFQHLD	☐	P08_HESA_PROFQHLD	P08_HESA_PROFQHLD	NUMC	1	0	HESA: Professional qualification held
18	RESACT	☐	P08P_HESA_RESACT_ALL	P08P_HESA_RESACT_ALL	CHAR	1	0	HESA: Active in the 1996/2001 Research Assessment Exercise
19	ABLWELSH	☐	P08_HESA_ABLWELSH	P08_HESA_ABLWELSH	CHAR	1	0	HESA: Ability to teach through the medium of Welsh
20	TCHWLH	☐	P08_HESA_TCHWLH	P08_HESA_TCHWLH	CHAR	1	0	HESA: Teaching through the medium of Welsh
21	CLINSTAT	☐	P08_HESA_CLINSTAT	P08_HESA_CLINSTAT	NUMC	1	0	HESA: Clinical status
22	NHSJOINT	☐	P08_HESA_NHSJOINT	P08_HESA_NHSJOINT	NUMC	1	0	HESA: NHS joint appointment.
23	GRADE	☐	P08_HESA_GRADE	P08_HESA_GRADE	CHAR	2	0	HESA: Grade structure	T5GPBSH_GRA
24	PSOS	☐	P08_HESA_PRSBS_OLD	NUMC2	NUMC	2	0	HESA: Principal source of basic salary
25	PSCAGI	☐	P08_HESA_PSCAGI	DEC3_2	DEC	5	2	HESA: Proportion of basic pay charged against general income
26	SSOS	☐	P08_HESA_SSOS_OLD	NUMC2	NUMC	2	0	HESA: Secondary source of basic salary
27	SALPOINT	☐	P08_HESA_SALPOINT	NUMC2	NUMC	2	0	HESA: Salary point
28	SALARY	☐	P08_HESA_SALARY	P_AMT08V	CURR	15	2	HESA: Current Salary at reference day reported
29	EMPPREYR	☐	P08_HESA_EMPPREYR_OLD	NUMC2	NUMC	2	0	HESA: Previous Employment
30	DATELHEI	☐	P08_HESA_DATELHEI	DATUM	DATS	8	0	HESA: Date left a HESA returnable appointment
31	DEST	☐	P08_HESA_DEST_OLD	NUMC02	NUMC	2	0	HESA: Destination on leaving
32	SENPH	☐	P08_HESA_SENPH_SCREEN	XFELD	CHAR	1	0	HESA: Senior management post holder
33	SREAD	☐	P08_HESA_READER_SCREEN	XFELD	CHAR	1	0	HESA: Reader
34	APPCONT	☐	P08_HESA_APPCONT	CHAR1	CHAR	1	0	HESA: Appointment identifier
35	UOA	☐	P08P_HESA_UOA	P08P_HESA_UOA	CHAR	3	0	HESA: Unit of Assessment

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P08P_HESA_CONTRACT	CCENTRE	T5GPBSH_CCT	CCENTRE	KEY
2	P08P_HESA_CONTRACT	ETHNIC	T5GPBSH_ETC	ETHNIC	KEY
3	P08P_HESA_CONTRACT	GRADE	T5GPBSH_GRA	GRADE	KEY

History

Last changed by/on	SAP	20130529
SAP Release Created in