Tip of the Week November 12, 2012

Create a Set to find small or large service entries

At times you may get abnormal service entries that have been created. For example, if you use the VicTouch module, sometimes a volunteer will sign-in for an assignment,  re- enter their PIN number to check the schedule, and then click the “Sign-out” button out of habit.  This creates a very small service entry such as a minute. Or, if volunteers enter their own service with the VicNet module, they may mistakenly enter a very small, or very large, number of service hours. One way to catch these would be to audit the service entries made through VicNet.

But if the service entries have already been made, another way to find the outliers is to use a Set. The “Their Service” Set rule has an option for “They have at least one service record with.” This option allows you to enter a hour limit and then search for service records that are “At least” or “Fewer than” the limit during a certain time frame. An example of how this could be used would be to find all volunteer records that have at least one service entry smaller than 10 minutes in any month of 2012. Another example would be to find all volunteer records that have at least one service entry larger than 8 hours in October 2012.

Leave a Reply