Wednesday, August 7, 2013

Last Known Inspection in Combo Reports

An extra field has been added to those pulled by the Building Combination Reports screen. The field, MAXDATE, pulls the last known inspection date for each permit. This is useful information to compare with the Expire Date field to see if a building project is truly in progress. The MAXDATE is determined by looking at all of the Last Inspect fields for each given permit and selecting the most recent one. If no inspections are recorded for a permit the field will be NULL.

No comments:

Post a Comment