Microsoft Access database tool for collating data for submission to the Mental Health Services Data Set (MHSDS).
The tool can be populated with the relevant data and submitted to the landing platform.
The structure of the Intermediate Database tool (IDB) must not be altered in any way. All tables must be present, even if some are not appropriate to the submission (based on the activity that has taken place). All fields listed in each table must also be present and the field types must be exactly as specified.
The data items required to populate the MHSDS IDB should be extracted directly from the appropriate service provider systems, such as a clinical system or Patient Administration System (PAS).
Current tool release:
This amended version incorporates format changes to six data items to resolve submission validation errors identified at go-live.
All table and field names remain the same. Please see the production log included in the release for details of the changes.
This version should be used for all 4.1 submissions going forward.
Released on Monday, 2 March 2020
Previous tool release:
This version can be downloaded but should not be used until 1 April 2019.
Released on Sunday, 16 December 2018