Family Email
============

This script runs from the Main Menu if added to the Menu.
It shows the Family ExtraValue with a Field name of `Email` 
along with other email addresses for the family.
The report is one row per family.

.. admonition:: Use Case - Conversions

    This is intended for conversions when the previous software had a family email address.
    We don't recognize family email in TouchPoint,
    so we put it into a Family Extra Value Text field (single email).
    If the church did not have emails on the individual people records,
    then they can run this report to know which records they need to correct.

The recommended name is ``FamilyEmail``

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

.. code-block:: sql

    SELECT 
        p.PeopleId, 
        p.Name2 HeadOfHouse,
        Data,
        p.EmailAddress,
        p.EmailAddress2,
        sp.PreferredName Spouse,
        sp.EmailAddress SpouseEmail,
        sp.EmailAddress2 SpouseEmail2,
        (SELECT COUNT(*) FROM dbo.People m WHERE m.FamilyId = fe.FamilyId) FamilyCount
    FROM dbo.FamilyExtra fe
    JOIN dbo.Families f ON f.FamilyId = fe.FamilyId
    JOIN dbo.People p ON p.PeopleId = f.HeadOfHouseholdId
    LEFT JOIN dbo.People sp ON sp.PeopleId = p.SpouseId
    WHERE Field = 'Email'
    ORDER BY p.Name2