| Gliffy | ||
|---|---|---|
|
This part of the data model is newly normalized in the wake of a previous scheme, which copied the DSP Group to the User record as an attribute. Currently we import user and org data from canonical sources and endeavor not to extend the user object (or other imported objects) to implement business logic.
Business logic can usually be implemented in business rules, UI Actions, script includes, scheduled jobs, and other code. This can make end user reporting more difficult, but building reporting structure on top of a primarily transactional database is not a good idea, precisely because it encourages denormalization and introduces complexity and the potential for confusion about what data to use (imagine 3 fields in different tables all representing the same object type but with different logic).
We already warehouse data with third parties for reporting purposes, so any attempt to denormalize transactional tables purely for reporting purposes is discouraged.