Foreign key orphan audit
Locate references to nonexistent parent records before merging tables.
Your entries stay in this page’s memory and are not submitted to us. Downloads are generated locally. Reloading or leaving the page clears your entries. Do not enter patient information.
The starting values are hypothetical. Use aggregate or synthetic inputs only.
Calculation results
- Orphan references
- 2
- Distinct missing parent keys
- G3
- Matched references
- 1
How to interpret the output
Parent identifiers must be unique. Child references may repeat. Compare exact keys after trimming surrounding whitespace. A missing parent may be a coverage or extraction issue. Resolve it before dropping unmatched rows.
Method reference