SAP ABAP Table PAPBSGB_HESA_P (HESA: Archive table for NISR Person table)

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	TRANSP	Transparent table
Transparent table	PAPBSGB_HESA_P	Table Relationship Diagram
Short Description	HESA: Archive table for NISR Person table

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	HYEAR	☑	P08_YEAR	GJAHR	NUMC	4	0	Year
3	PERNR	☑	PERSNO	PERSNO	NUMC	8	0	Personnel number	*
4	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
5	ATIME	☐	UZEIT	UZEIT	TIMS	6	0	Time
6	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
7	.INCLUDE	☐				0	0	HESA: NISR Person table format
8	RECID	☐	P08_HESA_RECID	NUMC5	NUMC	5	0	HESA: Record type indicator
9	INSTID	☐	P08_HESA_INSTID	P08_HESA_INSTID	CHAR	4	0	HESA: Institution ID	*
10	STAFFID	☐	P08_HESA_STAFFID	CHAR13	CHAR	13	0	HESA staff ID
11	BIRTHDATE	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
12	GENDER	☐	P08_HESA_GENDER	P08_HESA_GENDER	CHAR	1	0	HESA: Gender code
13	NATION	☐	P08_HESA_NATION	P08_HESA_NATION	CHAR	4	0	HESA: Nationality code
14	ETHNIC	☐	P08_HESA_ETHNIC	P08_HESA_ETHNIC	NUMC	2	0	HESA: Ethnicitiy code	T5GPBSH_ETC
15	NATID1	☐	P08P_HESA_NATID	P08P_HESA_NATID	CHAR	1	0	HESA: National Identity (Wales only)
16	NATID2	☐	P08P_HESA_NATID	P08P_HESA_NATID	CHAR	1	0	HESA: National Identity (Wales only)
17	DISABLE	☐	P08_HESA_DISABLE	P08_HESA_DISABLE	CHAR	1	0	HESA: Disabled
18	DATEHEI	☐	P08_HESA_DATEHEI	DATUM	DATS	8	0	HESA: Date entered current service
19	PREVEMP	☐	P08_HESA_EMPPREYR	P08_HESA_EMPPREYR	CHAR	2	0	HESA: Previous Employment	T5GPBSH_PRV2
20	PREVHEI	☐	P08_HESA_INSTID	P08_HESA_INSTID	CHAR	4	0	HESA: Institution ID	*
21	QUALHELD	☐	P08_HESA_QUAL	P08_HESA_QUAL	CHAR	2	0	HESA: Highest academic qualification	T5GPBSH_QUD2
22	ACCDIS1	☐	P08_HESA_ACD	P08_HESA_ACD	CHAR	4	0	HESA: Code for Academic Discipline	T5GPBSH_ACD
23	ACCDIS2	☐	P08_HESA_ACD	P08_HESA_ACD	CHAR	4	0	HESA: Code for Academic Discipline	T5GPBSH_ACD
24	RBODY	☐	P08P_CLIN_RBODY	P08P_CLIN_RBODY	CHAR	2	0	HESA: Regulatory body (clinical)	T5GPBSC_RBD
25	ABLWELSH	☐	P08_HESA_ABLWELSH	P08_HESA_ABLWELSH	CHAR	1	0	HESA: Ability to teach through the medium of Welsh
26	DATELHEI	☐	P08_HESA_DATELHEI	DATUM	DATS	8	0	HESA: Date left a HESA returnable appointment
27	DEST	☐	P08_HESA_DEST	P08_HESA_DEST	CHAR	2	0	HESA: Destination on leaving	T5GPBSH_DES2
28	RESACT	☐	P08P_HESA_RESACT2001	P08P_HESA_RESACT2001	CHAR	1	0	HESA: Active in 2001 Research Assessment Exercise	*
29	UOA	☐	P08P_HESA_UOA	P08P_HESA_UOA	CHAR	3	0	HESA: Unit of Assessment
30	TOTSAL	☐	P08P_HESA_TOTSAL	NUM07	NUMC	7	0	HESA: Total monies paid
31	DISABLE1	☐	P08P_HESA_DISABLE1	P08P_HESA_DISABLE	CHAR	2	0	HESA: Disability1
32	DISABLE2	☐	P08P_HESA_DISABLE2	P08P_HESA_DISABLE2	CHAR	2	0	HESA: Disability2

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PAPBSGB_HESA_P	ACCDIS1	T5GPBSH_ACD	HESAC	REF	1	CN
2	PAPBSGB_HESA_P	ACCDIS2	T5GPBSH_ACD	HESAC	REF	1	CN
3	PAPBSGB_HESA_P	DEST	T5GPBSH_DES2	DEST	REF	1	CN
4	PAPBSGB_HESA_P	ETHNIC	T5GPBSH_ETC	ETHNIC	REF	1	CN
5	PAPBSGB_HESA_P	PREVEMP	T5GPBSH_PRV2	EMPPREYR	REF	1	CN
6	PAPBSGB_HESA_P	QUALHELD	T5GPBSH_QUD2	QUAL	REF	1	CN
7	PAPBSGB_HESA_P	RBODY	T5GPBSC_RBD	RBODY	REF	1	CN

History

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