Are formula scores stored in the scores table?

The assertion that formula scores are not stored in the scores table is correct because the scores table is designed to hold specific types of scores derived from assessments or evaluations that have been explicitly calculated and recorded, rather than derived scores generated from formulas. Formula scores are typically dynamic, often recalculated based on underlying data whenever needed, making them not suited for permanent storage in the same way as static scores originating from completed assessments.

This architecture allows for agility and accuracy in data management and reporting, as formula scores may change with modifications in the underlying data or criteria. Consequently, these scores are not retained in the scores table as this storage format focuses on fixed, individual assessment results, ensuring that true captured performance metrics are accessible while maintaining system efficiency.