| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | HYEAR | Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | P08_YEAR | Allow NULL? |
| 3 | PERNR | Personnel number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | * | PERSNO | Allow NULL? |
| 4 | SEQNR | Number of Infotype Record with Same Key | nvarchar | 3 | 0 | NUMC | (N'000') | No | | SEQNR | Allow NULL? |
| 5 | AEDTM | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 6 | ATIME | Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | UZEIT | Allow NULL? |
| 7 | UNAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 8 | RECID | HESA: Record type indicator | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | P08_HESA_RECID | Allow NULL? |
| 9 | INSTID | HESA: Institution ID | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | P08_HESA_INSTID | Allow NULL? |
| 10 | CAMPID | HESA: Campus identifier | char | 1 | 0 | CHAR | (N' ') | Yes | | P08_HESA_CAMPID | Allow NULL? |
| 11 | STAFFID | HESA staff ID | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | P08_HESA_STAFFID | Allow NULL? |
| 12 | CONTRACTID | HESA: Contract Identifier | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P08P_HESA_CONTID | Allow NULL? |
| 13 | TERMS | HESA: Terms of employment | char | 1 | 0 | NUMC | (N'0') | Yes | | P08P_HESA_NISR_TERMS | Allow NULL? |
| 14 | MOE | HESA: Mode of employment | char | 1 | 0 | NUMC | (N'0') | Yes | | P08P_HESA_NISR_MOE | Allow NULL? |
| 15 | PEMPFUN | HESA: Academic employment function | char | 1 | 0 | CHAR | (N' ') | Yes | | P08_HESA_PEMPFUN | Allow NULL? |
| 16 | FTE | HESA: Full-time Equivalent in output format | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | P08P_HESA_FTE | Allow NULL? |
| 17 | TCHWLH | HESA: Teaching through the medium of Welsh | char | 1 | 0 | CHAR | (N' ') | Yes | | P08_HESA_TCHWLH | Allow NULL? |
| 18 | GRADE | HESA: Grade structure | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T5GPBSH_GRA | P08_HESA_GRADE | Allow NULL? |
| 19 | SMPH | HESA: Senior management post holder | char | 1 | 0 | CHAR | (N' ') | Yes | | P08P_HESA_NISR_SENPH | Allow NULL? |
| 20 | PSOS | HESA: Principal source of basic salary | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T5GPBSH_PSB | P08_HESA_PRSBS | Allow NULL? |
| 21 | PSCAGI | HESA: Full-time Equivalent in output format | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | P08P_HESA_FTE | Allow NULL? |
| 22 | SSOS | HESA: Secondary source of basic salary | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T5GPBSH_SSB | P08_HESA_SSOS | Allow NULL? |
| 23 | SALPOINT | HESA: Salary point | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | P08P_HESA_SALPOINT | Allow NULL? |
| 24 | SALARY | HESA: Basic Salary at Reference Date | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | P08P_HESA_SALREF | Allow NULL? |
| 25 | NHSJOINT | HESA: NHS Contract type | char | 1 | 0 | CHAR | (N' ') | Yes | * | P08P_CLIN_CTYPE | Allow NULL? |
| 26 | CGRADE | HESA: NHS contract grade (clinical) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T5GPBSC_CGR | P08P_CLIN_CGRADE | Allow NULL? |
| 27 | SPECL | Clinical specialty | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T5GPBSC_SPE | P08_CLIN_SPECL | Allow NULL? |
| 28 | HEIJOINT | HESA: Institution ID | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | P08_HESA_INSTID | Allow NULL? |
| 29 | ACTUAL_BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 30 | ACTUAL_ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ENDDA | Allow NULL? |
| 31 | ACT01 | HESA: Occupational categorie, activity code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T5GPBSH_OCC | P08P_HESA_OCC | Allow NULL? |
| 32 | CCE01 | HESA: Cost centre ("HEFCE") | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T5GPBSH_CCT2 | P08_HESA_CCENTRE | Allow NULL? |
| 33 | CCP01 | HESA: Full-time Equivalent in output format | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | P08P_HESA_FTE | Allow NULL? |
| 34 | ACT02 | HESA: Occupational categorie, activity code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T5GPBSH_OCC | P08P_HESA_OCC | Allow NULL? |
| 35 | CCE02 | HESA: Cost centre ("HEFCE") | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T5GPBSH_CCT2 | P08_HESA_CCENTRE | Allow NULL? |
| 36 | CCP02 | HESA: Full-time Equivalent in output format | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | P08P_HESA_FTE | Allow NULL? |
| 37 | ACT03 | HESA: Occupational categorie, activity code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T5GPBSH_OCC | P08P_HESA_OCC | Allow NULL? |
| 38 | CCE03 | HESA: Cost centre ("HEFCE") | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T5GPBSH_CCT2 | P08_HESA_CCENTRE | Allow NULL? |
| 39 | CCP03 | HESA: Full-time Equivalent in output format | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | P08P_HESA_FTE | Allow NULL? |
| 40 | GRADID | HESA: Grade identifier | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P08_HESA_GRADID | Allow NULL? |
| 41 | CLINICAL | HESA: Clinical Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P08P_CLIN_CLINICAL | Allow NULL? |
| 42 | PROFE | HESA: Professor | char | 1 | 0 | CHAR | (N' ') | Yes | | P08_HESA_PROFE | Allow NULL? |
