Purpose
As the AIRS database moves to the Oracle relational database platform, it provides the QA community an opportunity to add necessary QA features to the system. In discussions among the OAQPS Ambient Air QA Team, and the AIRS QA Technical Advisory Group, it appears that we should take the opportunity to develop a QA area. This area would allow for the easy entry and reporting of all types of QA data for the AIRS system and serves to meet the following QA goals:
· Ensure that the quality of NAMS/SLAM/PAMS database is known and easily understood
· Provide the tools to evaluate the quality of the data
A proposed layout for this report can be found in Conceptual Design: AIRS Quality Assurance Entry/Reporting Screens.
Fields and Their Origins
|
Field Name |
Field Origin (Table) |
Column Label on Report |
|
|
|
Automated Instruments |
|
Parameter_Desc |
PARAMETER |
Parameter |
|
State_Name |
STATES |
State |
|
Agency_Desc |
AGENCIES |
Agency |
|
State_Code |
SITES |
Monitor Id |
|
County_Code |
SITES |
|
|
Site_ID |
SITES |
|
|
PA_Parameter_Code |
MONITORS |
|
|
POC |
MONITORS |
|
|
Prec_Date |
PRECISION_DATA |
Date |
|
QA_Value |
QA_DETAILS |
Actual Value |
|
QA_Value |
QA_DETAILS |
Measured Value |
|
Unit_Desc |
UNIT |
Unit |
|
Function Get_Pct_Diff |
Relative % Diff |
|
|
|
|
Manual Methods |
|
Parameter_Desc |
PARAMETER |
Parameter |
|
State_Name |
STATES |
State |
|
Agency_Desc |
AGENCIES |
Agency |
|
State_Code |
SITES |
Monitor Id |
|
County_Code |
SITES |
|
|
Site_ID |
SITES |
|
|
PA_Parameter_Code |
MONITORS |
|
|
POC |
MONITORS |
|
|
Prec_Date |
PRECISION_DATA |
Date |
|
QA_Value |
QA_DETAILS |
Actual Value |
|
Methodology_Code |
SAMPLING_METHODOLOGIES |
Method Code |
|
QA_Value |
QA_DETAILS |
Collocated Value |
|
Methodology_Code |
SAMPLING_METHODOLOGIES |
Method Code |
|
Unit_Desc |
UNIT |
Unit |
|
Function Get_Pct_Diff |
|
Relative % Diff |
Relative Percent Difference (RPD)
The definition of the RPD is dependant on if the data is a manual or automated check, if the parameter is PM2.5, and, if it is PM2.5, if the collocated sampler is a Federal Reference Method (FRM). For details, please refer to CRR Equations for Observations to Include Under Sections for Precision & Accuracy Data document dated December 10, 1998. Equation 1, 10 & 20 used in function Get_Pct_Diff for Precision data are from Federal Register Vol.62, No.138, Friday, July 18, 1997 prepublication.