Table Information

Modified on Tue, 25 Jun at 8:30 PM

Table Information


Fact Tables: contain aggregated entity measurements at a specific point in time.  Aggregates are run daily.  All Daily aggregates will be retained for over a rolling 30 day period.  End of Month aggregates will be retained for the life of the data warehouse.


  • ALLWORKFACT
  • CAMPAIGNFACT
  • PROJECTFACT
  • PROOFFACT
  • TASKFACT
  • TIMEENTRYFACT
  • WORKREQUESTFACT


Dimension Tables: contain entity attributes and are effective for a range of time defined by the Effective Start Date and Effective End Date.


  • CAMPAIGNCUSTOMFIELDS
  • CAMPAIGNDIMENSION
  • DATEDIMENSION
  • PROJECTCUSTOMFIELDS
  • PROJECTDIMENSION
  • PROOFDIMENSION
  • TASKDIMENSION
  • USERDIMENSION
  • WORKREQUESTDIMENSION


Relationships: Tables are joined on Key columns.Dimension Types: Dimensions are type 6 dimensions where changes are tracked for some columns and not others.


  • Type 1 Column: Changes overwrite prior data with no tracking.
  • Type 2 Column: Changes cause a new row to be added.  Effective End Date is added to prior row and new row is added and designated as the current version.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article