Skip to main content

Part of Community Services Data Set (CSDS) guidance

Community Services Data Set video guides

Current Chapter

Current chapter – 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