Page | 1 Features Available in ATTAINS Cycle Comparison Reports Version: 3/10/2020 - This corresponds with the February 2020 release of ATTAINS Purpose: To explain some of the features available in the Cycle Comparison Reports. These features include the ability to add columns to a report, filter results, and download the filtered results. Audience: Any ATTAINS user with access to an Organization. These features are available for users with Read Only access or higher. 1. Login to ATTAINS. 2. If you are an EPA user, select an Organization from the top right drop-down menu. State or Tribal users can only access your own Organization, so you can skip this step. 3. Go to the Reports tab. % S fi © ® © Home Assessment Units Assessments Actions Reports Priorities Surveys Administration Cycle Comparison Report Type- Cycle Comparison T Report* Assessments ~ Cycle* 2018 - Organization Final Action - Submits Comparison 2016 - EPA Final Action (Snapshot) Cycle* Run Report 4. In Report Type, select "Cycle Comparison". a. In the Report drop-down select either Assessments or Parameters. (Once the report is run, you can click between them.) Assessments will look at changes in the EPA IR Cycle. Parameters will look at changes in the Parameter Attainments. b. In the Cycle drop-down, select the snapshot or working copy of the most recent cycle to be compared. c. In the Comparison Cycle drop-down, select the older snapshot to be compared. d. Note: It is important to select the newer cycle or snapshot in the first drop-down, and then select the older snapshot in the second drop-down. Otherwise, the Summary column calculation will not make sense. A This document covers two types of Cycle Comparison Reports: • Cycle Comparison Reports showing changes at the Assessment Level • Cycle Comparison Reports showing changes at the Parameter Level ------- Page | 2 Cycle Comparison Report - Assessments The Cycle Comparison Report for Assessments looks at changes from the overall Assessment Unit ID level. 1. Default Columns: The report initially runs with several default columns a. Assessment Unit ID: The Assessment Unit ID in the newer cycle or snapshot b. Assessment Unit Name: The Assessment Unit ID in the newer cycle or snapshot c. Previous Assessment Unit Name: The Assessment Unit Name in the older cycle or snapshot d. EPA IR Category: The EPA IR Category at the Assessment Unit ID level for the newer cycle or snapshot e. Previous EPA IR Category: The EPA IR Category at the Assessment Unit ID level for the older cycle or snapshot f. EPA IR Category Summary: This Summary column looks at changes to the EPA IR Category between the two selected cycles or snapshots. This column is highlighted with a red box in the image below. i. ADDED: If a new Assessment Unit ID has been assessed, it will show as "ADDED". ii. CHANGED: If the EPA IR Category at the Assessment Unit ID level has changed between the comparison cycles or snapshots, it will show as "CHANGED". iii. No Change: If the EPA IR Category at the Assessment Unit ID level has not changed between the comparison cycles or snapshots, it will show as (meaning No Change). Cycle Comparison + New Report Assessments Parameters s:i Columns ® Download Assessment Unit ID ; Assessment Unit Name t Previous Assessment Unit Name EPA IR Category ; Previous EPA IR Category EPA IR Category Summary - - - CC_BS-L-MADISON_01 Lake Madison Lake Madison 5 5 -- CC_CH-L-BISMARK_01 Bismark Lake Bismark Lake 5 3 CHANGED CC_BF-R-BEAR_Bin~TE_01 Bear Butte Creek Bear Butte Creek 1 1 -- CC_J A-R-FIRESTEE L_01 Firesteel Creek Firesteel Creek 1 1 -- TBrenametest test 3 ADDED 10 25 50 100 15 Records 2. Adding Columns: You may choose additional columns to add to the results table. Click the Columns button. The available columns are listed on the next page. As you add columns, you may need to use the horizontal scroll bar to see additional columns. The results table is driven by the combination of columns selected. For example, if the Water Type column is added and an Assessment Unit ID has multiple water types, then it will have multiple rows for the same Assessment Unit ID. 3. Downloading results: Once you have the data the way you want (e.g., have added the columns that you want, and applied filters if you would like), using the Download button will export the results table to .CSV format. If you want all the results from the table, remove any applied filters. ------- Page | 3 Additional Columns for Cycle Comparison - Assessments Report These are the columns that are available in the report. To choose columns for the report, click the "Columns" button. Gray check marks are for columns that are locked and cannot be turned off. Additional fields are turned on by default (black checks) but may be hidden (i.e., unchecked). The empty boxes are fields that may be turned on. Select your choices and click the Close button. The Assessment list refers to columns in the newer cycle or snapshot, and the Previous Assessment list refers to columns in the older cycle or snapshot. Assessment Assessment Unit ID ® Assessment Unit Name ~ State Code ~ Assessment Unit Status Location Description a Multi IR Categories Water Type Units ~ Source Scale ~ Cycle Last Assessed r Validation a EPA IR Category Use Class Name Agency Code Assessment Unit Comment Assessment Rationale Water Size Size Source Estimation Method ~ Cycle Last Modified Previous Assessment Previous Assessment Unit ID J Previous EPA IR Category — Previous Assessment Unit Name J EPA IR Category Summary O Previous Use Class Name Previous Agency Code Previous Assessment Unit Comment Previous Assessment Rationale Previous Water Size Previous Size Source Previous Estimation Method O Previous Cycle Last Modified ~ Previous State Code Previous Assessment Unit Status Previous Location Description Previous Multi IR Categories 1 Previous Water Type O Previous Units ~ Previous Source Scale ~ Previous Cycle Last Assessed Previous Validation Close ------- Page | 4 Cycle Comparison Report - Parameters The Cycle Comparison Report for Assessments looks at changes from the overall Assessment Unit ID level. 1. Default Columns: The report initially runs with several default columns a. Assessment Unit ID: The Assessment Unit ID in the newer cycle or snapshot b. Assessment Unit Name: The Assessment Unit ID in the newer cycle or snapshot c. Parameter Name: The Parameter name in the newer cycle or snapshot d. Parameter IR Category: The EPA IR Category at the Parameter level, for the newer cycle or snapshot e. Previous Parameter IR Category: The EPA IR Category at the Parameter level, for the older cycle or snapshot f. Parameter IR Category Summary: This Summary column looks at changes to the EPA IR Category at the Parameter level between the two selected cycles or snapshots. This column is highlighted with a red box in the image below. i. ADDED: If the parameter has been added to the Assessment Unit ID in the newer cycle or snapshot, it will show as "ADDED". ii. CHANGED: If the Parameter IR Category has changed between the comparison cycles or snapshots, it will show as "CHANGED". iii. REMOVED: If the parameter has been removed from the Assessment Unit ID in the newer cycle or snapshot, it will show as "REMOVED". iv. No Change: If the Parameter IR Category has not changed between the comparison cycles or snapshots, it will show as (meaning No Change). Cycle Comparison + New Report Assessments Parameters Columns ® Download Assessment Unit ID ~ Assessment Unit Name i Parameter Name t Parameter IR Category Previous Parameter IR Category Parameter IR Category Summary - - - - CC_CH-L-BI S MARK_01 Bismark Lake TURBIDITY 2 ADDED CC_CH-L-BISMARK_01 Bismark Lake DISSOLVED OXYGEN 5 ADDED 123456789 TEST 1,11,2- TETRACHLOROETHANE 2 ADDED CC_BA-L-F REEMANO1 Freeman Lake SELENIUM 5 ADDED 123456789 TEST DISSOLVED OXYGEN 5 ADDED 10 25 50 100 24 Records 2. Adding Columns: You may choose additional columns to add to the results table. Click the Columns button. The available columns are listed on the next page. As you add columns, you may need to use the horizontal scroll bar to see additional columns. The results table is driven by the combination of columns selected. For example, if the Water Type column is added and an Assessment Unit ID has multiple water types, then it will have multiple rows for the same Assessment Unit ID. ------- Page | 5 3. Downloading results: Once you have the data the way you want (e.g., have added the columns that you want, and applied filters if you would like), using the Download button will export the results table to .CSV format. If you want all the results from the table, remove any applied filters. Additional Columns for Cycle Comparison - Parameters Report These are the columns that are available in the report. To choose columns for the report, click the "Columns" button. Gray check marks are for columns that are locked and cannot be turned off. Additional fields are turned on by default (black checks) but may be hidden (i.e., unchecked). The empty boxes are fields that may be turned on. Select your choices and click the Close button. The Parameters list refers to columns in the newer cycle or snapshot and the Previous Parameters list refers to columns in the older cycle or snapshot. Parameters i Assessment Unit ID < Parameter Name O State Code U Status Delisted Use Attainment ® Assessment Unit Name ® Parameter IR Category ~ Validation Parameter Status Use Name Parameter Attainment Seasons) Start-End) Cycle Scheduled for TMDL ~ Organization IR Category ~ Alternate Listing Identifier ~ Consent Decree Cycle Associated Action Ids Parameter Trend ~ Cycle First Listed Cycle Expected to Attain Impaired Water Agency CWA 303(d) Priority Ranking Impaired Water Comment Previous Parameters Previous Assessment Unit ID Previous Parameter Name Parameter IR Category Summary - Previous Validation Previous Parameter Status - Previous Use Name Previous Parameter Attainment Previous Seasons)Start-End) ~ Previous Pollutant Indicator H Previous Cycle Scheduled for TMDL Previous Assessment Unit Name ' Previous Parameter IR Category - Previous State Code ~ Previous Status Previous Delisted - Previous Use Attainment ~ Previous Parameter Trend Pollutant indicator Previous Cycle First Listed I1 Previous Cycle Expected to Attain Q Previous Organization IR Category Previous Alternate Listing Identifier Previous Consent Decree Cycle Previous CWA 303(d) Priority Ranking Previous Impaired Water Comment Previous Impaired Water Agency Previous Associated Action Ids Close ------- |