...
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 |