Bi Database Sync Intervals

Bi Database Sync Intervals

This article details the sync mechanisms for the tables within the BI DataBase.

Legend Sync Method

  1. CRC-based incremental sync - changes to data are detected and sync is done

  2. Date-partitioned sync - Syncs data based on date partitions to optimize performance and reduce load

BI Table​
Sync Method
Sync Frequency
Standard Run (Sync - based on the service schedule - for ex. once in 30 mins)
Extended Daily Run (Once in 24hrs sync)
SurburbBi
Daily Full Sync
Once daily
NA
Full Data
CustomerBi
CRC-based incremental sync
Based on Service schedule
Full Data & CRC checked
NA
AgentBi
CRC-based incremental sync
Based on Service schedule
Full Data & CRC checked
NA
TicketBi
CRC-based + Date-partitioned incremental sync
Based on Service schedule + Per-day looped retrigger
Last 14 days of data (per run)
Last 90 days of data (once daily if previous run over 1 day already)
UserBi
CRC-based incremental sync
Based on Service Schedule
Full Data & CRC checked (for Staff, Customer, Agent)
NA
ConsignmentBi​
CRC-based + Date-partitioned incremental sync
Based on Service schedule + Per-day looped retrigger
Last 7 days of data (per run)
Last 6 months of data (once daily if previous run over 1 day already)
ConsignmentCustomerPriceBi
CRC-based + Date-partitioned incremental sync
Based on Service schedule + Per-day looped retrigger
Last 7 days of data (per run)
Last 6 months of data (once daily if previous run over 1 day already)
ConsignmentAgentPriceBi
CRC-based + Date-partitioned incremental sync
Based on Service schedule + Per-day looped retrigger
Last 7 days of data (per run)
Last 90 days of data (once daily if previous run over 1 day already)
CustomerInvoiceBi
CRC-based + Date-partitioned incremental sync
Based on Service schedule + Per-day looped retrigger
Last 14 days of data (per run)
Last 90 days of data (once daily if previous run over 1 day already)
AgentInvoiceBi
CRC-based + Date-partitioned incremental sync
Based on Service schedule + Per-day looped retrigger
Last 14 days of data (per run)
Last 90 days of data (once daily if previous run over 1 day already)
ConsignmentReportableCostBi
CRC-based + Date-partitioned incremental sync
Based on Service schedule + Per-day looped retrigger
Last 14 days of data (per run)
Last 90 days of data (once daily if previous run over 1 day already)
ScanBi
CRC-based + Date-partitioned incremental sync
Based on Service schedule + Per-day looped retrigger

Last 7 days of data (per run)
Last 30 days of data (once daily if previous run over 1 day already)
ManifestCustomerBi
CRC-based + Date-partitioned incremental sync
Based on Service schedule + Per-day looped retrigger
Last 3 days of data (per run)
Last 7 days of data (once daily if previous run over 1 day already)
ManifestAgentBi
CRC-based + Date-partitioned incremental sync
Based on Service schedule + Per-day looped retrigger
Last 3 days of data (per run)
Last 7 days of data (once daily if previous run over 1 day already)
ManifestRunsheetBi
CRC-based + Date-partitioned incremental sync
Based on Service schedule + Per-day looped retrigger
Last 3 days of data (per run)
Last 7 days of data (once daily if previous run over 1 day already)
DriverDailySummaryBi
CRC-based + Date-partitioned incremental sync
Based on Service schedule + Per-day looped retrigger
Last 3 days of data (per run)
NA
QuoteBi
CRC-based + Date-partitioned incremental sync
Based on Service schedule + Per-day looped retrigger
Last 7 days of data (per run)
Last 6 months of data (once daily if previous run over 1 day already)
DriverDailySummaryBi
CRC-based + Date-partitioned incremental sync
Based on Service schedule + Per-day looped retrigger
Last 3 days of data (per run)
NA
EquipmentTypeBi
CRC-based incremental sync
Based on Service schedule
Full Data & CRC checked
NA
EquipmentTransactionBi
CRC-based + Date-partitioned incremental sync
Based on Service schedule + Per-day looped retrigger
Last 3 days of data (per run)
Last 30 days of data (once daily if previous run over 1 day already)
ConsignmentCommentBi
CRC-based + Date-partitioned incremental sync
Based on Service schedule + Per-day looped retrigger
Last 3 days of data (per run)
Last 30 days of data (once daily if previous run over 1 day already)
ManifestLinehaulBi
CRC-based + Date-partitioned incremental sync
Based on Service schedule + Per-day looped retrigger
Last 3 days of data (per run)
Last 7 days of data (once daily if previous run over 1 day already)
VehicleBi
CRC-based incremental sync
Based on Service schedule
Full Data
NA
VehicleMaintenanceBi
CRC-based incremental sync
Based on Service schedule
Full Data
NA
VehicleMaintenancePartsBi
CRC-based incremental sync
Based on Service schedule
Full Data
NA
VehicleAlertsBi
CRC-based incremental sync
Based on Service schedule
Full Data
NA
ConsignmentPodBi
CRC-based incremental sync
Based on Service schedule
Last 7 days of data (per run)
Last 30 days of data (once daily if previous run over 1 day already)




    • Related Articles

    • BI (Business Intelligence) Database

      BI Reporting When you need the ultimate level of flexibility and customisation with your reporting to drive your analysis and effective decision making processes, a BI reporting option is the stand out choice. What do you get? Your own private read ...

    • GLOBAL SETUP

      Global Setup General General Field Descriptions This section allows you to define default general settings for mobile devices. Auto Updates Enabled: As updates to the mobile application are rolled out, notifications will be automatically sent to the ...

    • Card Files (Staff)

      Create a New Staff Card 1. To create a new staff card, in your Transvirtual web portal, go to Transport > Configuration and Setup > Card Files (Customers/Suppliers/Staff), click on Staff (Users) tab, the staff list will display as shown below. 2. On ...

    • Licence Types

      Licence Types This article gives you an overview to see the list of licence classes available for vehicles within the company. 1. On Licence Type page you can add, edit, and delete licence type details from the database. 2. To see the licence type ...

    • Credit Cards

      Credit Cards 1. This article will describe how to add and enable the Credit Card(s) in transvirtual database. 2. To do it, go to Configuration > Transvirtual Account > Credit Cards, the credit card list page will display as shown below. How to Add a ...