Post Data Batch Stat CR and Post AQS

Post Data

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

Stat CR = Statistical Critical Review Scan Report 3 Provides information on maximum values and validity flags for raw data Stat Evaluation Report Evaluation of data to discover possible but unlikely data Results available in Scan and Stat Evaluation Reports 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/AQSUser. Guide. pdf Post Data to AQS

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 4 Post Data to AQS

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

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

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

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

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

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. 10 Posting Data to Production

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

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

Batch: Raw Data Inventory Report 13 Post Data to AQS