There must be a standard naming convention for temp table creation, and they must have temp prefix/suffix along with DDMMYYYY indication:

  • Naming Convention: TEMP_<TEAM: CSM|BL|AR>_<number to keep><D|W|M|Y>_<free text/Incident No>_<creation_date:DDMMYYYY >
  • E.g. TEMP_CS_3M_RETENTION_DUP_01122023


Account DB archival routines should check and exclude these temp tables from backup.