Also, how many years have you been in Tessitura, and how many organizations are in your database?
Org 1: 16 years
Org 2: 1 year
Org 3: 0 years
Total: 6077
By Inactive Flag:
Y 4212N 1865
**self-hosted**
294 rows in T_GL_ACCOUNT; 187 inactive = Y, 107 inactive = N
SLSO has been a Tessitura client since 2003
1 organization
Ashley Elliott
Database Administrator
St. Louis Symphony Orchestra
314-286-4198
ashleye@slso.org
We have been on Tessitura since 2006 and have 187 rows in the table. 183 inactive = N, 4 inactive = Y
I'm detecting a trend which does not surprise me...
We have one organization, and it looks like 2005 was the first season with Tessitura.
Total GLs: 451
Inactive:
N 422Y 29
We have been with Tessitura since 2018. We have 132 rows in the table; 117 active and 15 inactive.
1 org, since 2007, 305 GLs, 19 inactive
1 organization with Tessitura since 2015. 510 rows active and 202 inactive.
We've been a Tessitura client since our 2002/2003 season, and it's just us in our instance.771 rows, but only 341 are active. We also completely changed our GL structure about four years ago.
One org, in production since 2014; 190 rows, 113 inactive.
1 Org
2014
53 Active
1 Inactive
10 years on Tessitura, 3 orgs in our database. 97 active GL's, 18 inactive.
I'll add that we've only just started to add new GL's with a higher frequency so our count will probably grow a lot in the coming years.
We've been using Tessitura since 2005.
3 orgs
1177 active GLs,
991 inactive GLs
One organization in Tessitura for 4 years. Counts by inactive flag:
Y 165
N 389
One organization - 3 years
Total: 3219
Y 3219N 0
Requisite explanation - we have 40+ business units (each of our house museums plus various other parts of the organization) as subaccounts on our primary chart of accounts. When we launched, we built out this table by basically joining every possible subaccount Tessitura might need to deal with (museum 1, museum 2, etc.) to every possible account (grants corp, grants foundation, program income, etc.). Some of these may seldom or never be used, but that way we had a consistent set of accounts and subaccounts available for all business units.
I might bother you about how your thoughts on GL structure change sometime