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