AQS Annual PE Report – Added New Fields [d52711]
Added the following fields to the AQS Annual PE Report:
- "PVGP_ID" (Mapped to dt_equipment_parameter.custom_field_1)
- "Cylinder_ID" (Mapped to dt_equipment_parameter.custom_field_2)
AQS Format – Added Filter for Reported_Unit Value [d47876]
Fixed an issue when exporting data in EDP using the AQS Format to avoid errors that come from missing data in RT_AQS_UNIT.EQUIS_UNIT_CODE upon export:
- Added filtering to the EDD import
- When a new value is added in EDP, the status will default to 'A'
AQS Format – Added New Fields to the QA_Annual_PE Section [d52803]
Added the following new fields to the QA_Annual_PE section of the AQS Format:
AQS Format – Fixed DT_RESULT Error During Data Import From QA_Duplicate [d47686]
Fixed the "AQS data requires both [AQS_parameter_code] and [AQS_method_code] - one of these is NULL." error when data were loaded to DT_RESULT from the QA_Duplicate section of the AQS format.
AQS Format – Fixed DT_TEST.ANALYTIC_METHOD Error During Data Import From QA_PB_Analysis_Audit [d47363]
Added the "Monitor Method Code" lookup field to QA_PB_Analysis_Audit to resolve the "Column 'analytic_method' does not allow nulls." error when data were inserted into DT_TEST.
AQS QA Reports – Fixed Duplicate Entry Issue for Report Parameter [d45484]
Fixed a bug in the AQS QA reports where the report parameter for "Location: Individual" could contain duplicate entries. The affected reports were:
- AQS QA 1 Point QC
- AQS QA Annual PE
- AQS QA Zero Span
- AQS QA Flow Rate Verification
- AQS QA Semi Annual Flow Rate Audit
AQS QA Reports – Updated Report Parameters [d45660]
Added a new “AQS Results" section to improve report querying and removed the "Analyte" section for the following AQS Module reports:
- AQS QA 1 Point QC
- AQS QA Annual PE
- AQS QA Flow Rate Verification
- AQS QA Semi Annual Flow Rate Audit
- AQS QA Zero Span
AQS QA Semi Annual Flow Rate Report – Changed ASSESSMENT_DATE Date Format [d45588]
Updated the date format for the ASSESSMENT_DATE field to use YYYYMMDD.
AQS Raw Reports – Added New “AQS Results" Section [d53063]
Added a new "AQS Results" section to AQS Raw Data and AQS Raw Blanks report parameters to improve report querying.