1 / 13

Post Data

Post Data. AQS Batch Data Input Flowchart. Staging Tables. Production Tables - Preproduction Status. Raw. R = Relational Status S = Stat Analysis. Y. Stats CR. Maintain Raw. Scan Report. Stat Eval. N. Post. Y. Legend. Batch. Post. Raw Data Inventory. End. Report.

mariko
Download Presentation

Post Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Post Data

  2. AQS Batch Data Input Flowchart Staging Tables Production Tables - Preproduction Status Raw R = Relational Status S = Stat Analysis Y Stats CR Maintain Raw Scan Report Stat Eval N Post Y Legend Batch Post Raw Data Inventory End Report Online Production Tables – Production Status Batch: Stat CR and Post Only applies to Raw Data Stat CR, then Post Post Data to AQS

  3. Stat CR • Stat CR = Statistical Critical Review • Evaluation of data to discover possible but unlikely data Results available in Scan and Stat Evaluation Reports • Scan Report • Provides information on maximum values and validity flags for raw data • Stat Evaluation Report • Compares pre-production data to existing production data using Shewhart test, Patterns test, and Gap test • Additional information found in http://www.epa.gov/ttn/airs/aqs/softw/AQSUserGuide.pdf Post Data to AQS

  4. Critical Reviews • Once data posted, it is viewable by public. • Stat CR activities help flag data anomalies prior to release of data • Real errors that fit with rest of data not captured • Anomalies found are not necessarily errors • Stat CR and Post must always be run when raw data is added to or changed in database Post Data to AQS

  5. Batch: Stat CR • Push button • wait for completion (e-mail/ refresh for notification) Post Data to AQS

  6. Batch: Statistical Evaluation Report • Only records that fail a test are reported Post Data to AQS

  7. Batch: Scan Report • Report flags or “sports” in the data with * 7 Post Data to AQS

  8. Batch: Post AQS Batch Data Input Flowchart Staging Tables • Post is final step in batch update process • One last chance to verify that data is ready for the world • Raw Data Inventory Report is available after Post Production Tables - Preproduction Status R = Relational Status S = Stat Analysis Post Y Legend Batch Post Raw Data Inventory End Report Online Production Tables – Production Status 8 Post Data to AQS

  9. Batch: Post form Post button on batch form calls-up new form to use to review data This information is in the Scan Report This information is in the Statistical Evaluation Report 9 Post Data to AQS

  10. Batch: Post Form Raw Data Tab This display allows verification of incidents that “qualify” (explain) unusual value(s) before data is posted to public. Qualifier information cannot be entered in this form, only verified. Posting Data to Production

  11. Batch: Post Form, Raw Overview Remember, though aberrations look like “errors” they may be perfectly acceptable data values. 11 Post Data to AQS

  12. Batch: Post Form, Raw Data ALL records belonging to screening group are posted, no matter who loaded the data. 12 Post Data to AQS

  13. Batch: Raw Data Inventory Report 13 Post Data to AQS

More Related