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 ...

    • How to Add, Enable and Disable a Credit Card

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

    • Planning Tab

      The dashboard is a customisable overview of your operations, it gives an overview of your account activity. 1. On Planning dashboard, you can create/assign/release the load as well as you can edit/delete a load also. To see the planning dashboard, ...

    • 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 ...

    • Address List

      The address list contains a list of all the addresses of the senders and receivers from your consignments. Addresses can be added to the list through various methods as below: Manually Added: You can manually add addresses while on the Address List ...