The main data model is responsible for finding the relevant performance documents, calculating questionnaire scores, combining those scores with overall summary ratings, and deriving the final tier description. The query starts by identifying recently updated evaluations so that the process only works on records that changed within the configured time window. This is useful for … Continue reading SQL to calculate the final rating score and produce HDL-ready columns