DATS NSW Reports

NSW Drug and Alcohol Coordinators should run the DATS NSW reports to create the files for monthly submission to the Centre for Drug and Alcohol, NSW Department of Health no later than the 21st day of the month following the month of data collection.

To run a report:
  1. As an Adminsitrator, select Report > DATS NSW > required report.
  2. Click Advanced iconAdvanced.
  3. Complete the fields and click Save iconOK.
  4. In the Query Results window, click Export data iconExport data.
  5. Click Select all iconselect all to select all fields and move them to the Destination table fields list, and click Next iconNext.
  6. For the Destination type, set ASCII and click Next iconNext.
  7. In the Destination Parameters window:
    1. Set Delimit numeric fields.
    2. In the File name field, enter the filepath and file name for this report (refer to Table 1. For example, C:\DATS\202208\episode.txt.
    3. Click Next iconNext.
  8. Enter the number of records to export. Ensure that the number of records to export matches the source number of records
  9. Click Export data iconExport.
Table 1. DATS NSW reports
Report > DATS NSW Description
Monthly Episodes Export Creates the episode.txt file for monthly submission.

All fields and records are exported in ASCII format using the filename episode.txt (in lower case).

Monthly Other Drugs Export Creates the otherdrg.txt file for monthly submission.

All fields and records should be exported in ASCII format using the filename otherdrg.txt (in lower case).

Monthly Other Services Export Creates the othersrv.txt file for monthly submission.

All fields and records should be exported in ASCII format using the filename othersrv.txt (in lower case).

Monthly Pharmacotherapy Type Export Creates the pharmaco.txt file for monthly submission.

All fields and records should be exported in ASCII format using the filename pharmaco.txt (in lower case).

Monthly Previous Services Export Creates the prevtrmt.txt file for monthly submission.

All fields and records should be exported in ASCII format using the filename prevtrmt.txt (in lower case).

Monthly Service Contacts Export Creates the srvccnct.txt file for monthly submission.

All fields and records should be exported in ASCII format using the filename srvccnct.txt (in lower case).