Currently API Scan all documents and all routing / status to get latest status. Which is very time consuming.
To make it fast we can add new column into document table which will contain latest status and Updated Date.

Once document status set to Completed & Rejected after that if user viewed document then no need to update status as Viewed.

So we can get latest status of document of document and no need to join with document routing.