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.
- As an Adminsitrator, select .
- Click Advanced.
- Complete the fields and click OK.
- In the Query Results window, click Export data.
- Click select all to select all fields and move them to the Destination table fields list, and click Next.
- For the Destination type, set ASCII and click Next.
- In the Destination Parameters window:
- Set Delimit numeric fields.
- 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.
- Click Next.
- Enter the number of records to export. Ensure that the number of records to export matches the source number of records
- Click Export.
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). |