Skip to content
English
❔
Log into Projectworks
  • There are no suggestions because the search field is empty.

13 October 2024 - SQL views include write-off columns

Included in this release:

Feedback or questions? 

Email us as support@projectworks.io and one of the team will get back to you!

 

SQL Views including write-off columns

Following the introduction of write-offs to Projectworks in September, additional write-off columns have been added to a number of views, so that write-offs can be included in your SQL report building. 

[BI].[FactProjectTimesheets]

Four new columns have been added:

  • OverrideType

  • OverrideAmount

  • OverrideBy

  • OverrideDate

[BI].[FactProjectBurn]

One new column has been added

  • OverrideAmount

[BI].[FactUserActivity] 

One new column has been added

  • OverrideType

[BI].[FactUserActivityWithHolidays] 

One new column has been added

  • OverrideType

Read more about SQL Views schema here →

Stay in the loop

Want to stay up-to-date with Projectworks product updates as they drop? To get monthly updates straight to your inbox, sign up to our product mailing list.