MANDT |
✔ |
Client |
MANDT |
CLNT |
3 |
* |
FYEAR |
✔ |
Year |
P08_YEAR |
NUMC |
4 |
|
RECID |
✔ |
TPS Control record ID |
P08P_TPS_ID |
CHAR |
8 |
|
PERNR |
✔ |
Personnel number |
PERSNO |
NUMC |
8 |
* |
SEQNR |
✔ |
TPS Record serial number |
P08P_TPS_SERIAL_NUM |
NUMC |
1 |
|
AEDTM |
|
Changed On |
AEDAT |
DATS |
8 |
|
ATIME |
|
Time |
UZEIT |
TIMS |
6 |
|
UNAME |
|
Name of Person Who Changed Object |
AENAM |
CHAR |
12 |
|
TDFES |
|
TPS Teacher's DfES reference number |
P08P_TPS_DFES |
NUMC |
7 |
|
GENDER |
|
Gender Key |
GESCH |
CHAR |
1 |
|
PERNI |
|
TPS National Insurance Number |
P08P_TPS_NI |
CHAR |
9 |
|
SNAME |
|
TPS Surname |
P08P_TPS_SNAME |
CHAR |
9 |
|
INITS |
|
TPS Initials |
P08P_TPS_INITS |
CHAR |
2 |
|
BNAME |
|
TPS Previous surname |
P08P_TPS_BNAME |
CHAR |
9 |
|
BDATE |
|
Date of Birth |
GBDAT |
DATS |
8 |
|
AREAC |
|
TPS LEA number / Area code |
P08P_TPS_LEA_AREA |
CHAR |
3 |
|
SCLTY |
|
TPS School number or type of employment |
P08P_TPS_SCL_TYPE |
NUMC |
4 |
|
SALSC |
|
TPS Salary scale code |
P08P_TPS_SAL_SCALE |
CHAR |
3 |
|
FPTIME |
|
TPS Full or part time indicator |
P08P_TPS_FPTIME |
CHAR |
1 |
|
BEGDA |
|
Start Date |
BEGDA |
DATS |
8 |
|
ENDDA |
|
End Date |
ENDDA |
DATS |
8 |
|
WITHD |
|
TPS Withdrawal confirmation |
P08P_TPS_WITHDRAWAL |
CHAR |
1 |
|
DAYEX |
|
TPS Days excluded from service |
P08P_TPS_DAYS_EXCL |
CHAR |
3 |
|
FULSAL |
|
TPS Salary rate |
P08P_TPS_SAL_RATE |
NUMC |
6 |
|
INCRM |
|
TPS Incremental Point |
P08P_TPS_INCRM_POINT |
NUMC |
2 |
|
PARSAL |
|
TPS Salary rate |
P08P_TPS_SAL_RATE |
NUMC |
6 |
|
SAFAS |
|
TPS Safeguarded salary or fast track contract indicator |
P08P_TPS_SAFAS |
CHAR |
1 |
|
LONDON |
|
TPS Allowance rate indicator |
P08P_TPS_RATE_INDICATOR |
CHAR |
1 |
|
SPASEN |
|
TPS Allowance rate indicator |
P08P_TPS_RATE_INDICATOR |
CHAR |
1 |
|
REGUL |
|
TPS regular or irregular part-time employment indicator |
P08P_TPS_REGULAR |
NUMC |
1 |
|
ALLOW |
|
TPS Allowance rate |
P08P_TPS_ALLOW_RATE |
NUMC |
5 |
|
RECTY |
|
TPS record type |
P08P_TPS_REC_TYPE |
NUMC |
1 |
|
SERNM |
|
TPS Record serial number |
P08P_TPS_SERIAL_NUM |
NUMC |
1 |
|
SUPPL |
|
TPS Allowance rate |
P08P_TPS_ALLOW_RATE |
NUMC |
5 |
|
FULS2 |
|
TPS Salary rate |
P08P_TPS_SAL_RATE |
NUMC |
6 |
|
PARS2 |
|
TPS Salary rate |
P08P_TPS_SAL_RATE |
NUMC |
6 |
|
ALLO2 |
|
TPS Allowance rate |
P08P_TPS_ALLOW_RATE |
NUMC |
5 |
|
SUPP2 |
|
TPS Allowance rate |
P08P_TPS_ALLOW_RATE |
NUMC |
5 |
|