12.3.1 Templates as Lookup Data for Model Execution
Templates serve as dynamic reference data sources that models use during execution. Instead of embedding static or hardcoded values, models retrieve required inputs directly from configured templates.
- Read sandbox data
- Perform calculations
- Store results in sandbox tables
By externalizing reference values into templates, model logic remains flexible, reusable, and configuration-driven.
- Rating is sourced from a maintained hierarchy
- Risk Weight is defined as a custom Cartesian column within the template
Rather than hardcoding these values, the model dynamically queries the template at runtime. Templates can also store scalar parameters, execution flags, and other configurable inputs required for processing.
The template name acts as a logical placeholder within the model. Multiple templates may share the same structural design but contain different data values. At runtime, users select the appropriate template, allowing the same model to execute with different configurations without any code changes.