Table | Field | Action | Comment / Extended Property Description |
DebtorInvoiceLinkOrderReference | | Deleted | |
[rar].[PAYGLeavePaymentDeductionHeader] | | Deleted | |
[FPSPayees] | [EmployeeEmploymentPaymentPeriodsCovered] | Added | No of pay periods included in the FPS. |
[InvoiceHeader] | [CustomerName] | Changed | Field length changed |
[FO].[CacheReportDesigner] | [ReportString] | Changed | Made nullable |
[FO].[Countries] | [OnlyIncludeTimesheetsWithinCurrentPeriod] | Deleted | |
[rar].[GrossWageBatch] | [OnlyIncludePayeesWithTimesheets_flag] | Deleted | |
[rar].[GrossWageBatch] | [OnlyIncludeTimesheetsWithWeekendingDateLessThanPayPeriod_flag] | Deleted | |
[rar].[GrossWageBatchItem] | [InsertedIdMappingsBatchNo] | Added | Field needed only for internal logic |
[rar].[GrossWageBatchItem] | [GrossWageBatchItemTempId] | Added | Field needed only for internal logic |
[rar].[GrossWageBatchItem] | [IsSystemCalculatedGST] | Added | Indicates if the GST is calculated by the system or not. |
[rar].[GrossWageBatchItemLeavePaymentRateDetails] | [LeaveRequestTimeId] | Added | Foreign key to rar.LeaveRequestTime table. |
[rar].[GrossWageBatchItemLeavePaymentRateDetails] | [GrossWageBatchItemTempId] | Added | Field needed only for internal logic |
[rar].[GrossWageBatchPayee] | [GrossWageBatchPeriodId] | Added | Foreign key to rar.GrossWageBatchPeriods table. |
[rar].[GrossWageBatchPayee] | [PayeeHeaderId] | Added | Foreign key to rar.PayeeHeader table. |
[rar].[GrossWageBatchPayee] | [CandidateId] | Added | Foreign key to FO.Candidates table. |
[rar].[GrossWageBatchPayee] | [IsManuallyAdded] | Added | Indicates if the payee added to the pay batch manually. |
[rar].[GrossWageBatchPayee_History] | [GrossWageBatchPeriodId] | Added | Foreign key to rar.GrossWageBatchPeriods table. |
[rar].[GrossWageBatchPayee_History] | [PayeeHeaderId] | Added | Foreign key to rar.PayeeHeader table. |
[rar].[GrossWageBatchPayee_History] | [CandidateId] | Added | Foreign key to FO.Candidates table. |
[rar].[GrossWageBatchPayeeDeductionsHistoryUK] | [BroughtFowardDeductionAmount] | Added | Brought forward deduction amount. |
[rar].[GrossWageBatchPayeeDeductionsHistoryUK] | [BroughtFowardProtectedEarnings] | Added | Brought forward protected earnings. |
[rar].[GrossWageBatchPayeeDeductionsUK] | [BroughtFowardDeductionAmount] | Added | Brought forward deduction amount. |
[rar].[GrossWageBatchPayeeDeductionsUK] | [BroughtFowardProtectedEarnings] | Added | Brought forward protected earnings. |
[rar].[GrossWageBatchPayeeTax] | [TempGrossWageBatchPayeeTaxId] | Added | Field needed only for internal logic |
[rar].[GrossWageBatchProcessLog] | [PayPeriodId] | Added | Foreign key to rar.PayPeriod table. |
[rar].[LeaveTransaction] | [IsTopUpAccrual] | Added | Indicates if the accrual is a top up accrual. |
[rar].[LeaveTransaction] | [ReprocessType] | Added | Reprocess type, 1 - Reprocess, 2 - Top up |
[rar].[LeaveTransactionGrossWageBatch] | [IsTopUpAccrual] | Added | Indicates if the accrual is a top up accrual. |
[rar].[LeaveTransactionGrossWageBatch] | [ReprocessType] | Added | Reprocess type, 1 - Reprocess, 2 - Top up |
[rar].[LeaveTransactionGrossWageBatch] | [LeaveTransferRuleId] | Added | Foreign key to rar.LeaveTransferRules table. |
[rar].[NationalInsuranceContributionsByNationalInsuranceBandGrossWageBatch] | [GrossWageBatchPayeeId] | Added | Foreign key to rar.GrossWageBatchPayee table. |
[rar].[NationalInsuranceContributionsByNationalInsuranceBandGrossWageBatchHistory] | [GrossWageBatchPayeeHistoryId] | Added | Foreign key to rar.GrossWageBatchPayeeHistory table. |
[rar].[Payee] | [PAYGRate] | Added | PAYG Rate. |
[rar].[PayeeAllowance] | [IsToBePaidEveryPeriod] | Added | Indicate if the allowance should be paid every pay period. |
[rar].[PayeeAllowance] | [ExcludeBasedOnPayCodeGroupId] | Added | Indicate if the allowance should be paid only when a timesheet is not present with the given pay codes. |
[rar].[PayeeSickPeriodOfIncapcityToWorkDetailGrossWageBatchUK] | [SSPWeekEndDay] | Added | Made not nullable. |
[rar].[PayeeSickPeriodOfIncapcityToWorkDetailsGrossWageBatchHistoryUK] | [SSPWeekEndDay] | Added | Made not nullable. |
[rar].[PAYGLeavePayment] | [ConditionalVariableId] | Added | Foreign Key to rar.ConditionalVariable.ConditionalVariable_id |
[rar].[PAYGLeavePayment] | [CountryId] | Added | Foreign key to fo.Countries.CountryId. |
[rar].[PAYGLeavePayment] | [ConfigurationTypeId] | Added | 1 = Standard |
[rar].[PAYGLeavePayment] | [PercentageHierarchyId] | Added | 1 = Payee, 2 = Country |
[rar].[PayGroup] | [IsIncludePriorPeriodsTimesheetsInCurrentPeriod] | Deleted | |
dbo.ProformaRemittancePayResult | [ConsumptionTax] | Added | VAT/GST Amount |
[dbo].[TimesheetHeader] | [IsAWRAdjustment] | Added | |
[FO].[AttendanceDetails] | [AWRNumberOfWeeksPauseApplies] | Added | |
[FO].[Clients] | [QualifyingWeeksBeforeParity] | Added | |
[FO].[JobOrders] | [LegacySystemId] | Added | |
[FO].[JobOrders] | [IsAWRMonitoringNotRequired] | Added | |
[FO].[JobOrders] | [AWRJobRoleComparator] | Added | |
[FO].[JobOrders] | [AWRClockCount] | Added | |
[FO].[JobOrders] | [AWREnhancedHolidayOverride] | Added | |
[FO].[JobOrders] | [IsAWREnhancedHolidayOverrideToBeProcessed] | Added | |
[FO].[JobTemplates] | [LegacySystemId] | Added | |
[FO].[JobTemplates] | [IsAWRMonitoringNotRequired] | Added | |
[FO].[JobTemplates] | [AWRJobRoleComparator] | Added | |
[FO].[JobTemplates] | [AWREnhancedHolidayOverride] | Added | |
[FO].[Offices] | [QualifyingWeeksBeforeParity] | Added | |
[FO].[Offices] | [ResetAfterWeeksNotWorked] | Added | |
[rar].[BillRateSubRule] | [AWRParityType] | Added | |
[rar].[LeaveAccrualRule] | [UseAWREnhHolidayOverrideAtParity] | Added | |
[rar].[LeaveResetRule] | [IsIncludeTerminatedPayees] | Added | |
[rar].[PayBillRateSubRule] | [AWRParityType] | Added | |
[rar].[PayResult] | [ConsumptionTax] | Added | VAT/GST Amount |
[rar].[StandardRate] | [AWRParityType] | Added | |
[rar].[GrossWageBatchFailedLeaveRequestStatuses] | | Table Added | |
[rar].[GrossWageBatchHistoricalPeriodsForReprocessing] | | Table Added | |
[rar].[GrossWageBatchLeaveAccrualRulesToBeReprocessedAfterLeavePayments] | | Table Added | |
[rar].[GrossWageBatchLeaveRequestTimePreProcessSnapshots] | | Table Added | |
[rar].[GrossWageBatchNIableEarningsForSSP] | | Table Added | |
[rar].[GrossWageBatchPayeeSSPQualifyingDaysUK] | | Table Added | |
[rar].[GrossWageBatchPeriods] | | Table Added | |
[dbo].[AwrClockRestPauseServiceLog] | | Table Added | |
[FO].[AWRClockHistory] | | Table Added | |
[FO].[AWRClockHistoryHeader] | | Table Added | |
[FO].[AWRDataInitialisation] | | Table Added | |
[FO].[AWRLinkedJobs] | | Table Added | |
[dbo].[TimesheetHeader] | [IsAWRAdjustment] | Added | |
[FO].[AttendanceDetails] | [AWRNumberOfWeeksPauseApplies] | Added | |
[FO].[Clients] | [QualifyingWeeksBeforeParity] | Added | |
[FO].[Countries] | [IsAWR] | Added | |
[FO].[Countries] | [QualifyingWeeksBeforeParity] | Added | |
[FO].[Countries] | [ResetAfterWeeksNotWorked] | Added | |
[FO].[Countries] | [MonitoringNotRequiredForPayeeTypes] | Added | |
[FO].[Countries] | [ClockCountBasis] | Added | |
[FO].[Countries] | [AWRAdjustmentTimesheetReasonId] | Added | |
[FO].[Countries] | [ClockResetPauseAssessmentDay] | Added | |
[FO].[Countries] | [ClockResetPauseAssessmentTime] | Added | |