FastTrack360 Version 12 Online Help
Database Schema Changes (11.37 UK Release 12.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 |
dbo.DocumentEmailTemplate | Â | Table Removed |
dbo.InvoiceFormatGroup | Â | Table Removed |
dbo.InvoiceFormatGroupDocumentFormatLink | Â | Table Removed |
rar.PayeeConditionalVariable | Â | Table Removed |
rar.PayeeConditionalVariableLink | Â | Table Removed |
rar.PayeeConditionalVariableType | Â | Table Removed |
rar.PublicHolidayPaymentPayeeConditionalVariable | Â | Table Removed |
 |  |  |
dbo.DocumentFormatGroup | Â | Table Added |
dbo.DocumentFormatGroupDocumentFormatLink | Â | Table Added |
dbo.DocumentFormatUsage | Â | Table Added |
dbo.DocumentNotificationTemplate | Â | Table Added |
dbo.InvoiceAttachment | Â | Table Added |
dbo.TimesheetDelegations | Â | Table Added |
 |  |  |
FI.FinanceIntegrationBatchSchedules | Â | Table Added |
 |  |  |
FO.GlobalSectionConfiguration | Â | Table Added |
FO.GlobalSectionConfigurationMapping | Â | Table Added |
FO.MFACountryUserTypes | Â | Table Added |
FO.MFAMandatoryPermissionItems | Â | Table Added |
FO.MFASecurityRoles | Â | Table Added |
FO.ReportMapping | Â | Table Added |
FO.Schedules | Â | Table Added |
rar.AdditionalRARGroupItems | Â | Table Added |
rar.AgreementConditionalVariable | Â | Table Added |
rar.AgreementConditionalVariableType | Â | Table Added |
rar.BillRateFormula | Â | Table Added |
rar.BillRateFormulaItem | Â | Table Added |
rar.ConditionalVariableLink | Â | Table Added |
 |  |  |
rar.EFTBatchEftTransactionHeaderLink | Â | Table Added |
rar.EFTBatches | Â | Table Added |
rar.FormulaComponent | Â | Table Added |
rar.FormulaComponentBillOncostHeaderLink | Â | Table Added |
rar.GrossWageBatchItemLeavePaymentRateDetails | Â | Table Added |
rar.GrossWageBatchItemLeavePaymentRateDetailsHistory | Â | Table Added |
rar.GrossWageBatchProcessLog | Â | Table Added |
rar.JobLeaveConditionalVariableAssignment | Â | Table Added |
rar.JobTemplateLeaveLocks | Â | Table Added |
rar.LeaveFirstJobOrderStartDateCondition | Â | Table Added |
rar.LeaveJobLeaveCondition | Â | Table Added |
rar.PayCodeSupplementaryPayCodeLink | Â | Table Added |
rar.PayCodeSupplementaryPayCodeLinkValidity | Â | Table Added |
rar.PayCompanyNotification | Â | Table Added |
rar.PayeeFBTDetail | Â | Table Added |
rar.PublicHolidayPaymentConditionalVariable | Â | Table Added |
rar.RatesImportBatch | Â | Table Added |
rar.RatesImportBatchError | Â | Table Added |
rar.RatesImportBillAgreementData | Â | Table Added |
rar.RatesImportJobOrderBillAgreementData | Â | Table Added |
rar.RatesImportJobOrderPayAgreementData | Â | Table Added |
rar.RatesImportPayAgreementData | Â | Table Added |
rar.RatesImportStandardData | Â | Table Added |
rar.RatesImportTemplateBillAgreementData | Â | Table Added |
rar.RatesImportTemplatePayAgreementData | Â | Table Added |
rar.RatesImportTemplateStandardData | Â | Table Added |
rar.RemovedGrossWageBatchItem | Â | Table Added |
rar.RemovedGrossWageBatchPayOncostResult | Â | Table Added |
rar.RemovedLeaveTransactionGrossWageBatch | Â | Table Added |
rar.SuperTransferHistory | Â | Table Added |
 |  |  |
dbo.Debtor | LegacySystemId | Field Added |
dbo.DebtorInvoiceLink | DocumentFormatGroupId | Field Renamed (original name: InvoiceFormatGroup_id) |
dbo.DebtorPurchaseOrder | PurchaseOrderDescription | Field Added |
dbo.DocumentFormatComponentTableItem | TranslateText | Field Removed |
dbo.DocumentFormatComponentTableItem_History | TranslateText | Field Removed |
dbo.InvoiceHeader | DocumentFormat_id | Field Removed |
dbo.InvoiceHeader | DocumentFormat_History_id | Field Removed |
dbo.InvoiceItem | JobOrderSkillGroupId | Field Added |
dbo.InvoiceItem | JobOrderPositionId | Field Added |
dbo.InvoiceItem | JobOrderOwnerId | Field Added |
dbo.PortalCountrySetting | RateMinimumLabel | Field Added |
dbo.PortalCountrySetting | EnableRateMinimum | Field Added |
dbo.PortalCountrySetting | IsCustomLeaveBalanceOnPayslip | Field Added |
dbo.PortalCountrySetting | EnableAdditionalRARGrouping | Field Added |
dbo.PortalCountrySetting | AdditionalRARGroupingName | Field Added |
 |  |  |
FI.SalesExports | DebtorImportCode | Field Added |
FI.SalesExports | DebtorExportCode | Field Added |
 |  |  |
FO.Addresses | LegacySystemId | Field Added |
FO.AttachFiles | SecuredSign | Field Removed |
FO.AttachFiles | DueDate | Field Removed |
FO.Candidates | CreationSourceTypeId | Field Added |
FO.Candidates | LegacySystemId | Field Added |
FO.CandidateWorkReferences | LegacySystemId | Field Added |
FO.ClientContacts | LegacySystemId | Field Added |
FO.ClientContactDetails | EmailOne | nvarchar (255) |
FO.ClientContactDetails | EmailTwoOne | nvarchar (255) |
FO.Clients | LegacySystemId | Field Added |
FO.Comments | DisplayToApprover | Field Added |
FO.Comments | DisplayToInitiator | Field Added |
FO.CostCentre | LegacySystemId | Field Added |
FO.CustomSectionRecordTypes | ConnectPermissionCode | Field Added |
FO.EmailSmsTemplates | FromEmailAddress | Field Added |
FO.GeneralSettings | CloseJobsWhereStatusIs | Field Added |
FO.GeneralSettings | DaysAfterJobsEndDate | Field Added |
FO.GeneralSettings | EmailSmsSuppressAddComment | Field Added |
FO.GeneralSettings | DefaultPrimaryResumeLoad | Field Added |
FO.JobOrders | AdditionalRARGroupItemId | Field Added |
FO.JobOrders | LegacySystemId | Field Added |
FO.JobTemplates | AdditionalRARGroupItemId | Field Added |
FO.JobTemplates | LegacySystemId | Field Added |
FO.LayoutSettings | IsReport | Field Added |
FO.LayoutSettings | IsVisible | Field Added |
FO.Offices | IsAdditionalRARGroupingMandatory | Field Added |
FO.Offices | OverrideAdditionalRARGrouping | Field Added |
FO.Offices | AdditionalRARGroupingSelectionBehaviourType | Field Added |
FO.ParentCompanies | LegacySystemId | Field Added |
FO.PasswordPolicy | EnableBypassMFAOption | Field Added |
FO.PasswordPolicy | DefaultMethodology | Field Added |
FO.PasswordPolicy | EnableRememberThisDeviceType | Field Added |
FO.PasswordPolicy | MFAActiveDate | Field Added |
FO.PasswordPolicy | MfaSmsAuthenticationMessage | Field Added |
FO.PasswordPolicy | MfaTotpAuthenticationMessage | Field Added |
FO.PasswordPolicy | MfaMobileNumberRequiredMessage | Field Added |
FO.PasswordPolicy | MfaDontHaveMyDeviceMessage | Field Added |
FO.PasswordPolicy | MfaSmsAuthorisationCodeMessage | Field Added |
FO.PasswordPolicy | MfaExpiryTimeInMinutes | Field Added |
FO.PasswordPolicy | MfaNumberOfSmsLimit | Field Added |
FO.PasswordPolicy | MfaDontHaveMyDeviceDelayTimeInMilliSeconds | Field Added |
FO.PasswordPolicy | MfaPhoneNumberRegex | Field Added |
FO.ReportSchedules | ReportFrequencyId | Field Removed |
FO.ReportSchedules | EventType | Field Removed |
FO.ReportSchedules | StartDate | Field Removed |
FO.ReportSchedules | EndDate | Field Removed |
FO.ReportSchedules | ScheduledTime | Field Removed |
FO.ReportSchedules | ScheduleDays | Field Removed |
FO.ReportSchedules | ScheduledDate | Field Removed |
FO.ReportSchedules | IsScheduledLastDate | Field Removed |
FO.ReportSchedules | WeekNumber | Field Removed |
FO.ReportSchedules | UserId | Field Removed |
FO.ReportSchedules | NextScheduleDateTime | Field Removed |
FO,SkillKeywords | SkillKeywordName | varchar (100) |
FO.UserDetails | LegacySystemId | Field Added |
FO.Users | MfaMethod | Field Added |
FO.Users | MfaSMSCode | Field Added |
FO.Users | MfaSmsExpiry | Field Added |
FO.Users | IsApiTermConditionAccepted | Field Added |
FO.Users | AcceptedBy | Field Added |
FO.Users | AcceptedDateTime | Field Added |
FO.Users | MfaGuid | Field Added |
FO.Users | IsViewQR | Field Added |
FO.Users | LoginId | Field Added |
 |  |  |
rar.Agreement | EnforceAttendanceTypeInTimesheet | Field Added |
rar.Agreement | AdditionalRARGroupItemId | Field Added |
rar.Agreement | UseSupplementaryRatesForOncosts | Field Added |
rar.AgreementAssignmentConditionalVariable | AgreementConditionalVariable_id | Field Renamed (Original name: ConditionalVariable_id) |
rar.BillOncostRate | RateType | Field Added |
rar.BillOncostRate | AdditionalRARGroupItemId | Field Added |
rar.BillOncostRate | UseSupplementaryRatesForOncosts | Field Added |
rar.BillRateRule | AdditionalRARGroupItemId | Field Added |
rar.BillRateSubRule | AgreementConditionalVariable_id | Field Renamed (Original name: ConditionalVariable_id) |
rar.BillRateSubRule | LinkedBillRateFormulaId | Field Added |
rar.BreakRule | InsufficientShiftDurationCondition | Field Added |
rar.ConditionalVariable | IsActive | Field Removed |
rar.ConditionalVariableType | Country_id | Field Added |
rar.ConditionalVariableType | Name | Field Added |
rar.ConditionalVariableType | Active_flag | Field Added |
rar.ConditionalVariableType | Type | Field Added |
rar.ConditionalVariableType | Agreement_id | Field Removed |
rar.ConditionalVariableType | Identifier | Field Removed |
rar.ConditionalVariableType | Mandatory_flag | Field Removed |
rar.ConditionalVariableType | IsActive | Field Removed |
rar.DeductionHeaderValidity | Type | Field Added |
rar.DeductionHeaderValidity | Value | Field Added |
rar.DeductionHeaderValidity | NetProtectedType | Field Added |
rar.DeductionHeaderValidity | NetProtectedValue | Field Added |
rar.DeductionHeaderValidity | ApplyDefaultRate | Field Added |
rar.DeductionHeaderValidity | CalculationBaseType | Field Added |
rar.DeductionHeaderValidity | ContractorDeductibleServiceFee | Field Added |
rar.EftTransactionHeader | CreatedDate | Field Removed |
rar.EftTransactionHeader | CreatedUser | Field Removed |
rar.EftTransactionHeader | PaymentDate | Field Removed |
rar.GrossWageBatchItem | LeavePaymentRateToBeDetermined | Field Added |
rar.GrossWageBatchPayeeTerminationEtp | ETPNonTaxableAmount | Field Added |
rar.GrossWageBatchPayeeTerminationEtp | ETPNonTaxablePayCodeId | Field Added |
rar.GrossWageBatchPayeeTerminationEtp_History | ETPNonTaxableAmount | Field Added |
 |  |  |
rar.GrossWageBatchPayeeTerminationEtp_History | ETPNonTaxablePayCodeId | Field Added |
rar.GrossWageBatchPayslipItem | RateDescription | Field Added |
rar.GrossWageBatchPayslipPayee | DocumentFormat_id | Field Removed |
rar.GrossWageBatchPayslipPayee | DocumentFormat_History_id | Field Removed |
rar.GrossWageBatchPayslipPayeeAustralia | STSLTotal | Field Added |
rar.GrossWageBatchPayslipPayeeAustralia | STSLTotalYTD | Field Added |
rar.GrossWageBatchPayslipPayeeSuper | ContributionType | Field Added |
rar.GrossWageBatchPayslipPayeeSuper | AmountMTD | Field Added |
rar.HolidayRule | AdditionalRARGroupItemId | Field Added |
rar.LeaveRequestTime | PaymentStatusTypeNo | Field Added |
rar.LeaveSet | IsForPayoutOrTerminationOnly | Field Added |
rar.LeaveTransaction | JobOrderId | Field Added |
rar.LeaveTransaction | LeaveRequestTimeId | Field Added |
rar.LeaveTransactionGrossWageBatch | LeaveRequestTimeId | Field Added |
rar.LeaveTransactionGrossWageBatch | JobOrderId | Field Added |
rar.LeaveTransactionGrossWageBatch | IsBasedOnLeavePayment | Field Added |
rar.LeaveType | AllowJobBasedAccrual | Field Added |
rar.LeaveType | DefaultAccrualMethodType | Field Added |
rar.LeaveVariableCondition | ConditionalVariable_id | Field Renamed (Original name: PayeeConditionalVariable_ |
rar.PayBillRateRule | AdditionalRARGroupItemId | Field Added |
rar.PayBillRateSubRule | AgreementConditionalVariable_id | Field Renamed (Original name: ConditionalVariable_id) |
rar.PayBillRateSubRule | RateDescription | Field Added |
rar.PayBillRateSubRule | RateMinimum | Field Added |
rar.PayCompanyAustralia | DeclarationType | Field Rename (Original name: STPDeclarationTypeId) |
rar.PayCompanyAustralia | IsABNAppointedToProviderABN | Field Added |
rar.PayCompanyAustralia | TransactionCode | Field Added |
rar.PayCompanyDocumentFormat | DocumentFormatGroupId | Field Renamed (Original name: PayslipFormatGroupId) |
rar.Payee | LegacySystemId | Field Added |
rar.PayeePayroll | DocumentFormatGroupId | Field Renamed (Original name: PayslipFormatGroupId) |
rar.PayeePayrollAustralia | IsTaxOffsetClaimed | Field Added |
rar.PayeePayrollAustralia | OffsetAmount | Field Added |
rar.PAYGLeavePayment | ConditionalVariableId | Field Renamed (Original name: PayeeConditionalVariableI |
rar.PayOncostRate | RateType | Field Added |
rar.PayOncostRate | AdditionalRARGroupItemId | Field Added |
 |  |  |
rar.PayOncostRate | UseSupplementaryRatesForOncosts | Field Added |
rar.PayResult | PayBillRateSubRuleId | Field Added |
rar.StandardRate | LinkedBillRateFormulaId | Field Added |
rar.StandardRate | RateDescription | Field Added |
rar.StandardRateHeader | UseSupplementaryRatesForPayOncosts | Field Added |
rar.StandardRateHeader | UseSupplementaryRatesForBillOncosts | Field Added |
rar.STPBatchPayCompanies | TaxPeriodEndDate | Field Added |
rar.STPBatchPayCompanies | PayCompanyTaxTotal | Field Added |
rar.STPBatchPayCompanies | IsBalancingPayment | Field Added (applicable fro V11.37 AU Tax Release) |
rar.STPBatchPayees | PayeeTaxTotal | Field Added |
rar.SuperTransaction | SuperRateRuleValidityId | Field Added |
rar.SuperTransaction | ContributionBasisApplied | Field Added |
rar.SuperTransaction | FixedAmount | Field Added |
rar.SuperTransaction | PercentageAmount | Field Added |
rar.SuperTransaction | PayeePayrollSuperId | Field Added |
rar.SuperTransactionGrossWageBatch | SuperRateRuleValidityId | Field Added |
rar.SuperTransactionGrossWageBatch | ContributionBasisApplied | Field Added |
rar.SuperTransactionGrossWageBatch | FixedAmount | Field Added |
rar.SuperTransactionGrossWageBatch | PercentageAmount | Field Added |
rar.VariableCondition | AgreementConditionalVariable_id | Field Renamed (Original name: ConditionalVariable_id) |
Â
Â
Classification-Public