## executive summary
The article handoff for core-004 is explicit about the task: show a private-practice owner how to use top CDT codes, annual frequency, office fees, and PPO allowed amounts to run a weighted fee-schedule analysis, while being careful with claims about negotiation, profitability, benchmarks, and carrier-specific advice. fileciteturn0file0L9-L19 fileciteturn0file0L43-L59
The strongest public support is not for an exact "industry standard" code count. It is for the mechanics. Public PMS documentation shows that a practice can already pull annual procedure counts, average billed fees, total billed fees, fee schedules, PPO write-offs, insurance-plan lists, and production/write-off timing from standard reports. In Open Dental alone, the Daily Procedures Report can group completed procedures by CDT code and show quantity, average fee, and total fees; the Procedure Codes - Fee Schedules Report prints or exports fees by fee schedule; the PPO Write-offs Report compares standard fees, PPO fees, and write-offs; Production and Income reports show production, write-offs, and income; and fee tools support fee exports. Those are the raw ingredients for a reproducible weighted model. citeturn54view0turn14view0turn14view2turn14view1turn43view2
The operational recommendation is to stop treating a PPO schedule as "good" or "bad" based on a simple average across codes. Use a weighted model based on the practice's own trailing-12-month procedure mix. A practical rule is to start with the top 15 CDT codes, then expand to 20 to 30 codes, or further if needed, until the selected set covers most of the PPO-relevant activity. In a general practice, a frequency-only cutoff can miss a large share of dollars because lower-frequency restorative, crown, and implant codes carry much more revenue per case than hygiene and exam codes. That recommendation is an inference from the math and from the report fields PMS vendors expose, not a published ADA rule. Confidence: moderate for the method, weak for any exact count. citeturn54view0turn14view0turn14view1
For publication, the safest framing is: a weighted fee-schedule analysis estimates reimbursement pressure and contract delta, not full practice profitability. Full profitability also depends on chair time, variable cost, lab cost, collections leakage, denials, rework, and scheduling friction. The uploaded brief correctly flags "This PPO is unprofitable," "Drop this PPO," peer fee comparisons, benchmark reimbursement rates, and carrier-specific advice as risk areas that need extra support or should be avoided. fileciteturn0file0L45-L58
## what to analyze and how many codes to include
No primary source reviewed here sets a universal rule such as "always analyze 12 codes" or "always analyze 25 codes." What the public sources do show is that PMS reports are designed to let offices rank procedures by code, frequency, average fee, and total fees, which means the right stopping rule is coverage-based, not arbitrary. Open Dental's grouped Daily Procedures Report gives exactly the fields needed to do that: code, description, quantity, average fee, and total fees. citeturn54view0
A practical recommendation for a general practice is this:
| practice pattern | starting set | expand until this is true | confidence |
|---|---:|---|---|
| small, single doctor GP | 15 codes | at least 80 percent of PPO procedure count and at least 70 percent of PPO submitted dollars | moderate |
| medium GP or multi-provider GP | 20 codes | at least 85 percent of PPO procedure count and at least 75 percent of PPO submitted dollars | moderate |
| larger multi-provider or specialty-mix office | 25 to 30 codes | at least 85 to 90 percent of PPO procedure count and at least 80 percent of PPO submitted dollars | moderate |
This is a method recommendation, not a legal or industry standard. The reason for the dual threshold is that procedure count and revenue concentration are not the same thing. The grouped Daily Procedures Report exposes both quantity and total fees, so the office can test both concentration curves before locking its code list. citeturn54view0
An illustrative large-practice synthetic example makes the point clearly:
| top n codes | cumulative procedure-count share | cumulative submitted-dollar share |
|---:|---:|---:|
| 10 | 84.3% | 55.8% |
| 15 | 94.6% | 81.2% |
| 20 | 99.4% | 93.4% |
| 22 | 100.0% | 100.0% |
That is why "top 10 by frequency" is often too short for PPO analysis. It captures the hygiene-heavy part of the mix, but it can underweight crowns, core buildups, perio, and implants. The safest article language is: "Analyze enough top codes to cover most of both your PPO procedure volume and your PPO submitted dollars." Confidence: well-supported for the logic, weak for naming one exact count. citeturn54view0turn14view1
## data inputs, PMS pulls, and key definitions
The public record does not clearly identify the exact PMS report names that Unlock "typically requests." I did not find a public primary source from Unlock that names that pullset. The best verified proxy is the report set below, mapped to public PMS documentation from Open Dental. Joey should confirm the exact vendor-specific names before publication. Confidence: weak on the literal "Unlock requests X" claim, well-supported on the underlying data elements. fileciteturn0file0L15-L19 citeturn54view0turn14view0turn14view1turn14view2turn55view0turn54view2turn43view2
The most useful PMS pullset is:
| purpose | public Open Dental equivalent | key fields documented | export notes | publication use |
|---|---|---|---|---|
| identify top codes | Daily Procedures Report, grouped by procedure code | code, description, quantity, average fee, total fees | page documents report fields; export type not specified on this page | rank codes and build weights |
| pull office/UCR fees | Procedure Codes - Fee Schedules Report | code, description, fee | page says print or export procedure codes and fees | office-fee baseline |
| pull PPO allowed fee schedule | Fee Schedules plus Procedure Codes - Fee Schedules Report | fee-schedule type, code, fee | fee tools support fee export to txt | carrier or network allowed table |
| measure write-offs | PPO Write-offs Report | standard fees, PPO fees, write-offs, by claim or by carrier | report preview page documents filters and fields | validate contract pressure |
| reconcile production and write-off timing | Production and Income Report, Net Production Detail Daily Report | production, write-off, UCR, original write-off estimate, estimate-vs-actual write-off, net production | report pages document timing logic | choose accrual basis |
| map plan structure | Insurance Plans Report | carrier name, subscriber name, carrier phone, group name | report preview page documents fields | tell carrier from plan |
| clean pending EOBs | Unfinalized Insurance Payments Report | type, patient, carrier, clinic, date, DOS, amount | explicitly exports to .txt or .xls | improve data hygiene |
The table above is grounded in public report documentation: the Daily Procedures Report lists completed procedures and can group them by procedure code with quantity, average fee, and total fees; the fee-schedule report prints or exports code-level fees; the PPO Write-offs Report compares standard fees, PPO fees, and write-offs; the Production and Income and Net Production reports document write-off timing; the Insurance Plans Report documents carrier and group-level fields; and the Unfinalized Insurance Payments Report documents .txt/.xls export. citeturn54view0turn14view0turn14view2turn14view1turn54view1turn55view0turn54view2turn43view2
The definitions below are the clearest public working definitions available from the reviewed sources:
| term | working definition for the article | best public source | confidence |
|---|---|---|---|
| office fee | the practice's own base fee, often its UCR or "Office Fees" schedule | Open Dental documents a UCR or Office fee schedule and even labels a fee-tool video "Updating Your UCR (Office) Fees." citeturn43view2turn43view1 | well-supported |
| master fee | not standardized in the sources reviewed; safest use is to define it locally as the practice's base office/UCR fee schedule, if Joey wants to use the term at all | Open Dental standardizes "fee schedule," "global fee," and UCR/Office fees, not "master fee." citeturn43view1turn42view1 | weak |
| UCR fee | "usual, customary, and reasonable" fee, used as the office's standard fee schedule for many internal comparisons | Open Dental says offices typically create fee schedules for UCR fees. HealthCare.gov separately defines UCR as an amount based on what providers in an area usually charge for similar services. citeturn43view1turn62search0 | moderate |
| contracted fee | the in-network fee schedule the practice agreed to under a PPO contract | Open Dental defines a Normal fee-schedule type as an "in-network contracted fee schedule." citeturn43view1 | well-supported |
| allowed amount | the maximum a plan will pay for a covered service; may also be called eligible expense, payment allowance, or negotiated rate | HealthCare.gov glossary. citeturn5view0 | well-supported |
| submitted fee | the fee actually billed on the patient's account or claim, based on the fee-schedule logic in use | Open Dental documents that the fee billed is determined by fee-schedule logic, and the Daily Procedures Report labels fee as the procedure amount billed to the patient's account. citeturn43view0turn54view0 | well-supported |
| write-off | the contractual reduction between the practice's standard fee and the PPO fee, tracked as a PPO write-off | Open Dental's PPO Write-offs Report lists standard fees, PPO fees, and write-off amounts; Production and Income reports subtract PPO write-offs from production. citeturn14view2turn14view1 | well-supported |
One detail matters more than it looks: if the office's posted "office fee" and its actual submitted fee are not the same, use the submitted fee as the revenue ceiling in the model. Open Dental's fee-schedule logic shows that the fee billed can come from different fee schedules depending on plan type and settings, while the insurance plan fee schedule may be used for write-off calculations instead of billing. citeturn43view0
## weighted calculation method
The method should be reproducible in a spreadsheet. Use one row per CDT code, one plan at a time, using a consistent trailing-12-month dataset, and keep the date basis consistent. Open Dental explicitly warns that write-offs can be applied by insurance payment date, procedure date, or an initial-claim-date estimate with later adjustment. If the article shows annual impact, it should tell readers to use one timing rule consistently for all compared plans. citeturn14view1turn54view1
The core formulas are simple:
```text
submitted_revenue_i = submitted_fee_i × frequency_i
allowed_revenue_i = PPO_allowed_i × frequency_i
writeoff_i = (submitted_fee_i - PPO_allowed_i) × frequency_i
weighted_allowed_ratio
= Σ(frequency_i × PPO_allowed_i) / Σ(frequency_i × submitted_fee_i)
weighted_writeoff_ratio
= Σ(writeoff_i) / Σ(submitted_revenue_i)
annual_delta_between_PPO_B_and_PPO_A
= Σ[(allowed_B_i - allowed_A_i) × frequency_i]
```
If the plan has provider-specific or clinic-specific fee tiers, keep separate rows or separate fee tables for the affected provider or clinic. Open Dental documents provider and clinic overrides and even gives PPO examples where providers can have different in-network fee tiers. citeturn42view1turn43view1
A clean workflow looks like this:
```mermaid
flowchart TD
A[Pull completed procedures for trailing 12 months] --> B[Group by CDT code]
B --> C[Sort by frequency and total submitted dollars]
C --> D[Choose top codes until coverage thresholds are met]
D --> E[Pull office or submitted fees]
E --> F[Pull PPO allowed amounts by plan or network]
F --> G[Normalize code year and provider or clinic overrides]
G --> H[Calculate per-code delta and annual write-off]
H --> I[Compute weighted allowed ratio]
I --> J[Compare PPO A vs PPO B]
J --> K[Review non-fee contract terms separately]
```
The supporting PMS reports are all public: grouped Daily Procedures for quantity and billed totals, Fee Schedules for fee tables, PPO Write-offs for reconciliation, and Production and Income for date handling. citeturn54view0turn14view0turn14view2turn14view1
A worked synthetic example, still small enough for a reader to check by hand:
| code | description | freq | submitted_fee | ppo_allowed | delta_per_case | annual_impact |
|:---|:---|---:|---:|---:|---:|---:|
| D1110 | Adult prophylaxis | 720 | 125 | 88 | 37 | 26640 |
| D2391 | Posterior resin, one surface | 210 | 215 | 132 | 83 | 17430 |
| D2740 | Crown porcelain/ceramic | 96 | 1450 | 940 | 510 | 48960 |
| D4341 | Perio scaling/root planing 4+ teeth/quadrant | 58 | 365 | 228 | 137 | 7946 |
In that four-code example, annual submitted fees are $295,520 and annual PPO allowed fees are $194,544, so the weighted allowed ratio is 65.8 percent. The crown line matters much more to annual impact than a simple per-code average suggests because each crown carries a much larger dollar delta. That is the entire reason to weight the analysis. If the article wants one sentence version: "Average the dollars, not the codes."
## example datasets and reproducible templates
The datasets below are synthetic and anonymized. They are meant to show structure, formulas, and reproducibility, not benchmark market fees.
### small-practice synthetic example
| code | freq | office_fee | submitted_fee | allowed_A | writeoff_per_case_A | annual_writeoff_A |
|:-------|-------:|-------------:|----------------:|------------:|----------------------:|--------------------:|
| D1110 | 720 | 125 | 125 | 88 | 37 | 26640 |
| D0120 | 680 | 72 | 72 | 52 | 20 | 13600 |
| D0274 | 640 | 95 | 95 | 61 | 34 | 21760 |
| D2391 | 210 | 215 | 215 | 132 | 83 | 17430 |
| D2392 | 185 | 265 | 265 | 161 | 104 | 19240 |
| D2740 | 96 | 1450 | 1450 | 940 | 510 | 48960 |
| D2950 | 70 | 395 | 395 | 252 | 143 | 10010 |
| D7140 | 62 | 315 | 315 | 190 | 125 | 7750 |
| D4341 | 58 | 365 | 365 | 228 | 137 | 7946 |
| D0210 | 52 | 195 | 195 | 123 | 72 | 3744 |
| D0220 | 145 | 39 | 39 | 24 | 15 | 2175 |
| D0150 | 120 | 110 | 110 | 69 | 41 | 4920 |
**summary for PPO A**
| metric | value |
|:-------------------------|--------:|
| Selected codes | 12 |
| Total annual frequency | 3038 |
| Annual submitted fees | 530480 |
| Annual PPO allowed A | 346305 |
| Annual write-off A | 184175 |
| Weighted allowed ratio A | 65.3 |
| Annual PPO allowed B | 360521 |
| Annual write-off B | 169959 |
| Weighted allowed ratio B | 68.0 |
| Annual gain of B vs A | 14216 |
A CSV-ready version of the same synthetic dataset:
```csv
code,freq,office_fee,submitted_fee,allowed_A,writeoff_per_case_A,annual_writeoff_A
D1110,720,125,125,88,37,26640
D0120,680,72,72,52,20,13600
D0274,640,95,95,61,34,21760
D2391,210,215,215,132,83,17430
D2392,185,265,265,161,104,19240
D2740,96,1450,1450,940,510,48960
D2950,70,395,395,252,143,10010
D7140,62,315,315,190,125,7750
D4341,58,365,365,228,137,7946
D0210,52,195,195,123,72,3744
D0220,145,39,39,24,15,2175
D0150,120,110,110,69,41,4920
```
### large-practice synthetic example
| code | freq | office_fee | submitted_fee | allowed_A | writeoff_per_case_A | annual_writeoff_A |
|:-------|-------:|-------------:|----------------:|------------:|----------------------:|--------------------:|
| D1110 | 4200 | 130 | 130 | 92 | 38 | 159600 |
| D0120 | 3900 | 75 | 75 | 54 | 21 | 81900 |
| D0274 | 3600 | 98 | 98 | 64 | 34 | 122400 |
| D0150 | 950 | 115 | 115 | 72 | 43 | 40850 |
| D0210 | 620 | 205 | 205 | 128 | 77 | 47740 |
| D0220 | 1100 | 41 | 41 | 25 | 16 | 17600 |
| D0230 | 950 | 34 | 34 | 21 | 13 | 12350 |
| D0330 | 540 | 165 | 165 | 101 | 64 | 34560 |
| D2391 | 1200 | 220 | 220 | 136 | 84 | 100800 |
| D2392 | 980 | 270 | 270 | 165 | 105 | 102900 |
| D2393 | 780 | 325 | 325 | 198 | 127 | 99060 |
| D2740 | 430 | 1490 | 1490 | 965 | 525 | 225750 |
| D2950 | 300 | 405 | 405 | 258 | 147 | 44100 |
| D4341 | 420 | 375 | 375 | 235 | 140 | 58800 |
| D4342 | 180 | 285 | 285 | 182 | 103 | 18540 |
| D4910 | 1350 | 165 | 165 | 106 | 59 | 79650 |
| D7140 | 260 | 325 | 325 | 196 | 129 | 33540 |
| D2750 | 120 | 1515 | 1515 | 980 | 535 | 64200 |
| D2330 | 310 | 225 | 225 | 140 | 85 | 26350 |
| D2394 | 210 | 385 | 385 | 232 | 153 | 32130 |
| D6010 | 72 | 2350 | 2350 | 1480 | 870 | 62640 |
| D6058 | 68 | 1675 | 1675 | 1105 | 570 | 38760 |
**summary for PPO A**
| metric | value |
|:-------------------------|-----------------:|
| Selected codes | 22 |
| Total annual frequency | 22540 |
| Annual submitted fees | 4270000 |
| Annual PPO allowed A | 2765780 |
| Annual write-off A | 1504220 |
| Weighted allowed ratio A | 64.8 |
| Annual PPO allowed B | 2902460 |
| Annual write-off B | 1367540 |
| Weighted allowed ratio B | 68.0 |
| Annual gain of B vs A | 136680 |
A CSV-ready version of the large synthetic dataset:
```csv
code,freq,office_fee,submitted_fee,allowed_A,writeoff_per_case_A,annual_writeoff_A
D1110,4200,130,130,92,38,159600
D0120,3900,75,75,54,21,81900
D0274,3600,98,98,64,34,122400
D0150,950,115,115,72,43,40850
D0210,620,205,205,128,77,47740
D0220,1100,41,41,25,16,17600
D0230,950,34,34,21,13,12350
D0330,540,165,165,101,64,34560
D2391,1200,220,220,136,84,100800
D2392,980,270,270,165,105,102900
D2393,780,325,325,198,127,99060
D2740,430,1490,1490,965,525,225750
D2950,300,405,405,258,147,44100
D4341,420,375,375,235,140,58800
D4342,180,285,285,182,103,18540
D4910,1350,165,165,106,59,79650
D7140,260,325,325,196,129,33540
D2750,120,1515,1515,980,535,64200
D2330,310,225,225,140,85,26350
D2394,210,385,385,232,153,32130
D6010,72,2350,2350,1480,870,62640
D6058,68,1675,1675,1105,570,38760
```
## comparing carrier, network, employer plan, or TPA and comparing two PPO offers
Public PMS logic supports a simple rule: analyze first at the level where the fee schedule actually changes, then roll up to carrier totals later. Open Dental documents that insurance-plan fee schedules drive write-off calculations and that reports can group write-offs by carrier. That means carrier-level reporting is useful, but it can blur plan-level or network-level differences. citeturn43view0turn14view2turn55view0
The most defensible workflow is:
| analysis level | when it is the right first cut | advantage | risk | recommendation |
|---|---|---|---|---|
| carrier | one carrier uses one fee schedule across most patients | fast management view | can hide multiple plan tables under one label | use as summary, not first pass |
| network or contracted fee schedule | several employer plans are paying on the same lease or PPO table | closest to the actual reimbursement table | requires better contract mapping | best first cut |
| employer plan | one self-funded group has unusual utilization or exceptions | captures real patient mix | can explode into too many slices | use only when it changes the economics |
| TPA or leased network | claims are repriced through a rental network or administrator | finds "same table, different logo" situations | often hard to map publicly | use when the contract structure makes it material |
The plan-level point is grounded in public fee-schedule logic. The TPA and leased-network layer is an operational inference, and it should be worded that way unless Joey has direct contract evidence for a named carrier. Confidence: moderate for the plan-first recommendation, weak for any blanket TPA generalization. citeturn43view0turn14view2turn55view0
A practical side-by-side comparison template for two PPO offers:
| code | annual freq | submitted fee | PPO A allowed | PPO B allowed | per-case delta B-A | annual delta B-A | note |
|---|---:|---:|---:|---:|---:|---:|---|
| D1110 | 720 | 125 | 88 | 88 | 0 | 0 | hygiene anchor |
| D2391 | 210 | 215 | 132 | 140 | 8 | 1,680 | modest restorative lift |
| D2392 | 185 | 265 | 161 | 171 | 10 | 1,850 | |
| D2740 | 96 | 1,450 | 940 | 995 | 55 | 5,280 | high-dollar driver |
| D4341 | 58 | 365 | 228 | 246 | 18 | 1,044 | perio sensitive |
| ... | ... | ... | ... | ... | ... | ... | ... |
| **total** | 3,038 | 530,480 | weighted 65.3% | weighted 68.0% | | **14,216** | synthetic example |
That table makes the decision visible. If PPO B only adds money on low-frequency codes, the annual delta will stay small even if a handful of code-level percentages look better on paper. If it raises crowns, core buildups, SRP, and common restorative codes, the annual gain appears quickly in the weighted total.
Decision criteria should stay concrete:
| criterion | what to look at | why it matters |
|---|---|---|
| weighted allowed ratio | total allowed divided by total submitted for selected codes | overall reimbursement pressure |
| annual delta | sum of per-code frequency-weighted differences | expected dollar upside or downside |
| concentration risk | percent of total delta driven by top 3 codes | avoids overreacting to one code |
| provider or clinic tiering | specialist or location overrides | some contracts vary by provider or clinic |
| timing basis | DOS vs payment-date treatment of write-offs | affects annual trend comparisons |
| non-fee terms | frequency limits, downgrades, recoupment terms, credentialing, termination provisions | fee schedules are not the whole contract |
That last row is an inference, but an important one. The public fee-schedule sources reviewed here document code and fee structure, not the full benefit design or operational contract terms. Article prose should say exactly that, rather than implying that a fee sheet alone answers every contracting question. citeturn14view0turn43view1
## legal and state-specific cautions
The basic antitrust rule is plain. Section 1 of the Sherman Act declares illegal every contract, combination, or conspiracy in restraint of trade. Section 5 of the FTC Act separately declares unfair methods of competition unlawful. For an article aimed at dentists, the practical translation is simple: do not recommend sharing actual competitor fees, future fee intentions, or pooled current pricing data with rival practices as a negotiation tactic. citeturn50view0turn51view0
That caution is not theoretical. Federal enforcers are also scrutinizing common pricing tools that combine competitors' nonpublic data. In 2025 the DOJ backed providers' challenge to MultiPlan's pricing software, arguing that common use of a pricing algorithm can violate antitrust law, and in 2026 legal analysis of active enforcement highlighted agency concern about common algorithms and the exchange or use of competitively sensitive pricing information. Those examples are not dental-specific, but they reinforce why peer reimbursement benchmarking and shared fee discussions are risky territory. citeturn24news2turn52news1
Dentistry has its own directly relevant antitrust warning. In *North Carolina State Board of Dental Examiners v. FTC*, the Supreme Court held that when a controlling number of a state board's decisionmakers are active market participants, state-action immunity requires active state supervision. That case involved the dental market specifically. For article purposes, the clean implication is that "other dentists do it" or "the board says so" is not a safe shortcut for antitrust analysis. citeturn39search0
State-specific contract rules vary too much to make 50-state claims without a separate legal survey. The article should tell readers to verify local rules on at least five issues before acting on a fee analysis: non-covered services, leased or silent PPO protections, all-products clauses, termination notice rules, and prompt-pay or recoupment statutes. Confidence: high that these are common legal flashpoints, low for any state-by-state statement in this report because a current 50-state primary-source survey was not completed here.
## source-quality review and publication questions for Joey
The strongest claims for publication are these:
| claim | confidence | why |
|---|---|---|
| A weighted fee-schedule model should use the practice's own code frequencies and billed dollars | well-supported | public PMS reports already expose code, quantity, average fee, total fees, fee schedules, and write-offs citeturn54view0turn14view0turn14view2 |
| Allowed amount means the maximum the plan will pay for a covered service | well-supported | HealthCare.gov glossary definition citeturn5view0 |
| Contracted fee schedule means the in-network fee schedule | well-supported | Open Dental fee-schedule type definition citeturn43view1 |
| Billed or submitted fee may differ from the insurance fee schedule used to calculate write-offs | well-supported | Open Dental fee-schedule logic citeturn43view0 |
| Write-off timing must be handled consistently in annual analysis | well-supported | Production and Income and Net Production docs citeturn14view1turn54view1 |
| Competitor fee sharing and benchmarking need antitrust caution | well-supported | Sherman Act, FTC Act, current enforcement examples, and the dental board case citeturn50view0turn51view0turn24news2turn39search0 |
The weaker claims are these:
| claim | confidence | publication advice |
|---|---|---|
| "Analyze exactly X top codes" | weak | present as a heuristic and use coverage thresholds instead |
| "Unlock typically requests these exact report names" | weak | say "a likely PMS pullset" unless Joey confirms the literal names |
| "PPO fees can be negotiated" | weak | avoid universal wording; say contract amendment paths vary by carrier and agreement |
| "This carrier pays poorly" | weak | only say it after a practice-specific weighted model and contract review |
The claims to avoid or heavily qualify are these, which align with the handoff's own flagged risk areas:
| claim | confidence | publication advice |
|---|---|---|
| "This PPO is unprofitable" from fee schedule alone | avoid | profitability needs cost and operations data, not just reimbursement fileciteturn0file0L45-L58 |
| "Drop this PPO" | avoid | too fact-specific and contract-specific |
| Peer fee benchmarking against rival local dentists | avoid | antitrust risk |
| Carrier-specific reimbursement rankings presented as market truth | avoid | highly variable by plan, geography, and contract year |
The most useful source register for the article is short and clean:
| source | publisher | date | best use |
|---|---|---|---|
| Allowed amount glossary citeturn5view0 | HealthCare.gov / CMS | undated page, accessed June 25, 2026 | allowed amount definition |
| Daily Procedures Report citeturn54view0 | Open Dental | undated manual page, accessed June 25, 2026 | top-code counts and billed-fee fields |
| Procedure Codes - Fee Schedules Report citeturn14view0 | Open Dental | undated manual page, accessed June 25, 2026 | fee schedule extraction |
| Fee Schedules and Fee Schedule Logic citeturn43view1turn43view0 | Open Dental | undated manual pages, accessed June 25, 2026 | office fee, contracted fee, billed-fee logic |
| PPO Write-offs Report citeturn14view2 | Open Dental | undated manual page, accessed June 25, 2026 | standard fee vs PPO fee vs write-off |
| Production and Income, Net Production Detail Daily citeturn14view1turn54view1 | Open Dental | undated manual pages, accessed June 25, 2026 | write-off timing and net production logic |
| 15 U.S.C. § 1 and 15 U.S.C. § 45 citeturn50view0turn51view0 | Cornell LII, U.S. Code text | current code text, accessed June 25, 2026 | antitrust baseline |
| DOJ support in MultiPlan pricing case citeturn24news2 | Reuters | March 27, 2025 | current enforcement context |
| North Carolina State Board of Dental Examiners v. FTC summary and holding citeturn39search0 | search summary of Supreme Court case | accessed June 25, 2026 | dentistry-specific antitrust caution |
Before publication, Joey should answer these questions from practice experience, because public sources do not answer them cleanly:
- Which PMS platforms make up most of Unlock's client base, and what are the exact report names in each one?
- Does Unlock want top codes ranked by completed procedures, submitted charges, or paid claims?
- When an office says "office fee," does Unlock mean posted UCR fee, currently submitted fee, or provider-specific billed fee?
- Does Unlock prefer a stopping rule based on code count, cumulative procedure count, cumulative submitted dollars, or a mix?
- Does Unlock want plan-level slicing, network-level slicing, or carrier-level rollups as the default deliverable?
- Does Unlock include only contractual write-off pressure, or also chair-time and variable-cost overlays, in later negotiation work?
The cleanest concrete ending for the published article is also the safest one: start with the grouped procedure-code report, because Open Dental's public documentation already shows the exact first-pass fields you need, code, quantity, average fee, and total fees. citeturn54view0