Note: The general information in this post is applicable in the Cloud database's Windows App as well as in the Legacy database; however, sql statements would need modification for the Windows App.
Greetings, All!
I had to get Rick to do a remote session with me in March or April to fix a problem. He noticed that some of my households had been assigned ID numbers and asked what they were for. Once I explained it to him, he asked me to post the idea on the forum for others to see. This is the first chance I've had to get on the forum since then, so here goes!
We use the Household ID number to help us run our child security system. When a clubber registers, the household (not the clubber) is issued an ID number. We then make 2 security cards for that household using 2 x 3 1/2" business cards, equally-sized laminate, and a laminating machine. We included the initials of our church followed by "Awana Club," the Awana logo, and John 3:16 on the front of the card (with the assigned number) and a statement on the back stating that, if the card was found, to please return it to... and included our church name and address. The parent is instructed to keep one card and give the other to a 2nd person who would be most likely to pick up the child(ren) if they don't.
We then create a "check-out" list for each club that includes only the first name of the clubber with their assigned household ID number. The parent shows their ID card to the leader at the door, goes into the room and gets the child(ren), and the ID card is checked off when they leave the room together. This alleviates the system where a child has to have something pinned to or hung on him (or her). It also prevents the practice of someone calling the child's name out so that anyone standing in the hallway can hear. It seems to work out pretty well.
As far as visitors go, we made several extra cards with VIS01, VIS02, etc. on them. When a visitor checks in with a parent, the parent receives a visitor ID card and the number is noted by the person checking him or her in. When the parent comes to pick up the visitor, he or she just turns in the card. If, and when, the visitor decides to register, a permanent Household ID is assigned. If the visitor comes with another clubber (rides with them), that visitor is picked up with the Household ID of the person who brought them. Some visitors always ride with a neighbor and so are permanently assigned to that persons household ID number.
Household ID numbers are assigned first alphabetically by last name and then numerically (A1-10, B 1-10, etc.). Rick designed an SQL formula for me to be able to create the check-out lists more quickly and easily. But he said that, if enough interest was shown in such a feature, he would be happy to add it as a report option. (BTW, our club is large. We averaged about 160 clubbers this past year.)
Secretary Diana
