Calculating Max Remaining using SQL and/or APIs... ???

[rinse-dental]

x-post from developer forum.

Hi, how do you calculate max remaining? The issue I'm finding is incorporating the 'Adjustments to Insurance Benefits' record (found on the Edit Insurance Plan screen within the Family Module) which I can't seem to find in the DB or APIs returns.

[SLeon]

Good morning,

From our manual:

Individual Annual Max - (Ins Used + Pending) = Remaining

You can incorporate the adjustments to insurance benefits entered in this form via the ClaimProc table. They will have a claimproc.Status of "Adjustment".

[rinse-dental]

You're the best! Dunno how i missed it but thank you!