Recommendation 2

To improve the management of Structured Query Language (SQL) scripts and their outputs, the ANAO recommends that the ATO develops:

  1. standard operating procedures for the development, testing, storage and quality control of SQL scripts as they relate to reporting from the data warehouse; and
  2. guidelines for the storage and archiving of SQL scripts outputs and referenced tables, where the exact replication of those outputs is required.

ATO response

We agreed with this recommendation and it is currently in progress.

    Last modified: 20 Feb 2015QC 42135