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].[InvoiceTerms] | Renamed | 12.15p2 - New name - [dbo].[Terms] | |
[FO].[JobOrderPermServices] | Renamed | 12.15p2 - New name - [FO].[JobOrderServices] | |
[dbo].[CreditNoteReason] | [ExportCode] | Added | 12.15p2 |
[dbo].[fttsheettemp] | [Username] | Added | 12.15p2 |
[dbo].[fttsheettemp] | [ExpiredDateTime] | Added | 12.15p2 |
[dbo].[TimesheetImportBatches] | [DefaultAdjustmentReasonId] | Added | 12.15p2 |
[dbo].[TimesheetImportBatchRawData] | [AdjustmentReason] | Added | 12.15p2 |
[dbo].[TimesheetImportBatchRawData] | [AdjustmentReasonImportCode] | Added | 12.15p2 |
[dbo].[TimesheetImportBatchRawData] | [ReimbursementProjectCode] | Added | 12.15p2 |
[dbo].[TimesheetImportBatchRawData] | [ReimbursementImportCode] | Added | 12.15p2 |
[dbo].[TimesheetImportBatchRawData] | [CurrencyCode] | Added | 12.15p2 |
[dbo].[TimesheetImportBatchRawData] | [CurrencyValue] | Added | 12.15p2 |
[FO].[Candidates] | [InterviewTime] | Added | 12.15p2 |
[FO].[Clients] | [InterpretedTimesheetStatusId] | Added | 12.15p2 |
[FO].[GeneralSettings] | [SMSCharacterLimit] | Added | 12.15p2 |
[FO].[PasswordPolicy] | [ForcePasswordLowercase] | Added | 12.15p2 |
[FO].[Reasons] | [ExportCode] | Added | 12.15p2 |
[FO].[Services] | [IsAutoInvoice] | Added | 12.15p2 |
[FO].[Services] | [IsCreationDateDeterminesInvoiceDate] | Added | 12.15p2 |
[rar].[PayCompanyDocumentFormat] | [TermId] | Added | 12.15p2 |
[rar].[PayeeHeaderPayroll] | [StartingProformaRemittanceId] | Added | 12.15p2 |
[rar].[PayeePayroll] | [TermId] | Added | 12.15p2 |
[rar].[PayeePayroll] | [IsProformaRemittanceEnabled] | Added | 12.15p2 |
[rar].[PayeePayroll] | [ProformaRemittanceDeliveryMethodTypeNo] | Added | 12.15p2 |
[rar].[PayeePayroll] | [ProformaRemittanceDocumentNotificationTemplateId] | Added | 12.15p2 |
[rar].[PayGroup] | [IsIncludePriorPeriodsTimesheetsInCurrentPeriod] | Added | 12.15p2 |
[rar].[TimesheetResult] | [TermId] | Added | 12.15p2 |
[rar].[TimesheetResult] | [PaymentTermDueDate] | Added | 12.15p2 |
[rar].[TimesheetResult] | [InterpretedTimesheetStatusId] | Added | 12.15p2 |
[rar].[TimesheetTransactionReportParam] | [UserName] | Added | 12.15p2 |
[dbo].[AutoInvoiceHeaders] | Added | 12.15p2 | |
[dbo].[AutoInvoiceItems] | Added | 12.15p2 | |
[dbo].[CreditNoteReasonImportCodes] | Added | 12.15p2 | |
[dbo].[ProformaRemittanceDetails] | Added | 12.15p2 | |
[dbo].[ProformaRemittanceDetailsItem] | Added | 12.15p2 | |
[dbo].[ProformaRemittanceHeaders] | Added | 12.15p2 | |
[dbo].[ProformaRemittancePayResult] | Added | 12.15p2 | |
[dbo].[ProformaRemittanceTimesheetResult] | Added | 12.15p2 | |
[dbo].[Terms] | Added | 12.15p2 | |
[FO].[JobOrderServices] | Added | 12.15p2 | |
[FO].[ServiceAutoInvoiceOptions] | Added | 12.15p2 | |
[rar].[InterpretedTimesheetStatuses] | Added | 12.15p2 | |
[rar].[TimesheetResultPaymentDueDateAudit] | Added | 12.15p2 | |
[rar].[GrossWageBatch] | AdjustmentTaxCalculationMethod | Added | 12.17 - B2 tax calculation method. 1 = Standard, 2 = Bii |
[rar].[PayCodePayrollAU] | Table Added | 12.17 - This table contains AU related configurations related to Pay code | |
[rar].[PayeeHeaderPayrollAustralia] | Table Added | 12.17 - Table contains the Australia specific Payee Payroll Information | |
[rar].[PayeePayrollAustralia] | IsSeniorsAndPensionersTaxOffsetApplied | Added | 12.17 - Flag to Identify Seniors And Pensioners Tax Offset Applied or not |
[rar].[PayeePayrollAustralia] | SeniorsAndPensionersTaxOffsetStatus | Added | 12.17 - Seniors And Pensioners TaxOffset Status Enum: 1 =Single ,2=Couple ,3= Illness Separated Couple |
[rar].[PayeePayrollAustralia] | MedicareLevySurchargeTier | Added | 12.17 - The MLS tiers that identifies the rate at which MSL will be calculated on. |
[rar].[PayeePayrollAustralia] | IsMedicareLevySurchargeApplied | Added | 12.17 - To flag a payee as being subject to a medicare levy surcharge |
[rar].[PayeePayrollAustralia] | IsSeasonalWorkerProgramme | Added | 12.17 - Flag to Identify whether the payee is working in Australia under the Seasonal Worker Programme (SWP) |
[rar].[PayeePayrollAustralia] | IsExemptFromWithholding | Added | 12.17 - Flag to identify whether the payee is exempt from withholding or not |
[rar].[PayeePayrollAustralia] | IsHorticulturalistShearersTaxRatesApply | Added | 12.17 - Indicates if payee is subject to the horticulturalist and shearers tax rates. Only applies to PAYG payees. 1 = True |
[rar].[TerminationReason] | STPCessationReasonType | Added | 12.17 - This is to map termination reasons to a cessation type code : 1 = V (Voluntary Cessation), 2 = I (Ill Health), 3 = D (Deceased), 4 = R (Redundancy), 5 = F (Dismissal), 6 = C (Contract Cessation), 7 = T (Transfer) |
[rar].[PayeePayrollAustralia] columns PayeeHeaderPayrollAustralia | IsWorkCoverPaymentsAfterTermination | Added | 12.17 - IsWorkCoverPaymentsAfterTermination Flag 0 = False,1 = True |
[rar].[PayeePayrollAustralia] columns PayeeHeaderPayrollAustralia | PayeeHeaderId | Added | 12.17 - PRIMARY KEY PayeeHeaderId |
[rar].[PayCodePayrollAU] columns PayCodePayrollAU | IsIncludeInGrossEarningsInSTPReport | Added | 12.17 - Determines if Paycode includes Gross Earnings in STP Reports |
[rar].[PayCodePayrollAU] columns PayCodePayrollAU | IsItemiseInSTPReports | Added | 12.17 - Determines if Paycode has setting for STP Reporting |
[rar].[PayCodePayrollAU] columns PayCodePayrollAU | IsReturnToWorkPayments | Added | 12.17 - Indicates if the pay code is marked as Return to Work Payments for STP |
[rar].[PayCodePayrollAU] columns PayCodePayrollAU | PayCodeId | Added | 12.17 - Indicates if the pay code is marked as Return to Work Payments for STP |