Attendance Change Detail for Orgs
=================================

The report is a supplement for the :doc:`AttendanceChangeForOrgs` script.
This script also runs from the `OrgSearch BlueToolbar`.
It is used to know where the percentages came from and which organizations were involved.
This report is also resource intensive, so we limited it to Admin role.

The recommended name is ``AttendanceChangeDetailForOrgs``

Use the following code to Create the SQL Script.
See :doc:`../CreateSqlScript`.

.. code-block:: sql

    --Roles=Admin
    --class=StartEndReport
    SELECT a.PeopleId ,
           p.Name2 ,
           o.OrganizationId ,
           o.OrganizationName ,
           a.Attended ,
           a.WeekDate
    FROM AttendanceChangeDetail(@orgids, @MeetingDate1, @MeetingDate2) a
    JOIN dbo.People p ON p.PeopleId = a.PeopleId
    JOIN dbo.Organizations o ON o.OrganizationId = a.OrganizationId
    ORDER BY Name2, o.OrganizationName, WeekDate