Skip to main content
Planview Customer Success Center

The UpdatedOn field in the DS_BudgetDetail view is not reflecting the update date of the budget

Reason:
The UpdatedOn field in the DS_BudgetDetail view comes from the RevisionHistory table, not from the Budget table.


Resolution:
The update information on the budget record can be queried from the Budget table itself.

Alternatively, the CreatedOn field from the DS_BudgetDetail view can be used when the UpdatedOn value is NULL. If there is no change in the budget revision since its creation, that means the latest update on the budget record is the creation of the revision, therefore the creation date of the latest budget revision record should give the latest update date on the budget record (there may be differences in milliseconds however).