I see there is a Role in the Contribution records now, but I cannot find where that is stored. I would especially like to use the Cr role to pull up Soft Credit contributions. Where is that coming from?
Jan LaRocque
Houston Symphony
Another resource where those ticket role IDs and definitions are explicitly spelled out is the Tessitura Table Structures document: https://www.tessituranetwork.com/en/Files/Docs/SystemAdmin/Tessitura-Table-Structures-V14
This doc doesn't cover every single table, but it does include a breakdown of column names, datatypes, and primary/foreign keys for most of the heavy hitters you'll regularly deal with. I've found it helpful as an alternative to diving into SSMS for quick structural questions.