Skip to Main Content
MCARE Ideas Portal
Created by Ant Mitchell
Created on May 19, 2025

Export of Care Plan Review Comments

There is currently no way to export care plan review comments to get a full picture (outside of PCS) of this aspect of the system. That's not strictly true, because these comments can be found via the Care Planning Audit report, but examining the JSON of this, bizzarely there is no link to the resident (connectionid / serviceuserid / personid or, sometimes even the "Name" is N/A) or the care plan itself, via careplanid / careplanids. It wouldn't have hurt to have included the careplanid field, surely.

  • Attach files
  • Ant Mitchell
    May 21, 2025

    FYI. We use APIs to pull into SQL Server. If anyone else is interested, I have found the review comments in the AuditRecordsReport, as mentioned above. I have found that by joining that data with the care plans table, using the ActionDescription and CurrentSituation fields of the care plan against the same fields in Audit Records, I can produce a match and then written an SP that shows them all together, with HTML tags removed (and even redacted names with initials). If anyone is interested in seeing how this was done, please let me know.