Hey all,
Is it generally considered safe to truncate and repopulate TR_BATCH_PERIOD? I'm not actually going to be changing the way the periods and quarters are structured, but the ids will change since I'm going farther back in time than what currently exists. Nothing should be expected to foreign-key on this id column, would it?
Hi Nick,
A quick look at the Tessitura database would indicate that this table is referenced by a few reports.
I'd always be very shy of truncating a Tessitura table - probably best to leave this populated with it's historical data.
To be honest, I have populated this (by SQL script) until the end of 2020 - it's one of those tables that's useful but nobody ever looks at it!
Martin