To populate the ‘S.19.01.01.LISTV’ input layer within return you should select S.19.01.01 single list input layer checkbox on Return Setup in the Company tab.

Selecting this checkbox will add S.19.01.01.LISTV sheet into the annual return workbook and exclude ALL S.19.01.01 QRTs that would otherwise be included in the return.
This option entails a single QRT worksheet (instead of the multiple S.19.01.01 QRTs, per LoB/currency) in the annual workbook, with three columns: QRT; datapoint; and value. Each record in this list should represent an S.19.01.01 QRT datapoint.

Note: This feature is only available in annual returns.

All existing validations have been programmed to also run on the S.19.01.01 list QRT – there is no loss of validation coverage in using this option. Further, other QRTs that bring in the data from S.19.01.01 (via “interactions” formulas) utilize this list instead eg. the SFCR P.19.01.01 QRT is populated from the S.19.01.01 list QRT.

Note: If a user adds a QRT in S.19.01.01.LISTV that is not one of the LoB and currency combinations selected in the Return Setup screen then:
- validations will flag a blocking error
- this data will NOT be exported to the QRT layout file

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment