Disabled child plan

Kyle -
In my testing of parent/child Plans, I confirm that, when a Parent subscription expires, any unexpired Child plans are not visible (e.g. disabled) on the Membership tab in the profile.

However, in the database, specifically the #__cbsubs_subscriptions table, the child plan is still set as Active (status = 'A')

For reporting purposes, I need to identify child Plans of expired parent Plans.
Where is that data element stored?
Thanks,
Fred
 

Child plans don't expire until they reach their own expiration date, but are functionally disabled. That's working as intended.

As for how they relate to each other that's entirely though the parent_plan and parent_subscription columns.