PAPBSGB_TPS_ARCH - TPS Archive table for TPS Annual return records of type 1

TPS Archive table for TPS Annual return records of type 1 information is stored in SAP table PAPBSGB_TPS_ARCH.
It is part of development package P08P1 in software component PY-GB-PS. This development package consists of objects that can be grouped under "HR Public Sector Great Britain".

Fields for table PAPBSGB_TPS_ARCH

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT3*
FYEARYearXP08_YEARNUMC4
RECIDTPS Control record IDXP08P_TPS_IDCHAR8
PERNRPersonnel NumberXPERSNONUMC8*
SEQNRTPS Record serial numberXP08P_TPS_SERIAL_NUMNUMC1
AEDTMLast Changed OnAEDATDATS8
ATIMETimeUZEITTIMS6
UNAMEName of Person Who Changed ObjectAENAMCHAR12
.INCLUDEP08P_TPS_HEADER0
TDFESTPS Teacher's DfES reference numberP08P_TPS_DFESNUMC7
GENDERGender KeyGESCHCHAR1
PERNITPS National Insurance NumberP08P_TPS_NICHAR9
SNAMETPS SurnameP08P_TPS_SNAMECHAR9
INITSTPS InitialsP08P_TPS_INITSCHAR2
BNAMETPS Previous surnameP08P_TPS_BNAMECHAR9
BDATEDate of BirthGBDATDATS8
AREACTPS LEA number / Area codeP08P_TPS_LEA_AREACHAR3
.INCLUDEP08P_TPS_SERVICE_VAR0
SCLTYTPS School number or type of employmentP08P_TPS_SCL_TYPENUMC4
SALSCTPS Salary scale codeP08P_TPS_SAL_SCALECHAR3
FPTIMETPS Full or part time indicatorP08P_TPS_FPTIMECHAR1
BEGDAStart DateBEGDADATS8
ENDDAEnd DateENDDADATS8
WITHDTPS Withdrawal confirmationP08P_TPS_WITHDRAWALCHAR1
DAYEXTPS Days excluded from serviceP08P_TPS_DAYS_EXCLCHAR3
FULSALTPS Salary rateP08P_TPS_SAL_RATENUMC6
INCRMTPS Incremental PointP08P_TPS_INCRM_POINTNUMC2
PARSALTPS Salary rateP08P_TPS_SAL_RATENUMC6
SAFASTPS Safeguarded salary or fast track contract indicatorP08P_TPS_SAFASCHAR1
LONDONTPS Allowance rate indicatorP08P_TPS_RATE_INDICATORCHAR1
SPASENTPS Allowance rate indicatorP08P_TPS_RATE_INDICATORCHAR1
REGULTPS regular or irregular part-time employment indicatorP08P_TPS_REGULARNUMC1
ALLOWTPS Allowance rateP08P_TPS_ALLOW_RATENUMC5
RECTYTPS record typeP08P_TPS_REC_TYPENUMC1
SERNMTPS Record serial numberP08P_TPS_SERIAL_NUMNUMC1
SUPPLTPS Allowance rateP08P_TPS_ALLOW_RATENUMC5
FULS2TPS Salary rateP08P_TPS_SAL_RATENUMC6
PARS2TPS Salary rateP08P_TPS_SAL_RATENUMC6
ALLO2TPS Allowance rateP08P_TPS_ALLOW_RATENUMC5
SUPP2TPS Allowance rateP08P_TPS_ALLOW_RATENUMC5
Privacy Policy