Page History
Ontario Structured Psychotherapy Program:
Data Submission Guide
The OSP Technical Specifications, also known as the Data Submission Template, is an Excel spreadsheet that provides a template to submit quantitative data collected from the OSP program. All NLOs are required to use this data format to submit their data.
Key Features:
- The template is created to align with the OSP data dictionary. New versions of the data dictionary may result in corresponding revisions to the data submission template.
- At present, 87 of the data elements documented in the OSP data dictionary have been mapped to 87 database columns in the Data Submission Template (V4.00). An additional 6 database columns are included for historically collected data elements.
Responsibilities of NLOs
The main responsibilities for NLOs are related to data coaching, quality, collection, and submission are summarized below:
...
- Securely transfer data on a on a bimonthly (per the data submission schedule) basis to the Provincial System Support Program’s (PSSP) Drug and Alcohol Treatment Information System (DATIS) at CAMH (or any future repositories, as these are developed) for consolidation and analysis.
- Conduct performance management across the network related to clinical outcomes and OSP standards (e.g., data quality, wait times) by reviewing data against provincial targets.
Data Submission Instructions
As part of OSP, all service providers must collect MDS data for evaluation purposes and send it to the Drug and Alcohol Treatment Information System (DATIS). DATIS staff will then evaluate the program overall, to determine if the program is being implemented successfully and where improvements can be made around training and supervision, clinical, data quality or administrative processes, and equity.
...
- Secure File Transfer Platform via WINSCP (preferred), or
- Secure file transfer, access manually granted by DATIS
Step 1: Initiate service request to create secure file transfer platform (SFTP) account
NLOs should initiate a service request with CAMH by providing DATIS with basic information, including their organization and contact personnel, and the request to create an SFTP account.
There will only be one SFTP account and corresponding key generated per NLO. To place a service request with DATIS, please contact Bill Que (Bill.Que@camh.ca).
Step 2: Generate a public/private key pair using PuttyGen
To generate a public/private key pair:
1) Download the software: First, you will need to download a software to generate the appropriate keys. PuttyGen is the easiest tool to use to do this and can be downloaded here: https://the.earth.li/~sgtatham/putty/latest/w64/puttygen.exe
2) Start PuttyGen
...
6. The extension of the private key is ppk (this is the default setting when you save). Create a public key and save it to the same folder as the private key. Your public key file should have the same name as your private key except instead of a ppk extension it should be pub. You will need to change this when you save. 
Step 3: Validate the public key and authenticate your SFTP account with DATIS
Now that you've generated a public/private key pair you are ready to start using those keys to send files to CAMH.
- You will need to supply DATIS with your public key so that we can add it to our system to authenticate you as a user, as an addendum to your initial service request
- Keep your private key saved in a secure place. Never share your private key and password with anyone outside of your organization
Step 4: Add and verify new SDS IDs
1. Save and open the "OSPP Data Specs" file
...
9.The OSPP Data Specs file is closed automatically.
Step 5: Uploading data into OSPP Data Specs (data submission template)
1.Format and save your data as a .csv file, using the specifications from the Data_File_Format tab in the "OSPP Data Specs".
...
| Note |
|---|
there may have a security warning message when users open the tool, as it's a macro-enable workbook. By default, Macros have been disabled, so users need to click "Enable Content" to use it.
|
Step 6A: Upload and submit the file using WINSCP to access the SFTP account
DATIS will supply a username, port number, and hostname to you when it is time to complete your submission. You will need to use a software called WINSCP to connect to the CAMH SFTP server.
...
7. Before proceeding you must have supplied your public key to CAMH and have verification it was applied. You can now test your connection by selecting your site and hitting the Login button. You will be prompted to enter the password you used when you created your private key. If all goes well you should be logged in and see the following screen:
Step 6B: Upload and submit the file using secure file transfer
If the platform is malfunctioning, which can occur in rare instances, you can email DATIS to support a secure file transfer, as an alternative to Step 5A.
...
