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

History

Last changed by/on	SAP	20130529
SAP Release Created in