System Tables

Here is the directions from the System Table Documentation.

Local Tables

Local system tables may be added for custom use.  Local system tables are useful for site-specific business rules and definitions that do not regularly fit into the standard Tessitura structure.  Tables can be used to categorize elements in a different way, add additional options for custom reporting, or be used for populating dropdown fields in a custom screen or tab.

Using SQL Server Management Studio, create a table in the impresario database with the prefix LTR_, e.g. LTR_CUSTOM_CATEGORY.  Select, Insert, Update, and Delete rights must be granted to the impusers database role for this table to be usable in the application.  After the table is created in the database, run the utility stored procedure UP_POPULATE_REFTABLES_TABLE which copies the necessary metadata into T_REFERENCE_TABLES.  T_REFERENCE_TABLES contains metadata information about each System Table in the application.  Local system table entries in T_REFERENCE_TABLES may be edited manually if desired.

The primary key for a local table must be an integer (tinyint, smallint, or bigint may be used as well) and be named ‘id’.  Standard audit columns may be added as long as they conform to the name and datatype indicated below:

·         created_by varchar(8) null

·         create_dt datetime null

·         create_loc varchar(16) null

·         last_updated_by varchar(8) null

·         last_update_dt datetime null

A checkbox may be used in an editable field if the datatype is CHAR(1) and the column is NULLABLE or has a default of ‘N’.  This is typically used for an Inactive column.  To make a column use a checkbox in the edit field, check the CheckBox column for the corresponding table and column in T_REFERENCE_TABLES.

Fields may also be edited using a dropdown.  Consult the T_REFERENCE_TABLES section for details on the values necessary for populating the dropdown box.

Now, if you didn’t name your local table starting with an LTR_, You can manually add each column in t_reference_Tables but it is not as fun.

At the request of someone in Marketing, I created a table to certain specifications so that it would be "in Tessitura".  Did that, no big deal.

He later called and said "I don't see it", and after much back and forth I finally understood that he basically meant "Can you make it show up in Tessitura's System Tables module so I can insert data into it readily?" to which I replied, "Sure", assuming I can figure out what makes a given table appear in said module.

So, I ask you fine Tessiturians, is such a thing possible?  Do you simply make a corresponding entry in some table to make tables appear in System Tables?  Or is it not possible?  I suspect it's not possible, but that's why I'm here...

BONUS TRIVIA DESSERT:  The buttons on a man's cuffs were originally intended to discourage manservants from wiping their noses on the sleeves of their uniforms

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Hi Matt,

There’s a SP called UP_POPULATE_REFTABLES_TABLE that populates system table. It will look for any custom table starting with the LTR prefix.

Like the trivia!

David

At the request of someone in Marketing, I created a table to certain specifications so that it would be "in Tessitura".  Did that, no big deal.

He later called and said "I don't see it", and after much back and forth I finally understood that he basically meant "Can you make it show up in Tessitura's System Tables module so I can insert data into it readily?" to which I replied, "Sure", assuming I can figure out what makes a given table appear in said module.

So, I ask you fine Tessiturians, is such a thing possible?  Do you simply make a corresponding entry in some table to make tables appear in System Tables?  Or is it not possible?  I suspect it's not possible, but that's why I'm here...

BONUS TRIVIA DESSERT:  The buttons on a man's cuffs were originally intended to discourage manservants from wiping their noses on the sleeves of their uniforms

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!