11

Intermediate Data ReviewIntermediate Data Review

22

Initial Data Review Already Initial Data Review Already Done During ImportDone During Import

• This qualification (flagging) was based This qualification (flagging) was based on on • Out-of-range concentrationsOut-of-range concentrations• Error codes, very negative valuesError codes, very negative values• QC checksQC checks• Other data quality issues you knew of Other data quality issues you knew of at at

that timethat time

Initial data review done back Initial data review done back here (gaseous):here (gaseous):

33

Or here (met):Or here (met): 44

Where is data now?Where is data now?

• All data in archive tablesAll data in archive tables

• Some data is flagged, based on your Some data is flagged, based on your assigned flags during import processassigned flags during import process

• Now you received an audit report, or Now you received an audit report, or remembered somethingremembered something

• Go to first green buttonGo to first green button

55

Intermediate Data Review: Intermediate Data Review: Logbook and External Info Logbook and External Info Data Flagging:Data Flagging:

66

77

Intermediate Data ReviewIntermediate Data Review• You should perform this step quarterly, or You should perform this step quarterly, or

when you get (or remember) new info:when you get (or remember) new info:

• Use this step two waysUse this step two ways• To view data for anything you may have To view data for anything you may have

missed during importmissed during import• To qualify (flag) data based on other To qualify (flag) data based on other

information that may have not been available information that may have not been available during import (logbooks, audit reports, during import (logbooks, audit reports, unusual events, any information that you have unusual events, any information that you have learned since doing the original import)learned since doing the original import)

88

When your data are already in When your data are already in the archive table, and now you the archive table, and now you

have new information, go to have new information, go to Logbook and External Info Logbook and External Info

Flagging buttonFlagging button

Top green button opens form with Top green button opens form with 4 boxes (4 types of data):4 boxes (4 types of data):

99

1010Buttons let you view all data, flagged Buttons let you view all data, flagged andand unflagged (ex: Continuous unflagged (ex: Continuous

PM10)PM10)

Select the data you want to view, then click here

1111The view data button pulls up the query The view data button pulls up the query window showing data for those window showing data for those dates/times:dates/times:

• Some data points have already been qualified Some data points have already been qualified (flagged) during import (1(flagged) during import (1stst tier of data review) tier of data review)

1212

What if my audit reports tells me What if my audit reports tells me to qualify some of the data?to qualify some of the data?• Let’s say we look at our logbook and Let’s say we look at our logbook and

determine that data from 10 AM until 1 determine that data from 10 AM until 1 PM on 7/1/03 need to be qualifiedPM on 7/1/03 need to be qualified

Change the range to only

that of the data you need to qualify…then click here

1313

Intermediate Data Review Intermediate Data Review (cont.)(cont.)

• A few message boxes will come up A few message boxes will come up about changing dataabout changing data

• Click OK or Yes on each of themClick OK or Yes on each of them

• The Toolbox then adds qualifiers (flags) The Toolbox then adds qualifiers (flags) to the data you selectedto the data you selected

• Remember to note this in your Toolbox Remember to note this in your Toolbox Logbook, especially if you are using Logbook, especially if you are using information from a phone call, etc. as information from a phone call, etc. as the basis for adding these flagsthe basis for adding these flags

1414

Let’s see what we didLet’s see what we did

Change the range back to the entire

two week period…

then click here

1515

And the results are…And the results are…

Qualifiers we just added

1616

List of toolbox qualifiers:List of toolbox qualifiers:

• The full list of qualifiers at the end of The full list of qualifiers at the end of SOP for Final Data Review and Invalidation

If you are done for now, close form:If you are done for now, close form:1717

OR, If you are ready to review data for OR, If you are ready to review data for AQS file generation:AQS file generation:

1818