Search found 6 matches
- Thu Jan 06, 2022 11:37 am
- Forum: Advanced Topics
- Topic: Getting The Allowed Column In Treatment Plan
- Replies: 7
- Views: 16117
Re: Getting The Allowed Column In Treatment Plan
The "Procedure.ComputEstimates/ClaimProc.ComputeBaseEst" in that column description for AllowedOverride is not a calculation. It is referring to a pair of functions in our code. For each procedure in the treatment plan, the Procedure.ComputeEstimates function calls the ClaimProc.ComputeBaseEst func...
- Thu Jan 06, 2022 7:12 am
- Forum: Advanced Topics
- Topic: Getting The Allowed Column In Treatment Plan
- Replies: 7
- Views: 16117
- Thu Jan 06, 2022 7:12 am
- Forum: Advanced Topics
- Topic: Getting The Allowed Column In Treatment Plan
- Replies: 7
- Views: 16117
- Wed Jan 05, 2022 7:43 am
- Forum: Advanced Topics
- Topic: Getting The Allowed Column In Treatment Plan
- Replies: 7
- Views: 16117
Getting The Allowed Column In Treatment Plan
I am trying to get the "Allowed" In the Treatment Plan page. After consulting with the OpenDental Documentation, in the "claimproc", I see this https://i.imgur.com/BhzgQc9.png So it seems that the "Allowed" column is calculated by looking at some column that has "ComputeEstimates" divided by "Comput...
- Sat Jul 31, 2021 10:51 am
- Forum: Advanced Topics
- Topic: Combining all these queries together (from Report) into One
- Replies: 4
- Views: 12167
Re: Combining all these queries together (from Report) into One
Hello Unioning them didnt work because the queries seem to be very different. I found Query #793 from the QueryList and it seems to work except the Writeoff amount is different from what is generated in the report. For reference, this is Query 793: https://pastebin.com/J5YhjjcL The production, adjus...
- Wed Jul 28, 2021 1:50 pm
- Forum: Advanced Topics
- Topic: Combining all these queries together (from Report) into One
- Replies: 4
- Views: 12167
Combining all these queries together (from Report) into One
I would like to combine all these queries together (from Report) into One SELECT procedurelog.ProcDate Date, CONCAT(CONCAT(CONCAT(CONCAT(patient.LName, ', '),patient.FName),' '),patient.MiddleI) namelf, procedurecode.Descript Description, provider.Abbr, procedurelog.ClinicNum Clinic, procedurelog.Pr...