• Replies 2 replies
  • Subscribers 962 subscribers
  • Views 86 views
  • Users 0 members are here
Related

NSCAN Attendance Scan Report - what qualifies as constituent: (General Public)

Allan Tina
$organization

Hi all,

Would anyone be able to explain what kind of scans might fall into the (general public) constituent? Most scans are associated to a specific constituent, but some are defaulted to (general public) which is not an actual constituent.

Example:

Daytime Admission
Constituent
Adult
Child
Other
 
(General Public)
58
0
0

Thanks for educating me!

Allan

Parents
  • $organization

    Hi I appreciate this was 4 years ago, but did you get anywhere with this question? We've got a few scans that are coming up as General Public but I can't find what orders they are associated with. 

  • $organization in reply to Ellen McCann

    Hi Ellen,

    A general public scan would be any order placed without specifying a constituent ID in the order, these go against customer_no 0, which is the 'General Public' constituent.  You cannot view this constituent record in Tessitura itself, but you are able to find these orders by searching the database in SQL:

    select * from T_ORDER
    where customer_no = 0

    And you can find attendance data specifically for this customer by querying:

    select * from T_ATTENDANCE
    where customer_no = 0

    If you would like us to provide specific data around this for you, please reach out in a support ticket and we can help you with that.

    Thanks,
    James

Reply
  • $organization in reply to Ellen McCann

    Hi Ellen,

    A general public scan would be any order placed without specifying a constituent ID in the order, these go against customer_no 0, which is the 'General Public' constituent.  You cannot view this constituent record in Tessitura itself, but you are able to find these orders by searching the database in SQL:

    select * from T_ORDER
    where customer_no = 0

    And you can find attendance data specifically for this customer by querying:

    select * from T_ATTENDANCE
    where customer_no = 0

    If you would like us to provide specific data around this for you, please reach out in a support ticket and we can help you with that.

    Thanks,
    James

Children
No Data