問題文
A distributor rolls revenue up to the ultimate parent of each corporate group. The group structure is maintained in an external company data source, but sales users have been editing the parent field directly, and the rolled up totals no longer agree with that source. Which design keeps the hierarchy correct for every consumer?
選択肢
- Lock the parent field so that no one can change it, and record any correction that a user proposes in a note on the account record so that the reporting team can adjust the totals by hand each quarter.
- Treat the external source as authoritative for the structure, refresh the parent relationship from it on a schedule, and route a user who spots an error through a request that corrects the external source first.
- Keep the structure only in the reporting layer and remove the parent relationship from the object altogether, because the hierarchy is needed for totals rather than for daily work, and a structure held in one place cannot diverge from the external source at all.
- Let the users keep editing the parent field and compare the two structures once a month, reconciling the differences by hand and adjusting whichever side looks wrong at the time.