I would like to know on what scenario records will be deleted from the address table. I see that records are being deleted from this table but dont know on what reasons it deletes.
In NmsAddress schema, usually the blacklisted,quarantine, valid, whitelisted data will be available.
The valid address will be automatically removed from this table using the option NPAI (NmsCleanup_LastCleanup) which is a part of clean up process.
This task lets you delete records which matches valid addresses from the NmsAddress table.
Check below link for the query how it will process
Database cleanup workflow
I Oversight this page. Thanks for your help
they might be purged based on purge settings. check here for further details