13 October 2024 - SQL views include write-off columns

Included in this release:

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