Migration script for Version 23.2 - benefit/frequency

[phi.bui]

Hello,
We're aware of a major change to the frequency/benefits for the new version 23.2 that would impact our integration when we're upgrading the open dental into this new version. Would it be possible that you could provide the migration script that you use when doing the upgrade? This will help us with the mapping/relationship on the changes. I believe it is directly impact the benefit table. If you have any questions or clarifications, please feel free to let me know.
Thank you very much!
Phi

[jsalmon]

No.

Wouldn't you just need to change your integration from looking at the deprecated preferences to looking at the new codegroup table?
Before:
An arbitrary preference dictated a group of codes for very specific benefits (based on how they were set up).
After:
A structured link is made between the benefit row and the group of codes it utilizes.
benefit.CodeGroupNum => codegroup row which holds the ProcCodes

[phi.bui]

Hello,
Could you provider some details on the deprecated preferences? where do I find those information?
As checking the database schema on 23.2, I do see CodeGroupNum added to benefit table, and a new table for codegroup for linking to the procedures. Could you help me understand the purpose for using the codegroup?
Thanks!

[jsalmon]

Could you provider some details on the deprecated preferences? where do I find those information?

They just held a comma delimited list of procedure codes. They all started with "InsBen..."
For Example:

Code: Select all

///<summary>Comma delimited list of procedure codes that represent bitewing codes.  Defaults to D codes for all users.</summary>
[Obsolete("This preference has been deprecated. Use CodeGroups instead.",true)]
InsBenBWCodes,
...

https://github.com/OpenDental/opendenta ... es/Pref.cs

Could you help me understand the purpose for using the codegroup?

The summary on the table type is probably the best description for the purpose behind using the codegroup.

Code: Select all

/// <summary>These groups of procedure codes are used in Benefit Frequencies and Insurance History. We can't use CovCats because those spans are frequently far too broad.  We often need specific codes. Cached.</summary>

https://github.com/OpenDental/opendenta ... deGroup.cs