Hey friends! I have an idea for a TLCC panel, and I would love one or two other people to go in on it with me: "Fun with System Tables"
I imagine this as being part of the "So Now You're a DBA" series, and it would cover some of the basics a new DBA would need to know about system tables (like, "It's always T_Defaults" and "Is there anything that doesn't live in T_Keywords?") as well as dipping a toe into some of the cool semi-custom things that you can do in system tables (like custom query elements).
Anyone want to throw your hat in with me? Or even just help me brainstorm how to flesh out this topic more?
--Shelly Binkley
Business Systems Analyst, Kennedy Center
Regarding creating local system tables, I wish I knew about the help system page on how to do it ahead of time. I did it on my own based off a reference within the Tessitura Table Structures document.
Tessitura v15 Help System - Local Tables (tessituranetwork.com)
If you build a Local System Table (Reference table in V16), make sure you use the Table Help part. Otherwise, you may forget the how/why you built it. This is a sample from one of our local system tables.
"Custom System Table used in conjunction with a scheduled Custom Update N-Scan Profile report and 3 daily scheduled SQL Jobs to control what performances show up in the perf_str (NScan Profiles) within the TR_NSCAN_PROFILE System Table.
The 3 SQL Jobs run before the scheduled report. If the Add To Profile Dt is in the past, the first Job changes the perf_type on the performance to whatever is in the New Perf Type No column. If the Remove From Profile Dt is in the past, the second Job changes the perf_type to whatever is in the Revert Perf Type No column. If Remove From Profile Dt is in the past, the third job then marks those rows as Inactive.
The scheduled Custom Update N-Scan Profile report (using the LRP_NSCAN_UPDATE_PROFILE stored procedure) adds a comma-delimited list of perf_no(s) to the perf_str column in the TR_NSCAN_PROFILE System Table.
Added Dddw Table information to TR_REFERENCE_COLUMN table to allow dropdowns for the perf_types nc."