Roll up an internal-model inventory you declare. Count the inventory by declared status, list the pending submission ids, age each pending submission in whole calendar days from its declared submitted date to your declared as_of snapshot, and read an overall verdict under a named 180-day aging rule. Every id, status, date, and the snapshot itself are yours: the page holds no register, no tape, and no clock.
The inventory snapshot date you declare. Nothing here reads a wall clock: the as_of date is an input, and every pending age is whole calendar days from each declared submitted date to it.
One row per declared model: an id (unique within the inventory), a declared status (submitted, approved, or rejected), and the declared submitted date. Rejected models are validated but counted nowhere. Any pending submission older than 180 days at as_of flags TRACKING_AGED; an inventory with no submitted and no approved models reads TRACKING_EMPTY.
| model id | status | submitted (YYYY-MM-DD) |
|---|