SCR – SII Data Model

There are three types of tables (sheets) within the Tabular Sii model:
- model entry
This is the inputs (from these inputs the Standard Formula calculations and the transformation into QRT data are performed)

- SCR calculations
These are always calculated tables. They show the SCR calculation results (based on the input data)

- QRTs
These are mostly calculated tables but in some cases a QRT is not included in the model and these QRTs must be manually entered into

In general, data is only entered into the “model entry” sheets and then the Sii Model Refresh button is used to run the processing/calculations on this data; the results being loaded to the SCR calculation sheets (read-only) and the QRTs.

Note:
- the specific set of tables/sheets generated to any specific return depends on the Company metadata entered into the Return Setup area e.g. if life business is set as the insurer type then the model entry, SCR and QRTs relating to non-life insurance will not be set for inclusion
- it is possible to combine all three types in the same return or to split these out into different return workbooks (this may be preferable to reduce the workbook sizes into more manageable smaller workbooks)