SAP ABAP Table PS0614 (HR Master data: infotype HESA Master data (0614))

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	PS0614	Table Relationship Diagram
Short Description	HR Master data: infotype HESA Master data (0614)

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	STAFF	☐	P08_HESA_STAFFID	CHAR13	CHAR	13	0	HESA staff ID
2	DATEH	☐	P08_HESA_DATEHEI	DATUM	DATS	8	0	HESA: Date entered current service
3	PROFQ	☐	P08_HESA_PROFQHLD	P08_HESA_PROFQHLD	NUMC	1	0	HESA: Professional qualification held
4	RESAC	☐	P08_HESA_RESACT	P08_HESA_RESACT	CHAR	1	0	HESA: Active in the 1996 Research Assessment Exercise	T5GPBSH_RAE
5	ABLWE	☐	P08_HESA_ABLWELSH	P08_HESA_ABLWELSH	CHAR	1	0	HESA: Ability to teach through the medium of Welsh
6	TCHWL	☐	P08_HESA_TCHWLH	P08_HESA_TCHWLH	CHAR	1	0	HESA: Teaching through the medium of Welsh
7	SENPH	☐	P08_HESA_SENPH_SCREEN	XFELD	CHAR	1	0	HESA: Senior management post holder
8	SREAD	☐	P08_HESA_READER_SCREEN	XFELD	CHAR	1	0	HESA: Reader
9	PRIID	☐	P08_HESA_PRIID	P08_HESA_INSTID	CHAR	4	0	HESA: Previous UK institution ID	T5GPBSH_IS
10	EMPPR	☐	P08_HESA_EMPPREYR	P08_HESA_EMPPREYR	CHAR	2	0	HESA: Previous Employment	T5GPBSH_PRV2
11	RESA2	☐	P08P_HESA_RESACT2001	P08P_HESA_RESACT2001	CHAR	1	0	HESA: Active in 2001 Research Assessment Exercise	T5GPBSH_RAE2
12	UOARAE	☐	P08P_HESA_UOARAE	P08P_HESA_UOARAE	CHAR	1	0	HESA: Unit of Assessment - Letter of multiple submission
13	SUBMISSION	☐	P08P_HESA_SUBMISSION	P08P_HESA_SUBMISSION	CHAR	2	0	HESA: Unit of Assessment	T5GPBSH_UOA
14	DISABLE1	☐	P08P_HESA_DISABLE1	P08P_HESA_DISABLE	CHAR	2	0	HESA: Disability1
15	DISABLE2	☐	P08P_HESA_DISABLE2	P08P_HESA_DISABLE2	CHAR	2	0	HESA: Disability2
16	ACTCHQ1	☐	P08P_HESA_ACTCHQUAL	P08P_HESA_ACTCHQUAL	CHAR	2	0	HESA: Academic teaching qualification
17	ACTCHQ2	☐	P08P_HESA_ACTCHQUAL	P08P_HESA_ACTCHQUAL	CHAR	2	0	HESA: Academic teaching qualification
18	ACTCHQ3	☐	P08P_HESA_ACTCHQUAL	P08P_HESA_ACTCHQUAL	CHAR	2	0	HESA: Academic teaching qualification
19	ACTCHQ4	☐	P08P_HESA_ACTCHQUAL	P08P_HESA_ACTCHQUAL	CHAR	2	0	HESA: Academic teaching qualification
20	ACTCHQ5	☐	P08P_HESA_ACTCHQUAL	P08P_HESA_ACTCHQUAL	CHAR	2	0	HESA: Academic teaching qualification
21	ACTCHQ6	☐	P08P_HESA_ACTCHQUAL	P08P_HESA_ACTCHQUAL	CHAR	2	0	HESA: Academic teaching qualification
22	ACTLEAVE	☐	P08P_HESA_ACTLEAVE	P08P_HESA_ACTLEAVE	CHAR	2	0	HESA: Activity after leaving
23	LOCLEAVE	☐	P08P_HESA_LOCLEAVE	P08P_HESA_LOCLEAVE	CHAR	1	0	HESA: Location after leaving
24	ECRSTAT	☐	P08P_HESA_ECRSTAT	P08P_HESA_ECRSTAT	CHAR	1	0	HESA: Early career researcher status
25	RESAST	☐	P08P_HESA_RESAST	P08P_HESA_RESAST	CHAR	1	0	HESA: Research Assistant
26	DISABLE3	☐	P08P_HESA_DISABLE3	P08P_HESA_DISABLE3	CHAR	2	0	HESA: Disability
27	GENDERID	☐	P08P_HESA_GENDERID	P08P_HESA_GENDERID	CHAR	2	0	HESA: Gender Identity
28	NATIOND1	☐	P08P_HESA_NATIOND	P08P_HESA_NATIOND	CHAR	1	0	HESA: National Identity
29	NATIOND2	☐	P08P_HESA_NATIOND	P08P_HESA_NATIOND	CHAR	1	0	HESA: National Identity
30	SEXORT	☐	P08P_HESA_SEXORT	P08P_HESA_SEXORT	CHAR	2	0	HESA: Sexual Orientation
31	CDIS1	☐	P08_HESA_DISC	P08_HESA_DISC	CHAR	4	0	Academic discipline	T5GPBSH_DIS2
32	CDIS2	☐	P08_HESA_DISC	P08_HESA_DISC	CHAR	4	0	Academic discipline	T5GPBSH_DIS2
33	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PS0614	CDIS1	T5GPBSH_DIS2	DISC	KEY
2	PS0614	CDIS2	T5GPBSH_DIS2	DISC	KEY
3	PS0614	EMPPR	T5GPBSH_PRV2	EMPPREYR	REF	1	CN
4	PS0614	PRIID	T5GPBSH_IS	INSTID
5	PS0614	RESA2	T5GPBSH_RAE2	RESACT	KEY	1	CN
6	PS0614	RESAC	T5GPBSH_RAE	RESACT
7	PS0614	SUBMISSION	T5GPBSH_UOA	SUBMISSION	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in