Database Schema Changes 11.38 (UK Release 12.10).

Table

Field

Action

Comment

dbo.DocumentFormatComponentDataItem

DisplayValueIfNull

Field Added

dbo.DocumentFormatComponentDataItem_History

DisplayValueIfNull

Field Added

dbo.InvoiceHeader

DebtorCorporateIdentityNumber

Field Added

dbo.TimesheetImportBatches

CloudStorageId

Field Added

dbo.TimesheetImportBatches

ExceptionReportCloudStorageId

Field Added

dbo.TimesheetImportBatches

ValidationReportCloudStorageId

Field Added

dbo.TimesheetImportBatches

ImportFileContentSizeMb

Field Added

dbo.TimesheetImportBatches

ExceptionReportFileContentSizeMb

Field Added

dbo.TimesheetImportBatches

ValidationReportFileContentSizeMb

Field Added

FO.ApplicationUsersToken

UniqueId

Field Added

FO.AttachFiles

CloudStorageId

Field Added

FO.AttachFiles

FileSizeMb

Field Added

FO.CustomFieldsValues

SortOrder

Field Added

FO.DataMigrationBatchHeader

ErrorFileName

Field Added

FO.DataMigrationBatchHeader

DatabaseStorageId

Field Added

FO.DataMigrationBatchHeader

DatabaseStorageErrorId

Field Added

FO.DataMigrationBatchHeader

[CloudStorageId]

Field Added

FO.DataMigrationBatchHeader

CloudStorageErrorId

Field Added

FO.DataMigrationBatchHeader

FileSizeMb

Field Added

FO.DataMigrationBatchHeader

ErrorFileSizeMb

Field Added

FO.GeneralSettings

DocumentStorageMethodId

Field Added

FO.GeneralSettings

DefaultJobRateListLoad

Field Added

FO.GeneralSettings

NoOfPayCodesDisplayed

Field Added

FO.Reports

LastUpdatedBy

Field Added

FO.Reports

LastUpdatedDateTime

Field Added

rar.AgreementAssignment

AdditionalRARGroupItemId

Field Added

rar.GrossWageBatchPayslipPayee

EmploymentTypeId

Field Added

rar.GrossWageBatchPayslipPayee

EmploymentTypeName

Field Added

rar.GrossWageBatchPayslipPayeeLeaveBalance

ShowAccrualCostOnPayslip

Field Added

rar.LeaveType

ShowAccrualCostOnPayslip

Field Added

rar.RatesImportBillAgreementData

RateHierarchyType

Field Added

rar.RatesImportBillAgreementData

RateHierarchyValue

Field Added

rar.RatesImportBillAgreementData

AgreementValidityStart

Field Added

rar.RatesImportBillAgreementData

AgreementValidityEnd

Field Added

rar.RatesImportBillAgreementData

BillRateFormulaId

Field Added

rar.RatesImportBillAgreementData

BillRateFormulaName

Field Added

rar.RatesImportBillAgreementData

NewBillRateFormula

Field Added

rar.RatesImportJobOrderBillAgreementData

RateHierarchyType

Field Added

rar.RatesImportJobOrderBillAgreementData

RateHierarchyValue

Field Added

rar.RatesImportJobOrderBillAgreementData

AgreementValidityStart

Field Added

rar.RatesImportJobOrderBillAgreementData

AgreementValidityEnd

Field Added

rar.RatesImportJobOrderBillAgreementData

BillRateFormulaId

Field Added

rar.RatesImportJobOrderBillAgreementData

BillRateFormulaName

Field Added

rar.RatesImportJobOrderBillAgreementData

NewBillRateFormula

Field Added

rar.RatesImportJobOrderPayAgreementData

RateHierarchyType

Field Added

rar.RatesImportJobOrderPayAgreementData

RateHierarchyValue

Field Added

rar.RatesImportJobOrderPayAgreementData

AgreementValidityStart

Field Added

rar.RatesImportJobOrderPayAgreementData

AgreementValidityEnd

Field Added

rar.RatesImportJobOrderPayAgreementData

IsTopUpRate

Field Added

rar.RatesImportJobOrderPayAgreementData

RateMinimum

Field Added

rar.RatesImportJobOrderPayAgreementData

NewRateMinimum

Field Added

rar.RatesImportPayAgreementData

RateHierarchyType

Field Added

rar.RatesImportPayAgreementData

RateHierarchyValue

Field Added

rar.RatesImportPayAgreementData

AgreementValidityStart

Field Added

rar.RatesImportPayAgreementData

AgreementValidityEnd

Field Added

rar.RatesImportPayAgreementData

IsTopUpRate

Field Added

rar.RatesImportPayAgreementData

RateMinimum

Field Added

rar.RatesImportPayAgreementData

NewRateMinimum

Field Added

rar.RatesImportStandardData

BillRateFormulaID

Field Added

rar.RatesImportStandardData

BillRateFormulaName

Field Added

rar.RatesImportStandardData

NewBillRateFormula

Field Added

rar.RatesImportTemplateBillAgreementData

TemplateId

Field Added

rar.RatesImportTemplateBillAgreementData

RateHierarchyType

Field Added

rar.RatesImportTemplateBillAgreementData

RateHierarchyValue

Field Added

rar.RatesImportTemplateBillAgreementData

EntityId

Field Added

rar.RatesImportTemplateBillAgreementData

EntityName

Field Added

rar.RatesImportTemplateBillAgreementData

Position

Field Added

rar.RatesImportTemplateBillAgreementData

BillRateFormulaId

Field Added

rar.RatesImportTemplateBillAgreementData

BillRateFormulaName

Field Added

rar.RatesImportTemplateBillAgreementData

NewBillRateFormula

Field Added

rar.RatesImportTemplateBillAgreementData

AgreementValidityStartDate

Field Added

rar.RatesImportTemplateBillAgreementData

AgreementValidityEndDate

Field Added

rar.RatesImportTemplatePayAgreementData

TemplateId

Field Added

rar.RatesImportTemplatePayAgreementData

RateHierarchyType

Field Added

rar.RatesImportTemplatePayAgreementData

RateHierarchyValue

Field Added

rar.RatesImportTemplatePayAgreementData

EntityId

Field Added

rar.RatesImportTemplatePayAgreementData

EntityName

Field Added

rar.RatesImportTemplatePayAgreementData

Position

Field Added

rar.RatesImportTemplatePayAgreementData

IsTopUpRate

Field Added

rar.RatesImportTemplatePayAgreementData

RateMinimum

Field Added

rar.RatesImportTemplatePayAgreementData

NewRateMinimum

Field Added

rar.RatesImportTemplatePayAgreementData

AgreementValidityStartDate

Field Added

rar.RatesImportTemplatePayAgreementData

AgreementValidityEndDate

Field Added

rar.RatesImportTemplateStandardData

EntityId

Field Added

rar.RatesImportTemplateStandardData

EntityName

Field Added

rar.RatesImportTemplateStandardData

BillRateFormulaId

Field Added

rar.RatesImportTemplateStandardData

BillRateFormulaName

Field Added

rar.RatesImportTemplateStandardData

NewBillRateFormula

Field Added

FO.ApplicationCache

CreatedDateTime

Field Added

FO.GeneralSettings

UploadBatchFileSizeLimit

Field Added

rar.PayCode

IncludeAtLeavePaymentsStage

Field Added

FO.ReportExecution

ReportQuery

Field Added

FO.AttachFiles

MigrationId

Field Added

FO.AttachFiles

LegacySystemId

Field Added

dbo.TimesheetImportBatches

ImportFileContentId

Field Changed

Field Changed from NOT NULL to NULL

rar.RatesImportTemplateBillAgreementData

TemplateName

Field Changed

Field Length changed from VARCHAR (40) to VARCHAR (310)

rar.RatesImportTemplateBillAgreementData

TemplateType

Field Changed

Field Length changed from VARCHAR (10) to VARCHAR (20)

rar.RatesImportTemplateBillAgreementData

ClientPosition

Field Changed

Field Length changed from VARCHAR (50) to VARCHAR (310)

rar.RatesImportTemplatePayAgreementData

TemplateName

Field Changed

Field Length changed from VARCHAR (40) to VARCHAR (310)

rar.RatesImportTemplatePayAgreementData

TemplateType

Field Changed

Field Length changed from VARCHAR (10) to VARCHAR (20)

rar.RatesImportTemplatePayAgreementData

ClientPosition

Field Changed

Field Length changed from VARCHAR (50) to VARCHAR (310)

rar.RatesImportTemplateStandardData

TemplateName

Field Changed

Field Length changed from VARCHAR (40) to VARCHAR (310)

rar.RatesImportTemplateStandardData

TemplateType

Field Changed

Field Length changed from VARCHAR (10) to VARCHAR (20)

rar.RatesImportTemplateStandardData

ClientPosition

Field Changed

Field Length changed from VARCHAR (50) to VARCHAR (310)

dbo.EmailQueue

ToAddress

Field Changed

Field changed from NVARCHAR

(255) NOT NULL to NVARCHAR (MAX) NULL

dbo.EmailQueue_Error

ToAddress

Field Changed

Field changed from NVARCHAR

(255) NOT NULL to NVARCHAR (MAX) NULL

dbo.EmailQueue_History

ToAddress

Field Changed

Field changed from NVARCHAR

(255) NOT NULL to NVARCHAR (MAX) NULL

dbo.TimesheetImportBatchRawData

ClientAlternateNo

Field Changed

Field length Changed from VARCHAR (20) to NVARCHAR (50

dbo.TimesheetImportBatchRawData

JobAltNo

Field Changed

Field length Changed from VARCHAR (20) to NVARCHAR (50

dbo.TimesheetImportBatchRawData

CandidateAltNo

Field Changed

Field length Changed from VARCHAR (20) to NVARCHAR (50

dbo.TimesheetImportBatchRawData

CandidateFirstName

Field Changed

Field length Changed from VARCHAR (25) to NVARCHAR (50

dbo.TimesheetImportBatchRawData

CandidateSurname

Field Changed

Field length Changed from VARCHAR (25) to NVARCHAR (50

FO.Candidates

ContractVisaDetails

Field Changed

Field Length Changed from NVARCHAR (255) to NVARCHAR (4000)

FO.Candidates

LegacySystemID

Field Changed

Field Renamed from LegacySystem to LegacySystemID

FO.DataMigrationBatchHeader

CreatedDate

Field Changed

Field type changed from DATETIME to DATETIMEOFFSET (7)

FO.DataMigrationBatchHeader

UpdatedDate

Field Changed

Field type changed from DATETIME to DATETIMEOFFSET (7)

FO.JobOrders

LegacySystemID

Field Changed

Field changed from LegacySystemI to LegacySystemID

FO.JobTemplates

LegacySystemID

Field Changed

Field changed from LegacySystemI to LegacySystemID

FO.Reasons

DisplayInPortal

Field Changed

Field changed from NULL to NOT NULL

FO.ReferralStages

DisplayInDiary

Field Changed

Field changed from NULL to NOT NULL

FO.ReferralStages

DisplayInPortal

Field Changed

Field changed from NULL to NOT NULL

FO.ApplicationCache

ApplicationUrl

Field Changed

Field length Changed from NVARCHAR (200) to NVARCHAR (500)

rar.GrossWageBatchItem

LeavePaymentRateToBeDetermined

Field Changed

Field Changed from DEFAULT ((0)) NOT NULL to DEFAULT 0 NOT NULL

dbo.Debtor

LegacySystemID

Field Changed

Field Changed from LegacySystemI to LegacySystemID

rar.Payee

LegacySystemID

Field Changed

Field Changed from LegacySystemI to LegacySystemID

FO.GeneralSettings

NoOfRatesDisplayed

Field Changed

Field Changed from NoOfPayCodesDisplayed to NoOfRatesDisplayed

FO.ReportExecution

SqlCommand

Field Changed

Field Changed from ReportQuery to SqlCommand

FO.ReportExecution

RunTimeInSeconds

Field Changed

Field Changed from ReportRenderingDifferenceInSecon to RunTimeInSeconds

FO.JobOrders

AdditionalRARGroupItemId

Field Removed

FO.JobTemplates

AdditionalRARGroupItemId

Field Removed

rar.Agreement

IsSupplementary_flag

Field Removed

rar.RatesImportBillAgreementData

AgreementHierarchyType

Field Removed

rar.RatesImportBillAgreementData

AgreementHierarchyValue

Field Removed

rar.RatesImportJobOrderBillAgreementData

AgreementHierarchyType

Field Removed

rar.RatesImportJobOrderBillAgreementData

AgreementHierarchyValue

Field Removed

rar.RatesImportJobOrderPayAgreementData

AgreementHierarchyType

Field Removed

rar.RatesImportJobOrderPayAgreementData

AgreementHierarchyValue

Field Removed

rar.RatesImportPayAgreementData

AgreementHierarchyType

Field Removed

rar.RatesImportPayAgreementData

AgreementHierarchyValue

Field Removed

rar.RatesImportTemplateBillAgreementData

PositionTemplateID

Field Removed

rar.RatesImportTemplateBillAgreementData

AgreementHierarchyType

Field Removed

rar.RatesImportTemplateBillAgreementData

AgreementHierarchyValue

Field Removed

rar.RatesImportTemplatePayAgreementData

PositionTemplateID

Field Removed

rar.RatesImportTemplatePayAgreementData

AgreementHierarchyType

Field Removed

rar.RatesImportTemplatePayAgreementData

AgreementHierarchyValue

Field Removed

FO.CacheReportDesigner

Table Added

FO.CacheReportViewer

Table Added

FO.ReportExecution

Table Added

FO.ReportQueries

Table Added

FO.ReportQueryColumns

Table Added

FO.ReportExecution

Table Added

FO.CacheKeys

Table Removed

FO.DataMigrationBatchDetails

Table Removed