Jake Summers/RTP/USEPA/US To AQS Users 1, AQS Users 2
12/18/07 12:55 cc
Subject Instructions for adding Exceptional Events Comments to Flags; AQS Report on Flagged
There has been a request to provide a procedure for adding comments to raw data values flagged with an exceptional event flag. These comments are required by the new "Exceptional Event Rule" that became effective May 21, 2007.
Below are the individual steps to add the comments to an existing raw data value. Where appropriate, the step is demonstrated with a screen capture for the specific step.
Please let me know if there are any problems or you have any questions.
The steps to follow are;
User must assign the screening group that owns the monitor.
User goes to Maintain Sample Values Raw Data
Enter the monitor ID and date that contains the flagged data values. Example follows:
Execute the query to return the sample values:
Since the first hour of the day is highlighted, clicking on the comments tab will display the existing comment.
I will demonstrate by adding a comment (just my name for simplicity) to the next hour.
Highlight that record, go to top menu, click on "+" to create a blank line, and click on duplicate record icon (second one from "+". At this point, the record has been duplicated. The "action Id" must be populated with "U" for update, and click on the save icon in top menu left corner.
With the record just entered highlighted, click on Comment tab, enter a sequence number, the comment, and save again.
To complete the processing, the user must go to the Batch screen and click on "Stat CR". After this process completes, click on "POST" to actually finish the processing. The monitor and data values should appear on the "POST" screens.
After the "POST" has completed, maintain can be used to show that the comment is now in the database.
Note the change from "R" to "P" for the status between the last 2 screen captures. That demonstrates that the comment has been successfully stored.
I did this processing in our testing database rather than the production database. I hope this will help with comment entry. I did not sue any special process to perform the update that any state user with raw data update can not perform.
National Air Data Group
Research Triangle Park, NC 27711
(919) 541-5695 (Phone) (919) 541-7674 (Fax)