Dental Record (DNT) — Untreated Decay and Caries Experience field labels are swapped in Query Builder, Database Definitions, and Update Code
When viewing DNT data in Query Builder, the column labeled "Untreated Decay" displays values that were entered as Caries Experience, and the column labeled "Caries Experience" displays values entered as Untreated Decay — the opposite of what was typed into the Dental form. The same reversed labels appear in Database Definitions and the Update Code Table field dropdown for the DNT table. The Dental data entry form and printed Student Dental Record display correctly, but the mismatch in Query Builder and related tools makes it difficult to trust query output or verify data for the DNT.VF and DNT.VC fields. We would like the field labels for Untreated Decay (VC) and Caries Experience (VF) corrected to match actual data storage so that all tools — Query Builder, Database Definitions, and Update Code Table — display consistent and accurate field names.
AdminMarie Cullens
(Senior Business Analyst, Aeries Software)
shared this idea
