Files in the releases of these items cannot be used to generate data set submission files for the Strategic Data Collection Service (SDCS) Cloud. Separate XML input schemas are used to assist with the creation of submission files, and can be found in the TRUD category NHS Data Model and Dictionary XML schemas.
The XML extract schemas describe the structure of the exports generated by the SDCS Cloud, and can help develop in-house analytical and checking tools.
Pre-deadline processing is applied to every file uploaded to the SDCS Cloud. It produces a pre-deadline extract and data summary reports.
Post-deadline processing is applied only to the ‘last good’ primary (and refresh, where applicable and if submitted) file that has passed validation by the submission deadline - files need to flow in sequence through the post-deadline processing, with all refresh files processed before primary files and only one of each type for each provider.
Both pre-deadline and post-deadline extracts have the same file format, structure and elements.
Read more about each data set in the guidance documents available on these external pages:
Community Services Data Set post-deadline extract XML Schema
Community Services Data Set pre-deadline extract XML Schema
Improving Access to Psychological Therapies Data Set pre- and post-deadline extract XML Schemas
Maternity Services Data Set pre-deadline, mid-window and post-deadline extract XML Schemas
Mental Health Services Data Set Commissioner extract XML Schemas
Mental Health Services Data Set pre- and post-deadline extract XML Schemas
File structure of the provider post-deadline extract for the Community Services Data Set.
Following post-deadline processing (once the submission window has closed), the SDCS Cloud generates a post-deadline extract for providers, which contains the elements of their data taken into data storage and additional derivations from the submitted data.
File structure of the provider pre-deadline extract for the Community Services Data Set.
Once a provider has submitted a successful file and it has been processed, a pre-deadline extract can be downloaded to show what data would be carried forward if this was the final submission.
Further processing is later required to produce the post-deadline extracts (this takes place after the submission deadline).
File structure for the outgoing provider pre- and post-deadline extracts for the Improving Access to Psychological Therapies (IAPT) Data Set.
Once a provider has submitted a successful file and it has been processed, a pre-deadline extract can be downloaded to show what data would be carried forward if this was the final submission.
Further processing is later required to produce the post-deadline extracts (this takes place after the submission deadline).
Following post-deadline processing (once the submission window has closed), the SDCS Cloud generates a post-deadline extract for providers, which contains the elements of their data taken into data storage plus additional derivations from the submitted data.
File structure for the outgoing provider pre-deadline, mid-window and post-deadline extracts for the Maternity Services Data Set (MSDS).
Once a provider has submitted a successful file and it has been processed, a pre-deadline extract can be downloaded to show what data would be carried forward if this was the final submission.
Further processing is later required to produce the mid-window and final post-deadline extracts. This takes place after the provisional procesing deadline for the mid-window extract, and after the final submission window closes for the post-deadline extract.
Following mid-window and post-deadline processing (during the submission window and once the submission window has closed), the SDCS Cloud generates mid-window and post-deadline extracts for providers. These extracts contain the elements of the provider data taken into data storage and additional derivations from the submitted data.
File structure for the outgoing Commissioner extract for the Mental Health Services Data Set (MHSDS).
Extracts are available for commissioners following post-deadline processing, and after they have been made available for providers. Commissioners will only see these once they have been loaded into the data warehouse. Their view will only show pseudonymised data.
File structure for the outgoing provider pre- and post-deadline extracts for the Mental Health Services Data Set (MHSDS).
Once a provider has submitted a successful file and it has been processed, a pre-deadline extract can be downloaded to show what data would be carried forward if this was the final submission.
Further processing is later required to produce the post-deadline extracts (this takes place after the submission deadline).
Following post-deadline processing (once the submission window has closed), the SDCS Cloud generates a post-deadline extract for providers, which contains the elements of their data taken into data storage plus additional derivations from the submitted data.