added filter scopes to column listings
added schema for pivot tables