In addition to data loaders for orders, site visits, etc., there are other loaders whose purpose is to add information that is static, rarely-changing, or not site-dependent to the Data Warehouse. One such loader is the TimeRepositoryLoader, which populates the ARF_TIME_YEAR, ARF_TIME_MONTH, etc. tables (see the Business Intelligence Data Warehouse Guide for information).

The TimeRepositoryLoader is run by the TimeRepositoryLoaderJob, a scheduled service that runs every two weeks by default. When the job runs, the loader populates the next two weeks worth of days into the appropriate tables. For example, if the loader runs on December 20, it loads the next fourteen days, two weeks, one month, and one year into the ARF_TIME_DAY, ARF_TIME_WEEK, ARF_TIME_MONTH, and ARF_TIME_YEAR Data Warehouse tables respectively.

The TimeRepositoryLoader includes a datetimezoneID property, which identifies the time zone to use when loading this data. The default is UTC, meaning that, if an order is loaded into the warehouse, the date and time of that order’s placement are converted from the values used in the order repository to the UTC equivalent, and the UTC times are used in reports.