Database Schema Changes (12.15p2 & 12.17)

[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