Database Schema Changes V12.33 & 12.33P2

The table below identifies all other database schema changes that have been made to support this release. These changes may have an impact on reports that have been created using custom queries.

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.

Table	Field	Action	Comment/Extended Property Description	Release
[rar].[GrossWageBatchPayeeSalarySacrificeAdjustmentHistoryUK]		Deleted		12.33
[rar].[GrossWageBatchPayeeSalarySacrificeAdjustmentUK]		Deleted		12.33
[rar].[NationalMinimumWageGrossWageBatchLink]		Deleted		12.33
[rar].[NationalMinimumWageGrossWageBatchLinkHistory]		Deleted		12.33
[dbo].[ManualItem]	LeaveRequestTimeId	Field Added	Foreign Key to [rar].[LeaveRequestTime table	12.33
[rar].[EmployerPensionContributionsGrossWageBatchHistoryUK]	Sacrifice	Field Added	Decimal (38, 6) NULL	12.33
[rar].[EmployerPensionContributionsGrossWageBatchUK]	Sacrifice	Field Added	Decimal (38, 6) NULL	12.33
[rar].[GrossWageBatchPayslipPayeePensionUK]	SalarySacrifice	Field Added	DECIMAL (38, 6) DEFAULT ((0)) NOT NULL	12.33
[rar].[GrossWageBatchPayslipPayeePensionUK]	SalarySacrificeYTD	Field Added	DECIMAL (38, 6) DEFAULT ((0)) NOT NULL	12.33
[rar].[LeaveResetRule]	ResetCarryoverAfterValue	Field Added	Decimal (38, 6) NULL	12.33
[rar].[LeaveResetRule]	CarryoverResetPeriodType_no	Field Added	TINYINT NULL	12.33
[rar].[LeaveResetRule]	TransferBalanceIntoCarryoverPot	Field Added	BIT DEFAULT ((0)) NOT NULL	12.33
[rar].[LeaveTransaction]	IsCarryover	Field Added	BIT NULL	12.33
[rar].[LeaveTransaction]	CarryoverExpiryDate	Field Added	DATE NULL	12.33
[rar].[LeaveTransactionGrossWageBatch]	IsCarryover	Field Added	BIT NULL	12.33
[rar].[LeaveTransactionGrossWageBatch]	CarryoverExpiryDate	Field Added	DATE NULL	12.33
[rar].[PayCode]	AttendanceDetailId	Field Added	INT NULL	12.33
[rar].[PayCode]	DefaultAttendanceStartTime	Field Added	TIME (7) NULL	12.33
[rar].[PayeePayrollChildRelatedPaymentEpisodesUK]	EmployerPensionContributionAdjustmentAmount	Field Added	Decimal (38, 6) NULL	12.33
[rar].[PayeePayrollChildRelatedPaymentEpisodesUK]	EmployerPensionableEarningsAdjustmentAmount	Field Added	Decimal (38, 6) NULL	12.33
[rar].[PayeeTaxYTDUK]	PensionSalarySacrificeYTD	Field Added	Decimal (38, 6) NULL	12.33
[rar].[PensionAutoEnrolmentsGrossWageBatchHistoryUK]	IsSalarySacrifice	Field Added	BIT NULL	12.33
[rar].[PensionAutoEnrolmentsGrossWageBatchUK]	IsSalarySacrifice	Field Added	BIT NULL	12.33
[rar].[PensionProviderOutputs]	SalarySacrificeEnabled	Field Added	BIT CONSTRAINT [DF_ensionProviderOutputs_SalarySacrificeEnabled] DEFAULT ((0)) NOT NULL	12.33
[rar].[PensionSchemes]	SalarySacrifice	Field Added	BIT CONSTRAINT [DF_PensionSchemes_SalarySacrifice] DEFAULT ((0)) NOT NULL	12.33
[rar].[PensionSchemes]	NonSalarySacrificeSchemeName	Field Added	VARCHAR (50) NULL	12.33
[rar].[PensionSchemes]	PayslipSalarySacrificeName	Field Added	VARCHAR (50) NULL	12.33
[rar].[PensionSchemeValidity]	SalarySacrificePayCode	Field Added	INT NULL	12.33
[rar].[RemovedLeaveTransactionGrossWageBatch]	IsCarryover	Field Added	BIT NULL	12.33
[rar].[RemovedLeaveTransactionGrossWageBatch]	CarryoverExpiryDate	Field Added	DATE NULL	12.33
[dbo].[TimesheetHeader]	[IsNoCreditInterpret]	Field Added	BIT NULL	12.33P2
[dbo].[TimesheetImportBatches]	[IsNoCreditInterpret]	Field Added	BIT NULL	12.33P2
[dbo].[TimesheetImportTemplates]	[IsNoCreditInterpret]	Field Added	BIT NULL	12.33P2