Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Company Cost Centres
    • CostCentre
  • Company Departments
    • Department
  • Company Divisions
    • Division
  • Company Nominal Codes
    • Type - Department or Cost Centre
    • Description
    • Nominal CodeNominalCode
  • Company Nominal Masks
    • Description
    • Source1
    • CharPos1
    • Source2
    • CharPos2
    • ...
    • Source39
    • CharPos39
    • Source40
    • CharPos40
  • Company Pay Elements
    • Factor
    • GenderPayGap
    • GenderPayGapBonus
    • GenderPayGapHours
    • NIable
    • NMW
    • Notional
    • PayElement
    • PayElementName
    • Payment
    • Pensionable - (used for Auto Enroment Enrolment Qualifying Earnings)
    • RateAmount
    • RateType
    • Salary
    • SalarySacrifice
    • Taxable
  • Company Pay Elements (Update)
    • Archived
    • Factor
    • GenderPayGap
    • GenderPayGapBonus
    • GenderPayGapHours
    • NominalCode
    • NominalCode2
    • PayElement
    • QualifyingEarnings
    • PayElementName
    • RateAmount
    • RateType
  • Employee Additional Starter
    • EmployeeNumber
    • Forename
    • Surname
    • NINumber
    • Department
    • Division
    • CostCentre1
    • CostCentrePercent1
    • CostCentre2
    • CostCentrePercent2
    • CostCentre3
    • CostCentrePercent3
    • Department1 

    • DepartmentPercent1 

    • Department2 

    • DepartmentPercent2 

    • Department3 

    • DepartmentPercent3

    • P45EmployersReference
    • P45LeavingDate
    • P45PayFrequency
    • P45PeriodNo
    • P45TaxablePay
    • P45TaxBasis
    • P45TaxCode
    • P45TaxDistrictNo
    • P45TaxPaid
    • P46Statement
    • P46StatementD
    • P46Statement
    • P46StatementD
    • HolidayScheme
    • RolledOverDays
    • HolidayRate
    • P46StudentLoan

    • StudentLoanBeforeLast6April

    • StudentLoanPlanType 

    • StudentLoanRepayDirectly

  • Employee Bank Details
    • AccountName
    • AccountNumber
    • EmployeeNumber
    • SortCode
    • Forename
    • NINumber
    • RollNumber
    • Surname
  • Employee Basic (This is actually an updater only so template must be first exported)
    • EmployeeNumber
    • Address1
    • Address2
    • Address3
    • County
    • DateOfBirth
    • Forename
    • HoursWorked - Requires A,B,C,D or E
    • IrregularPayments
    • NINumber
    • NoticeDate - Auto Enrolment related
    • OptOutDate - Auto Enrolment related
    • Postcode
    • PostponeDate - Auto Enrolment related
    • Sex
    • Surname
    • TeacherNo
    • EmailPayslip
    • TerminateDate - Auto Enrolment related
    • Title
    • Town
    • WorkEmail
    • Teacher No
    • Make Starter Current
    • Contracted Hours
    • Irregular Hours
    • ExternalId
  • Employee Holiday
    • EmployeeNumber
    • HolidayRateType (manual,calculated rate,company rate)
    • LeaveEndDate
    • LeaveStartDate
    • NoOfDays
    • Forename
    • HolidayRate
    • NINumber
    • Surname
  • Employee Holiday Scheme
    • Accrued Override
    • Carried Forward
    • EmployeeNumber
    • Forename
    • NINumber
    • Scheme
    • Surname
  • Employee Holiday Take On
    • EmployeeNumber
    • Forename
    • Surname
    • Period1Pay
    • Period2Pay 
    • ...
    • Period11Pay
    • Period12Pay
    • Period1Hours
    • Period2Hours
    • ...
    • Period11Hours
    • Period12Hours
  • Employee Leaver
    • EmployeeNumber
    • Forename
    • Surname
    • NINumber
    • LeavingDate
    • LeavingReason
    • PaidToDate
    • WholePeriod
  • Employee Number Update
    • EmployeeNumber
    • Forename
    • Surname
    • NewEmployeeNumber
  • Employee Locations
    • EmployeeNumber
    • StartDate
    • CostCentre1
    • CostCentre2
    • CostCentre3
    • CostCentrePercent1
    • CostCentrePercent2
    • CostCentrePercent3
    • Department
    • Department1 

    • DepartmentPercent1 

    • Department2 

    • DepartmentPercent2 

    • Department3 

    • DepartmentPercent3

    • Division
    • Forename
    • NINumber
    • Surname
  • Employee One-Off Payments
    • Amount
    • EmployeeNumber
    • PayElement
    • PayPeriod
    • Forename
    • Hours
    • NINumber
    • Rate
    • Surname
  • Employee OSP Scheme
    • EmployeeNumber
    • Forename
    • Surname
    • OSPScheme
    • EffectiveDate
  • Employee Payments
    • EmployeeNumber
    • PayElement
    • StartDate
    • AnnualAmount
    • ContractedHours
    • EndDate
    • Forename
    • LoanBalance
    • NINumber
    • PeriodAmount
    • RateEffectiveDate
    • Surname
  • Employee Pensions
    • EmployeeNumber
    • PensionScheme
    • StartDate
    • EEAmount
    • EEType - P or V for Percentage or Value
    • EndDate
    • ERAmount
    • ERType - P or V for Percentage or Value
    • Forename
    • NINumber
    • OverrideContr
    • Surname
    • EndAll
      • Y: end all of the employee's current pensions before importing the new record
      • N: end all of the employee's current pensions on the same scheme before importing the new record
  • Employee Pay Element Rates
    • EmployeeNumber
    • PayElement
    • Forename
    • NINumber
    • Surname
    • Units
    • Value
  • Employee Spinal Points
    • EmployeeNumber
    • Forename
    • Surname
    • NINumber
    • Grade
    • Point
    • Start Date
    • End Date
    • FTE
    • Full Time Hours
    • Working Hours
    • Working Weeks
    • Custom 1
    • Custom 2
  • Employee SSP
    • EmployeeNumber
    • Forname
    • Surname
    • NINumber
    • SSPStartDate
    • SSPEndDate
    • AlreadyPaid
  • Employee Starter*
    • DateOfBirth
    • DateOfJoining
    • EmployeeNumber
    • Forename
    • NINumber
    • NITableLetter
    • Payroll
    • ServiceStartDate
    • Sex - M or F
    • Surname
    • TaxBasis
    • TaxCode
    • Title
    • Workgroup
    • AcademyPayElement
    • AccountName
    • AccountNumber
    • Address1
    • Address2
    • Address3
    • AnnualAmount - For Salary
    • AnnualAmountD
    • PayElement - For Salary
    • ContractedHours
    • CostCentre1
    • CostCentre2
    • CostCentre3
    • CostCentrePercent1
    • CostCentrePercent2
    • CostCentrePercent3
    • County
    • Deduction
    • Department
    • Department1
    • DepartmentPercent1
    • Department2
    • DepartmentPercent2
    • Department3
    • DepartmentPercent3
    • DirectorNonCumulative
    • DirectorStartDate
    • Division
    • EEAmount
    • EEType
    • ERAmount
    • ERType - P or V for percentage or value
    • ExternalId
    • FTE
    • FTEWorkingWeeks
    • FullTimeHours
    • Grade
    • HoursWorked - A, B, C , D or E
    • IrregularPayments
    • KnownAs
    • Leaver
    • LeavingDate
    • LoanBalance
    • MethodOfPayment
    • MiddleName
    • Migrated - Employee will be set to current not starter
    • NotificationDate
    • NotificationSource
    • OSPScheme
    • P45EmployersReference
    • P45LeavingDate
    • P45PayFrequency
    • P45PeriodNo
    • P45TaxablePay
    • P45TaxBasis
    • P45TaxCode
    • P45TaxDistrictNo
    • P45TaxPaid
    • P46StatementP46StatementD
    • P46StudentLoan
    • PayType
    • PensionScheme
    • PeriodAmount
    • PeriodAmountD
    • PGLoanNotRepaid
    • PGMonthlyPayments
    • Point
    • Postcode
    • RollNumber
    • ScheduleOverride
    • ScheduleStartDate
    • Scottish
    • SortCodeStudentLoanStartDate
    • StudentLoanPlanType
    • StudentLoanRepayDirectly
    • StudentLoanBeforeLast6April
    • TaxOffice
    • Town
    • WorkEmail
    • WorkingHours
  • Employee Statutory Override
    • EmployeeNumber
    • Forename
    • Surname
    • NINumber
    • PayPeriod
    • PayElement
    • Amount
  • Employee Tax Codes
    • EmployeeNumber
    • StartDate
    • TaxBasis
    • TaxCode
    • Forename
    • NINumber
    • NotificationDate
    • NotificationSource - P6, P9, P45 or P46
    • Scottish
    • Surname
  • Employee Timesheets
    • EmployeeNumber
    • PayElement
    • PayPeriod
    • Amount
    • Forename
    • Hours
    • NINumber
    • Rate
    • Surname
  • Employee Unpaid Leave
    • EmployeeNumber
    • LeaveEndDate
    • LeaveStartDate
    • Forename
    • NINumber
    • Surname
  • Employee YTD NI Balances
    • Amount
    • Director
    • EmployeeNumber
    • NITableLetter
    • PayElement
    • Forename
    • NINumber
    • Surname
  • Employee YTD Pay Balances
    • Amount
    • EmployeeNumber
    • PayElement
    • Forename
    • NINumber
    • Surname

...