PAPBSGB_TPS_ARCH

TPS Archive table for TPS Annual return records of type 1 | #masterdata | Component: null
Column Name Description
MANDT Client
FYEAR Year
RECID TPS Control record ID
PERNR Personnel Number
SEQNR TPS Record serial number
Column Name Description
Column Name Description
Column Name Description
AEDTM Last Changed On
ATIME Time
BDATE Date of Birth
BEGDA Start Date
ENDDA End Date
Column Name Description
GENDER Gender Key Show values
FPTIME TPS Full or part time indicator Show values
WITHD TPS Withdrawal confirmation Show values
LONDON TPS Allowance rate indicator Show values
SPASEN TPS Allowance rate indicator Show values
REGUL TPS regular or irregular part-time employment indicator Show values
RECTY TPS record type Show values
Column Name Description Domain name
UNAME Name of Person Who Changed Object USNAM
TDFES TPS Teacher's DfES reference number NUM07
PERNI TPS National Insurance Number CHAR9
SNAME TPS Surname CHAR9
INITS TPS Initials CHAR2
BNAME TPS Previous surname CHAR9
AREAC TPS LEA number / Area code CHAR3
SCLTY TPS School number or type of employment NUMC04
SALSC TPS Salary scale code CHAR3
DAYEX TPS Days excluded from service CHAR3
FULSAL TPS Salary rate NUM06
INCRM TPS Incremental Point NUM02
PARSAL TPS Salary rate NUM06
SAFAS TPS Safeguarded salary or fast track contract indicator CHAR1
ALLOW TPS Allowance rate NUM05
SERNM TPS Record serial number NUM01
SUPPL TPS Allowance rate NUM05
FULS2 TPS Salary rate NUM06
PARS2 TPS Salary rate NUM06
ALLO2 TPS Allowance rate NUM05
SUPP2 TPS Allowance rate NUM05