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.
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.
Please sign in to leave a comment.