SAP ABAP Table PAPBSGB_HESA_C (HESA Archive table for NISR Contract 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_C | Table Relationship Diagram |
Short Description | HESA Archive table for NISR Contract 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 | SEQNR | SEQNR | NUM03 | NUMC | 3 | 0 | Number of Infotype Record With Same Key | ||
5 | AEDTM | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
6 | ATIME | UZEIT | UZEIT | TIMS | 6 | 0 | Time | ||
7 | UNAME | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
8 | .INCLUDE | 0 | 0 | HESA: NISR Contract record | |||||
9 | RECID | P08_HESA_RECID | NUMC5 | NUMC | 5 | 0 | HESA: Record type indicator | ||
10 | INSTID | P08_HESA_INSTID | P08_HESA_INSTID | CHAR | 4 | 0 | HESA: Institution ID | * | |
11 | CAMPID | P08_HESA_CAMPID | CHAR1 | CHAR | 1 | 0 | HESA: Campus identifier | ||
12 | STAFFID | P08_HESA_STAFFID | CHAR13 | CHAR | 13 | 0 | HESA staff ID | ||
13 | CONTRACTID | P08P_HESA_CONTID | P08P_HESA_CONTID | CHAR | 20 | 0 | HESA: Contract Identifier | ||
14 | TERMS | P08P_HESA_NISR_TERMS | P08P_HESA_NISR_TERMS | NUMC | 1 | 0 | HESA: Terms of employment | ||
15 | MOE | P08P_HESA_NISR_MOE | P08_HESA_NISR_MOE | NUMC | 1 | 0 | HESA: Mode of employment | ||
16 | PEMPFUN | P08_HESA_PEMPFUN | P08_HESA_PEMPFUN | CHAR | 1 | 0 | HESA: Academic employment function | ||
17 | FTE | P08P_HESA_FTE | CHAR5 | CHAR | 5 | 0 | HESA: Full-time Equivalent in output format | ||
18 | TCHWLH | P08_HESA_TCHWLH | P08_HESA_TCHWLH | CHAR | 1 | 0 | HESA: Teaching through the medium of Welsh | ||
19 | GRADE | P08_HESA_GRADE | P08_HESA_GRADE | CHAR | 2 | 0 | HESA: Grade structure | T5GPBSH_GRA | |
20 | SMPH | P08P_HESA_NISR_SENPH | P08P_HESA_NISR_SENPH | CHAR | 1 | 0 | HESA: Senior management post holder | ||
21 | PSOS | P08_HESA_PRSBS | P08_HESA_PSOS | CHAR | 2 | 0 | HESA: Principal source of basic salary | T5GPBSH_PSB | |
22 | PSCAGI | P08P_HESA_FTE | CHAR5 | CHAR | 5 | 0 | HESA: Full-time Equivalent in output format | ||
23 | SSOS | P08_HESA_SSOS | P08_HESA_SSOS | CHAR | 2 | 0 | HESA: Secondary source of basic salary | T5GPBSH_SSB | |
24 | SALPOINT | P08P_HESA_SALPOINT | CHAR3 | CHAR | 3 | 0 | HESA: Salary point | ||
25 | SALARY | P08P_HESA_SALREF | CHAR07 | CHAR | 7 | 0 | HESA: Basic Salary at Reference Date | ||
26 | NHSJOINT | P08P_CLIN_CTYPE | P08P_CLIN_CTYPE | CHAR | 1 | 0 | HESA: NHS Contract type | * | |
27 | CGRADE | P08P_CLIN_CGRADE | P08P_CLIN_CGRADE | CHAR | 2 | 0 | HESA: NHS contract grade (clinical) | T5GPBSC_CGR | |
28 | SPECL | P08_CLIN_SPECL | P08_CLIN_SPECL | CHAR | 3 | 0 | Clinical specialty | T5GPBSC_SPE | |
29 | HEIJOINT | P08_HESA_INSTID | P08_HESA_INSTID | CHAR | 4 | 0 | HESA: Institution ID | * | |
30 | ACTUAL_BEGDA | BEGDA | DATUM | DATS | 8 | 0 | Start Date | ||
31 | ACTUAL_ENDDA | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
32 | ACT01 | P08P_HESA_OCC | P08P_HESA_OCC | CHAR | 2 | 0 | HESA: Occupational categorie, activity code | T5GPBSH_OCC | |
33 | CCE01 | P08_HESA_CCENTRE | P08_HESA_CCENTRE | CHAR | 2 | 0 | HESA: Cost centre ("HEFCE") | T5GPBSH_CCT2 | |
34 | CCP01 | P08P_HESA_FTE | CHAR5 | CHAR | 5 | 0 | HESA: Full-time Equivalent in output format | ||
35 | ACT02 | P08P_HESA_OCC | P08P_HESA_OCC | CHAR | 2 | 0 | HESA: Occupational categorie, activity code | T5GPBSH_OCC | |
36 | CCE02 | P08_HESA_CCENTRE | P08_HESA_CCENTRE | CHAR | 2 | 0 | HESA: Cost centre ("HEFCE") | T5GPBSH_CCT2 | |
37 | CCP02 | P08P_HESA_FTE | CHAR5 | CHAR | 5 | 0 | HESA: Full-time Equivalent in output format | ||
38 | ACT03 | P08P_HESA_OCC | P08P_HESA_OCC | CHAR | 2 | 0 | HESA: Occupational categorie, activity code | T5GPBSH_OCC | |
39 | CCE03 | P08_HESA_CCENTRE | P08_HESA_CCENTRE | CHAR | 2 | 0 | HESA: Cost centre ("HEFCE") | T5GPBSH_CCT2 | |
40 | CCP03 | P08P_HESA_FTE | CHAR5 | CHAR | 5 | 0 | HESA: Full-time Equivalent in output format | ||
41 | GRADID | P08_HESA_GRADID | P08_HESA_GRADID | CHAR | 10 | 0 | HESA: Grade identifier | ||
42 | CLINICAL | P08P_CLIN_CLINICAL | P08P_HESA_CLINICAL | CHAR | 1 | 0 | HESA: Clinical Status | ||
43 | PROFE | P08_HESA_PROFE | CHAR1 | CHAR | 1 | 0 | HESA: Professor |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PAPBSGB_HESA_C | ACT01 | T5GPBSH_OCC | OCCAT | REF | 1 | CN |
2 | PAPBSGB_HESA_C | ACT02 | T5GPBSH_OCC | OCCAT | REF | 1 | CN |
3 | PAPBSGB_HESA_C | ACT03 | T5GPBSH_OCC | OCCAT | REF | 1 | CN |
4 | PAPBSGB_HESA_C | CCE01 | T5GPBSH_CCT2 | CCENTRE | REF | 1 | CN |
5 | PAPBSGB_HESA_C | CCE02 | T5GPBSH_CCT2 | CCENTRE | REF | 1 | CN |
6 | PAPBSGB_HESA_C | CCE03 | T5GPBSH_CCT2 | CCENTRE | REF | 1 | CN |
7 | PAPBSGB_HESA_C | CGRADE | T5GPBSC_CGR | CGRADE | REF | 1 | CN |
8 | PAPBSGB_HESA_C | GRADE | T5GPBSH_GRA | GRADE | KEY | 1 | CN |
9 | PAPBSGB_HESA_C | PSOS | T5GPBSH_PSB | PSOS | REF | 1 | CN |
10 | PAPBSGB_HESA_C | SPECL | T5GPBSC_SPE | SPECL | REF | 1 | CN |
11 | PAPBSGB_HESA_C | SSOS | T5GPBSH_SSB | SSOS | REF | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 500 |