Tracking New vs. Modified Records in EDL
How to distinguish between new and modified records in monthly data deliveries
Currently, there is no specific flag indicating changes in the records. However, there is a first_seen_date in the PERMITS table which could be used to determine whether a record is new or pre-existing.