Versions Compared

Key

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

...

Table

Field

Action

Comment/Extended Property Description

[rar].[BankAccount]

[CompanyName]

Added

Name of the business

[rar].[DeductionHeader]

[ApplyBankDetailsOnPayeeDeduction]

Added

The bank details have been picked up from the payee deduction record

[rar].[DeductionRule]

[BankAccountId]

Added

The bank account ID

[dbo].[HMRCIncomingMessages]

[HMRCWorksNumber]

Updated

[nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[rar].[PayeePayrollNewZealand]

[UseCompanyNameForIRDReporting]

Added

Indicates if the Company Name is to be used for IRD Reporting

[rar].[PayeePayrollPensionEnrolmentsUK]

[APIEnrolmentSentDate]

Added

API Enrolment Sent Date

[rar].[PensionProviders]

[EmployerIdentifier]

Added

Employer Identifier for UK Pension Reporting

[rar].[PensionProviders]

[PensionProviderOutputId]

Added

Foreign Key to rar.PensionProviderOutputs.PensionProviderOutputId for UK Pension Reporting

[rar].[PensionProviders]

[OutputAPIUsername]

Added

Username For API Connections for UK Pension Reporting

[rar].[PensionProviders]

[OutputAPIPassword]

Added

Password For API Connections for UK Pension Reporting

[rar].[PensionProviders]

[OutputAPIEndpoint]

Added

Base endpoint URL for API output

[rar].[PensionSchemes]

[PaymentSource]

Added

The method by which an employer pays contributions to NEST

[rar].[PensionSchemes]

[PensionPaymentScheduleId]

Added

Foreign Key for rar.PensionPaymentSchedule, PensionPaymentScheduleId

[rar].[STPServicePollingConfiguration]

[MinLogicalDocument]

Updated

[MinLogicalDocument] [int] NOT NULL,

[rar].[STPServicePollingConfiguration]

[MaxLogicalDocument]

Updated

[MaxLogicalDocument] [int] NOT NULL,

[rar].[NationalMinimumWagePeriodsUK]

New Table

[rar].[NationalMinimumWageRatesUK]

New Table

[rar].[PensionApiOutgoingMessages]

New Table

[rar].[PensionManagementBatchItem]

New Table

[rar].[PensionManagementBatch]

New Table

[rar].[PensionPaymentSchedulePeriod]

New Table

[rar].[PensionPaymentSchedule]

New Table

[rar].[PensionProviderOutputTypes]

New Table

This table contains the Pension Provider Output Type details for each PensionProviderOutputs record

[rar].[PensionProviderOutputs]

New Table

This table contains the Pension Provider Output header details (Name and Output Type)