Issues with Check-In Look-ups and Duplication of Entries
Posted: Thu Jun 14, 2012 12:10 pm
We finally launched off our check-in kiosks after a lot of prep work.
Now we are finding issues when checking children in and quirks that result in a lot of erroneous entries in the main PowerChurch Plus membership profile database.
Here are some real-life scenarios that were uncovered:
• The Check-In system provides only one way to search, & that is using the guardian’s name. They cannot search for the child’s name, & so when there is a different last name (which I would guess is anywhere from 25%-50% of the time), they add the new unit.
• The system also requires that the child be in the same “household unit” as the one dropping them off. So when someone other than the parent drops them off, they have to add that person to the same household as the child even though this person is already in the database. For example, Danny Aguayo drops off his nephew, but since they are not in the same household unit (although technically they live at the same address), the children’s worker had to add Danny to Ruth’s household so now Danny is in the database twice. This is the same situation with Damien Reyes/Addison Lopez. In this case, the guardian & the child are not even related. This is also the case with Anthony Salgado/Carmen Galvan, who are related but don’t live in the same place. Right now, the only way I can think of to accommodate this is for the workers to continue adding these duplicates & for me to go in every Monday & tag these duplicates so that they don’t appear in our directories, mailing lists or other reports. But they’ll still be in the database. I’m making full use of the “Notes” sections so that the original & the duplicates can be distinguished, but over time I imagine the database might get very complicated.
This has the potential of becoming a nightmare over time when there are so many 'unconventional' guardian/child relationships....something not that unusual for us in our Chicago urban environment.
SOMEONE - Please help us or let us know that this program is going to be improved upon!
Otherwise, I could be faced with running a separate instance of PCP and Check-In on a totally different server system...which would not be an elegant solution.
Now we are finding issues when checking children in and quirks that result in a lot of erroneous entries in the main PowerChurch Plus membership profile database.
Here are some real-life scenarios that were uncovered:
• The Check-In system provides only one way to search, & that is using the guardian’s name. They cannot search for the child’s name, & so when there is a different last name (which I would guess is anywhere from 25%-50% of the time), they add the new unit.
• The system also requires that the child be in the same “household unit” as the one dropping them off. So when someone other than the parent drops them off, they have to add that person to the same household as the child even though this person is already in the database. For example, Danny Aguayo drops off his nephew, but since they are not in the same household unit (although technically they live at the same address), the children’s worker had to add Danny to Ruth’s household so now Danny is in the database twice. This is the same situation with Damien Reyes/Addison Lopez. In this case, the guardian & the child are not even related. This is also the case with Anthony Salgado/Carmen Galvan, who are related but don’t live in the same place. Right now, the only way I can think of to accommodate this is for the workers to continue adding these duplicates & for me to go in every Monday & tag these duplicates so that they don’t appear in our directories, mailing lists or other reports. But they’ll still be in the database. I’m making full use of the “Notes” sections so that the original & the duplicates can be distinguished, but over time I imagine the database might get very complicated.
This has the potential of becoming a nightmare over time when there are so many 'unconventional' guardian/child relationships....something not that unusual for us in our Chicago urban environment.
SOMEONE - Please help us or let us know that this program is going to be improved upon!
Otherwise, I could be faced with running a separate instance of PCP and Check-In on a totally different server system...which would not be an elegant solution.