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)
⤷ 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 |