add a test of parent id resolution
use prepare_for_db to resolve parent id on orgs