Port Document Expiration

Had a request asked yesterday about patient portal encounter documents expiration. The doctor does physicals for boxers. The boxer can get a copy of his physical from the patient portal. The physical is only good for one year. Even though the printed physical shows the date the physical was done. The doc would like to remove access to the physical if a year has gone by.
That way the boxer can’t print a copy and with technical magic change the date the physical was done. So, if the physical is not accessible then there would be less of a chance for the document to being fraudulently edited.

Off the top of my head, that would just need some extra metadata in the database. Probably just an expiry_date field. And then the SQLs just need to be updated to take that field into account. Likely a good candidate for an index