PowerSchool Extract Tool: Contact addresses appear to be duplicated

If contact addresses are shown as being duplicated in Illuminate ... this is due to the extract scripts pulling 'Mailing Street' for Address 1 and 'Street' for Address 2.  If these fields are the same in PowerSchool it would appear as "duplicate" addresses being shown in Illuminate.

This can be corrected by making modifications to the scripts shown below.

c:\ps_illuminateed_exporter\contacts_mother.sql

c:\ps_illuminateed_exporter\contacts_father.sql

Change the line below;

 || :TAB ||  s.Street

The modified line should look as shown below;

 || :TAB || CASE WHEN (s.Street != s.Mailing_Street) THEN s.Street ELSE '' END

Make this change in both .sql files and save the changes.  The duplicated addresses should then be corrected during the next nightly import cycle.