Computed_AncestorStatus Table

The Computed_AncestorStatus table tracks the common-ancestor computation status for each kit — when it was last computed, how many matches were processed, and how many ancestors were found. The application uses it to show whether a kit’s cached results are up to date and to decide which kits still need computation.

Column Reference

Column	Type	Description
Id	int (PK)	Auto-incrementing primary key
KitGuid	string	The DNA kit this status applies to
Company	string	Which service the kit belongs to
MatchLevel	int	The name-matching strictness level used for the run
LastComputeDate	DateTime	When the computation last ran (UTC)
MatchesProcessed	int	How many matches were processed in the run
AncestorsFound	int	Total number of common ancestors found across all matches

How It’s Populated

After the common-ancestor compute service finishes (or is cancelled) for a kit, it upserts a status row — deleting any prior row for the KitGuid and inserting a new one with LastComputeDate set to the current UTC time, along with the final MatchesProcessed and AncestorsFound totals. The application reads these rows to determine which kits need (re)computation.

Related Tables

• Computed_CommonAncestors — the per-match common-ancestor rows produced by the same compute run this status summarizes.
• Kit_TreeAssignment — the assigned tree whose comparison this run computed; kits with an assignment but no current status still need computation.