Known Issue - Parent Data Confirmation multiple records being added - Fixed 12/21/2017

Some customers have reported cases of duplicate records being added as a result of parents using the Data Confirmation feature of the parent portal. Most prominently this has been seen with Authorizations (AUT) and Medical History (MHS) tables.


It has been discovered that this occurs when parents click the 'Confirm and Continue' button more than once before the page refreshes.



image



Districts may wish to delete the redundant data if this becomes an issue. The following SQL statement may be run to display and optionally remove the duplicate AUT and MHS data. Aeries Support may also be contacted for assistance in running these queries and cleaning up this data.

  

--Show AUT choices that are duplicates on the same day (newest matching choice omitted)
select aut.*, a.maxsq --into AUT_cleanup
from aut
left join
(select pid, DT, ty, co, sdt, cd, st, src, max(sq) maxsq from AUT where DEL = 0
group by pid, DT, ty, co, sdt, cd, st, src) a
on aut.pid = a.pid and aut.dt = a.dt and aut.ty = a.ty and aut.co = a.co and aut.sdt = a.sdt and aut.cd = a.cd and aut.st = a.st and aut.src = a.src
where del = 0 and aut.sq <> a.maxsq

/*
--DEL tag AUT choices that are duplicates on the same day (newest matching choice omitted)
update aut set del = 1
from aut
left join
(select pid, DT, ty, co, sdt, cd, st, src, max(sq) maxsq from AUT where DEL = 0
group by pid, DT, ty, co, sdt, cd, st, src) a
on aut.pid = a.pid and aut.dt = a.dt and aut.ty = a.ty and aut.co = a.co and aut.sdt = a.sdt and aut.cd = a.cd and aut.st = a.st and aut.src = a.src
where del = 0 and aut.sq <> a.maxsq
*/

--Show MHS choices that are duplicates on the same day (newest matching choice omitted)
select mhs.*, a.maxsq --into mhs_cleanup
from mhs
left join
(select pid, DT, co, pc, cd, max(sq) maxsq from mhs where DEL = 0
group by pid, DT, co, pc, cd) a
on mhs.pid = a.pid and mhs.dt = a.dt and mhs.co = a.co and mhs.cd = a.cd and mhs.pc = a.pc
where del = 0 and mhs.sq <> a.maxsq

/*
--DEL tag MHS choices that are duplicates on the same day (newest matching choice omitted)
update MHS set DEL = 1
from mhs
left join
(select pid, DT, co, pc, cd, max(sq) maxsq from mhs where DEL = 0
group by pid, DT, co, pc, cd) a
on mhs.pid = a.pid and mhs.dt = a.dt and mhs.co = a.co and mhs.cd = a.cd and mhs.pc = a.pc
where del = 0 and mhs.sq <> a.maxsq
*/

  

Programming is investigating this issue and will work on a fix once a method of resolution has been determined.



Just wanted to post an update that programming has found a fix for this issue, and it is currently being tested for effectiveness.

This issue was resolved with the 12/21/2017 version of Aeries. The Confirm and Continue button can now only be pressed one time by parents.

Login to post a comment