Oh, and if you don’t have LAST_UPDATED at all, you can just map it to your RPT_DATE
/ ENCOUNTER_DATE
in the DOC_FIELD_EMR_INTENT
table. Something like:
update DOC_FIELD_EMR_INTENT
set SOLR_FIELD_NAME = 'RPT_DATE'
where NAME = 'LAST_UPDATED'