CAWIS / WSDRS - FEEDBACK DATA EXTRACT REQUESTS

SEE PBI#115128 - CAWIS WSDRS - Feedback Magazine Datasets time frames for extractions needs to be more flexible

https://tc.canada.ca/en/aviation/aircraft-airworthiness/continuing-airworthiness/feedback-canadian-aviation-service-difficulty-reports

Feedback magazine is to be published quarterly by the Continuing Airworthiness publications group. Unfortunately when it is published late, the hard coded time parameters in the application will not permit the client to extract the Service Difficulty Reporting (SDR) & Airworthiness Directive (AD) data for the required time frame.

The code to do this is available in the attachment here :
Note: in TOAD, the three scripts, for SDR, Equipment AD and AD need to be run separately.

For an example of a recent response to a request from the client please refer to the child task

209998 Produce Feedback Magazine Datasets

The parent bug with the details of the request from the client is 208364 CAWIS WSDRS - Feedback Magazine Datasets

Open

Simply replace the <> values with the required dates, run the queries, drop the data into an Excel spreadsheet, attach the spreadsheet to the PBI (one tab per result set), and notify the requestor.

A future CAWIS enhancement should be to remove these time frame restrictions on the data extract, and let the user select their own start and end dates.