Database Schema Changes V12.32

Table

Field

Action

Comment / Extended Property Description

[rar].[NationalMinimumWagePeriodsUK]

Deleted

This table has been renamed to be generic for all countries to [rar].[NationalMinimumWagePeriods]

[rar].[NationalMinimumWageRatesUK]

Deleted

This table has been renamed to be generic for all countries to [rar].[NationalMinimumWageRates]

[dbo].[CreditRebill]

Status_no

Changed

Extended property description changed to include new enum values

[dbo].[ManualItem] 

BillRate

Added

[dbo].[ManualItem] 

IsSupersededRate

Added

[dbo].[PortalTokenParameter]

ParameterValue

Changed

Increased length from 2,000 to 4,000

[dbo].[ProcessVerificationReasonCodes]

SubProcessTypeNo

Changed

Extended property description changed to include new enum values

[dbo].[TimesheetHeader]

AltTimesheetId  

Added

[dbo].[TimesheetImportBatches]

GroupField

Added

[dbo].[TimesheetImportBatchRawData]

TimesheetAltNo

Added

[dbo].[TimesheetImportBatchRawData]

BillCodeImportCode

Added

[dbo].[TimesheetImportBatchRawData]

BillRate

Added

[dbo].[TimesheetImportBatchRawData]

BillCodeName

Added

[dbo].[TimesheetImportTemplates]

GroupField

Added

[FO].[Clients]

IsAdjustmentOnly

Added

[FO].[Countries]

IsNationalMinimumWageEnabled

Added

[FO].[Countries]

NMWLabel

Added

[FO].[Countries]

NMWExcludedPayeeTypes

Added

[FO].[GeneralSettings]

FrontOfficeIntegrationType

Added

[FO].[JobOrders]

IsAdjustmentOnly

Added

[FO].[JobOrders]

AdvertiseDescription

Changed

Increased length from 3,000 to MAX

[FO].[JobOrders]

JobOrderDescription

Changed

Increased length from 3,000 to MAX

[FO].[JobTemplates]

JobOrderDescription

Changed

Increased length from 3,000 to MAX

[FO].[JobTemplates]

AdvertiseDescription

Changed

Increased length from 3,000 to MAX

[FO].[JobTemplates]

IsAdjustmentOnly

Added

[rar].[BillResult]

IsSupersededRate

Added

[rar].[DeductionHeader]

IsAffectsNMW

Added

[rar].[GrossWageBatchPayslipDeduction]

AccountReference

Added

[rar].[LeaveAccrualRule] 

LeaveRateType_Id

Added

[rar].[LeaveTransaction]

RateTotalPay

Added

[rar].[LeaveTransaction]

RateTotalQuantity

Added

[rar].[LeaveTransactionGrossWageBatch]

RateTotalPay

Added

[rar].[LeaveTransactionGrossWageBatch]

RateTotalQuantity

Added

[rar].[PayCodePayroll] 

IsNMWBaseRate

Added

[rar].[PayCodePayroll] 

IsIncludedInNMWDetermination

Added

[rar].[PayCodePayrollAU]

STPPaidLeaveType

Changed

Extended property description changed to include new enum values

[rar].[PayCodePayrollUK]

IsSalarySacrifice

Added

[rar].[PayeePayrollAustralia]

FlatRateCIRValue

Changed

Extended property description changed

[rar].[PayeePayrollAustralia]

IsCIRApplied

Changed

Extended property description changed

[rar].[PayResult]

IsSupersededRate

Added

[rar].[PensionManagementBatch]

DataRetrievalFromDate

Added

[rar].[PensionManagementBatch]

DataRetrievalToDate

Added

[rar].[PensionProviderOutputTypes]

PensionProviderOutputTypeFormat

Changed

Extended property description changed

[dbo].[ProcessVerificationReasonsHistory]

Table Added

[FI].[ExportFileFormats]

Table Added

[FI].[GenericAccessFinancialsSaleExports]

Table Added

[FI].[GenericAccessFinancialsWageExports]

Table Added

[FI].[GenericAccountMaintenanceOptions]

Table Added

[FI].[GenericAccountMaintenanceTemplates] 

Table Added

[FI].[GenericFieldMaintenanceOptions]

Table Added

[FI].[GenericFieldMaintenanceTemplates]

Table Added

[FI].[GenericFISystems]

Table Added

[FI].[GenericMasterSettings]

Table Added

[FI].[GenericMYOBDebtorExports]

Table Added

[FI].[GenericMYOBSaleExports]

Table Added

[FI].[GenericMYOBWageExports]

Table Added

[FI].[GenericPerformanceLogs]

Table Added

[FI].[GenericSageSaleExports]

Table Added

[FI].[GenericSageWageExports]

Table Added

[FI].[GenericTemplates]

Table Added

[FI].[GenericWageGroupingTemplates]

Table Added

[FI].[GenericWageItemTypeTemplates]

Table Added

[FI].[GenericXERODebtorExports]

Table Added

[FI].[GenericXEROSaleExports]

Table Added

[FI].[GenericXEROWageExports]

Table Added

[FO].[VincereIntegrationSettings]

Table Added

[FO].[VincereIntegrationTenant]

Table Added

[rar].[NationalMinimumWageGrossWageBatch]

Table Added

[rar].[NationalMinimumWageGrossWageBatchHistory]

Table Added

[rar].[NationalMinimumWagePeriods]

Table Added

This table was originally named [rar].[NationalMinimumWagePeriodsUK]

[rar].[NationalMinimumWageRates]

Table Added

This table was originally named [rar].[NationalMinimumWageRatesUK]

[rar].[PensionManagementBatchItemImports]

Table Added