Do dates and date ranges trip you up? This course is intended to reinforce and build your understanding of how to handle dates in your reports. We cover dates and date-times, discrete dates and date ranges. We will review formulas like dateadd() and datediff(), and provide some new toys to play with too. Students will work on two reports, one focused on goods and services, and the other on service restrictions.
Cost: $250.00 per person, plus applicable taxes Class Size: 6 maximum Difficulty: 🔴🔴⭕⭕⭕
This 3-hour small group seminar is intended for people who are already familiar with developing reports in Crystal Reports. It introduces or reintroduces the idea of embedding reports inside other reports, which can be used to coordinated data that otherwise doesn't go together. We will cover subreport placement, recurring subreports, subreport linking, and performance.
Cost: $250.00 per person, plus applicable taxes Class Size: 6 maximum Difficulty: 🔴🔴🔴⭕⭕
Lovely to see everyone today. Lots of stuff going on. Today we talked about:
Referrals project - Nancy wanted to know what was going on
MMAH - new reporting requirements related to unsheltered and encampments. Which is nice timing because of HIFIS 4.0.60.5, newly released, with big updates to the encampments module.
COR report - some who are not coming to next week's learning session asked for me to give them a sneak peak
AOC3 - how are communities doing that? Some really good conversation about that!
Lovely to see everyone today. Lots of stuff going on. Today we talked about:
Referrals project - Nancy wanted to know what was going on
MMAH - new reporting requirements related to unsheltered and encampments. Which is nice timing because of HIFIS 4.0.60.5, newly released, with big updates to the encampments module.
COR report - some who are not coming to next week's learning session asked for me to give them a sneak peak
AOC3 - how are communities doing that? Some really good conversation about that!
Kat shared some information that 17% of her active clients were over the 90-day inactivity threshold but hadn't received any services in 90 days. She has a script from HICC that verifies this, and she's curious how prevalent this issue is in other communities. Here's a link to the SQL code. Please contact @Kat LeBlanc with any interesting results.
Several communities are currently testing the new COR report.
Pero asked about how communities are validating the (older) CHR report and what the definitions were.
We're going deep on activity and inactivity!
Kat shared some information that 17% of her active clients were over the 90-day inactivity threshold but hadn't received any services in 90 days. She has a script from HICC that verifies this, and she's curious how prevalent this issue is in other communities. Here's a link to the SQL code. Please contact @Kat LeBlanc with any interesting results.
Several communities are currently testing the new COR report.
Pero asked about how communities are validating the (older) CHR report and what the definitions were.
First call in a while, since the last one was cancelled. This week we had about 12 people. Here were some highlights:
Transitional housing - if a client moves in to housing for only a couple days, is there a way we can record this but not count it as a transition to housing?
Veteran confirmation - North Bay's VAC office told them they needed a SIN number to confirm veteran status, which is of course a big challenge
CAEH innovation funding - lots of communities applying and crossing their fingers
Immigrations & refugees - funding available through the Interim Housing Assistance Program, lots of discussion about data needs
First call in a while, since the last one was cancelled. This week we had about 12 people. Here were some highlights:
Transitional housing - if a client moves in to housing for only a couple days, is there a way we can record this but not count it as a transition to housing?
Veteran confirmation - North Bay's VAC office told them they needed a SIN number to confirm veteran status, which is of course a big challenge
CAEH innovation funding - lots of communities applying and crossing their fingers
Immigrations & refugees - funding available through the Interim Housing Assistance Program, lots of discussion about data needs
Welcome to our new participants from the West coast in Red Deer, Grande Prairie, and Whitehorse!
Today we talked about:
APIs and data linkages - lots of partners assume that HIFIS already talks to other systems (like SAMS). Ali does a little overview of what an API is, talked about send/receive functions, and how the software on both ends would need to have an enabling piece to allow this
Case Management Sessions - Discussion from Red Deer and Chatham about Case Sessions.
Activity statuses - in ETO (Alberta's current system) there are other Client Statuses - "Unknown" and "Disappeared," so we talked about how that works in HIFIS
Lindsey reporting about the recent HIFIS Working Group - some discussion about collecting information about disabilities, also supportive housing and recording rent as an expense and subsidies as income.
Welcome to our new participants from the West coast in Red Deer, Grande Prairie, and Whitehorse!
Today we talked about:
APIs and data linkages - lots of partners assume that HIFIS already talks to other systems (like SAMS). Ali does a little overview of what an API is, talked about send/receive functions, and how the software on both ends would need to have an enabling piece to allow this
Case Management Sessions - Discussion from Red Deer and Chatham about Case Sessions.
Activity statuses - i…
Welcome to our new participants from the West coast in Red Deer, Grande Prairie, and Whitehorse!
Today we talked about:
APIs and data linkages - lots of partners assume that HIFIS already talks to other systems (like SAMS). Ali does a little overview of what an API is, talked about send/receive functions, and how the software on both ends would need to have an enabling piece to allow this
Case Management Sessions - Discussion from Red Deer and Chatham about Case Sessions.
Activity statuses - in ETO (Alberta's current system) there are other Client Statuses - "Unknown" and "Disappeared," so we talked about how that works in HIFIS
Lindsey reporting about the recent HIFIS Working Group - some discussion about collecting information about disabilities, also supportive housing and recording rent as an expense and subsidies as income.
Add to Google calendar
Add to Apple calendar
Add to Yahoo calendar
Add to Outlook calendar
Add to Office365 calendar
Comments