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