SAP ABAP Table P08P_HESA_OUT_SAP (HESA: Individualised Staff Return internal 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_SAP	Table Relationship Diagram
Short Description	HESA: Individualised Staff Return internal 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	PERNR	☐	PERSNO	PERSNO	NUMC	8	0	Personnel number	*
2	ENAME	☐	EMNAM	TEXT40	CHAR	40	0	Formatted Name of Employee or Applicant
3	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
4	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
5	ACTUAL_BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
6	ACTUAL_ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
7	PERACA_CONTRACT_ENDDA	☐	P08_HESA_ACFTE	DEC3_2	DEC	5	2	HESA: Academic FTE
8	ACFTE_CONTRACT	☐	P08_HESA_FTE	DEC3_2	DEC	5	2	HESA: Staff FTE
9	REPRT	☐	P08_HESA_REPRT	P08_HESA_REPRT	CHAR	1	0	HESA: Reason reported in individualised staff return
10	PREVIOUS_DATEHEI	☐	P08_HESA_DATEHEI	DATUM	DATS	8	0	HESA: Date entered current service
11	REASON_DECISION_TREE	☐	P08_HESA_DECISIONTREE	CHAR1	CHAR	1	0	HESA: Reason for record reported
12	.INCLUDE	☐				0	0	HESA: Individualised Staff Return Int. Internal/SAP format
13	RECID	☐	P08_HESA_RECID	NUMC5	NUMC	5	0	HESA: Record type indicator
14	INSTID	☐	P08_HESA_INSTID	P08_HESA_INSTID	CHAR	4	0	HESA: Institution ID	*
15	.INCLUDE	☐				0	0	HESA: Individualised Staff Return Int. Internal/SAP format.
16	CAMPID	☐	P08_HESA_CAMPID	CHAR1	CHAR	1	0	HESA: Campus identifier
17	STAFFID	☐	P08_HESA_STAFFID	CHAR13	CHAR	13	0	HESA staff ID
18	BIRTHDTE	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
19	GENDER	☐	P08_HESA_GENDER	P08_HESA_GENDER	CHAR	1	0	HESA: Gender code
20	TERMS	☐	P08_HESA_TERMS	P08_HESA_TERMS	NUMC	1	0	HESA: Terms of employment
21	MOE	☐	P08_HESA_MOE	P08_HESA_MOE	NUMC	1	0	HESA: Mode of employment
22	PEMPFUN	☐	P08_HESA_PEMPFUN	P08_HESA_PEMPFUN	CHAR	1	0	HESA: Academic employment function
23	PERACA	☐	P08_HESA_PERACA	DEC3_2	DEC	5	2	HESA: Percentage time academic
24	FTE	☐	P08_HESA_FTE	DEC3_2	DEC	5	2	HESA: Staff FTE
25	CCENTRE	☐	P08_HESA_CCENTRE	P08_HESA_CCENTRE	CHAR	2	0	HESA: Cost centre ("HEFCE")	T5GPBSH_CCT
26	NATION	☐	P08_HESA_NATION	P08_HESA_NATION	CHAR	4	0	HESA: Nationality code
27	ETHNIC	☐	P08_HESA_ETHNIC	P08_HESA_ETHNIC	NUMC	2	0	HESA: Ethnicitiy code	T5GPBSH_ETC
28	DISABLE	☐	P08_HESA_DISABLE	P08_HESA_DISABLE	CHAR	1	0	HESA: Disabled
29	DATEHEI	☐	P08_HESA_DATEHEI	DATUM	DATS	8	0	HESA: Date entered current service
30	QUALHELD	☐	P08_HESA_QUAL_OLD	NUMC2	NUMC	2	0	HESA: Highest academic qualification	*
31	ACCDIS	☐	P08_HESA_ACCDIS	CHAR6	CHAR	6	0	HESA: Academic discipline
32	PROFQHLD	☐	P08_HESA_PROFQHLD	P08_HESA_PROFQHLD	NUMC	1	0	HESA: Professional qualification held
33	RESACT	☐	P08P_HESA_RESACT_ALL	P08P_HESA_RESACT_ALL	CHAR	1	0	HESA: Active in the 1996/2001 Research Assessment Exercise	*
34	ABLWELSH	☐	P08_HESA_ABLWELSH	P08_HESA_ABLWELSH	CHAR	1	0	HESA: Ability to teach through the medium of Welsh
35	TCHWLH	☐	P08_HESA_TCHWLH	P08_HESA_TCHWLH	CHAR	1	0	HESA: Teaching through the medium of Welsh
36	CLINSTAT	☐	P08_HESA_CLINSTAT	P08_HESA_CLINSTAT	NUMC	1	0	HESA: Clinical status
37	NHSJOINT	☐	P08_HESA_NHSJOINT	P08_HESA_NHSJOINT	NUMC	1	0	HESA: NHS joint appointment.
38	GRADE	☐	P08_HESA_GRADE	P08_HESA_GRADE	CHAR	2	0	HESA: Grade structure	T5GPBSH_GRA
39	PSOS	☐	P08_HESA_PRSBS_OLD	NUMC2	NUMC	2	0	HESA: Principal source of basic salary	*
40	PSCAGI	☐	P08_HESA_PSCAGI	DEC3_2	DEC	5	2	HESA: Proportion of basic pay charged against general income
41	SSOS	☐	P08_HESA_SSOS_OLD	NUMC2	NUMC	2	0	HESA: Secondary source of basic salary	*
42	SALPOINT	☐	P08_HESA_SALPOINT	NUMC2	NUMC	2	0	HESA: Salary point
43	SALARY	☐	P08_HESA_SALARY	P_AMT08V	CURR	15	2	HESA: Current Salary at reference day reported
44	EMPPREYR	☐	P08_HESA_EMPPREYR_OLD	NUMC2	NUMC	2	0	HESA: Previous Employment	*
45	DATELHEI	☐	P08_HESA_DATELHEI	DATUM	DATS	8	0	HESA: Date left a HESA returnable appointment
46	DEST	☐	P08_HESA_DEST_OLD	NUMC02	NUMC	2	0	HESA: Destination on leaving	*
47	SENPH	☐	P08_HESA_SENPH_SCREEN	XFELD	CHAR	1	0	HESA: Senior management post holder
48	SREAD	☐	P08_HESA_READER_SCREEN	XFELD	CHAR	1	0	HESA: Reader
49	APPCONT	☐	P08_HESA_APPCONT	CHAR1	CHAR	1	0	HESA: Appointment identifier
50	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_SAP	CCENTRE	T5GPBSH_CCT	CCENTRE	KEY
2	P08P_HESA_OUT_SAP	ETHNIC	T5GPBSH_ETC	ETHNIC	KEY
3	P08P_HESA_OUT_SAP	GRADE	T5GPBSH_GRA	GRADE

History

Last changed by/on	SAP	20130529
SAP Release Created in