schema and other changes needed to properly support state legislators