Part of Community Services Data Set (CSDS) guidance
Community Services Data Set video guides
Community Services Data Set – data submission
This is a series of videos demonstrating, as end-to-end and step-by-step, the process of submitting Community Services data to the Strategic Data Collection Service (SDCS) cloud.
We would greatly value your feedback on what could be improved in existing guidance provided on this site. Please use our feedback form to let us know what you think.
Registration
This video will look at the different parts involved in registering to make a data submission. It will look at the ODS Code, Information Governance, DUC Forms and Two-Factor Authentication.
Intermediate Database - downloading IDB from TRUD website
This video will demonstrate how to download the Intermediate Database (IDB) from the Technology Reference data Update Distribution (TRUD) site. The XML schema can also be downloaded from this same location.
Introducing MS Access and the Intermediate Database
This video introduces MS Access and the Intermediate Database (IDB).
Supporting documentation – Technical Output Specification
This video provides descriptions of information held within the Technical Output Specification (TOS) document.
Supporting documentation – user guidance
This video provides a general description of the User Guidance document and highlights key sections of it.
Supporting documentation – Data Model
This video provides an overview of the Data Model for CSDS. The Data Model is a PDF file showing the tables and how they are related.
Intermediate Database - examples of data population
This video will show examples of data written to tables such as Header, MPI, GP, Referral and Care Contact for the Community Services IDB.
Populating the IDB – manually
This video demonstrates how to make manual population to the Header table within the Community Services Data Set IDB Access database.
Populating the IDB – copy and paste
This video demonstrates how to copy and paste data from an Excel sheet into a table within our IDB. The exercise pastes data into the GP table.
Populating the IDB - Data Import
This video demonstrates how to import data from an Excel sheet, and a CSV file, into a table within our IDB. The exercise imports data into the GP table.
SDCS - Data Submission Pattern
This video describes the pattern in which CSDS data can be submitted. Described is the submission window and the Primary / Refresh model.
SDCS - making a data submission
This video will walk through making a data submission on the Strategic Data Collection Service (SDCS) cloud.
Rejects and Warnings - handling rejected submission
This video will provide more detail on the reasons a data submission might be rejected.
Rejects and Warnings - handling reject messages
This video will show how to retrieve the reject messages, how to understand them, and how to approach fixing them.
Rejects and Warnings – handling warning messages
This video will show how to get the data warning messages from SDCS Cloud and how to understand them.
Useful site - ODS portal
This video looks at the ODS Portal (Organisation Data Service) website. This is a public site allowing the searching and display of information on organisations who have an ODS code.
Last edited: 8 July 2022 1:05 pm