Versions Compared

Key

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

...

It is important to check your custom reports prior to upgrade to ensure they are working as expected. If you find any issues with data, the information below should assist you to make any changes required.Add table

Table

Field

Action

Comment/Extended Property Description

[rar].[GrossWageBatchPayeeSalarySacrificeAdjustmentHistoryUK]

Deleted

[rar].[GrossWageBatchPayeeSalarySacrificeAdjustmentUK]

Deleted

[rar].[NationalMinimumWageGrossWageBatchLink]

Deleted

[rar].[NationalMinimumWageGrossWageBatchLinkHistory]

Deleted

[dbo].[ManualItem]

LeaveRequestTimeId

Field Added

Foreign Key to [rar].[LeaveRequestTime table

[rar].[EmployerPensionContributionsGrossWageBatchHistoryUK]

Sacrifice

Field Added

Decimal (38, 6) NULL

[rar].[EmployerPensionContributionsGrossWageBatchUK]

Sacrifice

Field Added

Decimal (38, 6) NULL

[rar].[GrossWageBatchPayslipPayeePensionUK]

SalarySacrifice

Field Added

DECIMAL (38, 6) DEFAULT ((0)) NOT NULL

[rar].[GrossWageBatchPayslipPayeePensionUK]

SalarySacrificeYTD

Field Added

DECIMAL (38, 6) DEFAULT ((0)) NOT NULL

[rar].[LeaveResetRule]

ResetCarryoverAfterValue

Field Added

Decimal (38, 6) NULL

[rar].[LeaveResetRule]

CarryoverResetPeriodType_no

Field Added

TINYINT NULL

[rar].[LeaveResetRule]

TransferBalanceIntoCarryoverPot

Field Added

BIT DEFAULT ((0)) NOT NULL

[rar].[LeaveTransaction]

IsCarryover

Field Added

BIT NULL

[rar].[LeaveTransaction]

CarryoverExpiryDate

Field Added

DATE NULL

[rar].[LeaveTransactionGrossWageBatch]

IsCarryover

Field Added

BIT NULL

[rar].[LeaveTransactionGrossWageBatch]

CarryoverExpiryDate

Field Added

DATE NULL

[rar].[PayCode]

AttendanceDetailId

Field Added

INT NULL

[rar].[PayCode]

DefaultAttendanceStartTime

Field Added

TIME (7) NULL

[rar].[PayeePayrollChildRelatedPaymentEpisodesUK]

EmployerPensionContributionAdjustmentAmount

Field Added

Decimal (38, 6) NULL

[rar].[PayeePayrollChildRelatedPaymentEpisodesUK]

EmployerPensionableEarningsAdjustmentAmount

Field Added

Decimal (38, 6) NULL

[rar].[PayeeTaxYTDUK]

PensionSalarySacrificeYTD

Field Added

Decimal (38, 6) NULL

[rar].[PensionAutoEnrolmentsGrossWageBatchHistoryUK]

IsSalarySacrifice

Field Added

BIT NULL

[rar].[PensionAutoEnrolmentsGrossWageBatchUK]

IsSalarySacrifice

Field Added

BIT NULL

[rar].[PensionProviderOutputs]

SalarySacrificeEnabled

Field Added

BIT CONSTRAINT [DF_ensionProviderOutputs_SalarySacrificeEnabled] DEFAULT ((0)) NOT NULL

[rar].[PensionSchemes]

SalarySacrifice

Field Added

BIT CONSTRAINT [DF_PensionSchemes_SalarySacrifice] DEFAULT ((0)) NOT NULL

[rar].[PensionSchemes]

NonSalarySacrificeSchemeName

Field Added

VARCHAR (50) NULL

[rar].[PensionSchemes]

PayslipSalarySacrificeName

Field Added

VARCHAR (50) NULL

[rar].[PensionSchemeValidity]

SalarySacrificePayCode

Field Added

INT NULL

[rar].[RemovedLeaveTransactionGrossWageBatch]

IsCarryover

Field Added

BIT NULL

[rar].[RemovedLeaveTransactionGrossWageBatch]

CarryoverExpiryDate

Field Added

DATE NULL