SAP ABAP Table P08P_HESA_NISR_CONTRACT_DISP (HESA NISR contract record display 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)
⤷ 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_CONTRACT_DISP | Table Relationship Diagram |
Short Description | HESA NISR contract record display 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 | PERNR | PERSNO | PERSNO | NUMC | 8 | 0 | Personnel number | * | |
2 | ENAME | EMNAM | TEXT40 | CHAR | 40 | 0 | Formatted Name of Employee or Applicant | ||
3 | CATEGORY | P08P_HESA_STAFF_CATEGORY | P08P_HESA_STAFF_CATEGORY | CHAR | 1 | 0 | HESA Staff return category for NISR | ||
4 | ERROR | P08P_HESA_ERROR | XFELD | CHAR | 1 | 0 | HESA: flag for HESA validation error | ||
5 | .INCLUDE | 0 | 0 | HESA: NISR Contract record | |||||
6 | RECID | P08_HESA_RECID | NUMC5 | NUMC | 5 | 0 | HESA: Record type indicator | ||
7 | INSTID | P08_HESA_INSTID | P08_HESA_INSTID | CHAR | 4 | 0 | HESA: Institution ID | * | |
8 | CAMPID | P08_HESA_CAMPID | CHAR1 | CHAR | 1 | 0 | HESA: Campus identifier | ||
9 | STAFFID | P08_HESA_STAFFID | CHAR13 | CHAR | 13 | 0 | HESA staff ID | ||
10 | CONTRACTID | P08P_HESA_CONTID | P08P_HESA_CONTID | CHAR | 20 | 0 | HESA: Contract Identifier | ||
11 | TERMS | P08P_HESA_NISR_TERMS | P08P_HESA_NISR_TERMS | NUMC | 1 | 0 | HESA: Terms of employment | ||
12 | MOE | P08P_HESA_NISR_MOE | P08_HESA_NISR_MOE | NUMC | 1 | 0 | HESA: Mode of employment | ||
13 | PEMPFUN | P08_HESA_PEMPFUN | P08_HESA_PEMPFUN | CHAR | 1 | 0 | HESA: Academic employment function | ||
14 | FTE | P08P_HESA_FTE | CHAR5 | CHAR | 5 | 0 | HESA: Full-time Equivalent in output format | ||
15 | TCHWLH | P08_HESA_TCHWLH | P08_HESA_TCHWLH | CHAR | 1 | 0 | HESA: Teaching through the medium of Welsh | ||
16 | GRADE | P08_HESA_GRADE | P08_HESA_GRADE | CHAR | 2 | 0 | HESA: Grade structure | * | |
17 | SMPH | P08P_HESA_NISR_SENPH | P08P_HESA_NISR_SENPH | CHAR | 1 | 0 | HESA: Senior management post holder | ||
18 | PSOS | P08_HESA_PRSBS | P08_HESA_PSOS | CHAR | 2 | 0 | HESA: Principal source of basic salary | * | |
19 | PSCAGI | P08P_HESA_FTE | CHAR5 | CHAR | 5 | 0 | HESA: Full-time Equivalent in output format | ||
20 | SSOS | P08_HESA_SSOS | P08_HESA_SSOS | CHAR | 2 | 0 | HESA: Secondary source of basic salary | * | |
21 | SALPOINT | P08P_HESA_SALPOINT | CHAR3 | CHAR | 3 | 0 | HESA: Salary point | ||
22 | SALARY | P08P_HESA_SALREF | CHAR07 | CHAR | 7 | 0 | HESA: Basic Salary at Reference Date | ||
23 | NHSJOINT | P08P_CLIN_CTYPE | P08P_CLIN_CTYPE | CHAR | 1 | 0 | HESA: NHS Contract type | * | |
24 | CGRADE | P08P_CLIN_CGRADE | P08P_CLIN_CGRADE | CHAR | 2 | 0 | HESA: NHS contract grade (clinical) | T5GPBSC_CGR | |
25 | SPECL | P08_CLIN_SPECL | P08_CLIN_SPECL | CHAR | 3 | 0 | Clinical specialty | T5GPBSC_SPE | |
26 | HEIJOINT | P08_HESA_INSTID | P08_HESA_INSTID | CHAR | 4 | 0 | HESA: Institution ID | * | |
27 | ACTUAL_BEGDA | BEGDA | DATUM | DATS | 8 | 0 | Start Date | ||
28 | ACTUAL_ENDDA | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
29 | ACT01 | P08P_HESA_OCC | P08P_HESA_OCC | CHAR | 2 | 0 | HESA: Occupational categorie, activity code | T5GPBSH_OCC | |
30 | CCE01 | P08_HESA_CCENTRE | P08_HESA_CCENTRE | CHAR | 2 | 0 | HESA: Cost centre ("HEFCE") | T5GPBSH_CCT2 | |
31 | CCP01 | P08P_HESA_FTE | CHAR5 | CHAR | 5 | 0 | HESA: Full-time Equivalent in output format | ||
32 | ACT02 | P08P_HESA_OCC | P08P_HESA_OCC | CHAR | 2 | 0 | HESA: Occupational categorie, activity code | T5GPBSH_OCC | |
33 | CCE02 | P08_HESA_CCENTRE | P08_HESA_CCENTRE | CHAR | 2 | 0 | HESA: Cost centre ("HEFCE") | T5GPBSH_CCT2 | |
34 | CCP02 | P08P_HESA_FTE | CHAR5 | CHAR | 5 | 0 | HESA: Full-time Equivalent in output format | ||
35 | ACT03 | P08P_HESA_OCC | P08P_HESA_OCC | CHAR | 2 | 0 | HESA: Occupational categorie, activity code | T5GPBSH_OCC | |
36 | CCE03 | P08_HESA_CCENTRE | P08_HESA_CCENTRE | CHAR | 2 | 0 | HESA: Cost centre ("HEFCE") | T5GPBSH_CCT2 | |
37 | CCP03 | P08P_HESA_FTE | CHAR5 | CHAR | 5 | 0 | HESA: Full-time Equivalent in output format | ||
38 | GRADID | P08_HESA_GRADID | P08_HESA_GRADID | CHAR | 10 | 0 | HESA: Grade identifier | ||
39 | CLINICAL | P08P_CLIN_CLINICAL | P08P_HESA_CLINICAL | CHAR | 1 | 0 | HESA: Clinical Status | ||
40 | 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 | P08P_HESA_NISR_CONTRACT_DISP | ACT01 | T5GPBSH_OCC | OCCAT | REF | 1 | CN |
2 | P08P_HESA_NISR_CONTRACT_DISP | ACT02 | T5GPBSH_OCC | OCCAT | REF | 1 | CN |
3 | P08P_HESA_NISR_CONTRACT_DISP | ACT03 | T5GPBSH_OCC | OCCAT | REF | 1 | CN |
4 | P08P_HESA_NISR_CONTRACT_DISP | CCE01 | T5GPBSH_CCT2 | CCENTRE | REF | 1 | CN |
5 | P08P_HESA_NISR_CONTRACT_DISP | CCE02 | T5GPBSH_CCT2 | CCENTRE | REF | 1 | CN |
6 | P08P_HESA_NISR_CONTRACT_DISP | CCE03 | T5GPBSH_CCT2 | CCENTRE | REF | 1 | CN |
7 | P08P_HESA_NISR_CONTRACT_DISP | CGRADE | T5GPBSC_CGR | CGRADE | REF | 1 | CN |
8 | P08P_HESA_NISR_CONTRACT_DISP | SPECL | T5GPBSC_SPE | SPECL | REF | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 470 |