Adding in my vote here. Might expand this to really any data element
that has a formal "status" field should be logged in the back with a
date/time/user stamp...rather than continually updating a single field
or only being able to return the first line of data of a specific
element (aka most recent). This would (theoretically) allow for
historical reporting across the board during a specified time range.
Similar use case as above - report on # of active vs completed projects,
# of at risk vs on ...