@juggernautsei , would recommend having your report sort out what an active vs inactive patient is; and we could go from there (ie. could in the end have a selector that had the available options, like the facility for example, where has all patient, patients seen within 1 year, etc; and could work in globals options as needed). Note the AMC and CQM calculations do this by usually looking at last encounter for its calculations, and notable what is in the denominator (ie. active vs inactive) is not always the same from rule to rule.
Regarding archiving, isn’t one of the benefits of computerized records to be able to get to records at the push of a button(no matter how old the records are). Would seem odd from a physician perspective that I would click for a patient records and it would no longer exist since it has been archived(there have been times where the only record of a simple hemoglobin from 10 years ago in a patient that presents to the hospital has been helpful).
Also, to add, even in the case of a deceased patient(where it seems like it would make sense to archive the data), I have sometimes had to field questions or fill in paperwork long after.