{"id":4745,"date":"2019-07-01T18:12:30","date_gmt":"2019-07-01T17:12:30","guid":{"rendered":"https:\/\/singlepensionscheme.gov.ie\/?page_id=4745"},"modified":"2023-01-06T15:15:56","modified_gmt":"2023-01-06T15:15:56","slug":"templates","status":"publish","type":"page","link":"https:\/\/singlepensionscheme.gov.ie\/ga\/databank\/employers\/resources\/templates\/","title":{"rendered":"Databank Scheme File Templates & Quality Assurance"},"content":{"rendered":"

<\/p>\n

<\/a>Databank Scheme File Templates<\/strong><\/span><\/h1>\n
\n

Three separate Scheme Files<\/strong> must be submitted in respect of each Relevant Authority<\/strong> for each Scheme Year.
\n<\/strong>These Scheme File templates are available in the table immediately below:<\/p>\n

 <\/p>\n\n\n\n\n\t\n\n\t\n\t\n\t
Name<\/th>Descriptor<\/th>Type<\/th>\n<\/tr>\n<\/thead>\n
1. Membership Data Scheme File Template<\/a><\/td>Scheme File Template<\/a><\/td>\"Microsoft<\/a><\/td>\n<\/tr>\n
2. Benefits Payment Data Scheme File Template<\/a><\/td>Scheme File Template<\/a><\/td>\"Microsoft<\/td>\n<\/tr>\n
3. Purchase Transfer Data Scheme File Template<\/a><\/td>Scheme File Template<\/a><\/td>\"Microsoft<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n

Additional template guidance resources are also available below.<\/p>\n

Only authorised administrators may submit completed templates to the Databank, using the DGVT application, once local quality assurance checks have been completed on each file (see below).<\/span><\/strong><\/p>\n

Please note: where a Relevant Authority has zero Single Scheme members\/pensioners\/purchase of additional retirement benefits for a particular Scheme Year, a \u201cnil return\u201d must still be made for the Scheme Years in question.<\/p>\n

 <\/p>\n

<\/a>Quality Assurance – Prior to submitting data to the Databank<\/strong><\/span><\/h1>\n
\n

Context<\/strong>: In advance of submitting a Scheme File to the Databank, you should ensure that you have completed robust quality assurance on your data. The suggested quality assurance checklists have been developed to assist administrators with completing quality assurance on their data. Organisations are free to develop their own QA checklists or to amend these resources as they see fit.<\/span><\/p>\n

Important:<\/span>\u00a0<\/strong>Each Relevant Authority remains legally accountable for the administration of the Single Scheme in respect of its members, including the quality of the data maintained for its members that, in turn, is submitted to the Single Scheme Databank.<\/em><\/p>\n

 <\/p>\n\n\n\n\n\t\n\n\t\n\t\n\t
Name<\/th>Descriptor<\/th>Type<\/th>\n<\/tr>\n<\/thead>\n
1. Irish Membership Data QA Checklist<\/a><\/td>Irish QA Checklist<\/a><\/td>\"Microsoft<\/a><\/td>\n<\/tr>\n
2. Irish Benefits Payment Data QA Checklist<\/a><\/td>Irish QA Checklist<\/a><\/td>\"Microsoft<\/a><\/td>\n<\/tr>\n
3. Purchase Transfer Data QA Checklist<\/a><\/td>QA Checklist<\/a><\/td>\"Microsoft<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n

 <\/p>\n

<\/a>Additional Template Guidance<\/strong><\/span><\/h1>\n
\n

The above Scheme File Templates should be read in conjunction with the following resources:<\/p>\n

 <\/p>\n\n\n\n\n\t\n\n\t\n\t\n\t\n\t
Name<\/th>Descriptor<\/th>Type<\/th>\n<\/tr>\n<\/thead>\n
4. Single Scheme Databank Template Descriptions Document <\/a><\/td> Template Guidelines<\/a><\/td>\"PDF<\/td>\n<\/tr>\n
5. Membership Data \u2013 Quick Reference Sheet & Sample Data<\/a><\/td>Quick Reference Sheet<\/a><\/td>\"Microsoft<\/a><\/td>\n<\/tr>\n
6. Benefits Payment Data Template \u2013 Quick Reference Sheet & Sample Data<\/a><\/td>Quick Reference Sheet<\/a><\/td>\"Microsoft<\/td>\n<\/tr>\n
7. Purchase Transfer Data Scheme \u2013 Quick Reference Sheet & Sample Data<\/a><\/td>Quick Reference Sheet<\/a><\/td>\"Microsoft<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n

Additional supports to assist administrators in accurately preparing and uploading completed Scheme Files are available in the Databank Training Resources section.<\/span><\/span><\/a><\/p>","protected":false},"excerpt":{"rendered":"

Databank Scheme File Templates Three separate Scheme Files must be submitted in respect of each Relevant Authority for each Scheme …<\/p>\n","protected":false},"author":8,"featured_media":0,"parent":4727,"menu_order":20,"comment_status":"closed","ping_status":"closed","template":"content-template.php","meta":[],"categories":[10],"tags":[22],"acf":[],"_links":{"self":[{"href":"https:\/\/singlepensionscheme.gov.ie\/ga\/wp-json\/wp\/v2\/pages\/4745"}],"collection":[{"href":"https:\/\/singlepensionscheme.gov.ie\/ga\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/singlepensionscheme.gov.ie\/ga\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/singlepensionscheme.gov.ie\/ga\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/singlepensionscheme.gov.ie\/ga\/wp-json\/wp\/v2\/comments?post=4745"}],"version-history":[{"count":36,"href":"https:\/\/singlepensionscheme.gov.ie\/ga\/wp-json\/wp\/v2\/pages\/4745\/revisions"}],"predecessor-version":[{"id":7262,"href":"https:\/\/singlepensionscheme.gov.ie\/ga\/wp-json\/wp\/v2\/pages\/4745\/revisions\/7262"}],"up":[{"embeddable":true,"href":"https:\/\/singlepensionscheme.gov.ie\/ga\/wp-json\/wp\/v2\/pages\/4727"}],"wp:attachment":[{"href":"https:\/\/singlepensionscheme.gov.ie\/ga\/wp-json\/wp\/v2\/media?parent=4745"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/singlepensionscheme.gov.ie\/ga\/wp-json\/wp\/v2\/categories?post=4745"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/singlepensionscheme.gov.ie\/ga\/wp-json\/wp\/v2\/tags?post=4745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}