SAP ABAP Table P08P_HESA_NISR_PERSON (HESA: NISR Person table 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_NISR_PERSON	Table Relationship Diagram
Short Description	HESA: NISR Person table 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	STAFFID	☐	P08_HESA_STAFFID	CHAR13	CHAR	13	0	HESA staff ID
4	BIRTHDATE	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
5	GENDER	☐	P08_HESA_GENDER	P08_HESA_GENDER	CHAR	1	0	HESA: Gender code
6	NATION	☐	P08_HESA_NATION	P08_HESA_NATION	CHAR	4	0	HESA: Nationality code
7	ETHNIC	☐	P08_HESA_ETHNIC	P08_HESA_ETHNIC	NUMC	2	0	HESA: Ethnicitiy code	T5GPBSH_ETC
8	NATID1	☐	P08P_HESA_NATID	P08P_HESA_NATID	CHAR	1	0	HESA: National Identity (Wales only)
9	NATID2	☐	P08P_HESA_NATID	P08P_HESA_NATID	CHAR	1	0	HESA: National Identity (Wales only)
10	DISABLE	☐	P08_HESA_DISABLE	P08_HESA_DISABLE	CHAR	1	0	HESA: Disabled
11	DATEHEI	☐	P08_HESA_DATEHEI	DATUM	DATS	8	0	HESA: Date entered current service
12	PREVEMP	☐	P08_HESA_EMPPREYR	P08_HESA_EMPPREYR	CHAR	2	0	HESA: Previous Employment	T5GPBSH_PRV2
13	PREVHEI	☐	P08_HESA_INSTID	P08_HESA_INSTID	CHAR	4	0	HESA: Institution ID	*
14	QUALHELD	☐	P08_HESA_QUAL	P08_HESA_QUAL	CHAR	2	0	HESA: Highest academic qualification	T5GPBSH_QUD2
15	ACCDIS1	☐	P08_HESA_ACD	P08_HESA_ACD	CHAR	4	0	HESA: Code for Academic Discipline	T5GPBSH_ACD
16	ACCDIS2	☐	P08_HESA_ACD	P08_HESA_ACD	CHAR	4	0	HESA: Code for Academic Discipline	T5GPBSH_ACD
17	RBODY	☐	P08P_CLIN_RBODY	P08P_CLIN_RBODY	CHAR	2	0	HESA: Regulatory body (clinical)	T5GPBSC_RBD
18	ABLWELSH	☐	P08_HESA_ABLWELSH	P08_HESA_ABLWELSH	CHAR	1	0	HESA: Ability to teach through the medium of Welsh
19	DATELHEI	☐	P08_HESA_DATELHEI	DATUM	DATS	8	0	HESA: Date left a HESA returnable appointment
20	DEST	☐	P08_HESA_DEST	P08_HESA_DEST	CHAR	2	0	HESA: Destination on leaving	T5GPBSH_DES2
21	RESACT	☐	P08P_HESA_RESACT2001	P08P_HESA_RESACT2001	CHAR	1	0	HESA: Active in 2001 Research Assessment Exercise	*
22	UOA	☐	P08P_HESA_UOA	P08P_HESA_UOA	CHAR	3	0	HESA: Unit of Assessment
23	TOTSAL	☐	P08P_HESA_TOTSAL	NUM07	NUMC	7	0	HESA: Total monies paid
24	DISABLE1	☐	P08P_HESA_DISABLE1	P08P_HESA_DISABLE	CHAR	2	0	HESA: Disability1
25	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	P08P_HESA_NISR_PERSON	ACCDIS1	T5GPBSH_ACD	HESAC	REF	1	CN
2	P08P_HESA_NISR_PERSON	ACCDIS2	T5GPBSH_ACD	HESAC	REF	1	CN
3	P08P_HESA_NISR_PERSON	DEST	T5GPBSH_DES2	DEST	REF	1	CN
4	P08P_HESA_NISR_PERSON	ETHNIC	T5GPBSH_ETC	ETHNIC	REF	1	CN
5	P08P_HESA_NISR_PERSON	PREVEMP	T5GPBSH_PRV2	EMPPREYR	REF	1	CN
6	P08P_HESA_NISR_PERSON	QUALHELD	T5GPBSH_QUD2	QUAL	REF	1	CN
7	P08P_HESA_NISR_PERSON	RBODY	T5GPBSC_RBD	RBODY	REF	1	CN

History

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