Automating our Arena ChMS Intranet

Using the Arena “Dockable Modules” module we have been developing our intranet. One of our desires was to be able to push data Staff Anniversaries, Birthdays as well as Employment Anniversaries for the current month to our staff home page.

We were able to do the Birthdays and Anniversaries fairly simply by using the Report Grid from Query module-

The Employment Anniversaries were a bit tricky as we do not track HR information in Arena – it is stored with in Shelby’s Payroll module. Thankfully the Arena Report Grid module allows you to connect to another database to pull information- so we wrote a stored procedure to grab the information from Shelby.

Now our staff can go to our Arena Home Page, and add the additional modules they wish to access.

We plan to add some additional report grids in the future for upcoming events, etc – but this is working well for us so far.