Update Person Activity

Update Person Activity¶

This is primarily a SQL stored procedure that updates a set of person attributes with up to date information. If run nightly it will provide you with accurate details about a person's activity in the church. The following statistics are tracked:

• Last Attendance Date (any attendance counts, small group, event, worship service, anything that generates an occurrence attendance record)
• Last Contribution Date (any money given to the church as a contribution counts, wether or not it is tax deductable)
• Attendance over last 3 months
• Attendance over last 6 months
• Attendance over last 12 months
• Contributions over last 3 months
• Contributions over last 6 months
• Contributions over last 12 months

The same information is also tracked on a family basis, meaning if you have no attendance records your "Attendance over last 3 months" will be 0, but if your spouse has attended weekly then your "Family attendance over last 3 months" will be 12. If two people attend the same something at the same date/time it only counts as one. So if both you and your spouse attend 12 times over the last 3 months to the same event(s), it will only show Family attendance of 12 as well.

Additionally, the "over last n months" are integer values that count the number of times. So it will not tell you how much somebody has contributed, just how many times they wrote a check.

The required Person Attributes will automatically be created for you. You will need to update the security on them as they will be viewable by the Admin user only.

Your List Configuration will also be automatically updated to include the new person attributes for use in lists.

Installation is fairly straight forward:

1. Load the update_person_activity.sql script on your SQL server and execute it against the ArenaDB database. (Download from here)
2. Assuming no errors, log into Arena as the Admin user and update the security settings on the Person Attributes and give proper permissions as desired (the new attribute group name is Attendance Overview).
3. Open a new SQL window and execute the stored procedure by hand to do the initial run (this may take an hour or longer, after this each run should only take a few minutes at most).

• EXEC cust_hdc_sp_update_person_activity

4. Create a new SQL Server Agent job to automatically run the stored procedure every night

• General Tab * Name: Update Person Activity
• Steps Tab * Add a new Step
  • Step Name: SQL
  • Database: ArenaDB
  • Command: EXEC cust_hdc_sp_update_person_activity
• Schedule Tab * Add a new Schedule
  • Name: Nightly
  • Occurs: Daily
  • Recurs every: 1 day
  • Occurs once at: 04:00:00AM (You can have it run at whatever time you want)