FastTrack360 Version 12 Online Help
Database Schema Changes V12.10
- Fiona Sims
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 |
|---|---|---|---|---|
[dbo].[Address] | PostCode | Field Changed | Field Length changed to 50 | 12.10 |
[dbo].[Address] | AddressLine3 | Field Added |
| 12.10 |
[dbo].[AlertTemplate] | AlertType | Field Changed | Field Name changed from AlertTypeId | 12.10 |
[dbo].[AlertTemplate] | DeliveryMethodType | Field Changed | Field Name changed from DeliveryMethodTypeId | 12.10 |
[dbo].[AlertTemplateStaff] | AlertStaffType | Field Changed | Field Name changed fom AlertStaffTypeId | 12.10 |
[dbo].[AQLog] |
| Table Deleted | Table Deleted | 12.10 |
[dbo].[BillingCompany] | ContactPhone | Field Changed | Field Length changed to 50 | 12.10 |
[dbo].[BillingCompanyOfficeLink] | BillingCompanyOfficeLink_id | Field Added |
| 12.10 |
[dbo].[CIS300Headers] |
| Table Added | Table Added | 12.10 |
[dbo].[CIS300Subcontractors] |
| Table Added | Table Added | 12.10 |
[dbo].[CISVerifications] |
| Table Added | Table Added | 12.10 |
[dbo].[Debtor] | CorporateIdentityNumber | Field Changed | Changed from Not Null to Null | 12.10 |
[dbo].[DebtorInvoiceLink] | InvoiceBillCodeGroupId | Field Added |
| 12.10 |
[dbo].[DocumentFormat] | EffectiveFromDate | Field Added |
| 12.10 |
[dbo].[DocumentFormatComponentDataItem] | RoundingItem | Field Changed | Changed from Null to Not Null | 12.10 |
[dbo].[DocumentFormatComponentDataItem] | IsMultiCurrencyField | Field Added |
| 12.10 |
[dbo].[DocumentFormatComponentDataItem_History] | RoundingItem | Field Changed | Changed from Null to Not Null | 12.10 |
[dbo].[DocumentFormatComponentDataItem_History] | IsMultiCurrencyField | Field Added |
| 12.10 |
[dbo].[DocumentFormatComponentTableItem] | Type_no | Field Deleted | Field Deleted | 12.10 |
[dbo].[DocumentFormatComponentTableItem_History] | Type_no | Field Deleted | Field Deleted | 12.10 |
[dbo].[DocumentNotificationTemplate] | PayslipTypeNo | Field Added |
| 12.10 |
[dbo].[EmailTemplate] | OfficeCode | Field Changed | Field Name changed from Office_id | 12.10 |
[dbo].[EPSBatchChildRelatedPaymentDetailIs] |
| Table Added | Table Added | 12.10 |
[dbo].[EPSBatches] |
| Table Added | Table Added | 12.10 |
[dbo].[EPSStateAidSectorsUK] |
| Table Added | Table Added | 12.10 |
[dbo].[FPSHeaders] |
| Table Added | Table Added | 12.10 |
[dbo].[FPSPayeeCars] |
| Table Added | Table Added | 12.10 |
[dbo].[FPSPayees] |
| Table Added | Table Added | 12.10 |
[dbo].[FPSPayeesNationalInsurance] |
| Table Added | Table Added | 12.10 |
[dbo].[HMRCEventValidations] |
| Table Added | Table Added | 12.10 |
[dbo].[HMRCFormsAudit] |
| Table Added | Table Added | 12.10 |
[dbo].[HMRCFormsAuditDetails] |
| Table Added | Table Added | 12.10 |
[dbo].[HMRCFormsAuditFieldMappings] |
| Table Added | Table Added | 12.10 |
[dbo].[HMRCFormsEntityAudit] |
| Table Added | Table Added | 12.10 |
[dbo].[HMRCFormsEntityAuditDetails] |
| Table Added | Table Added | 12.10 |
[dbo].[HMRCIncomingMessages] |
| Table Added | Table Added | 12.10 |
[dbo].[HMRCIncomingMessagesCISVerfications] |
| Table Added | Table Added | 12.10 |
[dbo].[HMRCOutgoingMessagePolling] |
| Table Added | Table Added | 12.10 |
[dbo].[HMRCOutgoingMessages] |
| Table Added | Table Added | 12.10 |
[dbo].[IncomingGovernmentFormsBatches] |
| Table Added | Table Added | 12.10 |
[dbo].[IncomingGovernmentFormsWaterMarksUK] |
| Table Added | Table Added | 12.10 |
[dbo].[InvoiceBillCodeGroup] |
| Table Added | Table Added | 12.10 |
[dbo].[InvoiceBillCodeGroupGrouping] |
| Table Added | Table Added | 12.10 |
[dbo].[InvoiceBillCodeGroupGroupingBillCode] |
| Table Added | Table Added | 12.10 |
[dbo].[InvoiceHeader] | DebtorCurrencyCodeId | Field Added |
| 12.10 |
[dbo].[InvoiceHeader] | CurrencyConversionRate | Field Added |
| 12.10 |
[dbo].[InvoiceHeader] | CurrencyConversionDate | Field Added |
| 12.10 |
[dbo].[InvoiceHeader] | InvoiceSubTotalInDebtorCurrency | Field Added |
| 12.10 |
[dbo].[InvoiceHeader] | InvoiceTotalInDebtorCurrency | Field Added |
| 12.10 |
[dbo].[InvoiceHeader] | BalanceDueInDebtorCurrency | Field Added |
| 12.10 |
[dbo].[InvoiceHeader] | InvoiceFeeInDebtorCurrency | Field Added |
| 12.10 |
[dbo].[InvoiceHeader] | DebtorCorporateIdentityNumber | Field Changed | Changed from Not Null to Null | 12.10 |
[dbo].[InvoiceHeaderTaxation] | TotalInDebtorCurrency | Field Added |
| 12.10 |
[dbo].[InvoiceItem] | CostInDebtorCurrency | Field Added |
| 12.10 |
[dbo].[InvoiceItem] | RateInDebtorCurrency | Field Added |
| 12.10 |
[dbo].[InvoiceItem] | ItemSubTotalInDebtorCurrency | Field Added |
| 12.10 |
[dbo].[InvoiceItem] | ItemTaxTotalInDebtorCurrency | Field Added |
| 12.10 |
[dbo].[InvoiceItem] | ItemBillingFeeTotalInDebtorCurrency | Field Added |
| 12.10 |
[dbo].[InvoiceItem] | ItemTotalInDebtorCurrency | Field Added |
| 12.10 |
[dbo].[InvoiceItem] | ItemBillingFeeTaxTotalInDebtorCurrency | Field Added |
| 12.10 |
[dbo].[InvoiceItem] | ItemSubTaxTotalInDebtorCurrency | Field Added |
| 12.10 |
[dbo].[InvoiceItemBillingFee] | TotalInDebtorCurrency | Field Added |
| 12.10 |
[dbo].[InvoiceItemBillingFeeTaxation] | TotalInDebtorCurrency | Field Added |
| 12.10 |
[dbo].[InvoiceItemTaxation] | TotalInDebtorCurrency | Field Added |
| 12.10 |
[dbo].[InvoiceTaxation] | TotalInDebtorCurrency | Field Added |
| 12.10 |
[dbo].[ManageGridLayout] |
| Table Added | Table Added | 12.10 |
[dbo].[ManualItem] | OriginCurrencyCodeId | Field Added | Field Added | 12.10 |
[dbo].[ManualItem] | OriginRate | Field Added | Field Added | 12.10 |
[dbo].[ManualItem] | CurrencyConversionRate | Field Added | Field Added | 12.10 |
[dbo].[PlugInConfiguration] |
| Table Added | Table Added | 12.10 |
[dbo].[PlugInConfigurationEFT] |
| Table Added | Table Added | 12.10 |
[dbo].[PortalCountrySetting] |
| Table Deleted | Table Deleted | 12.10 |
[dbo].[PortalCountrySettingStandardRateBillType] |
| Table Deleted | Table Deleted | 12.10 |
[dbo].[PortalMessage] |
| Table Deleted | Table Deleted | 12.10 |
[dbo].[ProcessVerificationReasonCodes] |
| Table Added | Table Added | 12.10 |
[dbo].[ProcessVerificationReasons] |
| Table Added | Table Added | 12.10 |
[dbo].[ThirdPartyCommunicationLogs] | HTTPRequestText | Field Added | Field Added | 12.10 |
[dbo].[ThirdPartyCommunicationLogs] | HTTPResponseText | Field Added | Field Added | 12.10 |
[dbo].[TimesheetImportBatch] |
| Table Deleted | Table Deleted | 12.10 |
[dbo].[TimesheetImportBatchRawData] | ProjectCode1 | Field Changed | Changed from Varchar to Nvarchar | 12.10 |
[FI].[DebtorsExports] | DebtorCurrencyCode | Table Added | Table Added | 12.10 |
[FI].[SalesExports] | DebtorCurrencyCode | Field Added | Field Added | 12.10 |
[FI].[SalesExports] | ExchangeRate | Field Added | Field Added | 12.10 |
[FI].[SalesExports] | CurrencyInvoiceTotal | Field Added | Field Added | 12.10 |
[FI].[SalesExports] | CurrencyInvoiceTotalIncTax | Field Added | Field Added | 12.10 |
[FI].[SalesExports] | CurrencyTaxTotal | Field Added | Field Added | 12.10 |
[FI].[SalesExports] | CurrencyBillAmount | Field Added | Field Added | 12.10 |
[FI].[SalesExports] | CurrencyTaxAmount | Field Added | Field Added | 12.10 |
[FO].[Addresses] | AddressLineThree | Field Added | Field Added | 12.10 |
[FO].[Addresses] | LegacySystemId | Field Changed | Changed from LegacySystemID | 12.10 |
[FO].[ApiUserDomains] |
| Table Deleted | Table Deleted | 12.10 |
[FO].[ApplicationRules] |
| Table Deleted | Table Deleted | 12.10 |
[FO].[ApplicationTimezones] | SortOrder | Field Added | Field Added | 12.10 |
[FO].[Attachments] |
| Table Deleted | Table Deleted | 12.10 |
[FO].[CacheKeys] |
| Table Added | Table Added | 12.10 |
[FO].[Candidates] | PassportNumber | Field Added | Field Added | 12.10 |
[FO].[CandidateWorkReferences] | LegacySystemId | Field Changed | Change from LegacySystemID | 12.10 |
[FO].[Countries] | Currency | Field Deleted | Field Deleted | 12.10 |
[FO].[Countries] | CurrencySymbol | Field Deleted | Field Deleted | 12.10 |
[FO].[Countries] | CurrencySample | Field Deleted | Field Deleted | 12.10 |
[FO].[Countries] | DisplayPayeeMailingAddress | Field Added | Field Added | 12.10 |
[FO].[Countries] | SocialSecurityNumberLabel | Field Added | Field Added | 12.10 |
[FO].[Countries] | SocialSecurityNumberFormat | Field Added | Field Added | 12.10 |
[FO].[Countries] | IsReimbursement | Field Added | Field Added | 12.10 |
[FO].[Countries] | GstLabel | Field Added | Field Added | 12.10 |
[FO].[Countries] | OnlyIncludeTimesheetsWithinCurrentPeriod | Field Added | Field Added | 12.10 |
[FO].[Countries] | MarginMarkupType | Field Added | Field Added | 12.10 |
[FO].[Countries] | PayOncostsEnabled | Field Added | Field Added | 12.10 |
[FO].[Countries] | StandardRateRoundingType | Field Added | Field Added | 12.10 |
[FO].[Countries] | StandardRateRoundingPrecision | Field Added | Field Added | 12.10 |
[FO].[Countries] | MarginOncostType | Field Added | Field Added | 12.10 |
[FO].[Countries] | InterpreterReviewSearchLimit | Field Added | Field Added | 12.10 |
[FO].[Countries] | SuperStreamEnabled | Field Added | Field Added | 12.10 |
[FO].[Countries] | DefaultPayeeTaxType | Field Added | Field Added | 12.10 |
[FO].[Countries] | LastLeaveService_date | Field Added | Field Added | 12.10 |
[FO].[Countries] | IsLeaveOccurrenceBasedAvailable | Field Added | Field Added | 12.10 |
[FO].[Countries] | IsLeaveCalculateWithSpecificFormulaAvailable | Field Added | Field Added | 12.10 |
[FO].[Countries] | GenerateEOFYStatementForPaymentSummaryType | Field Added | Field Added | 12.10 |
[FO].[Countries] | BillRateType | Field Added | Field Added | 12.10 |
[FO].[Countries] | BackOfficeId | Field Added | Field Added | 12.10 |
[FO].[Countries] | PayDocumentDeliveryType | Field Added | Field Added | 12.10 |
[FO].[Countries] | CurrencyCodeId | Field Added | Field Added | 12.10 |
[FO].[Countries] | EnableMultiCurrency | Field Added | Field Added | 12.10 |
[FO].[Countries] | IsGrossPayPayroll | Field Added | Field Added | 12.10 |
[FO].[Countries] | EarningsYearEndDateMonth | Field Added | Field Added | 12.10 |
[FO].[Countries] | EarningsYearEndDateDay | Field Added | Field Added | 12.10 |
[FO].[Countries] | IsReimbursementTaxHiddenOnTimesheets | Field Added | Field Added | 12.10 |
[FO].[Countries] | ReimbursementNetLabel | Field Added | Field Added | 12.10 |
[FO].[Countries] | IsDeductionNetComponentEnabled | Field Added | Field Added | 12.10 |
[FO].[Countries] | IsEnforceOnDebtorCorporateIdentityNumberFormat | Field Added | Field Added | 12.10 |
[FO].[Countries] | AdditionalRARGroupingName | Field Added | Field Added | 12.10 |
[FO].[Countries] | RateMinimumLabel | Field Added | Field Added | 12.10 |
[FO].[Countries] | EnableRateMinimum | Field Added | Field Added | 12.10 |
[FO].[Countries] | IsCustomLeaveBalanceOnPayslip | Field Added | Field Added | 12.10 |
[FO].[Countries] | EnableAdditionalRARGrouping | Field Added | Field Added | 12.10 |
[FO].[CountryGenderTypeMappings] |
| Table Added | Table Added | 12.10 |
[FO].[CountryLabelMaster] | Address3Label | Field Added | Field Added | 12.10 |
[FO].[CountryLabelMaster] | DisplayAddress3 | Field Added | Field Added | 12.10 |
[FO].[CustomFieldMappings] | IsForInvoice | Field Added | Field Added | 12.10 |
[FO].[CustomFields] | CountryId | Field Added | Field Added | 12.10 |
[FO].[CustomFields] | IsMandatory | Field Added | Field Added | 12.10 |
[FO].[CustomFields] | BackOfficeId | Field Added | Field Added | 12.10 |
[FO].[CustomFields] | IsLocked | Field Added | Field Added | 12.10 |
[FO].[EntityLocks] | UserId | Field Changed | Changed from Null to Not Null | 12.10 |
[FO].[GeneralSettings] | IntegrationUserId | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | IntegrationUserPassword | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | IntegrationNotificationEmailAddress | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | IntegrationNotificationFromEmailAddress | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | BackOfficeId | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | CheckSuburb | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | CheckCity | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | CheckState | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | CheckCountry | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | CheckEmail | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | CheckMobilePhone | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | CheckFirstName | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | CheckSurName | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | CheckSocialSecurityNumber | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | LastKeywordUploadDateTime | Field Added | Field Added | 12.10 |
[FO].[GeneralSettings] | DuplicateCandidateOptions | Field Added | Field Added | 12.10 |
[FO].[IntegrationCentres] |
| Table Deleted | Table Deleted | 12.10 |
[FO].[LayoutFieldSettings] |
| Table Deleted | Table Deleted | 12.10 |
[FO].[ObjectTranslations] |
| Table Deleted | Table Deleted | 12.10 |
[FO].[Offices] | PayslipMessage | Field Added | Field Added | 12.10 |
[FO].[PasswordPolicy] | ForcePasswordUppercase | Field Added | Field Added | 12.10 |
[FO].[PasswordPolicy] | ForcePasswordSymbol | Field Added | Field Added | 12.10 |
[FO].[PasswordPolicy] | UniquePasswordLimit | Field Added | Field Added | 12.10 |
[FO].[Permissions] | ModuleId | Field Added | Field Added | 12.10 |
[FO].[Permissions] | PermissionItemId | Field Added | Field Added | 12.10 |
[FO].[Reasons] | Description | Field Added | Field Added | 12.10 |
[FO].[Reasons] | Country_id | Field Added | Field Added | 12.10 |
[FO].[Reasons] | ValidityStart_date | Field Added | Field Added | 12.10 |
[FO].[Reasons] | Default_flag | Field Added | Field Added | 12.10 |
[FO].[Reasons] | ValidityEnd_date | Field Added | Field Added | 12.10 |
[FO].[Reasons] | BackOfficeId | Field Added | Field Added | 12.10 |
[FO].[SystemCountries] | CurrencyCodeId | Field Added | Field Added | 12.10 |
[FO].[SystemCountries] | Currency | Field Deleted | Field Deleted | 12.10 |
[FO].[SystemCountries] | CurrencySymbol | Field Deleted | Field Deleted | 12.10 |
[FO].[SystemCountries] | CurrencySample | Field Deleted | Field Deleted | 12.10 |
[FO].[UserNetworkPerformance] |
| Table Added | Table Added | 12.10 |
[FO].[UserPasswordHistory] |
| Table Added | Table Added | 12.10 |
[FO].[Users] | MoBoExperienceId | Field Added | Field Added | 12.10 |
[FO].[UserSettings] | DefaultPayCountryId | Field Added | Field Added | 12.10 |
[rar].[AEODeductionRatesUK] |
| Table Added | Table Added | 12.10 |
[rar].[AEODeductionRateTypesUK] |
| Table Added | Table Added | 12.10 |
[rar].[ApprenticeshipLevyTransactions] |
| Table Added | Table Added | 12.10 |
[rar].[ApprenticeshipLevyTransactionsGrossWageBatch] |
| Table Added | Table Added | 12.10 |
[rar].[BankAccount] | BSBNumber | Field Changed | Field Length Change from 7 to 10 and Data Type changed from NVARCHAR to VARCHAR | 12.10 |
[rar].[BankAccount] | PlugInConfigurationEFTId | Field Added | Field Added | 12.10 |
[rar].[BankAccount] | SelfBalancingFileFlag | Field Added | Field Added | 12.10 |
[rar].[BankAccount] | AccountSuffix | Field Added | Field Added | 12.10 |
[rar].[BankAccount] | BACSUserNumber | Field Added | Field Added | 12.10 |
[rar].[BankAccount] | IdentificationNo | Field Added | Field Added | 12.10 |
[rar].[BankAccount] | BankIdentifierCode | Field Added | Field Added | 12.10 |
[rar].[BankAccount] | IBAN | Field Added | Field Added | 12.10 |
[rar].[ChildRelatedPaymentNotPaidReasonsUK] |
| Table Added | Table Added | 12.10 |
[rar].[ChildRelatedPaymentPeriodsUK] |
| Table Added | Table Added | 12.10 |
[rar].[CurrencyCodes] |
| Table Added | Table Added | 12.10 |
[rar].[DeductionHeader] | ApplyToTypeNo | Field Added | Field Added | 12.10 |
[rar].[DeductionHeader] | AllowApplyToTypeOverrideOnPayee | Field Added | Field Added | 12.10 |
[rar].[DeductionHeader] | DeductionNetComponentHeaderId | Field Added | Field Added | 12.10 |
[rar].[DeductionHeaderValiditiesUK] |
| Table Added | Table Added | 12.10 |
[rar].[DeductionNetComponentHeaders] |
| Table Added | Table Added | 12.10 |
[rar].[DeductionNetComponentHeaderValidities] |
| Table Added | Table Added | 12.10 |
[rar].[DeductionNetComponentHeaderValidityDeductions] |
| Table Added | Table Added | 12.10 |
[rar].[DeductionNetComponentHeaderValidityPayCodes] |
| Table Added | Table Added | 12.10 |
[rar].[DeductionNetComponentHeaderValidityPayCodeTypes] |
| Table Added | Table Added | 12.10 |
[rar].[DeductionRule] | ApplyOrder | Field Added | Field Added | 12.10 |
[rar].[DeductionRulesUK] |
| Table Added | Table Added | 12.10 |
[rar].[EFTFileGenerationLog] |
| Table Added | Table Added | 12.10 |
[rar].[EftTransaction] | BuildingSocietyReference | Field Added | Field Added | 12.10 |
[rar].[EftTransaction] | AmountInPaymentCurrency | Field Added | Field Added | 12.10 |
[rar].[EftTransaction] | BankIdentifierCode | Field Added | Field Added | 12.10 |
[rar].[EftTransaction] | IsDeafultAccount | Field Added | Field Added | 12.10 |
[rar].[EftTransactionHeader] | PayCompanyBankAbbreviation | Field Changed | Field Chagned from Not Null to Null | 12.10 |
[rar].[EftTransactionHeader] | PayCompanyBranchNumber | Field Chagned | Field Length Chagned from 7 to 10 | 12.10 |
[rar].[EftTransactionHeader] | IdentificationNo | Field Added | Field Added | 12.10 |
[rar].[EftTransactionHeader] | BankIdentifierCode | Field Added | Field Added | 12.10 |
[rar].[EftTransactionHeader] | IBAN | Field Added | Field Added | 12.10 |
[rar].[EmployerPensionContributionsGrossWageBatchHistoryUK] |
| Table Added | Table Added | 12.10 |
[rar].[EmployerPensionContributionsGrossWageBatchUK] |
| Table Added | Table Added | 12.10 |
[rar].[EmploymentIntermediaryReportDetails] |
| Table Added | Table Added | 12.10 |
[rar].[EmploymentIntermediaryReportHeader] |
| Table Added | Table Added | 12.10 |
[rar].[EmploymentTypeSweden] |
| Table Deleted | Table Deleted | 12.10 |
[rar].[ExchangeRateImportAudit] |
| Table Added | Table Added | 12.10 |
[rar].[ExchangeRates] |
| Table Added | Table Added | 12.10 |
[rar].[GrossWageBatch] | IsIncludePayeesWithYTDadjustmentOnly | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchChildRelatedPaymentRecoveriesHistoryUK] |
| Table Added | Table Added | 12.10 |
[rar].[GrossWageBatchChildRelatedPaymentRecoveriesUK] |
| Table Added | Table Added | 12.10 |
[rar].[GrossWageBatchItem] | PayeePayrollChildRelatedPaymentsId | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchItem] | IsSystemCalculatedGST | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchItem_History] | PayeePayrollChildRelatedPaymentsId | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchItem_History] | IsSystemCalculatedGST | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayee] | PaymentCurrencyCodeId | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayee] | PaymentCurrencyConversionRate | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayee] | PaymentCurrencyConversionDate | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayee_History] | PaymentCurrencyCodeId | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayee_History] | PaymentCurrencyConversionRate | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayee_History] | PaymentCurrencyConversionDate | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayeeDeduction] | IsManuallyAdded | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayeeDeductionsHistoryUK] |
| Table Added | Table Added | 12.10 |
[rar].[GrossWageBatchPayeeDeductionsUK] |
| Table Added | Table Added | 12.10 |
[rar].[GrossWageBatchPayeeHistoryUK] |
| Table Added | Table Added | 12.10 |
[rar].[GrossWageBatchPayeePensionableEarningsHistoryUK] |
| Table Added | Table Added | 12.10 |
[rar].[GrossWageBatchPayeePensionableEarningsUK] |
| Table Added | Table Added | 12.10 |
[rar].[GrossWageBatchPayeeTaxP45] |
| Table Added | Table Added | 12.10 |
[rar].[GrossWageBatchPayeeTaxUk] |
| Table Added | Table Added | 12.10 |
[rar].[GrossWageBatchPayeeTaxUk_History] |
| Table Added | Table Added | 12.10 |
[rar].[GrossWageBatchPayeeUK] |
| Table Added | Table Added | 12.10 |
[rar].[GrossWageBatchPayslipOffice] |
| Table Added | Table Added | 12.10 |
[rar].[GrossWageBatchPayslipPayCompany] | UmbrellaCompanyId | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayslipPayCompanyUK] |
| Table Added | Table Added | 12.10 |
[rar].[GrossWageBatchPayslipPayee] | PaymentCurrencyCodeId | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayslipPayee] | PaymentCurrencyConversionRate | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayslipPayee] | PaymentCurrencyConversionDate | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayslipPayee] | GrossWageBatchPayslipOffice_id | Field Added | Field Added | 12.10 |
[rar].[GrossWageBatchPayslipPayeeGrossPay] |
| Table Added | Table Added | 12.10 |
[rar].[GrossWageBatchPayslipPayeePensionUK] |
| Table Added | Table Added | 12.10 |
[rar].[GrossWageBatchPayslipPayeeUK] |
| Table Added | Table Added | 12.10 |
[rar].[GrossWageBatchStages] |
| Table Added | Table Added | 12.10 |
[rar].[GuaranteeSalaryBlueCollar] |
| Table Deleted | Table Deleted | 12.10 |
[rar].[GuaranteeSalaryWhiteCollar] |
| Table Deleted | Table Deleted | 12.10 |
[rar].[HoursWorkedCategories] |
| Table Added | Table Added | 12.10 |
[rar].[IRElectronicReportHistory] |
| Table Deleted | Table Deleted | 12.10 |
[rar].[LeaveQualifyingWeekCondition] |
| Table Added | Table Added | 12.10 |
[rar].[LeaveRateTypeValue] | IsBasedOnWorkedDaysOnly | Field Added | Field Added | 12.10 |
[rar].[LeaveRequestTime] | GrossWageBatch_id | Field Added | Field Added | 12.10 |
[rar].[LeaveTakenConditions] |
| Table Added | Table Added | 12.10 |
[rar].[LeaveType] | LeaveTypeConfiguration | Field Added | Field Added | 12.10 |
[rar].[LeaveType] | IsLeaveRequestForWeekdaysOnly | Field Added | Field Added | 12.10 |
[rar].[LeaveTypeConditionEvaluationCommencingDates] |
| Table Deleted | Table Deleted | 12.10 |
[rar].[NationalInsuranceAdjustment] |
| Table Added | Table Added | 12.10 |
[rar].[NationalInsuranceAdjustmentHistory] |
| Table Added | Table Added | 12.10 |
[rar].[NationalInsuranceBandsUK] |
| Table Added | Table Added | 12.10 |
[rar].[NationalInsuranceCategoriesUK] |
| Table Added | Table Added | 12.10 |
[rar].[NationalInsuranceContributionsByJobOrderGrossWageBatch] |
| Table Added | Table Added | 12.10 |
[rar].[NationalInsuranceContributionsByJobOrderGrossWageBatchHistory] |
| Table Added | Table Added | 12.10 |
[rar].[NationalInsuranceContributionsByNationalInsuranceBandGrossWageBatch] |
| Table Added | Table Added | 12.10 |
[rar].[NationalInsuranceContributionsByNationalInsuranceBandGrossWageBatchHistory] |
| Table Added | Table Added | 12.10 |
[rar].[NationalInsuranceContributionsGrossWageBatch] |
| Table Added | Table Added | 12.10 |
[rar].[NationalInsuranceContributionsGrossWageBatchHistory] |
| Table Added | Table Added | 12.10 |
[rar].[NationalInsuranceEarningsByBandYTDGrossWageBatchHistory] |
| Table Added | Table Added | 12.10 |
[rar].[NationalInsuranceContributionsGrossWageBatch] |
| Table Added | Table Added | 12.10 |
[rar].[NationalInsuranceContributionsGrossWageBatchHistory] |
| Table Added | Table Added | 12.10 |
[rar].[NationalInsuranceEarningsByBandYTDGrossWageBatchHistory] |
| Table Added | Table Added | 12.10 |
[rar].[NationalInsuranceRatesUK] |
| Table Added | Table Added | 12.10 |
[rar].[NationalInsuranceThresholdsUK] |
| Table Added | Table Added | 12.10 |
[rar].[NationalInsuranceYTDGrossWageBatchHistory] |
| Table Added | Table Added | 12.10 |
[rar].[P60BatchesUK] |
| Table Added | Table Added | 12.10 |
[rar].[P60BatchPayeesUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayCodeCalculationGroup] |
| Table Deleted | Table Deleted | 12.10 |
[rar].[PayCodePayroll] | Description | Field Changed | Change from Not Null to Null | 12.10 |
[rar].[PayCodePayrollUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayCompany] | ContactPhone | Field Chagned | Field Length chagned from 25 to 50 | 12.10 |
[rar].[PayCompany] | ContactFax | Field Chagned | Field Length chagned from 25 to 50 | 12.10 |
[rar].[PayCompany] | AccountName | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompany] | AccountNumber | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompany] | AccountReference | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompany] | ContactMobile | Field Chagned | Field Length chagned from 25 to 50 | 12.10 |
[rar].[PayCompany] | BankAccountId | Field Added | Field Added | 12.10 |
[rar].[PayCompany] | ReimbursementCurrencyConversionDateType | Field Added | Field Added | 12.10 |
[rar].[PayCompany] | NetPayCurrencyConversionDateType | Field Added | Field Added | 12.10 |
[rar].[PayCompanyAustralia] | BankAbbreviation | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompanyAustralia] | BSBNumber | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompanyAustralia] | BankUserId | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompanyAustralia] | EFTFileTypeNo | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompanyAustralia] | SelfBalancingFileFlag | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompanyAustralia] | IntermediaryBHPhone | Field Changed | Field Length chagned from 15 to 50 | 12.10 |
[rar].[PayCompanyDefaultsUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayCompanyDocumentFormat] | PayCompanyDefaultUKId | Field Added | Field Added | 12.10 |
[rar].[PayCompanyNewZealand] | BankAbbreviation | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompanyNewZealand] | BSBNumber | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompanyNewZealand] | EFTFileTypeNo | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompanyNewZealand] | SelfBalancingFileFlag | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompanyNewZealand] | AccountSuffix | Field Deleted | Field Deleted | 12.10 |
[rar].[PayCompanyStateAidSectorsUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayCompanyUK] |
| Table Added | Table Added | 12.10 |
[rar].[Payee] | LegacySystemId | Field Changed | Changed from LegacySystemID | 12.10 |
[rar].[PayeeBankAccount] | AccountName | Field Changed | Changed from Not Null to Null | 12.10 |
[rar].[PayeeBankAccount] | AccountNumber | Field Changed | Changed from Not Null to Null | 12.10 |
[rar].[PayeeBankAccount] | BuildingSocietyReference | Field Added | Field Added | 12.10 |
[rar].[PayeeBankAccount] | BankIdentifierCode | Field Added | Field Added | 12.10 |
[rar].[PayeeCarBenefitsUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayeeChildRelatedPaymentsYTDUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayeeContract] |
| Table Deleted | Table Deleted | 12.10 |
[rar].[PayeeHeader] | PayeeMigrationId | Field Added | Field Added | 12.10 |
[rar].[PayeeHeaderPayroll] | TaxTypeUK_no | Field Added | Field Added | 12.10 |
[rar].[PayeeHeaderPayroll] | UmbrellaCompanyId | Field Added | Field Added | 12.10 |
[rar].[PayeeHeaderPayroll] | PayeeTypeUk | Field Added | Field Added | 12.10 |
[rar].[PayeeHeaderPayroll] | GrossPayTaxTypeNo | Field Added | Field Added | 12.10 |
[rar].[PayeeHeaderPayrollUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayeeNationalInsuranceContributionsYTDUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayeeNiableEarningsByBandYTDUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayeePayroll] | CurrencyCodeId | Field Added | Field Added | 12.10 |
[rar].[PayeePayrollChildRelatedPaymentBlocksUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayeePayrollChildRelatedPaymentEpisodeNotPaidReasonsUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayeePayrollChildRelatedPaymentEpisodePartnerDetailsUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayeePayrollChildRelatedPaymentEpisodesUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayeePayrollChildRelatedPaymentsUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayeePayrollChildRelatedPaymentsWeeklyBreakupUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayeePayrollGrossPay] |
| Table Added | Table Added | 12.10 |
[rar].[PayeePayrollHMRCUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayeePayrollNewZealandKiwiSaverOptInDate] |
| Table Deleted | Table Deleted | 12.10 |
[rar].[PayeePayrollNewZealandKiwiSaverOptInDateHoliday] |
| Table Deleted | Table Deleted | 12.10 |
[rar].[PayeePayrollPensionEnrolmentPostponementsUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayeePayrollPensionEnrolmentsUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayeePayrollUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayeePensionYTDUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayeeSickPeriodOfIncapcityToWorkDetailGrossWageBatchUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayeeSickPeriodOfIncapcityToWorkDetailsGrossWageBatchHistoryUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayeeSickPeriodOfIncapcityToWorkHeaderGrossWageBatchUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayeeSickPeriodOfIncapcityToWorkHeaderUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayeeTaxYTDUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayeeTerminationsUK] |
| Table Added | Table Added | 12.10 |
[rar].[PayGroup] | ContractorOnly | Field Added | Field Added | 12.10 |
[rar].[PayGroup] | PortalPayslipReleaseTypeNo | Field Added | Field Added | 12.10 |
[rar].[PayGroup] | TimesheetWarningTimeZoneId | Field Changed | Field Name and Datatype Changed | 12.10 |
[rar].[PayGroupSweden] |
| Table Deleted | Table Deleted | 12.10 |
[rar].[PayPeriodSweden] |
| Table Deleted | Table Deleted | 12.10 |
[rar].[PayPeriodUK] |
| Table Added | Table Added | 12.10 |
[rar].[PensionAutoEnrolmentPostponementsGrossWageBatchUK] |
| Table Added | Table Added | 12.10 |
[rar].[PensionAutoEnrolmentsGrossWageBatchHistoryUK] |
| Table Added | Table Added | 12.10 |
[rar].[PensionAutoEnrolmentsGrossWageBatchUK] |
| Table Added | Table Added | 12.10 |
[rar].[PensionPeriodsUK] |
| Table Added | Table Added | 12.10 |
[rar].[PensionProviders] |
| Table Added | Table Added | 12.10 |
[rar].[PensionRateRule] |
| Table Added | Table Added | 12.10 |
[rar].[PensionRateRuleValidity] |
| Table Added | Table Added | 12.10 |
[rar].[PensionSchemes] |
| Table Added | Table Added | 12.10 |
[rar].[PensionSchemeValidity] |
| Table Added | Table Added | 12.10 |
[rar].[PensionThresholdsUK] |
| Table Added | Table Added | 12.10 |
[rar].[PerformancePay] |
| Table Deleted | Table Deleted | 12.10 |
[rar].[PostGraduateLoanThresholdsUK] |
| Table Added | Table Added | 12.10 |
[rar].[PostgraduateLoanTransactionsGrossWageBatch] |
| Table Added | Table Added | 12.10 |
[rar].[PostgraduateLoanTransactionsHistory] |
| Table Added | Table Added | 12.10 |
[rar].[PublicHolidayPaymentHeader] | ConditionalVariableComparisonType | Field Changed | Field Name changed from PayeeConditionalVariableComparisonType | 12.10 |
[rar].[StatePensionAgeRulesUK] |
| Table Added | Table Added | 12.10 |
[rar].[StudentLoanThresholdsUK] |
| Table Added | Table Added | 12.10 |
[rar].[StudentLoanTransactions_History] |
| Table Added | Table Added | 12.10 |
[rar].[StudentLoanTransactionsGrossWageBatch] |
| Table Added | Table Added | 12.10 |
[rar].[SuperStreamServiceProvider] | ContactPhone | Field Chagned | Field Length changed from 10 to 50 | 12.10 |
[rar].[TaxCodeUpdateDetailsUK] |
| Table Added | Table Added | 12.10 |
[rar].[TaxCodeUpdateHeaderUK] |
| Table Added | Table Added | 12.10 |
[rar].[TaxCodeUpdatePayGroupsUK] |
| Table Added | Table Added | 12.10 |
[rar].[TaxMonthsUK] |
| Table Added | Table Added | 12.10 |
[rar].[TaxPeriodsScotland] |
| Table Added | Table Added | 12.10 |
[rar].[TaxPeriodsUK] |
| Table Added | Table Added | 12.10 |
[rar].[TaxPeriodsWales] |
| Table Added | Table Added | 12.10 |
[rar].[TaxRatesCISUK] |
| Table Added | Table Added | 12.10 |
[rar].[TaxRatesScotland] |
| Table Added | Table Added | 12.10 |
[rar].[TaxRatesUK] |
| Table Added | Table Added | 12.10 |
[rar].[TaxRatesWales] |
| Table Added | Table Added | 12.10 |
[rar].[UKTaxCodesInfo] |
| Table Added | Table Added | 12.10 |
[rar].[UmbrellaCompany] |
| Table Added | Table Added | 12.10 |
[FI].[FinanceIntegrationBatches] | IsDownloaded | Field Added | Field Added | 12.10 Patch 1 |
[FO].[CandidateWorkReferences] | EmailAddress | Field Added | Field Added | 12.10 Patch 1 |
[FO].[JobOrders] | TotalPackage | Field Length changed | Field Length changed from Decimal(38, 6) to (38,2) | 12.10 Patch 1 |
[FO].[JobOrders] | BaseSalary | Field Length changed | Field Length changed from Decimal(38, 6) to (38,2) | 12.10 Patch 1 |
[FO].[Reports] | DisabledByFastTrack | Field Added | Field Added | 12.10 Patch 1 |
[FO].[Candidates] | PassportCountryId | Field Added | Field Added | 12.10 Patch 3 |
[rar].[LeaveType] | PaidLeaveType | Field Added | Field Added | 12.10 Patch 3 |
[rar].[MedicareLevySurchargeTierRate] |
| Table Added | Table Added | 12.10 Patch 3 |
[rar].[NationalInsurancePeriodsUK] |
| Table Added | Table Added | 12.10 Patch 3 |
[rar].[NationalInsuranceThresholdsUK] |
| Column Renamed | TaxPeriodId renamed to NationalInsurancePeriodUKId | 12.10 Patch 3 |
[rar].[PayCode] | IsBonusCommissionPayments | Field Added | Field Added | 12.10 Patch 3 |
[rar].[PayeePayrollAustralia] | IsRegisteredWHMEmployer | Field Added | Field Added | 12.10 Patch 3 |
[rar].[PayeePayrollAustralia] | WithholdingVariationType | Field Added | Field Added | 12.10 Patch 3 |
[rar].[PayeePayrollAustralia] | IsCIRApplied | Field Added | Field Added | 12.10 Patch 3 |
Related content
Classification-Public