Hi All,
Could anyone tell me how T-Stats calculates package size? I know that it represents the number of performances within the package, but where does it get that?
Thanks,
Bryan
Hi Bryan,
I'm going to provide some basic and some technical information given your title at CSO. Let me know if you're after something different than what I'm providing here.
During the load from Tessitura into the TStats data warehouse, a procedure called load_package is executed.
For Fixed Seat Packages: package size is determined by counting the performance lineitems in the package.
* count(distinct li_seq_no) where perf_no>0* load_package lines 1016-1043 and 1106-1116
For Non-Fixed Seat Packages: packages size is determined by dividing the total number of tickets by the total number of package seats. If division results in a remainder, it's flagged as an error.
* (count of sli_no) / (t_lineitem num_seats_pur-num_seats_ret)* load_package lines 449-510
And for what it's worth, the lines between the various Forums and Group Discussion areas blur easily, but there's a T-Stats Group with a Discussion area that's ideal for these kinds of posts.
I hope that helps. Best,Chris
__________________________________________ Chris Wallingford Product Manager | JCA 575 Eighth Ave., 21st Floor | New York, NY 10018 Phone: 203-468-9123 | Fax: 212-465-2349 chris.wallingford@jcainc.com | twitter www.jcainc.com | twitter | blog
Helping Non-Profits Work Smarter Visit JCA’s blog for the latest insights into how nonprofits can work smarter!