Find unique addresses (households for district-wide mailings

You can use an advanced query to send one letter per family for a district-wide mailing.

First you need to decide how you want to identify a household. The following advanced query uses phone number and address line 1. Modify to suit your district’s needs:

SELECT * FROM STUDENT

, (

SELECT MAX(PSN_OID) AS

  FROM PERSON

 INNER JOIN PERSON_ADDRESS

    ON PSN_ADR_OID_PHYSICAL = ADR_OID

 INNER JOIN STUDENT

    ON PSN_OID = STD_PSN_OID AND STD_ENROLLMENT_STATUS = 'Active'

 WHERE PSN_STUDENT_IND = '1'

 GROUPBY PSN_PHONE_01, ADR_ADDRESS_LINE_01

 

) A

WHERE STD_PSN_OID = A.PERSON_OID