Summary

A developer asks: We have a class group that has several individual classes (work types in one work pool). Some columns we want to expose for some work types are not present in other work types.

Can we specify separate, distinct Data-Admin-DB-Table definitions for each individual class?

Suggested Approach

This is not possible, by definition of class group.

The purpose a of class group is to group the individual member classes into one shared database table.  One Data-Admin-DB-Table, therefore, maps the entire class group; you can't place member classes into distinct tables.

This design simplifies access for reporting and searching across work types, and allows a work object initially created in one work type to be updated into another work type.

For example, a mail room intake process may create very generic work objects by scanning images from arriving mail. Upon more detailed human review of the scanned images, the work objects may be assigned more specific work type (Accounts Recievable, Customer Complaint, and so on) based on the document content. Both the generic work objects and all the specific work objects are saved in a single table.