HI everyone
I'm doing some year-end housekeeping. In particular, I'd like to tackle the TR_WEB_SOURCE_NO table which is where you link your Source No for an offer to a user-friendly Promo code for use in TNEW. This table has never had anything deleted in over 10 years. Some entries have been inactivated, but there are many still active from previous years which are no longer in use as they relate to past seasons/events.
What's best practice for managing these? Do you delete entries or just inactivate them? I'd like to delete the really old ones and just inactivate the more recent ones. The documentation for this table does not cover inactivation or deletion. I'm assuming it does not affect reporting as this is usually by Source No/Name rather than promo code.
Any thoughts/reassurances welcome!
Many thanksBest wishes
Dawn
I've been thinking about this again of late. I think I would generally like to keep the data, so I'm inclined to create a Local Reference Table (LTR_ARCHIVE_WEB_SOURCE_NO or the like) and then perhaps annually copying over values while deleting them from TR_WEB_SOURCE_NO. Inactivating still leaves the table with a lot of cruft to potentially scroll through, and when tables get large enough even creates performance issues. We'd probably keep at least one or two seasons in the original table for quick reference?