Database Schema Changes (3TA Release)

To support this release changes have been made to the database schema. 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	Release

Table	Field	Action
[FO].[Candidates]	[PassportCountryId]	Added
[rar].[EFTBatches]	[PayCompanyId]	Added
[rar].[EFTBatches]	[PlugInConfigurationEFTId]	Added
[rar].[GrossWageBatchPayslipPayCompany]	[SupplierId]	Added
[rar].[LeaveType]	[PaidLeaveType]	Added
[rar].[NationalInsuranceThresholdsUK]	[NationalInsurancePeriodUKId]	Added
[rar].[PayCode]	[IsBonusCommissionPayments]	Added
[rar].[PayeeHeaderPayroll]	[SupplierId]	Added
[rar].[PayeePayroll]	[IsOverridePaymentTerm]	Added
[rar].[PayeePayrollAustralia]	[IsRegisteredWHMEmployer]	Added
[rar].[PayeePayrollAustralia]	[WithholdingVariationType]	Added
[rar].[PayeePayrollAustralia]	[IsCIRApplied]	Added