Download here - Fish Passage Center
Transcript
Smolt Monit M toring g Pro ogram Prrotoc col d FPC C32.net Data D ogra am and Entrry Pro User's U s Ma anuall Manua al Version – 2013 Seas son Produc ced by: The e Fish Pass sage Cente r (Last updated 2/21/2 2013) -i- Table of Contents Table of Contents I. Smolt Monitoring Program (SMP) Protocol I.A. Introduction to the SMP I.B. Summary of Data to be Collected for the SMP I.B.1 Target Species and Species Identification I.B.2 Species Specific Data to Collect Age Code Special Species Code Clipping, Marking, and Tagging Data Descaling Data Mortality Data I.B.3 Fish Sampling at Main-stem Monitoring Sites Sample Size Targets Recommended Sample Rates Anesthetic Fry Handling Protocol II. III. IV. V VI ii 1 1 1 2 2 2 2 2 3 3 3 3 4 4 5 Introduction 6 II.A. II.B. 6 6 The Fish Passage Center (FPC) Remote SMP Site Data Entry Program (FPC32.net) FPC Contacts and Correspondence 7 III.A. Personnel to Contact for Technical Help III.B. Correspondence III.C. SMP Remote Site Facilities and 2013 Dates 7 7 7 Glossary Site by Site SMP Overview 9 12 V.A. V.B. V.C. V.D. V.E. V.F. V.G. V.H. V.I. V.J. V.K. V.L. 12 12 13 13 13 13 13 14 14 14 14 15 Bonneville Dam Powerhouse 1 Bonneville Dam Powerhouse 2 Grande Rhode River Trap Imnaha River Trap John Day Dam Lewiston Trap Little Goose Dam Lower Granite Dam Lower Monumental Dam McNary Dam Rock Island Dam Whitebird Trap System Requirements and Program Installation 16 VI.A. Hardware and Software 1. PC Details 2. Software 3. Communication Devices 16 16 16 16 - ii - VI.B. Procedure to Install FPC32.net Program VI.C. Procedure to Install Newest Version of FPC32.net and Uninstall an Older Version VI.D. Procedure to Allow for Full Control for Windows 7 Operating System VII Overview of FPC32.net Program 16 20 21 24 VII.A. Running the FPC32.net Program and Select Settings 24 VII.B. Entering Fish Condition Data via the Touch Screen 26 VII.B.1 Brief Overview of Steps to Entering Fish Condition Data via the Fish Condition Touch Screen 26 VII.B.2 Exporting Daily Fish Condition Records from Wet Lab Lab Computer 29 VII.C. Importing a Batch from the Condition Sample or Creating a New Batch 30 VII.C.1 Importing Daily Fish Condition Records into FPC32.net Main Form 31 VII.C.2 Creating a New Batch Record Directly from the FPC32.net Main Form 32 VII.D. Entering Non-Condition Fish Data (Catch Detail) 33 VII.E. Entering Incidental Catch Data 35 VII.F. Entering Mark/Recapture Data 36 VII.G. Validating Condition Data 37 VII.H. Promoting Condition Data into the Batch 38 VII.I. Entering Transportation Data 40 VII.I.1 Manual Entry of Transportation Data 41 VII.I.2 Importing Data from Catch Detail For Transportation Data Entry Tab 42 VII.J. Validating Batch 43 VII.K. End and Send 44 VII.L. Reposts 45 VII.M. Special Situations 46 VII.M.1 Daylight Savings Time Transitions 46 VII.M.2 Sampling End Date is the Same for Two Batches 47 VIII Detailed Data Entry Instructions VIII.A. Catch Tab VIII.A.1 Definitions and Data Entry Start Date Start Hour End Date End Hour Trap Location Gear Code Sample Code Sample Hours Total Discharge PH1 Flow/Turbine Discharge - iii - 48 48 48 50 50 50 50 50 51 51 52 52 52 PH2 Flow Total Spill Comments1 ad Comments 2 VIII.A.2 Editing Records in the Catch Data Entry Tab Adjusting Batch Numbers and Creating Batches for Past Dates Editing Older Batches Removing a Batch Record from the Local Database VIII.B. Catch Detail Tab VIII.B.1 Definitions and Data Entry Sub Batch Tank/Trap Species Code Age Code Fin Clipped CWT Special Species Code Gear Code Multiplier and Sample Rate Non-Cond Sample Count Estimated Collection Num Exam for Descale Num Descaled Sample Morts Facility Morts Research Morts PIT Tag Morts Promoted Summary Condition Fish VIII.B.2 Editing or Deleting Catch Detail Records VIII.C. Incidental Species Tab VIII.C.1 Definitions and Data Entry Species Code Sample Count Sample Morts Promoted Summary Condition Fish VIII.C.2 Editing or Deleting Incidental Catch Records VIII.D. Mark Recapture Tab VIII.D.1 Definitions and Data Entry Sub Batch Tank/Trap Species Code Age Code Mark Type Brand Location Brand Code Brand Orientation Tag Number - iv - 53 53 54 54 54 55 56 57 57 59 59 59 60 61 61 62 63 63 65 65 65 66 66 67 67 67 68 68 68 69 70 71 71 71 72 72 73 74 74 74 74 75 75 75 75 75 Tag Color Clip Code Supplemental Code Tally Total Promoted Summary Condition Fish VIII.D.2 Editing or Deleting Mark Recapture Records VIII.E. Transportation Tab VIII.E.1 Definitions and Data Entry Tank Species Code Special Species Code Age Code Fin Clipped CWT Num Bypassed Num Trucked Num Barged VIII.E.2 Editing or Deleting Transportation Records VIII.F. Conditions Tab VIII.F.1 Definitions and Data Entry Site and Batch Sub Batch Tank Species Code Miscellaneous Incidental Special Species Code Mark Type Elas. Code Color Code Descaling Weight Length Predator Checkboxes Injury Checkboxes Disease Checkboxes Other Conditions Checkboxes General Comment VIII.F.2 Editing or Deleting Conditions Records VIII.G. Summary Condition Tab VIII.G.1 Definitions Site and Batch Catch Detail Sub Batches Conditions Sub Batches VIII.H. Fish Condition Touch Screen VIII.H.1 Data Entry Sequence for the Fish Condition Touch Screen -v- 76 76 76 76 76 76 77 77 79 79 79 79 79 79 79 79 80 80 80 80 82 82 82 82 82 83 83 84 84 84 84 85 86 86 87 87 88 88 89 89 90 90 91 91 92 VIII.H.2 Fish Condition Touch Screen – Function Buttons Number Pad Exit Panel New Save/New Edit Delete Next Previous Cancel Export VIII.H.3 Fish Condition Touch Screen – Record Browsing Panel Tank/Trap Species Code Special Species Clip Code Elastomer Color CWT General Comment Special Comment Predator Injury Other Conditions Disease Weight Length Site Batch Date Sub-Batch Sequence VIII.H.4 Fish Condition Touch Screen – Tallies “Tank A and None” and “Tank B” Tallies Special Species Tallies Total Incidental Tally Total Sampled Tally VIII.H.5 Fish Condition Touch Screen – Condition, Species and Mark Type Buttons Elastomer Location and Color General Comments, Sub Batch, and Tank Disease/Predator Conditions Injury Conditions Miscellaneous Conditions Descaling Predator Conditions - vi - 94 94 95 95 95 95 95 95 95 95 96 96 96 96 97 97 97 97 97 97 97 98 98 98 98 98 98 98 99 99 99 96 99 99 99 99 99 100 102 102 103 103 104 104 104 Mark Types Weight and Length Species and Special Species IX X Validation 108 IX.A. Automatic Data Validation Alerts IX.A.1 Suspect Data Entry Alert – Red Dot Example 1 – Improper Gear Code, Sample Code, Sample Hours Combination Example 2 – Improper Species, Special Species Combination Example 3 – Improper Sample Code, Sub-batch Combination IX.A.2 Suspect Data Entry Alert – Red Field in Data Review Grid Example 1 – Anomalous Length Entry IX.A.3 Data Entry Error Message Example 1 – Flow and Spill Data Entry IX.A.4 Data Reminders Example 1 – Entering a Tank IX.B. FPC32.net Validation Reports IX.B.1 Daily Summary Report IX.B.2 Mark Recapture Report IX.B.3 Incidental Catch Report IX.B.4 Fish Condition Report IX.B.5 Individual Fish Condition Report IX.B.6 Daily Batch/Tank Report IX.B.7 Special Species Daily Batch/Tank Report IX.B.8 Lamprey Batch/Tank Report IX.C. FPC Weekly Validation IX.D. FPC Validation Spreadsheets IX.E. End of Year Validation IX.F. Project by Project Details for SMP Reporting Requirements 108 108 109 109 110 110 110 111 111 111 112 113 114 114 115 116 117 118 118 118 119 Printing Daily Reports, Sending Data to FPC and Detailed Report Descriptions 125 X.A. X.B. XI XII 104 105 105 Generating and Printing Reports Next/Previous Page Printing Reports Save Report As Percent Zoom Sending SMP Data and Hand Logs to the FPC Sending New Batches via E-mail Uploading New Batches via HTTP Sending Hand Logs to the FPC 108 108 109 125 126 126 126 127 127 127 128 130 What’s New with FPC32.net (2013) 132 XI.A. Procedure to Allow Full Control for Windows 7 Operating System XI.B. Lamprey Condition Monitoring (Pred. Bird vs. Body Injury) 132 132 Notes 134 - vii - FPC32.net Manual Acknowledgement Form - viii - 137 I.SmoltMonitoringProgram(SMP)Protocol I.A. Introduction to the SMP There are two primary goals of the Smolt Monitoring Program (SMP): 1) to provide real-time data on juvenile fish migration to support in-season fisheries management decisions and 2) to provide a long-term time series of consistently collected data that allow for comparison of the impacts of changing river conditions among years, particularly with respect to juvenile fish survival. To achieve these goals, there are three components to the SMP: 1) PIT-tag marking at hatcheries, 2) PIT-tag marking and monitoring at Snake River Basin traps and Rock Island Dam, and 3) fish sampling at COE bypass facilities at Lower Snake River, and Columbia River dams. This Protocol addresses the data that are collected for the SMP at COE bypass facilities at Lower Snake River and Columbia River dams. The sampling sites covered by this protocol include; Lower Granite Dam (LGR), Little Goose Dam (LGS), Lower Monumental Dam (LMN), McNary Dam (MCN), John Day Dam (JDA), and Bonneville Dam (BON). For the remainder of the document these sampling sites will be referred to as Main-stem Monitoring Sites. This protocol is meant to compliment the Condition Sampling Protocol and provides overall guidelines for sampling and data to collect. In past years, the primary data gathered at these main-stem monitoring sites is count data on juvenile salmonids that are sampled from the bypass system. However, lamprey juveniles have been added to the list of target species for the SMP. These target species are identified to species and any clips and marks/tags are also recorded. Based on these count data (i.e., sample counts), an estimate of daily collection can be generated at each project. From estimates of collection, passage and population indices can be generated if the sample data are representative based on 24-hour sampling that is systematic and sample rates are known throughout that period. Estimates of passage and population indices will not be done for lamprey juveniles. In addition to sample counts, data on fish condition are also collected. Two levels of condition data are collected based on the level of detailed information to be collected. For the full sample, fish are examined for descaling based on FTOT criteria. A subsample of the full sample is examined for detailed condition information, including descaling, injury, and disease. Salmonid fry are NOT examined for descaling or detailed condition information. All COE dam sites conduct detailed condition monitoring on salmonid species. In addition, BON, JDA, and MCN conduct detailed condition monitoring on juvenile and larval lamprey. The protocol for examination of fish for detailed condition monitoring can be found in a separate document entitled Condition Sampling Protocol. I.B. Summary of Data to be Collected for the SMP 1 I.B.1 - Target Species and Species Identification The target species for the SMP include juvenile salmonids and larval and juvenile lamprey. Among the juvenile salmonids that are considered target species are: 1) yearling (age 1) and subyearling (age 0) Chinook (Oncorhynchus tshawytscha), 2) Sockeye (O. nerka), 3) Coho (O. kisutch), and 4) Steelhead (O. mykiss). Among the larval and juvenile lamprey that are considered target species are: 1) pacific lamprey (Lampetra tridentatus) ammocoetes, 2) pacific lamprey (L. tridentatus) macropthalmia, 3) brook lamprey (Lampetra richardsoni) ammocoete, 3) and unknown ammocoete. The above species make up the majority of the fish that are collected for the SMP. However, incidental species are also of interest. Incidental species should also be identified and counted. The Fish Passage Center recommends using the “Columbia River Basin Juvenile Fish Field Guide” published by Pacific States Marine Fisheries Commission for identifying juvenile fish and incidental species. I.B.2 - Species-Specific Data to Collect: For each of the target species, there are additional species-specific data that are to be collected for the SMP. Below is a brief explanation of each of these pieces of species-specific data. Age Code: Age Code is used for Chinook only. Chinook are to be assigned an age of “1” or “0” based on morphology and size. A discussion of the morphological criteria can be found in Section VIII.B.1. Chinook fry are age 0. Special Species Code: There are four possible Special Species Codes that are to be recorded for particular target species of the SMP. These four Special Species Codes correspond to salmonid juveniles only. Below is a brief explanation of each of the Special Species Codes, along with details as to which target species apply. Eroded Fin (EF) for unmarked steelhead with eroded fins. This Special Species Code is used to identify hatchery steelhead that are otherwise unmarked. Lyons Ferry Yearling Fall Chinook (LF) for yearling fall Chinook that are known to have been reared at Lyons Ferry hatchery Holdover Fall Chinook (HO) for yearling fall Chinook that are identified as being holdovers, based on size and morphology. See Section VIII.B.1 for detailed description of how to identify holdover fall Chinook. Fry (FR) for Chinook and coho fry based on size (60mm or less). See Section I.B.3 below for fry handling protocol. Clipping, Marking, and Tagging Data: In order to aide in the identification of origin, the SMP collects information on the clipping, marking, and/or tagging of target salmonid species. Below is a 2 brief explanation of the various clipping, marking, and tagging information that are to be collected for the SMP. See Sections VIII.B.1 and VIII.D.1 for more information on these categories. Fin Clips are recorded on all target salmonid species at all sites. Fin clips include Adipose, Left Vent, and/or Right Vent clips (or any combination of the three. If a fish has any of these clips, that fish is considered “Clipped”. Elastomer Tags are to be recorded on all target salmonid species at all sites. For fish that have Elastomer tags, sites are expected to record tag location and tag color, in addition to species, special species, and clipping information. Coded Wire Tags are to be recorded for all unclipped Chinook (age 0 & 1), unclipped coho, and unclipped sockeye that are sampled at LGR, LGS, LMN, WTB, LEW, and GRN. This request was based on the increasing proportion of hatchery releases that are otherwise unclipped or unmarked. By including CWT data, SMP can differentiate many unmarked hatchery fish from wild origin fish. This is important for use in run-reconstruction, wild fish population estimates, timing data and other analyses of wild origin stocks. Descaling Data: Descaling data will be collected on all target salmonid species in the sample (except Fry and those salmonids that are sampled as part of the Gas Bubble Trauma program). Larval and juvenile lamprey will not be examined for descaling. Fish that are part of the detailed condition sample will be examined for descaling as well as other indices of fish health status (See the Condition Sampling Protocol for more information). Other fish that are sampled but are not part of the detailed condition sub-sample, are considered non-condition fish. These non-condition fish will be examined for descaling, based on the FTOT protocol. A fish will be recorded as descaled if at least 20% of either side of the fish is descaled. Descaling is defined as areas of the fish where scales have been removed by mechanical or other means (including predators) and it cannot be determined that scales have regenerated or healing has occurred. When in doubt examiner should report the fish as descaled. Consistency is important since changes in descaling rate are what triggers management action. Mortality Data: Fish that are found dead in the sample or die during or after handling should be recorded as mortalities in the non-condition sample. See the Section VIII.B.1 for more details about what data to record. I.B.3 – Fish Sampling at Main-stem Monitoring Sites Sample Size Targets: Fish Passage Center recommends collecting between 300 and 500 fish for the Smolt Monitoring Program at main-stem sites. These target sample sizes 3 correspond with the goal of achieving accurate and precise estimates of total collection at the dams. These sample sizes have been reduced from historic sampling targets in an attempt to reduce fish handling. The above target includes fish that are examined for detailed condition monitoring. Recommended Sample Rates: Sites should use the table below to determine sample rates. Use a sample rate that achieves the target sample sizes of 300 to 500 fish (when possible). Typically, Lower Columbia sites should limit sample rates to at or below 25% except when increased numbers of fish may be needed for research or to address immediate management needs. Avoid using sample rates between 12% and 25% whenever possible to avoid impacts to sample accuracy as well as to minimize impacts to PIT-tag studies near the divert during sample (DDS) trigger of 20%. When possible, sites should try to avoid the 0.6%, 0.67%, 0.7%, 1.5%, 3.0%, 7.0%, and 15% sample rates as much as possible, as they have the highest probability of causing rounding errors in data reports. Sites should attempt to minimize the number of times per season sample rates switch from above to below 20%, or from below to above 20% to minimize the number of times the DDS is turned on or off. Estimated Daily Sample Equivalent Multiplier Sample Subsamples Subsample Estimated Number Collection Rate (%) (1/sample rate) Seconds/Hour Per Hour Duration (sec.) of Fish in Sample Emergency 0.5 200 18 2 9 50,000-75,000 0.7 143 25.2 2 12.6 350-525 35,000-50,000 1.0 100 36 3 12 350-500 20,000-35,000 1.5 66.6 54 4 13.5 300-525 15,000-20,000 2.0 50 72 6 12 300-400 10,000-15,000 3.0 33.3 108 6 18 300-450 7,500-10,000 4.0 25 144 6 24 300-400 6,500-7,500 5.0 20 180 6 30 300-375 4,500-6,000 7.0 14.3 252 6 42 315-420 3,000-4,500 10.0 10 360 6 60 300-450 2,500-3,000 12.5 8 450 6 75 313-375 1,500-2,500 20.0 5 720 6 120 300-500 1,000-1,500 25.0 4 900 6 150 250-375 600-1,000 50.0 2 1,800 6 300 300-500 <600 100.0 1 3,600 1 3,600 < 600 th * Carry multipliers to 3 digits total, then round (1/multiplier,3) will provide a sample rate to nearest 10 place that is correct. For custom sample rates, it may be necessary to carry to 6 digits beyond the decimal place if rate results in longer than 6 digits. ** During periods of peak juvenile shad passage, lower sample rated than needed to meet salmonid sample goals may be used to reduce handling and mortalities of shad. Anesthetic: Research funded by COE has shown that MS-222 can degrade relatively rapidly causing added stress to fish as a result. Degradation was found to occur within a few weeks of mixing the dry powder with water. In order to minimize stress to fish it is recommended that batches of MS-222 be mixed in quantities to assure that these mixed (i.e. liquid) batches will be used within 1 week to 2 weeks of being prepared. It is unclear what impacts degradation will have on fish, but to be conservative, mix as small a batch as is practical to avoid impacts of anesthetic. Sites should try to minimize the amount of time that fish are in anesthetic to approximately 15 minutes or less. 4 Fry Handling Protocol: It is recommended that fry (Chinook or Coho ≤ 60mm TL) not be handled more than is necessary to collect information on the species and counts. It is preferred that sites avoid anesthetizing fry by netting them directly from the sample tank, if this is possible. In this case a sanctuary net should be used to remove these fish only if it is possible with minimal disruption to other fish. Chasing fish to capture them would increase stress to the fry and other fish in the holding tank so only net those individuals that can be easily captured with a sanctuary net. If fry are anesthetized, sites should work them up immediately but only for species identification and count purposes only. Fry are not to be examined as part of the condition monitoring, as this would mandate anesthetic and increase the time that they are handled. In general, sites should begin working up the smallest fish and fish that are deepest in anesthetic first and move to larger fish. 5 II.IntroductiontoFPC32.net II.A. The Fish Passage Center (FPC) The Fish Passage Center (FPC) provides current and historic data on salmon and steelhead passage in the main stem Snake and Columbia River Basins. Data from the Smolt Monitoring Program (SMP) are intended to provide the information basis for federal, state and tribal recommendations for fish passage in the Federal Columbia River Hydro-electric System. In addition to real-time access to SMP data, the FPC provides data about river conditions, hatchery releases, smolt migration and adult returns. The FPC plans and implements the annual Smolt Monitoring Program (SMP) that provides daily information for in-season management decisions. The FPC also provides the agencies and tribes, and the FPC Board of Directors, with reservoir operation information and analysis, including current and historical data. During the in-river migration season, FPC summarizes current conditions in a Weekly Report. FPC also provides web distribution of System Operation Requests (SORs) made by the Salmon Managers. SORs are requests to the U.S. Army Corps of Engineers to operate the federal hydrosystem to protect or enhance in-river fish passage and survival conditions. If you would like more information or to view Weekly Reports and SORs please visit our web page www.fpc.org, or contact our office at (503) 230-4099. II.B. Remote SMP Site Data Entry Program (FPC32.net) The FPC32.net data entry program was originally designed as an organized method of obtaining fish and water flow data from remote Smolt Monitoring Program sites. The software program has changed names slightly over the years, beginning with RSDEP (Remote Site Data Entry Program). Later it was ported to Windows and named FPC32. The current version is FPC32.net, Version 3.0.0.10. It has many improvements including a touch screen for entering fish condition data and the batch data entry is now done through forms. This manual has been provided for the biologist who input the data as a reference to assist in the operation of the FPC32.net program. It is essential that all SMP personnel who are responsible for entering fish data into the FPC32.net program and corresponding with the FPC read and understand this manual. If any questions arise, please call Brandon Chockley at the Fish Passage Center (503) 230-5362 with questions. After the manual is read by each individual SMP remote site staff member; please sign the form on the last page of the manual, which acknowledges that you have read the manual, and return the signed form to Brandon Chockley at the Fish Passage Center. 6 III.FPCContacts&Correspondence III.A. Personnel to Contact For Technical Help. Brandon Chockley – SMP Co-Manager (503) 230-5362 [email protected] Weekend number: 503-521-0184 Contact Brandon for questions about definition of a specific fish condition, change / addition to procedures, GBT questions, and questions on how to enter data or information using FPC32.net and how to run or use specific commands. Brandon is the principle contact for the SMP program. Jerry McCann – SMP Co-Manager (503) 230-4291 [email protected] Weekend number: 503-432-0676 Contact Jerry for questions about definition of a specific fish condition, change / addition to procedures, GBT questions, etc. Christopher McCarty - Computer Specialist (503) 230-4582 [email protected]. Weekend number: 503-851-1549. Contact Chris for computer hardware / windows and software setup technical problems, i.e. problems with computer hardware errors and issues. Lynnae Sutton – Data Management Specialist (503) 230-4290 [email protected] Weekend number: 503-720-8205 Contact Lynnae for questions about how to enter data or information about using FPC32.net and about how to use site-specific database management tools. Main Line / Voice (503) 230-4099 Leave a message at the front desk for other questions not identified here. III.B. Correspondence. Fax for hand logs – (503) 230-7559. Main SMP E-mail for batches and hand logs – [email protected]. Reposting E-mail – [email protected]. GBT E-mail – [email protected] FTP site – ftp.fpc.org. Web site – www.fpc.org. Mailing Address – 1827 NE 44th Ave., Suite 240, Portland, OR 97213. III.C. SMP Remote Site Facilities and 2013 Dates. Bonneville Dam Powerhouse 1 (BO1) – Pacific States Marine Fisheries Commission 7 Bonneville Dam Powerhouse 2 (BO2) – Pacific States Marine Fisheries Commission Grande Ronde River Trap (GRN) – Oregon Dept. of Fish and Wildlife Imnaha River Trap (IMN) – Nez Perce Tribe John Day Dam (JDA) – Pacific States Marine Fisheries Commission Lewiston Snake River Fish Trap (LEW) – Idaho Dept. of Fish and Game Little Goose Dam (LGS) – Oregon Dept. of Fish and Wildlife Lower Granite Dam (LGR) – Washington Dept. of Fish and Wildlife Lower Monumental Dam (LMN) – Washington Dept. of Fish and Wildlife McNary Dam (MCN) – Washington Dept. of Fish and Wildlife Rock Island Dam (RIS) – Chelan Public Utility District Whitebird Salmon River Trap (WTB) – Idaho Dept. of Fish and Game. Smolt Monitoring Dates for 2013 BO2 March 12 - October 31 GRN March 5 - May 26 IMN March 5 - May 26 JDA April 2- September 17 LEW March 1 - May 31 LGS April 2- October 31 LGR March 26- October 31 LMN April 2 - September 30 MCN April 2 - September 30 RIS April 2 - August 31 WTB March 1 - May 31 Send in your daily batch via email and your daily batch hand logs via fax or email. Send this information into FPC prior to the end of the business day or early the next morning. FPC should only lag one day behind the current day’s batch information. 8 IV.Glossary Bypass Facilities – Smolt bypass facilities, smolt bypass/collection facilities. These terms refer collectively to the mainstream dam remote SMP sites of BO1, BO2, JDA, MCN, RIS, LMN, LGS and LGR. Coded Wire Tag – A small piece of wire inserted into the surface of a fish’s nose, which has been coded with information about the origin of the fish. COE Daily Report – The US Army Corps of Engineers produces many hydrological reports containing measurements of various hydro system parameters. Descaled – For SMP basin-wide purposes, when a fish is at more than 20% descaled on either side as determined by ocular measurement, the fish is considered descaled, even if descaling was clearly caused by predation in which case it would be considered descaled “with predation marks present”. Descaled fish tagged with PIT tags that are entered into PTAGIS are segmented into three descaling categories: at least 10% descaled, between 10-20% descaled, and greater than 20% descaled. This last PTAGIS descaling category is similar to the basin-wide SMP definition of a “descaled” fish. Electronic Batch – The (.xml) file, which is sent from the remote SMP sites to FPC each sampling day of the fish migration season. This file is a text file formatted in xml notation. External Mark – Fish tags or marks, which are readable through simple visual inspection. Floy Tags, Freeze Brands, Elastomer Tags, and Visual Implant tags are examples of External marks. PIT tags and Coded Wire Tags are not considered external marks, since they are not readable through simple visual inspection. FPC32.net – The current Windows version of the Fish Passage Center’s Remote Site Data Entry Program for the Smolt Monitoring Project (SMP). This program can run under these operating systems: Windows XP or Windows 7. Freeze Brands – A form of external mark whereby a fish is branded with a mark using a super-cold branding iron. Ftp client – A program installed on a computer that enables the user to download files from FTP sites on the Internet using File Transfer Protocol (FTP). Gas Bubble Trauma Monitoring Program – Also referred to as GBT monitoring. This is a monitoring program, which examines fish after they pass through dams to monitor and measure biological effects from dissolved gas. Incidental Catch – Fish that are caught in the sample tanks at Remote SMP sites that are not one of the four main anadromous fish species whose passage is monitored in the Smolt Monitoring Program. The target species for the SMP are Chinook Salmon, Sockeye Salmon, Coho Salmon, Steelhead, and juvenile lamprey (both Pacific and Brook Lamprey). Julian Date – In Basin biological terms, the number of the day of the year, from 1365. In computer software terms, the number of days after Julius Caesar changed the Roman calendar from the old Roman lunar calendar to the new Julian Sun calendar in 44BC. KCFS – Kilo (or thousands of) cubic feet per second--a quantity measurement of liquid flow. A commonly used measurement scale at main stem dams in the Columbia and Snake River basin. 9 Major Species – The four anadromous salmonid species that are monitored in the Columbia/Snake River basin, Chinook (Oncorhynchus tshawytscha), Sockeye (O. nerka), Coho (O. kisutch), and Steelhead (O. mykiss). Mark Recapture – When an externally marked fish is recaptured and observed at an SMP remote sample site, it is called a “mark recapture” or “mark recap”. The marks that are considered “external” are elastomer tags; freeze brands, floy tags, and visual implants. PIT tags and coded wire tags and blank cheek tags are not considered external marks. Multiplier – The mathematical inverse of the sample rate, I.E. one over the sample rate. (1/sr) Pick List - Drop down menu, List Box, or any popup menu, which uses a scrolling highlighted bar to mark the desired choice. PIT tag – Passive Integrated Transponder Tag. This is an internal mark, which is used in the SMP predominately to measure travel time down the hydro system. SMP PIT tag marking sites are generally Rock Island, White Bird, Lewiston, Imnaha, and Grand Ronde. The PIT tag is a small glass cylinder approximately 1mm in diameter x 10 mm in length, which contains a small coil and chip which transmit a tiny 134.7 kHz radio signal when excited by a 134.7 kHz radio frequency signal. Raceway – Part of the juvenile bypass system at main stem dams that are transportation sites (LMN, LGS, LGR, and MCN). Raceways are large water troughs where the fish are stored awaiting transportation by truck or barge after they have passed through the bypass system and/or the sample tanks and recovery tanks. Rearing disposition – A fish is reared in the wild, or it is reared in a hatchery, or where it was reared is unknown. Remote site – The locations, (remote to FPC), where SMP sampling takes place. There are currently four remote sites that are fish traps in rivers, and seven remote sites at main stem dams on the Snake and Columbia Rivers. Repost – (revise and resend) – When an SMP batch of data is resent to FPC from a remote site for any reason, it is called a repost. Reasons for reposting a batch of data can vary widely and include such things as intermittent Internet email failure and erroneous data entry that was not picked up by the error checking algorithms. Separator – This is part of the juvenile bypass system at main stem dams, which have a juvenile bypass system. The separator is designed to let small fish pass through, and keep mini-jacks, jacks, and adults out of the juvenile bypass system. The separator is also part of the dewatering system in the juvenile bypass systems that removes water and increases the statistical density of fish within a given volume of water passing through the system. Smolt – An anadromous fish that is migrating down river, towards the ocean. In the SMP, the use of the term smolt almost always refers to the four monitored anadromous fish species. As a juvenile anadromous fish begin to move down river, morphological changes can occur to the juvenile fish. For example, some species will “silver up” or become more silver in color. As another example, fall Chinook will become more “football shaped” as they reach the time to migrate downstream. SMP – Smolt Monitoring Program, the program to monitor and evaluate the four main anadromous fish species in the Columbia/Snake River basin. 10 Sub-batch – Each batch of electronic data sent from the remote sites to FPC can contain multiple sub-batches, but not all batches do. Some batches only use the default sub-batch number for the entire batch, which is “01”. Usually, one creates a sub-batch for each change in the sample rate during a 24-hour sample. Up to 99 sub-batches can be made for each batch of submitted SMP data. Transportation – At LGR, LGS, LMN, and MCN, sometimes referred to as the four collector sites, juvenile anadromous fish headed downstream are collected and transported via barge or truck to a place in the river downstream from Bonneville Dam, where they are unloaded back into the river. The transportation program was created to attempt to mitigate the negative health effects on anadromous fish of in-river passage through the hydro system. Trap Facilities – This refers collectively to the remote site SMP river traps of LEW, WTB, IMN, and GRN. Validation process – In terms of the SMP, there are multiple levels of the “validation process”. First of all, a statistical quality control process is applied to the submitted electronic batches and hand logs, and any discrepancies and possible errors are brought to the attention of the remote site that submitted the batch for possible correction by the remote site. Secondly, each week during fish migration season a spreadsheet containing all of the data submitted year to date from a remote site is sent to the remote site to ensure that what FPC has in its database matches what the remote site has in its database. Wire Tag – A wire tag can be a coded wire tag (CWT) or a blank wire tag. NOTE: FISH CONDITION terminology is located in a separate manual. 11 V.SitebySiteSMPOverview Migration year 2013 is the fifth season when all SMP sites will be using FPC32.net for data entry. A detailed site-by-site overview is provided below which outlines what type(s) of data are being collected. Also, below is a brief step-by-step outline of how the various types of data will be entered and processed using the FPC32.net data entry program. 1. For the remote data entry sites (BO2, JDA, MCN, LMN, LGS, and LGR), once fish are in hand, site personnel will use the FPC32.net fish condition touch screen to enter detailed condition data (Section VIII.H). Trap sites (LEW, GRN, WTB) and RIS do not collect fish condition data and, therefore, will not use the condition touch screen. A more detailed description of sample sizes, target species, and condition definitions with examples is provided in Section I of this manual. 2. Simultaneously, all SMP site personnel will continue to tally information on non-condition fish in the sample, by species and clip-code using existing counting stations. These data will be recorded onto hand logs. 3. Once sampling is completed, detailed condition data will be transferred from the wet lab computer and imported into the office computer (Section VII and VIII). 4. Non-condition data will be entered from hand logs using FPC32.net (Section VII and VIII). Entry of non-condition data begins with the Catch screen, followed by the Catch Detail, Incidental Catch, and Mark/Recaptures. After non-condition data have been entered into FPC32.net, these data are validated (Section IX). 5. Condition data are then validated via the Conditions tab and/or Individual Fish Condition Report. After validation, condition fish are incorporated into the overall batch via promotion from the Summary Cond. tab. 6. Where applicable, after entering non-condition data and promoting condition data, transportation data are entered via the Transportation tab. 7. Reports are printed (Section X), and data are sent to FPC for posting into the central database (Section VII.K) and the FPC website. V.A. Bonneville Dam Powerhouse 1. No sampling will conducted at Bonneville Powerhouse 1 in 2013. V.B. Bonneville Dam Powerhouse 2. Smolts will be examined for various factors including species, fin clips, marking data, and detailed fish condition data, including descaling. Fish from the general population are obtained from a timed sub-sample of fish diverted from the bypass channel during a 24-hour interval between 7am and 7am daily. Examination of fish may occur throughout the 24-hour sample interval, as necessary. 12 GBT monitoring is conducted at this site. See Gas Bubble Trauma Monitoring Protocol and GBT.net Data Entry Program User’s Manual. V.C. Grande Ronde River Trap. Operate a scoop trap on the lower Grande Ronde River 5 km upstream of the mouth seven days per week for a 12-week period. The primary function of this site for SMP is to PIT-tag out-migrating smolts. V.D. Imnaha River Trap. Operate of the screw trap in the lower Imnaha River seven days per week. The primary function of this site for SMP is to PIT-tag out-migrating smolts. The Nez Perce Tribe provides data on fish collection based on a prior agreement, no funding is provided by SMP. V.E. John Day Dam. Smolts will be examined for various factors including species, fin clips, marking data, and detailed fish condition data, including descaling. Fish from the general population are obtained from a timed sub-sample of fish diverted from the bypass channel during a 24-hour interval between 7am and 7am daily. Examination of fish may occur throughout the 24-hour sample interval, as necessary.. V.F. Lewiston Trap. Operate a dipper trap on the lower Snake River at Lewiston for a 12-week. The primary function of this site for SMP is to PIT-tag out-migrating smolts. V.G. Little Goose Dam. Smolts will be examined for various factors including species, fin clips, marking data, and detailed fish condition data, including descaling. Fish from the general population are obtained from a timed sub-sample of fish diverted from the bypass channel during a 24-hour interval between 7am and 7am daily. Sample smolts from the collection for counts by species and clipped/unclipped status. Examine all unclipped yearling Chinook for coded wire tags. GBT monitoring is conducted at this site. See Gas Bubble Trauma Monitoring Protocol and GBT.net Data Entry Program User’s Manual. 13 V.H. Lower Granite Dam. Smolts will be examined for various factors including species, fin clips, marking data, and detailed fish condition data, including descaling. Fish from the general population are obtained from a timed sub-sample of fish diverted from the bypass channel during a 24-hour interval between 7am and 7am daily. Sample smolts from the collection for counts by species and clipped/unclipped status. Examine all unclipped yearling Chinook for coded wire tags. GBT monitoring is conducted at this site. See Gas Bubble Trauma Monitoring Protocol and GBT.net Data Entry Program User’s Manual. V.I. Lower Monumental Dam. Smolts will be examined for various factors including species, fin clips, marking data, and detailed fish condition data, including descaling. Fish from the general population are obtained from a timed sub-sample of fish diverted from the bypass channel during a 24-hour interval between 7am and 7am daily. Sample smolts from the collection for counts by species and clipped/unclipped status. Examine all unclipped yearling Chinook for coded wire tags.. GBT monitoring is conducted at this site. See Gas Bubble Trauma Monitoring Protocol and GBT.net Data Entry Program User’s Manual. V.J. McNary Dam. Smolts will be examined for various factors including species, fin clips, marking data, and detailed fish condition data, including descaling. Fish from the general population are obtained from a timed sub-sample of fish diverted from the bypass channel during a 24-hour interval between 7am and 7am daily. Sample smolts from the collection for counts by species and clipped/unclipped status. Examine all unclipped yearling Chinook for coded wire tags.. GBT monitoring is conducted at this site. See Gas Bubble Trauma Monitoring Protocol and GBT.net Data Entry Program User’s Manual. V.K. Rock Island Dam. Smolts will be examined for various factors including species, fin clips, marking data, and detailed fish condition data, including descaling. Fish from the general population are obtained from the bypass channel during a 24-hour interval between 7am and 7am daily. Sample smolts for counts by species and clipped/unclipped status. In additional another primary function of this site for SMP is to PIT-tag outmigrating smolts. 14 GBT monitoring is conducted at this site. See Gas Bubble Trauma Monitoring Protocol and GBT.net Data Entry Program User’s Manual. V.L. Whitebird Trap. Operate a scoop trap on the lower Salmon River above Whitebird for a 12-week period five days per week. The primary function of this site for SMP is to PIT-tag outmigrating smolts. 15 VI.SystemRequirements&ProgramInstallation The FPC32.net program was designed and tested on Windows XP. It has not been tested on newer Windows operating systems, but should operate properly in those environments. FPC32.net will not operate in Windows 2000 or older operating systems. VI.A. Hardware and Software. 1. PC Details: A PC running Windows XP with Service Pack 2 or later, with at least 512MB of RAM to run the FPC32.net program (1 GB recommended) and at least 1 GB of hard drive space (2 GB are recommended). 2. Software: A. FPC32.net runs on Windows XP and Windows 7. B. An internet e-mail connection capable of sending files attached with base 64 encoding. 3. Communication Devices: A. A printer (preferably a laser printer that understands PCL 4 or above) to print the daily reports. B. Access to a Fax machine or e-mail account to send daily hand logs to FPC. C. An appropriate modem or other types of communication hardware for other types of internet connections such as a cable modem, DSL or ISDN. D. A thumb drive or other portable device for carrying batch files (.XML files) from wet lab touch screen computer to data entry computer. VI.B. Procedure to Install the FPC32.net Program (including the fish condition touch screen) 1. 2. To install this program you will need to have Windows XP (or a newer version of Windows). NOTE: If you already have Windows XP with Service Pack 3 (or a more recent version of Windows), you do not need to install Microsoft .NET Framework 3.5 (or higher). Within File Explorer make a temporary directory to save the installation program files. In this procedure, this directory is referred to as c:\installfpc32net. 16 3. Ope en Internett Explorer and a go to fttp://ftp.fpc.o org/FPC32..net/. Rightt-click on setu up.exe and d choose Sa ave Targett As… Navvigate to c:\installfpc3 32net and d save this file f to this directory d LGR, LGS S, LMN, RIS, WTB, LE EW, and GRN – Rightt-click on TouchSc creenSetup p3.msi and choose Sa ave Target As… Navigate to c:\installlfpc32net and a save this file to this directory A, MCN – Right-click R o on TouchS ScreenSetu up3_lampre rey.msi BON, JDA and choose Save Ta arget As… Navigate tto c:\installlfpc32net a and save this file to o this directo ory 4. ce the files have been saved to yyour local ha ard drive, u using File E Explorer, Onc nav vigate to c:\\installfpc3 32net and d double-clickk on the Tou uchScreenSetup3.ms si (or Touc chScreenSe etup3_lam mprey.msi) file to beg gin the insta allation proc cess Notte: If you are a installing g this from a CD, open n File Explo orer and na avigate to t the direc ctory of the CD and do ouble-click o on the TouchScre T eenSetup3 3.msi or TouchScreen nSetup3_la amprey.ms si. This s program requires r .NET Framew work Versiion 3.5 (or better) and d Mic crosoft 200 05 SQL Exp press editio on software e packages to be insta alled. Afte er you doub ble-click on the .msi file e, you will b be prompte ed to install .NET Framework Ve ersion 3.5 (if you don’t already h have it). Cho oose Yes 5. 6. 17 Afte er selecting Yes, your default inte ernet browsser will open n to the UR RL http p://msdn.mic crosoft.com m/en-us/nettframework//aa569263.aspx. If the dialog box b asking you to cho oose Yes to o install .NE ET Framew work does no ot appear, manually m op pen Interne et Explorerr and open the URL htttp://msdn.m microsoft.co om/en-us/ne etframeworrk/aa56926 63.aspx OR R Go to ftp://ftp p.fpc.org/FP PC32.net/, rright-click o on the file d dotnetfx35..exe and ch hoose Save e Target as s, and navig gate to a te emporary file on your h hard drrive and sav ve the file. Double-clicck on the file to begin the installa ation of the .NET fram mework. OR O If you are ins stalling this from a CD,, double-click on the fiile dotnetfx x35.exe fro om the CD directory and follow th he installation procedu ure promptss, using de efault prompts. 8. From the http:///msdn.microsoft.com//en-us/netfrramework/a aa569263.a aspx web bsite, selectt the INSTA ALL IT NOW W button. 7. 9. ce the .NET T Framewo ork 3.5 insta allation pro ogram has ccompleted Onc dow wnloading, choose c to Run R the pro ogram. 18 10. Afte er you choo ose to Run the program m, the computer begin ns downloading and installing the .N NET Frame ework 3.5 ssoftware. NOTE E: If you re eceive a me essage thatt the .NET fframework is already iinstalled on yo our compute er, proceed d to the nexxt step. 11. Onc ce the insta allation of th his software e is complette, you will also be req quired to install Microso oft SQL 2005 Express s. wnload Mic crosoft SQL L 2005 Exp press from the FPC w website 12. Dow ftp:///ftp.fpc.org/FPC32.ne et/ by right-cclicking on tthe file SQL LEXPR.EX XE and cho oosing Save e Target as s. Navigate e to a temporary file on n your hard d drive and d save the file. 13. Dou ow all uble-click on the SQLE EXPR.EXE file to begiin the installation. Follo prom mpts and accept a all de efault settin ngs. 14. Onc ce the .NET T Framewo ork 3.5 and the Micros soft SQL 2 2005 Expre ess edittion have be een installe ed on your llocal compu uter, open File Explorrer and nav vigate back to C:\insta allfpc32.nett. Double-cclick on the e Tou uchScreenSetup3.ms si (or TouchScreenSe etup3_lamprey.msi) file. 19 15. Follow the prompts and accept a all de efault settin ngs. The program will place an icon on you ur desktop called c Fish Condition n. This is th he FPC32.n net prog gram, which includes the t batch d data entry a and the fish condition ttouch scre een. NOT TES: The .NE ET Framew work 3.5 an nd the Micro osoft SQL 2005 Exprress edition only o need to t be downlloaded and d installed o once. If you already have e Windows s XP with S Service Pac ck 3 (or a n newer version of Window ws), you do o not need tto install Microsoft .NET Framew work 3.5. VI.C. V Prrocedure e to Insttall New west Vers sion of F FPC32.n net and Uninstal U ll an Old der Vers sion 1. If yo ou want to install i a new wer version n of FPC32.net, you m must first un ninstall the old version n. To unins stall the olde er version o of FPC32.n net, choose Start | Settings | Con ntrol Panell. 2. 3. From within Co ontrol Panel, select A Add Remov ve Program ms. dd Remove e Program ms, select FishConditiion3 and ch hoose From within Ad Rem move. 20 4. 5. A dialog box appears ask king you to confirm the e removal o of FishCond dition3, cho oose Yes to o uninstall FishCondit F ion3. Follo ow the prom mpts to unin nstall the prog gram. Afte er the progrram has been uninstal led, follow the instructtions for insstalling FPC C32.net (Se ection VI.B B above). NOT TE: Uninsta alling FPC32 2.net and in nstalling a n newer version can som metimes lead to an a Error message m sta ating that th he MS SQL L Server Da atabase could no ot open and d that the u user should contact the eir system adminis strator. The e FPC data staff has o only encoun ntered this iissue once bu ut has deterrmined thatt is usually means thatt there is a problem with Mic crosoft SQ QL 2005 Ex xpress. If yyou encounter this problem, please call c Lynnae e Sutton at FPC and she will walkk you through a procedu ure to prope erly uninsta all Microsofft SQL 200 05 Express s. Uninsta alling Microsoft SQL 2 2005 Expre ess is not e enough and d will not remedy y this proble em. VI.D. V Prrocedure e to Allo ow Full C Control for Wind dows 7 Operrating Sy ystem When W FPC3 32.net is ins stalled on a machine w with Window ws 7 operatting system m, the user may ex xperience problems p wh hen trying tto save new w records. These prob blems may m occur each e time FPC32.net is s uninstalle ed and reinsstalled. The FPC stafff has fo ound that th his is often a permissio ons issue th hat can affe ect whetherr SQL Exprress 21 database file es can be written w to by y the curren nt user. If tthis is the case, the usser will ty ypically get one of the following tw wo error me essages wh hen trying tto create a new batch. The T first erro or message e appears to o be an “Un nhandled E Exception E Error” with a message m tha at appears when the user u attemp pts to save a new reco ord. This errror message m sta ates something to the effect of: C:\Program C m Files (x86 6)\Fish Pas ssage Centter\FishCo ondition3\D Data\fpcFis sh.dbf is re ead only. A similar errror may occ cur when starting the p program aftter it is insta alled or rein nstalled. This T error sttates: Catch Info o Table not found…Una f able to open n the physiccal file C:\Prrogram Filees (x86)\Fish Passage Center\FishCo ondition3\D Data\fpcFish h_log.ldf.” O Operating system error 5: “5(Access is denieed)”. ault database. Login faailed. Cannot open user defa ure for user ‘…………… ……….’. Login failu File activattion failure.. The physiccal file nam me “C:\Progrram Files (xx86)\Fish Passage Ceenter\FishC Condition3\D Data\fpcfish h_log.ldf” m may be incorrrect. Below B is a brief b descrip ption of how w to remedyy both these e errors. 1. Navig gate to the directory: d C:\Program C m Files (x86 6)\Fish Pas ssage Cente er\FishCon ndition3\Da ata 22 2. Right-click on th he file name ed fpcFiish.mdf and select Properties. Thiis will open the fpcFiish Properties dialog box. 3. Click on the Sec curity tab and a se Users among the list of choos Grou up or User Names 4. Once e Users has s been sele ected, look to t see if Full Control has a check k mark nextt to it in the e list of Perm missions fo or Users. 5. If it do oes NOT, select s the Edit E button n. Select Users again and check k the Full Control C box x. Click Apply y and then OK. gate to the directory: d 6. Navig C:\Prrogram File es (x86)\Fis sh Passage Cente er\FishCon ndition3\Da ata ed 7. Rightt-click on the file name fpcFiish_log.LD DF and select Properties. Thiis will open a dialog g box titled Data Prop perties. 8. Click on the Sec curity tab and a choos se Users among the list of Grou up or User Names 9. Once e Users has s been sele ected, look to t see if Full Control has a check k mark nextt to it in the e list of Perm missions fo or Users. oes NOT, select s the Edit E 10. If it do button n. Select Users again and check k the Full Control C box x. Click Apply y and then OK. 23 VIII.Overviewo ofFPC3 32.NET TProgrram VII.A. V Running R the FPC C32.net Program m and Se elect Se ettings 1. 2. Onc ce FPC32.n net is installed an icon will appea ar on your desktop. Dou uble-click on the FishC Condition iicon on you ur computer desktop. This s opens the e program. By default, the progra am is set to o open to the Batch Datta Entry Sc creen and a an icon is p placed in yo our system ttray (low wer right hand corner). Right-clic k on the FP PC32.net/F Fish Condittion icon in th he system tray t and choose Settin ng. The settting dialog box appea ars. From this dialo og box, you u can choosse whether you want th he Fish Co ondition Tou uch Screen n as the prim mary data e entry scree en. Computters located d in the wet lab should be set to have h the Fis ish Conditiion Touch Screen as the mary data entry e screen n upon open ning the pro ogram. Co omputers located in prim the office shou uld be set to o have the B Batch Data a Entry Sc creen as the e primary data a entry wind dow upon opening o the e program. To make m the Fish F Condittion Touch h Screen th he primary e entry scree en, select the Fish Cond dition Touc ch Screen Only checkkbox (see ffigure below w). Com mputers in the t wet lab should be configured in this man nner. 24 3. 4. 5. 6. 7. 8. Regardless of which computer you are configuring, the Settings dialog box can also be used to set many of the default settings for SMP sites, including: Site, Gear Code, Sample Rate(s), Start Hour, and End Hour. i. Site: enter your site in the Site box by choosing a value from the Site Code drop down list. ii. Gear Code: enter a default gear code by selecting a value from the Default Gear Code drop-down menu. A gear code of MT will not be allowed at the dams, and a gear code of GC will not be allowed at the traps. iii. Sample Rate(s): enter the default sample rates for your site and subbatches, by choosing a value from the Select Default Sample Rate drop-down menu for Sub-batch 1 and Sub-batch 2. Sample rates for additional sub-batches will be entered later in the data entry process. A sample rate of greater than 1 and less than 0 will not be allowed. iv. Start and End Hour: enter the default start and stop hours, in military time, ranging from 0000 to 2400. v. Trap Location: if you are at a trap location, the trap location field appears in the site configuration screen, otherwise it does not. The Batch Export Directory button is used to specify where your batch records (i.e., .XML file) will be stored on your PC. Use the Browse button to browse to the directory where you want these files to be saved. NOTE: Regardless of whether the wet lab or office computer is being used to generate the XML file, the file is named in the same convention. It is imperative that the sites recognize this and do not confuse the two files. The file that is generated by the wet lab computer can be renamed if site personnel choose (see Section VI.B.2 below). The XML file that is generated by the office computer is the only file that will be processed by the FPC (see Section VI.K below). The Batch Import Directory button is used to specify which directory FPC32.net will look in for XML files to be imported. If you want to use the same directory as the Batch Export, press the Same as Export button. Otherwise, use the Browse button to browse to the directory where you want these files to be imported from. FPC32.net has built-in sounds that prompt users when certain functions have been performed or need attention. To hear these messages, the Play Sound Checkbox must be checked. NOTE: to hear messages, speakers need to be connected to the computer. If desired, sites can have their batch files (i.e., XML files) sent directly to FPC upon completion. To do this, site personnel must enter [email protected] in the e-mail dialog box in the settings screen. It is NOT mandatory that sites do this. FPC32.net allows for up to three user defined comments that can be incorporated in the Comments2 drop-down menu of the Catch data entry tab. These comments are labeled as Custom Comment 1, Custom Comment 2, and Custom Comment 3 in the Setting screen. If you have a comment that you want to enter repeatedly (that is not already in the dropdown menu) you can type that comment in one of these three text boxes. 25 Any text that is entered into these text boxes will automatically show up in the Comment2 drop-down menu. 9. The Delete Prev Year and Delete Old buttons delete the batches stored in the local database (except the current day’s batch). These buttons should only be used to clean the database. The Delete All button deletes all of the records in the local database. 10. Once you are finished with the Settings dialog box, choose Save Setting to save the settings you have entered. A dialog box appears prompting the user to restart the application for the setting changes to take effect. Select Yes and the application will Exit. VII.B. Entering Fish Condition Data Via the Touch Screen Species, Length, and Sub-batch data are required in the Fish Condition touch screen in order for records to be saved successfully. Weight is not required, however, some of the sites collecting fish condition data will collect weight as a part of the fish condition dataset (except for incidental species). By default, the Sub-batch number on the first record is set to 1. To change sub-batch for the first record press the Sub-batch button as many times as is necessary to get to the desired sub-batch number. If the sub-batch number is incorrect, choose Clr. Sub-batch. The sub-batch number is carried forward from the previous record until it is changed. To enter a Tank, press the appropriate Tank button (either Tank A or Tank B). The tank letter is carried forward to the next record from the previous record until it is changed by the user. Sites that do not have separate tanks will not see a Tank button. To enter a Species and Clip type, choose the appropriate Species-Clip button. For example, CH1 is for unclipped yearling Chinook, CH1-AD is for an adipose fin clipped yearling Chinook. If the species is an incidental species choose Miscellaneous Incidental Species and choose the appropriate button from the pop-up menu. To enter specific fish condition data, press the appropriate button on the touch screen. For a detailed description of each of these buttons and what types of data should be entered, see Section VIII.H below The data are saved to the database behind the touch screen and appear on the bottom left corner of the touch screen. Most of the buttons are toggle buttons, which means that pressing the button once adds the selected condition to the fish record and pushing the same button again removes the condition from the fish record. There are some buttons where only one choice can be selected. These include: Species or Species Clip, Special Species, Descaling, and Elastomer Tag Orientation/Color buttons. VII.B.1. Brief Overview of Steps to Entering Fish Condition Data via the Fish Condition Touch Screen 1. To enter fish condition data with the Fish Condition touch screen, doubleclick on the FishCondition icon on the desktop on the wet lab computer. A dialog box appears with three buttons. The Batch End Day Today button 26 crea ates a batch with the end e date m atching tod day’s date, tthe Batch E End Day Tom morrow buttton creates s a batch w with the end d date matcching tomorrrow’s date e, and the Batch B End Day Yeste erday butto on creates a batch with h the end date e matching yesterday’s date. Th e Batch En nd Day Tom morrow bu utton sho ould only be e used if a sample s is being worke ed up early. The Batch h End Day y Yesterday button sh hould only b be used if a sample is being workked up afte er being held for 24-ho ours. Click on one of these button ns to create e a new batc ch. If a batch alrea ady exists in n the local database w with a particcular “Batch h End Day y”, a pushpin icon appears next to o the corresponding “B Batch End d Day” buttton. Touch scrreen for LGR R, LGS, and L LMN for 2013 3 27 Touch screen s for BO ON, JDA, and d MCN for 20 013 (incorporrates conditiion monitorin ng for lamprey juveniles). Note: N BON and JDA scre een does nott have Tank B Clip/Unclip p Tally 2. 3. 4. 5. The e Fish Cond dition touch screen the en appears. The backkground pan nel app pears gray until u you se elect New. Sele ect New to enter a new w fish cond dition record d. The bacckground pa anel turn ns white, me eaning thatt the compu uter will acccept data. T The New button disa appears and d a Save/N New button appears. IIf the backg ground panel is gray y, the comp puter will be eep when yyou press a button beccause it is n not in the New w or Edit mode. m In ad ddition, the Species, W Weight, and d Length fields in the lower left hand h cornerr are highlig ghted in yelllow. This a allows to usser to ee when these data arre entered into the pro ogram. morre clearly se Turn on the sc cale and ad dd the tray ((the scale a automatically tares or calibrates to co ompensate for the weiight of the ttray), place e the fish in the tray, and d press the Print button on the sccale. It is imporrtant that yo ou press th he Print buttton on the scale only once Once a weight w has been b entere ed, the weig ght field will turn from yellow to white and d the corres sponding we eight will ap ppear. If this weiight is incorrrect, presss the Clear Weight button on the touch screen an nd then pre ess the Prin nt button on n the scale Ente er the fish length using g the touch h screen number pad. Using the number pad d on the touch screen automatica a ally shifts the focus to tthe length ffield. Once a le ength has been b entere ed, the leng gth field will turn from yyellow to white and d the corres sponding le ngth will ap ppear. If this leng gth is incorrrect, press the Clear L Length buttton on the touch screen an nd then re-e enter the co orrect lengtth 28 Press the appropriate Species, Clip, and Other Condition buttons. Once a species has been selected, the species field will turn from yellow to white and the corresponding species code will appear 7. For those sites with tanks, the Please Enter Tank/Trap warning will disappear once a tank is chosen. Records cannot be saved until a tank is chosen. 8. If a comment needs to be entered, press the General Comment button and type the comment using the touch screen keyboard pop-up. The user can enter up to two comments or codes in this field separated by a semicolon. 9. Press Save/New to save the individual fish record. The Save/New button also automatically starts a new record for the next fish. Follow steps 4 through 8 for each subsequent fish in the condition sample. NOTE: The scale will occasionally need to be zeroed between fish by pressing the Tare button. 10. Once the last fish has been entered and the Save/New button has been pushed, push the Cancel button to end data entry 6. VII.B.2 - Exporting Daily Fish Condition Records from the Wet Lab Computer: Typically, condition records are entered on the wet lab computer and the batch records are entered on a different computer in the office. Therefore, the daily condition records must be saved to an .XML file on the wet lab computer which is then imported into the office computer. 1. 2. 3. 4. After completing the fish condition records, press the Export button on the lower right corner of the touch screen. This action creates an .XML file for the current batch that contains all of the fish condition records. This file is saved in the location specified under the Setting dialog box for this computer. FPC32.net uses the following naming convention for these exported .XML files: the first three characters are the site code, followed by a two digit year and three characters corresponding to the Julian day of the batch sample end date (1-366 days). From the wet lab computer, open Windows Explorer and navigate to where the daily batch .XML files are saved. Insert a portable storage device (e.g., thumb drive or floppy disk) into the wet lab computer. The computer may open a directory for the portable storage device. Highlight the current day’s batch or the batch you want to transfer to the office computer by clicking on the file name. Choose Edit | Copy. 29 5. 6. With hin Window ws Explorerr, navigate tto the porta able storage e device an nd cho oose Edit | Paste. P The e current da ay’s fish co ondition data a are now sstored on the portable sttorage devic ce. At this po oint, you can n rename th he fish condition XML file in orde er to avoid con nfusing it wiith the final batch file tthat will late er be saved d and sent to FP PC. To renam me the fish condition c X ML file in th he portable storage de evice, right click k on the file and choosse Rename e. You musst leave the first eight characters of the original file name in ntact and o on the left hand side. Forr example, the t file nam med BO211 1100.XML ccould be renamed BO21110 00Cond.XM ML. The e portable storage s dev vice needs tto be removved from th he wet lab com mputer. If th he portable storage de evice is a th humb drive,, right click on the Saffely Remov ve Hardwarre icon in th he system ttray, and ch hoose Safe ely Rem move Hard dware. A dialog box a appears, hig ghlight USB B mass storrage dev vice and pre ess Stop. Another A diallog box app pears, again highlight USB mas ss storage device d and press OK. A system message a appears sta ating that it is alright to re emove the USB devic e. Remove e the USB d drive and go o to the offic ce compute er. VII.C. V Im mporting g a Batc ch From the Con ndition S Sample or Crreating a New Batch B Creating C a new n batch in n the Catch h Data Entrry Tab Form m (i.e., Main n Form) de epends on whether condition c data were co ollected or not. If cond dition data were colleccted (as n Section VII.B V above), the batch h data from the condition sample is described in im mported into o the Batch h Data Entry Screen (i.e., Main Form) for e editing and entering non-conditio on data (see e Section VII.C.1 V belo ow). If no ccondition da ata were co ollected, 30 a new batch h record can n be created from with hin the Main n Form (se ee Section VII.C.2 below). .. VII.C.1 - Importin ng Daily Fish F Cond dition Re ecords intto FPC32 2.NET Main Form 1. 2. 3. 4. 5. From the office e computerr, double click on the F FishCondittion icon on n the des sktop. The office comp puter should be config gured so tha at the Main n Form ope ens by default. The Ma ain Form w window ope ens with the e Catch tab b forw ward. Cho oose the bu utton Imporrt from Battch. An open dialog b box appearss. Nav vigate to yo our portable e storage de evice and cchoose the batch you w want to imp port data fro om. Click on n Open (se ee picture below). e Main Form m displays the batch ffrom which fish conditiion recordss were The just imported in n the Catch h tab. Sele ect the batcch with the ffish conditio on reco ords you jus st imported d by clicking g on the reccord in the d data grid. S Selected reco ords have an a arrow be eside the ba atch. Cho oose Edit. This puts the selected d record intto the form at the top o of the pag ge, allowing the user to o edit the da ata fields in n the upperr portion of tthe scre een. From this point, users sho ould enter b basic Catch h data, including: 1) S Start Tim me, 2) End Time, T 3) Gear Code, 4) Sample e Code, 5) S Sample Ho ours, 6) 31 6. 7. 8. Total Discharrge, 7) Pow werhouse 1 flow, 8) P Powerhous se 2 flow (iff app plicable), 9) Total Spill, and 10) a any Comme ents (Comm ments 1 or Com mments 2) that pertain the entire e batch. Notte: The starrt time, end d time, and gear code will automa atically set tto the defa ault values that were entered e into o the Settin ngs dialog b box. For a deta ailed descrription of ea ach of these e fields and d what typess of data should be e entered, see s Section n VIII.A.1 b below Cho oose Save Record bu utton. Data entered into the Cattch tab sho ould be reviewed and vvalidated att this nt. poin Proceed to Section VII.D D. VII.C.2 - Creating a New Batch Re ecord Dirrectly from m the FPC32.n net Main Form F (forr sites wh here no c condition data are colle ected): 1. 2. From the office e computerr, double click on the F Fish Condition icon o on the des sktop. The office comp puter should be config gured so tha at the Main n Form ope ens by default. The Ma ain Form w window ope ens with the e Catch tab b forw ward. From within the e Catch tab b, choose N New Batch h End Day T Today to ccreate a new w batch with h the EndD Date matching today’s date. To ccreate a new w batch with h the endda ate matching tomorrow w’s date, se elect New B Batch End Day Tom morrow. To create a new batch with the En ndDate matching yestterday’s date e, select Ne ew Batch End E Day Ye esterday For all sites except LEW L and W WTB, the ba atch numbe er and site a are automatic cally genera ated based on the info ormation se elected in th he Settings dialog box and by the e current da ate on your computer. The 32 3. 4. 5. LEW and WTB sites will have to select the Site for which data are to be entered. To do this, select the Site from the Site Drop-down menu (located on the right-hand side). From this point, users should enter the remaining Catch data, including: 1) Start Time, 2) End Time, 3) Gear Code, 4) Sample Code, 5) Sample Hours, 6) Total Discharge, 7) Powerhouse 1 flow, 8) Powerhouse 2 flow (if applicable), 9) Total Spill, and 10) any Comments (Comment 1 or Comment 2) that pertain the entire batch. Note: The start time, end time, and gear code will automatically set to the default values that were entered into the Settings screen. Choose Save Record. Proceed to Section VII.D. VII.D. Entering Non-Condition Fish Data (Catch Detail) If all fish sampled that day were condition fish (and no mortalities were encountered), you may skip this step and move onto Section VII.E. Otherwise, once the Catch data have been entered, the next step is to enter the non-condition sample data via the Catch Detail tab. To select the Catch Detail screen for data entry, first select the record for the batch you want to add data to by clicking on the batch record in the data grid at the bottom of the Catch screen. A selected record has an arrow beside it. Second, select the Catch Detail tab. For a detailed description of data entry fields in the Catch Detail tab, see Section VIII.B below. Below is a brief overview of how to enter a single record of non-condition sample data: 1. 2. 3. 4. From the Catch Detail tab click on the New button Fill in the correct sub-batch and tank information for the record you wish to enter. Choose the appropriate Species, Age, Clip, Coded Wire Tag, and Special Species information for the record you wish to enter When entering the first record of a sub-batch, the program applies the default sample rate for that sub-batch. If this is not the sample rate that was used, you must change the sample rate/multiplier to the correct value. Use the Multiplier drop down menu to choose from the list of standard sample rates/multipliers. If a non-standard sample rate was used, you may enter this value directly into the Sample Rate field (this value must be between 0 and 1). The sample rate for a single sub-batch is carried forward to the next record from the previous record until the sub-batch number is changed by the user. Given this, it is critical that you verify that the sample rate for each subbatch is correct before saving the first record of each sub-batch. Section VIII.B provides detailed information for correcting the sample rate if you find that the wrong sample rate was entered for a sub-batch. 33 5. 6. 7. 8. 9. Enter Non-Cond. Sample Count, Num Exam for descaling, Num descaled, Sample Morts, Facility Morts, Research Morts, and PITTag Morts (where appropriate). When sample code is NOT GB, the field for Num Exam for Descaling will calculate automatically based on what is entered into the NonCond. Sample Count and Sample Morts fields for all species and special species combinations (except for lamprey juveniles and fry) using the following equation: Num. Exam for Descaling = Non-Cond. Sample Count – Sample Morts This assumes that 100% of non-condition fish were examined for descaling. If this is not the case, you may over-ride the calculated value of Num. Exam for Descaling after entering the Non-Cond. Sample Count and Sample Morts. Descaling is not assessed on GBT fish, lamprey juveniles, or fry, so the Num. Exam for Descaling for these records is assumed to be 0. When the entry is complete, choose Save/New .The Save/New button also automatically starts a new record for this batch. Follow steps 4 through 6 for each subsequent record to be entered. Once the last record has been entered and the Save/New button has been pushed, push the Cancel button to end data entry for this screen. Once all non-condition records have been entered, these data should be validated from the hand logs by printing or viewing the Daily Batch/Tank Report and/or the Lamprey Batch/Tank Report. To view these reports, chose Reports and select Daily Batch/Tank Report and/or Lamprey Batch/Tank Report. A separate report can be generated for each sub-batch that was entered. It’s best to do this level of validation prior to incorporating the condition data into the Catch Detail tab via promotion (see Section VII.H). Note: There are several fields on the Catch Detail tab that are inactive (i.e., grayed out). These are fields that are either calculated (e.g., Est. Collection, Cond. Collection) or are incorporated into the batch upon promotion of the Condition Data. (e.g., Cond. Sample Count, Num. Cond. Exam for Descaling, etc.). 34 VII.E. V Entering Incidental Catc ch Data Once O the Ca atch Detail data have been enterred, the nexxt step is to o enter the noncondition inc cidental spe ecies data via v the Incidental Cattch tab. Forr a detailed d description of o data entrry fields in the t Inciden ntal Catch ttab, see Se ection VIII.C C below. To T create a new record d in Inciden ntal Catch click on the e New butto on to add a record. Only O inciden ntals collectted as part of the non--condition d data are enttered into th he In ncidental Catch C tab at a this point. Data to e enter for eacch incidenta al species iinclude: 1) Species, 2) Sample e Count, an nd 3) Samp ple Morts. When the e entry of a ssingle omplete, ch hoose Save e Record. species is co Note: N Cond d. Count wiill be filled in n automaticcally when Condition D Data are in ncorporated d into the ba atch (see Section S VII..H). ncidental Catch C data should be validated b by printing o or viewing the Inciden ntal In Catch C summ mary report. To view th his report, cchose Repo orts and se elect Incide ental Catch. C If Co ondition Da ata include incidental sspecies, thiss validation n step should be done prior to o incorporating the con ndition data a into the In ncidental C Catch tab via promotion (s see Section n VII.H). 35 VII.F. V Entering Mark/Re ecapture e Data Once O the Inc cidental Ca atch data have h been e entered, the e next step p is to enterr the noncondition Ma ark/Recaptture data by selecting the Mark/R Recaptures s data entryy tab. For F a detaile ed description of data entry fieldss in the Marrk/Recaptu ures tab, se ee Section S VIIII.D below. To T create a new record d in Mark/R Recaptures s click on th he New buttton to add a record. Only O mark/re ecapture da ata for non--condition ffish are ente ered into th he Mark/Recap M ptures tab at a this point. Mandato ory data forr each markk/recapture record in nclude: 1) Tank T (where e applicable e), 2) Spec cies, 3) Age e, 4) Mark Type, 5) Ta ag Color, C 6) Clip Code (c chose N/A if i fish is un nclipped a and not CW WT), and 7) Tally Total. T Location for Elastomer Tags is pa art of the Ma ark Type co ode, so Tag g/Brand Lo oc is NOT N require ed for Elasto omer Tags. Tag/Bran nd Loc, Bra and Code, Brand Orientation O , Tag Num mber, Supplemental C Code, and L Length are e NOT mand datory. When W the en ntry is comp plete, choose Save Re ecord. Ma ark/Recaptu ure data sh hould be validated by y printing or viewing Ma ark Recaptture Summ mary Report. To view this re eport, chose Reports and select Mark Reca apture. If C Condition D Data include e Mark/Recap M pture data, this t validation step sho ould be don ne prior to incorporatin ng the condition da ata into the Mark Reca aptures tab b via promo otion (see S Section VII..H). 36 Note: Cond. C Coun nt and Tota al Count wiill be filled iin automatiically when Conditio on Data are e incorporatted into the e batch (see e Section V VII.H). VII.G. V Validatin V g Condiition Data Once O the Ma ark Recapttures data have been entered, th he next step p is to valid date the condition da ata by selec cting the Co onditions d data entry ta ab. For a d detailed desscription y fields in th he Conditio ons tab, se ee Section VIII.F below w. of data entry Validation V off condition data can be e done in tw wo ways: 1. Individual fish condition records ca an be viewe ed for valida ation directly from nditions tab b. By clickiing on the ccolumn hea ader, the data grid in the Con ecords can be sorted fo or easier viewing. Sorting by mu ultiple colum mns is re also possible e, simply ho old the Shifft key while e selecting tthe sequence of co olumns you wish to sort by. If errrors are fou und, recordss can be ed dited directly from the Condittions tab (ssee Section VIII.F for more detaiils on ed diting and in nstructions on group e editing). 2. Individual condition can also be vie ewed via th he Individual Fish Co ondition Re eport. To validate co ondition datta in this ma anner, choo ose Reportts and se elect the Ind dividual Fish Conditiion Reportt from the d drop-down m menu. Th his report may m be revie ewed or priinted for va alidation. If errors are ffound, re ecords can be edited directly d from m the Conditions tab ((see Sectio on VIII.F for more deta ails on editing). 37 VII.H. V Promotin P ng Condition Da ata into tthe Batc ch Once O the Co ondition da ata have be een validate ed and edite ed (when a applicable), the next sttep is to inc corporate condition sa ample data into the battch (Catch Detail, In ncidentals, Mark/Rec captures) by b selecting g the Summ mary Cond. data entryy tab. For F a detaile ed description of the Summary S C Cond. tab a and its functtions see S Section VIII.G V below w. To T incorpora ate conditio on sample data d into the e batch, select the Summary Co ond. tab and click on the Promo ote All butto on. When condition ssample data a are incorp porated in nto the Catc ch Detail ta ab, the sam mple countss for conditio on fish will appear in tthe Cond. C Samp ple Count column. Note: N If all fiish sampled d were condition fish, before prom moting, the e user must first enter the sample rate fo or each sub b-batch tha at was enterred using th he touch sccreen. The T default sample rate e(s) are listted but need to be che ecked and ccorrected (w when applicable). To do this, right click in the Sam mple Rate ccell in the C Condition SubBatches S s box at the e top of the e Summary y Cond scre een (A in fiigure below w). This allows you to o manually enter the sample s rate e for each in ndividual su ub-batch that was entered into the touch screen. s On nce this is d done, click o on the Prom mote All button. When W condition sample e data are incorporate ed into the C Catch Deta ail tab, the ssample 38 counts for co ondition fish h will appea ar in the gra ayed area o of Catch Detail tab an nd the Cond. C Samp ple Count column of the t data griid (Red box xes in figu ure below). A 39 IMPORTANT: The Cond. Sample Count, Num Cond. Exam., Num Cond. Descaled, and Cond. Collection fields cannot be edited. If an error was made in the fish condition records, these data need to be edited in the Conditions tab and then re-promoted (from Summary Cond.) for edits to take effect. VII.I. Entering Transportation Data Once the Condition sample data have been incorporated into the batch, the next step is to enter the Transportation data via the Transportation tab. For a detailed description of data entry fields in the Transportation tab, see Section VIII.E below. There are two ways to enter data using the Transportation tab. The first is manual data entry where each Tank, Species, Age, Clip, CWT, and Special Species (EF and Fry) combinations from that day’s batch are manually entered, one-by-one. Lamprey Juveniles are NOT to be entered into the Transportation Data Entry Tab. The other is to import the Tank, Species, Age, Clip, CWT, and Special Species (EF and Fry) combinations from the Catch Detail data entry screen, using the Import button. For a more detailed discussion of each of these methods, see Section VII.I.1 and Section VII.I.2 below. Regardless of which method you chose to use, you must know what your collection counts were for each Tank, Species, Clip, CWT, and Special Species code (EF and FR) combination. This information is summarized for the entire batch in the Daily Batch/Tank Report, which can be generated by selecting Reports and choosing Daily Batch/Tank Report (All – Subbatches) from the drop-down menu. This report should be printed. The data that are to be entered into the Transportation tab can be found in the rows labeled “Total Collection” and “Sample, Facility, Research Morts” (i.e., mortalities) (see figures below). NOTE: For each tank, all columns should be entered into the Transportation tab as separate records. Holdovers and Lyons Ferry fish are included in the UC, CWT, or CL columns for Chinook 1. Due to the collection of fish for NOAA marking, LGR is the only transportation site that cannot enter EF Steelhead separately. Unclipped steelhead should be entered as a single record at LGR. 40 VII.I.1 – Manual Entry of Transporrtation Data 1. 2. 3. 4. To create c a ne ew record in n the Trans sportation data entry screen click on the New w button to add a reco ord. Ente er the Tank k, Species,, Clip, CWT T, and Spe ecial Specie es code (EF and FR)) combinatio on for the record you w wish to crea ate Ente er the Num m. Bypasse ed, Num. Trrucked, an nd/or Num. Barged for each new w record. These T numb bers are de rived from tthe “Total C Collection”” minus tota al “mortalitiies” in the Daily D Batch h/Tank Rep port (All – S Sub-batche es). In the cas se when two day’s sam mples are b being transp ported toge ether, the Daily Battch/Tank Report R (All – Sub-batc ches) for e each of thesse batches will w have to be collectivvely entered in to the T Transporta ation tab. To validate v the ese data, re e-run the Da aily Batch//Tank Repo ort (All – S Subbatc ches) and verify that the t Num. B Bypassed, Num. Truc cked, and N Num. Barrged are co orrect. 41 VII.I.2 – Importin ng Data from Catc ch Detail for Trans sportation Data Entry Ta ab 1. To im mport the diffferent Tank, Species s, Age, Clip p, CWT, and Special S Species (EF and a Fry) com mbinations from the C Catch Detaiil tab into th he Transpo ortation tab, push p the Im mport button n. Only data a in Catch Detail D for th hat particula ar batch are imported. This means that additiona al Tank, Sp pecies, Age, Clip, CW WT, and Sp pecial Species (EF and Frry) combina ations from previous da ays may ne eed to be entered, when w every y-other-dayy transporta ation is in place. Only target salmonid d species a are imported d from Catc ch Detail. Lamprey juveniles are NOT to o be entered into the T Transporta ation tab. If conditio on data hav ve not been n promoted to Catch D Detail, these e Tank, Species, Age, Clip,, CWT, and d Special S Species (EF F and Fry) combinations may not be prese ent. be imported d as Unclipp ped NOTE: Eroded fin stteelhead att LGR will b steelhead d, as LGR cannot c know w how man ny EF steelh head were collected.. 2. Enterr the Num. Bypassed, Num. Tru ucked, and//or Num. B Barged for e each Tank k, Species, Age, Clip, CWT, and Special Species (EF F and Fry) comb binations. To T do this, select s each h record and d enter the correspond ding Num.. Bypassed d, Num. Trrucked, and d/or Num. B Barged for that record d, follow wed by the Save S Reco ord button. These collection cou unts can be e found in th he Daily Ba atch/Tank Report. 42 3. To va alidate these data, re-rrun the Dai ly Batch/Tank Reporrt (All – Subbatch hes) and th he Lamprey y Batch/Ta ank Reportt (All – Sub b-batches) and verify y that the Nu um. Bypas ssed, Num . Trucked, and Num. Barged arre correct. VII.J. V Va alidating g Batch The T Daily Batch/Tank B Report an nd the Lamp prey Batch h/Tank Rep port that we ere generated and printed for Section n VII.I abovve can be ussed for fina al data valid dation. These T reporrts summarrize sample counts, de escaling info ormation, ccollection co ounts and mortality y data for condition c an nd non-cond dition fish, sseparately by tank. V Validation frrom these reports r can be done fo or a single ssub-batch a at a time or for all sub--batches combined. Validate V no on-condition n data by co omparing th hese reportts to your hand lo ogs, paying special atttention to th he sample ccounts, num mber examiined for desscaling, descaling, mortality m cou unts, and flo ow/spill qua antities. Ho oldovers an nd Lyons Fe erry fish d in the UC,, CWT, or CL C columnss for Chinoo ok 1. are included ges need to o be made, edit the reccords with incorrect da ata using Iff any chang FPC32.net. F If data hav ve been ediited, run the e Daily Battch/Tank R Report and Lamprey L Ba atch/Tank Report aga ain. Once a all of the da ata are ente ered and va alidated, fo ollow the En nd and Sen nd (Section VII.K) insstructions b below. A separate report r (Spe ecial Specie es Daily Ta ank/Batch Report) ca an be used to validate the entry of ho oldover and Lyons Ferrry yearling Chinook da ata at the unclipped, clipped, c and d CWT leve el. Select R Reports and d choose S Special Spe ecies 43 Daily D Batch h/Tank Rep port from th he drop-dow wn menu. T This report summarize es sample coun nts, descaling information, collecttion countss and morta ality data forr condition an nd non-cond dition holdo over and Lyyons Ferry yyearling Ch hinook, sepa arately by tank. Validation from m this report can be do one for a single subba atch at a tim me or for all subbatches combine ed. Validatte non-cond dition data b by comparing this repo ort to your hand lo ogs, paying special attention to th he sample ccounts, num mber examiined for m cou unts, and flo ow/spill qua antities. descaling, descaling, mortality VII.K. V End E and Send Once O data have h been validated, v th he next step is to printt reports forr your recorrds and create an .X XML file thatt will be sen nt to The Fiish Passag ge Center. 1. Nav vigate to the e Catch tab b and click on Save as s Batch 44 2. 3. 4. This write es the data in the locall database to an XML file in the d directory specified in the Settings (see S Section VIII.A) In an XML file alread dy exists fo or that batch h, you may be prompte ed with a ou want to overwrite the existing batch. Sele ect Yes. message asking if yo End d data entry y each day by printing the Daily S Summary, Incidental Catch, Marrk Recaptu ures, Fish Condition, C Daily Batc ch/Tank (A All- Subbattches), and d Lamprey Batch/Tan nk (All-Sub bbatches) rreports, if th hey have no ot alre eady been printed. p Sen nd the .XML L file to the FPC office e via e-mail to smp@fp pc.org or up ploading to th he FPC website (see Section S X.B B). u must also send your hand logs to the Fish Passage C Center via F Fax to You (503 3) 230-7559 or e-mail to smp@fp pc.org. E-mailed hand h logs must m be sen nt in PDF fo ormat. The ey can be se ent in the same e-mail as the batch b file (i.e e., XML file e). If you cann not send the batches iin on time, be sure to call a mem mber of the data center c stafff and let us know the rreason and when you expect to get the e batch in. VII.L. V Reposts. Iff you need to t revise an nd resend a batch, you u must editt the batch tthat was prreviously created (see e instruction ns for editin ng a batch in Section V VIII below). If you wissh to esend a batch, you must docum ment why y you are cha anging the e batch and d submit re 45 this documentation along with the batch, preferably via FAX or email. FPC WILL NOT UPDATE BATCHES UNLESS PROPER DOCUMENTATION IS RECEIVED. You should also send a copy of this documentation to your project leader. If FPC has already posted the original batch, a reposted batch will not be allowed to overwrite the old batch. FPC staff must first delete the old batch before data from the newly updated batch can be posted. Call Chris McCarty (503)230-4582 if you have any questions about reposting. Reposted batches must be sent via email. When you send a batch for reposting, attach it to an email sent to [email protected], along with an explanation memo of why this batch is being resubmitted for reposting. If you use Microsoft Exchange, configure your mail client to send a return receipt back to you, acknowledging that the mail arrived. To edit a pre-existing batch for reposting: Open the FPC32.net Main Form. Under the Catch tab, select the batch that needs editing (selected records have an arrow next to them) from the data grid by clicking on the record. Select the appropriate tab for the data that need to be edited (e.g., Catch Detail). Under that tab, select the record that needs to be edited. Choose the Edit button. Make the appropriate changes to the record and then choose Save Record. If changes are made to individual condition records, these changes must be re-promoted into the Catch Detail, Incidental, and Mark/Recap records. To re-promote, choose the Summary Condition tab and choose Promote All to rewrite or change the daily batch condition records in the Catch Detail, Incidental and Mark/Recap tables. Once you have made all the required changes, select the Catch tab and press the Save As Batch button. A dialog box will prompt you to overwrite the previous batch record. Choose Yes. This creates a new daily batch .XML file for the day you have edited. Send the changed batch along with the appropriate documentation to the FPC via email to [email protected] (see above for further documentation). VII.M. Special Situations. VII.M.1 - Daylight Savings Time Transitions: In the Spring, the start and end times will be recorded normally, but on the day when daylight savings time begins, the sampling hours will be 1 hour less and the flows averaged for 23 hours. In the Fall, the start and end times will be recorded normally, but on the day when daylight savings time ends, the sampling hours will be 1 hour more and the flows averaged for 25 hours. 46 VII.M.2 - Sampling End Date D is the Same ffor Two B Batches: Each battch must ha ave a uniqu ue batch nu mber and e end date. If sampling ends on the same e day as the e previous batch, the b batch numb ber must be e that of the e following g day. Batch h numbers are created d automaticcally. From the FPC32 2.net Main Form you can n create battches (and hence a ba atch numbe er) for datess prior to the curre ent date. Select File e and click on Create Older Day ys Batch. A calendar will appear fro om which yo ou may cho oose your b batch end date. You a are limited to the t current year. To sswitch to a p previous month, presss and hold on the e current month m and m move up to select the d desired mo onth. Double-click on the date d for the batch you want to cre eate. h must be edited. e To e edit the batcch from the e Catch tab b, select This batch the batch to t be edited d and choo ose the Editt button. The following g are items that must be ed dited: o Put the t actual end date a and end ho our in the C Comments field o Put the t actual sample ho ours in the Sample Ho ours field o Put the t adjuste ed sample end date ((the followin ng day) in tthe End Date e field o Be sure s that yo ou choose tthe approprriate Sample Code fro om the drop p down list that t reflectss this adjussted sample e o Choose Save Record. R Follow instructions fo or sending tthe batch to o FPC found in Sectio on VII.K 47 VIII.DetailedDataEntryInstructions The purpose of this section is to provide detailed information on the types of data that are entered into FPC32.net and how to enter these data. This section also provides instructions on how data can be edited if/when errors are found during data entry and validation. For convenience, all data entry tabs in the FPC32.net Main Form have similar layouts. The fields found in each of the data entry tabs are presented in two ways. The upper portion of each data entry tab is a data entry panel. This panel is the location where new data are entered or existing data are edited. It provides an ordered list of metrics to be entered for each record. Many of the fields in this panel have data validation and integrity rules that check the data being entered to assist the user in determining if the entry is valid for the specified field. Although some fields have built in validation, not every field has validation checking routines. For clarification, this section of the manual provides information about suitable data entry for each field in each of the data entry tabs. Also, there is a glossary of the various terminology used throughout this manual (see Section IV). The lower portion of each data entry tab is a data grid for display of entered data. From this data grid, data can be browsed (scrolling up and down and left and right) and sorted (by header). As mentioned earlier, sorting by multiple headers is possible. To do this, simply hold down the Shift key while selecting the column headers in the order you wish to sort them by. This data grid allows the user to view all entered data for a single batch for error checking and/or validation. For each of the data entry tabs, one or more of the left-most columns are frozen to help the user identify the row as they scroll to the right. Column headers can also be resized and can be wrapped. To resize a column header, click and drag a column separator (the line between two columns). Maximizing the data entry window, allows the user to see more of the column headers. Data cannot be entered or edited directly from the data grid. To hide the Main Form, click on the X in the upper right hand corner. The program remains running in the background and can be re-opened by right-clicking on the FPC32.net icon in the system tray. To exit the FPC32.net program from the Main Form, choose File | Exit. If the Main Form is hidden, you may exit the FPC32.net program by right-clicking on the FPC32.net icon in the system tray and choosing Exit. VIII.A. Catch Tab. In the lower data grid, the Batch field is frozen on the left to help the user identify the row as they scroll to the right. VIII.A.1 – Definitions and Data Entry To view the Catch tab of the FPC32.net Main Form, either double-click on the FPC32.net icon on your desktop (if program not already running) or right-click on 48 the FPC3 32.net icon in the system tray and d choose O Open Main Form. The e Main Form win ndow opens with the Catch C tab fforward. d, the Catch h tab displa ays the batcch records that are in tthe Upon being opened temporarry database e in the data a grid near the bottom m. Each battch is repre esented by a sing gle row in th his data grid d. Creating g a new battch in the C Catch tab de epends on wheth her conditio on data werre collected or not. If ccondition da ata were co ollected, the batch h data from the conditiion sample are importted into the Main Form m for editing and entering g non-condiition data. A detailed description n of how to import condition n data is pro ovided in Section VII. C.1 above. If no cond dition data w were collected d, a new batch record can c be crea ated from w within the C Catch tab off the Main Form. A deta ailed description of how w to create a new batcch from within the Catch ta ab is provide ed in Sectio on VII.C.2 above. To edit an a existing batch b selec ct the batch record in tthe data grid and choo ose Edit. This allow ws the userr to make changes c via a the data e entry panel above the data grid. Afte er necessary changes s are made,, choose Sa ave Record rd. 49 Below is a table of the fields of data that are entered into the Catch tab along with the default settings for each field, prior to data entry. Following this table is a list of the fields and instructions of the types of data that should be entered into each field and how. Field Name Site Start date Batch End date Start hour End hour Trap location Gear code Sample code Sample hours River flow PH1 flow or Turbine Discharge PH2 flow Total Spill Comments Default Settings Set in setting dialog Typically 24 hours prior to the end date Computed based on system date and sample end date User defined based on whether End Date Today or End Date Tomorrow selected Default start hour is set to 0700, can be edited in the setting dialog Default end hour is set to 0700, can be edited in the setting dialog Trap location is left blank Default gear code is set to GC, can be edited in the setting dialog Default sample code is set to 01, can be edited in the setting dialog Default sample hours is set to 24 River flow default is zero Power house 1 flow default is set to zero Power house 2 flow default is set to zero Total spill default is set to zero Comments are left blank Start Date: Start date is calculated based on whether the user chose the End Date Today, End Date Tomorrow, or the End Date Yesterday button. This is typically 24 hour prior to the end date. Format = MM/DD/YYYY. Start Hour: The default start hour is carried forward from the Settings screen (Section III.A). If the listed Start Hour is incorrect, enter the actual start hour, in 24hr military time. Numbers less than 0000 or greater than 2400 are restricted from entry here. End Date: End date is determined by the user when he/she selects the End Date Today, End Date Tomorrow, or the End Date Yesterday button. Format = MM/DD/YYYY. End Hour: The default end hour is carried forward from the Settings screen (Section III.A). If the listed End Hour is incorrect, enter the actual end hour, in 24hr military time. Numbers less than 0000 or greater than 2400 are restricted from entry here. Trap Location: This field is only used by the SMP trap sites and not visible for other nontrap sites. Imnaha River Trap- enter “1, 2, 3,or 4” for trap positions 1-4. 50 Lewis ston Trap- enter “0” orr “east” whe en the trap is in its norrmal positio on. White ebird Trap-- enter the n number of m meters the trap is from m the northe ern cable to ower (e.g., 1 10m, 30m, 50m or 10,, 30, 50). Grand de Ronde River R Trap- enter the number of meters from m the east to ower that th he trap is lo ocated at (e e.g., 175). Gear Code: Th he default Gear G Code is carried fforward from m the Settiings screen n (S Section III.A A). If the lis sted Gear C Code is inccorrect, clickk on the Ge ear Co ode drop down list and select the e correct Gear Code. SMP Traps T must use Gear Code “MT T” or “00” SMP Sites S at Da ams can usse all Gear Codes, exccept “MT” Gear Code = “00 0” must be used when n there is no o sample co onducted in a co ollection pe eriod. Sa ample Cod de: Th he default Sample S Co ode is “1”, w which mean ns "Normall Complete e Sa ample". If you y wish to change thiis, click on the Sample e Code dro op down lis st and selec ct the desire ed Sample e Code. Be elow is a listt of the variious Sa ample Cod des, their meanings, m and approprriate Gear C Codes (in italics wh hen applica able). 51 1 = Normal Complete Sample (24 hours). 2 = Two or more samples taken during a day with separator clean out. 3 = No sample /biased sample due to abnormal flows or in-operation of sample unit. (GC = 00 if no sample; GC = GC if bias sample) 4 = No sample / biased sample due to weather conditions. (GC = 00 if no sample; GC = GC if bias sample) 5 = No sample / biased sample due to equipment failure / maintenance / repair. (GC = 00 if no sample; GC = GC if bias sample) 7 = Incomplete sample, no code provided, cause explained in comments. 8 = No fish counts were entered for this sample period; fish accumulated and were sampled at a later date. 9 = Incomplete / biased sample, counts are modified to estimate a normal sample. 10 = Multiple sample rates used throughout day (not including sample rate for GBT sample) 12 = Sample of fish accumulated 2 or more days. The sample code minus 10 is the number of days that fish accumulated before being sampled. Sample Hours: Enter the actual number of hours sampled, rounded to the nearest 100th place (e.g., 4 hours and 43 minutes = 4.72 hours). When daylight savings time begins and ends, the sample hours will need to be adjusted. The only time Sample Hours should be ≥24 is when Sample Code ≥ 12. For detailed instruction on these changes see Section VII.M.1 above. If Sample End Date is the same for two batches see Section VII.M.2 above. Total Discharge Total Discharge is the average hourly river flow (Kcfs) during the sampling period. This value is mandatory for the SMP sites at dams (BO2, JDA, MCN, RIS, LMN, LGS, and LGR) but it optional at the SMP trap sites (GRN, IMN, LEW, WTB). If a trap site chooses to enter this value, it is acceptable to use either KCFS or CFS units. Total Discharge is obtained from the COE’s Crohms System Daily Report or from online COE data reports such as Report 96 (ftp://ftp.nwdwc.usace.army.mil/pub/project_data). A copy of this report should be sent to FPC along with your daily hand-logs. When daylight savings time begins and ends, the period for calculating the Total Discharge will need to be adjusted. For detailed instruction on these changes see Section VII.M.1 above. On days when no sample is conducted, sites are still expected to send in a batch with flow and spill information only, using a Gear Code of “00” and a Sample Code of “3” PH 1 Flow or Turbine Discharge: For all sites except BO2 and RIS, PH1 Flow/Turbine Discharge is the average hourly flow (in Kcfs) through the powerhouse during the sampling period of the batch. For BO2 and RIS, PH1 Flow is the average hourly 52 flow (in Kcfs) through Powerhouse 1 during the sampling period of the batch. This field is mandatory for BO2, JDA, MCN, RIS, LMN, LGS, and LGR. o Obtain this daily number from the Army Corps. of Engineers at the project o For BO2, obtain this value by subtracting BON 2 AVG DISCH from AVG TURB DISCH on the COE daily report. This field is not displayed at WTB, IMN, LEW, and GRN. When daylight savings time begins and ends, the period for calculating the PH1 Flow or Turbine Discharge will need to be adjusted. For detailed instruction on these changes see Section VII.M.1 above. At JDA, MCN, LGS, LMN and LGR, the sum of the Turbine Discharge and Total Spill cannot be greater than the Total Discharge. If this occurs, an error message is displayed. At BO2 and RIS, the sum of PH1 Flow, PH2 Flow, and Total Spill cannot be greater than the Total Discharge. If this occurs, an error message is displayed. PH 2 Flow: This field only appears in the Catch data entry tab of the FPC32.net Main Form at BO2 and RIS. PH2 Flow is the average hourly flow (in Kcfs) through Powerhouse 2 during the sampling period of the batch. This number is found on the COE daily report BON 2 AVG DISCH. When daylight savings time begins and ends, the period for calculating the PH2 Flow will need to be adjusted. For detailed instruction on these changes see Section VII.M.1 above. At BO2 and RIS, the sum of PH1 Flow, PH2Flow, and Total Spill cannot exceed the Total Discharge. If this occurs, an error message is displayed. Total Spill: Total Spill is the average hourly spill (Kcfs) during the sampling period. This field is mandatory for BO2, JDA, MCN, RIS, LMN, LGS, and LGR. o Obtain this value is in row SPILL in the COE daily report. This field is not displayed at LEW, WTB, GRN, or IMN. When daylight savings time begins and ends, the period for calculating the Total Spill will need to be adjusted. For detailed instruction on these changes see Section VII.M.1 above. At JDA, MCN, LGS, LMN and LGR, the sum of the Turbine Discharge and Total Spill cannot be greater than the Total Discharge. If this occurs, an error message is displayed. At BON and RIS, the sum of PH1 Flow, PH2 Flow, and Total Spill cannot be greater than the Total Discharge. If this occurs, an error message is displayed. 53 Co omments1 and Comments2: Co omments are a used primarily to exxplain prob blems in gettting the da aily sa ample, as described d in n Section V VII.M.2 abovve. Observvations of fiish co ondition or abnormal a size s should also be inccluded in the commentts. Ex xtraordinary y events im mpacting fish h passage should be n noted in the e co omments fie eld(s). The comments field should NOT be u used to indicate da ata entry up pdates. Such commen nts as wate er turbidity, lamprey, ko okanee, ettc. should not n be includ ded. If Sam mple End D Date is the same for tw wo ba atches see Section VIII.M.2 abovve. Co omments2 2 has a drop p-down menu that allo ows for entrry of commo on co omments du uring certain periods. FPC32.net allows forr up to three e user de efined comm ments that can be editted through hout the sea ason by the e users. Th hese user-d defined com mments are e available iin the Com mment2 drop-down menu. These user defin ned comme ents can be e edited in tthe Setting gs dialog bo ox of FPC32.net (see Section S VII.A.7 above e). VIII.A.2 2 – Editing g Record ds in the C Catch Da ata Entry Tab Ad djusting Batch Numb bers and C Creating Ba atches for Past Dates s: To o create a batch b that corresponds c s to anothe er date othe er than Toda ay’s Da ate or Tomorrow’s Date, choose File | Crea ate Older D Days Batch h from the FPC32.net Main Fo orm. A cale endar appe ears. Selecct the date yyou want to create the batch for by b double-cclicking on tthe End Da ate of the ba atch you wa ant to creatte. You are e limited to creating ba atch for a date in the p present ye ear. The ba atch for the End Date you selecte ed is autom matically cre eated. Frrom the Catch tab, choose Edit a and begin e entering the e flow, spill,, and otther importa ant information. 54 diting Olde er Batches s: Ed Yo ou can only y edit one batch b at a time. Each batch is sto ored on the e local co omputer in a database e, unless it h has been d deleted by th he user. If a batch ha as been delleted by the e user, it ca an be re-imported into the databa ase. To do o this from the t Catch tab, t choose e Import Frrom Batch and naviga ate to the directory where the final .XML files are be eing saved to the office e co omputer hard drive. Select the .X XML file for the batch yyou want to o import an nd choose Open. O To o edit a batch, you mu ust first sele ect the Catc ch data enttry tab from the FP PC32.met Main M Form. Using the e scroll barss in the datta grid at the bottom off the page, scroll down n to the batcch you wan nt to edit. C Click on the record to highlight it. The T selecte ed record w will turn yello ow and havve an arrow w next to it. A batch is s not selecte ed until the e record is sselected byy clicking the e mouse even though h it appears s yellow). T The arrow n next to the rrecord is th he best (e indicator of th he selected d record. h has been selected, yyou may na avigate to th he data enttry tab Once a batch atch, Catch h Detail, In ncidental C Catch, Mark k that requires editing (Ca Re ecaptures,, Transporrtation, or C Conditions s). Once you select the e ap ppropriate tab, t navigatte to the reccord (from the data grrid) and cho oose the re ecord that re equires editting. You m may activatte a record for editing by se electing that record and pressing Edit or by double-cliccking on the e record yo ou wish to edit. e This populates p th he data entry panel at the top of tthe sc creen for the selected record. Yo ou may now w edit any o of the fields in this da ata entry pa anel. When n you have completed making the e necessarry co orrections to o the record d, choose S Save Reco ord. 55 Re emoving a Batch Rec cord from the Local Database Yo ou may cho oose to dele ete batch re ecords from m the local d database. To do this, select th he batch rec cord you w with to delete e (from the Catch tab) and hoose Dele ete. This will w delete a all records entered in nto the loca al ch co omputer da atabase fo or that batc ch (includin ng conditio on, inciden ntal ca atch, transportation, mark reca ap, and cattch detail rrecords. A dialog box appears as sking you iff you really want to de elete the batch, ch hoose Yes if you want to delete th he batch allong with alll of its supp porting re ecords. NO OTE: Do no ot delete th he current day’s batc ch record c created when entering condition records s, edit it instead. A second dia alog box ap ppears, again asking iff you want tto delete the batch f conditio on records.. Choose Y Yes if you w want to dele ete the including all fish ba atch along with w all of itts supportin ng records. OTE: This does not delete d the records fro om the FPC database, it NO on nly deletes s the batch h and it’s supporting records frrom your lo ocal da atabase on n your hard d drive. If a batch ha as been de eleted by th he user, it can be re--imported into i the loc cal database. To do this from the 56 Ca atch tab, choose c Imp port From Batch and navigate tto the directory where the final .XML files are be eing saved. Select th he .XML file e for the ba atch you want w to imp port and ch hoose Ope en. To o make cha anges to th he FPC database, the e reposting procedure must be e followed. VIII.B. V Catch C De etail Tab b. In n the lower data grid, the t Sub Ba atch, Seque ence, Tank k, Species Code, Age e Code, Special S Spe ecies Code e, Coded Wire W Tag, and Clip fiellds are frozzen on the left to help the use er identify th he row as th hey scroll to o the right. Data are e entered for each Subbatch, S Tank, T Spec cies Code, Age Code e, Special S Species Co ode and Co oded Wire W Tag co ombination that were tallied as pa art of non-ccondition sa ampling. VIII.B.1 – Definittions and d Data En ntry Before any data can n be entere ed or edited d in the Catc ch Detail d data entry ta ab, the st specify which w batch they intend d to add/ed dit data to b by selecting the user mus correspo onding batch in the Catch data en ntry tab. Once a batch h has been selected in the Catc ch tab, you may navig gate to the C Catch Deta ail tab. To create e a new rec cord in the Catch C Deta ail data enttry tab, cho oose New. This activates s the data entry e panel at the top o of the scree en. When the first reco ord is 57 created, Site and Batch are carried over from the Catch data entry tab. Also, default Sample Rate(s), Multiplier, and Gear Code are carried over from the Settings screen. The user should enter a separate detailed record for each Subbatch, Tank (where applicable), Species, Clip, CWT, and Special Species Code combination for the eight different target species of the SMP. For Chinook, separate Age Codes (1 or 0) should also be entered. To edit a record, select the record from the data entry grid at the bottom of the screen. Each record has a sequence number to make the editing process easier for the user. A selected record has an arrow on the left. The user may scroll to the right to evaluate the data to make sure it is the correct record for editing. If the data need to be edited, either click on the record (i.e., row) of data to be edited and choose Edit or double-click on the record to be edited. The data from the record then populate the data entry panel at the top of the screen and are editable. Once necessary changes are made, choose Save. For ease of navigation, the Tab Keys can be used to move between fields and Right and Left arrow keys can be used to move the cursor within a data field. Below is a table of the fields of data that are entered into the Catch Detail tab along with the default settings for each field, prior to data entry. Following this table is a list of the fields and instructions of the types of data that should be entered into each field and how. Field Name Site Sequence Sub Batch Tank Species Code Age Fin clipped Coded Wire Tag Special species code Gear code Multiplier Sample rates All number fields Default Settings Set in setting dialog For each subbatch, sequence starts at 1 and continues sequentially. When a new subbatch is started, sequence starts over at 1 Starts at 1. The value of subbatch for the next record is the same as the previous entry, until the user changes the value. Default is none. The value of tank for the next record is the same as the previous entry, until the user changes the value. Default is none. Species is a required field. The value of species code is the same as the previous entry, until the user changes the value. Default is none. This field is only used for Chinook. Default is none. Default is none. Default is none. Default is none. The value of gear code is the same as the previous entry, until the user changes the value. Default is set from the Setting dialog box. The value of multiplier is the same as the previous entry, until the user changes the value. Default is set from the Setting dialog box. The value of sample rate is the same as the previous entry, until the user changes the value. There is only one sample rate per sub batch. All number fields are initially set to zero. 58 Sub Batch: The defa ault for the first f record is 1. If the sample ratte changes during sam mple day, create a new sub-ba atch for eac ch period w with a differe ent sample rate. Ente er 2 for second sub-batch, s 3 for third, etc. e Examp ples where separate ssub-batchess are appropria ate include: 1) multiple e sample ra ates are use ed within a single day (Note: in this case e, Sample Code C in Cattch tab sho uld have va alue of 10), 2) a GBT ssample from the separator should s be entered e as a separate sub-batch,, 3) separattor mortalitie es should be entered as a a separa ate sub-batcch, 4) lamp prey juvenile es are encounte ered during separator clean-out p procedures, etc. If lamprey juv veniles are sampled a above the sa ample gate e (e.g., durin ng se eparator cle ean-out procedures, re emoved from dewateriing screenss, etc.), these individuals should d be identifiied to species (if possible) and re ecorded in Catch Dettail (non-co ondition sam mple count)) as a separate sub-ba atch, with a 100% sample rate, ge ear code of GC, and ta ank “none”. Any morta alities ssociated with w these la amprey sho ould also be e recorded. If species ID is not as po ossible, use e species co ode LU whe en recordin ng in Catch h Detail. net now valiidates whetther the Sa ample Code e (from Cattch tab) ma atches FPC32.n the numb ber of sub-b batches and d sample ra ate data tha at are enterred in Catc ch Detail. For exam mple, if a Sa ample Cod de of “1” is e entered into o the Catch h tab but tw wo subbatches with w different sample rates r are en ntered into Catch Dettail, a “Sam mple Code Va alidation Alert” will ap ppear. If/wh hen this happens, simply finish th he current re ecord and choose c Sav ve/New folllowed by C Cancel. Sw witch back to o the Catch ta ab and edit the Sample e Code to rreflect that two sample e rates werre used for this batch (e.g., Sample Co ode = “10”)). Tank/Tra ap: The Tank field is av vailable for editing at L LGS, LMN a and MCN. Choose either “A”, “B”, or “N None”. Forr these sites s, “None” d denotes a g group of fish h that were sampled from the separator and a NOT frrom Tank “A A” or “B”. T Tank “None e” for BO2, JDA, LGR, and RIS indic cates that th hese sites o only have a single tankk. At MCN use Tank “No one” to den note racewa ay 10. The Trap code e only pertains to site IMN. Choose either e “A” or o “B” to des signate trap p. Species Code: Click on the drop do own list und der Species s Code and d select the e appropriate c Thes se are the only o specie s codes tha at are allow wed to be en ntered species code. here. Target Species Codes: CH H = Chinook k CO O = Coho SO O = Sockeye e 59 ST T = Steelhea ad AB B = Ammoco oete (Brook k) AP P = Ammoco oete (Pacifiic) AS S = Ammoco oete (Unknown) MP P = Macropthalmia (Pa acific) LU U = Lamprey y sp. (Unide entified) NO OTE: Exclude Chinook mini-jacks (150-300m mm) that are e obvious precoc cious males s to the exte ent possible e from the C Chinook sm molt count. Enter them m in the Inciidental Cattch data en ntry tab. Be awa are that in April A and M May a signifiicant number of Holdo over Fall Chinoo ok could be encounterred in samp ples. These should be entered as Age e 1 Chinook k with a Spe ecial Species Code o of “HO” (see e below for furth her informa ation on ide entifying holldover fall C Chinook). All clipped sockey ye/kokanee e are to be rrecorded ass sockeye, except al, sockeye//kokanee ≥2 200mm are e to be reco orded as at RIS.. In genera kokane ee in the Incidental Catch data e entry tab un nless it is cllipped, has a CWT, C and/o or is PIT-tag gged, in wh hich case it is entered as a sockey ye in Catch Detail. Usse 450mm as the thre eshold for ad dult sockey ye fallbacks s. Use the e less strea amlined sha ape and the e non-silverry color charac cteristics of rainbow tro out to exclu ude them fro om the stee elhead smolt count c and enter e them iin the Incid dental Catc ch data enttry tab. AS (Am mmocoete Unknown) should be e used for a ammocoete es that are les ss than 70m mm or that ccannot be p positively identified as AB or AP. Age Cod de: For Chin nook choos se “0” for su ubyearlings or “1” for yyearlings. F For all other species, the Age Co ode radio buttons b are inactive. A Age is usefu ul for distinguishing ants (typica ally yearling g) from fall C Chinook migrants Spring/Summer Chinook migra y subyearlin ngs). Below w is a seriess of diagram ms to help u users distin nguish (typically between yearling an nd subyearrling Chinoo ok, based o on their morrphology. In recentt years a larrge number of yearling g fall Chino ook have be een release ed into the Snak ke River from Lyons Fe erry Hatche ery and accclimation po onds above e Lower Granite Dam, D and th hus should be assigne ed a “1” eve en though ttheir morphology is consisten nt with the “fall “ Chinoo ok” shown b below. Add ditionally, ho oldover fall Chinook should be assigned as age 1. 60 Fall C hinook/Subyeaarling Falll Chinook/Suby yearling 1. 2. 3. 4. 5. 1. 2. 3. 4. 5. Falll Chinook (su ubyearling) Ca audal fin forke ed, with outer margin usuallly black. Parr marks large e, vertical obllong shapes ccentered on la ateral line and d wider than interspaces Anal fin rays sho ort, wedge sh hapes, usuallyy not pigmentted. Large spots on back ody wider, ey yes smaller, nose n more s sharp than ye earling Sprin ng/Summer C Chinook Bo (fo ootball shape ed) Sprin ng/Summer Chinook C (yea arling) Cau udal fin forked d, usually edg ged in black. Parrr marks large, vertical oblo ong shapes ce entered on la ateral line and wider than in nterspaces Ana al fin rays short, wedge sha apes, usually not pigmente ed. Larg ge spots on back b Bod dy narrower, eyes larger,, nose more rounded tha an subyearlin ng fall Chino ook Fin Clipp ped: Choose “Y” “ for thos se fish that have a fin cclip, either an adipose or ventrral fin clippe ed. Choose e “N” for h that do no ot have a fin clip. those fish CWT: LGR, LG GS, LMN, WTB, W LEW, and GRN a are to examine all unclippe ed Chinook k (subyearliing and s), coho, an nd sockeye for coded-w wireyearlings tags. Fo or unclipped d Chinook, coho, c and ssockeye, choose “Y” for those e with CWT T and “N” fo or those witthout CWT.. If fish werre not examined for CWT than choos se “N/A”. T The default for clipped Chinook, ccoho, and sockeye at these sittes is “N/A””. The defa ault for RIS,, MCN, JDA A and BON N is “N/A”. 61 Special Species Code: Click on the Specia al Species drop down list and Choose one of the followin ng codes F R, EF, LF, or o HO. Choose “FR” “ for Fry y if fish is 60mm 6 or lesss at all site es. This cod de should only o be use ed for Chino ook, coho, or o sockeye,, as these a are the only species tha at have fry. If Chinookk is the species code, than the Ag ge Code must be entered as “0”, since only o age “0 0” Chinook ccan be fry. Steelhead d fry should be entered as a an incide ental specie es (Rainbow w trout) in tthe Inciden ntal Catch da ata entry tab. The “EF”” code for Eroded E Fin(s) is for usse only with h unclipped steelhead.. If the dorsal fin n or paired fins f of the unclipped u ssteelhead a are clearly e eroded as a result of being fro om a hatche ery (and is clearly c not tthe result o of wear and d tear from p passing through the t juvenile e bypass sy ystem) use this code. erry Hatche ery yearling fall Chin nook that arre The “LF”” code is forr Lyons Fe released either from m Lyons Ferry Hatcherry or at accclimation sites above L Lower Granite Dam. D This code should only be u used at Sna ake River ssites. The “HO” code is fo or Holdover yearling ffall Chinoo ok which ca an be identified by ogic charac cteristics at the Snake and Lowerr Columbia River damss. morpholo Those morphologic m characteris stics include e downturn ned eye, de eep body, deeply forked ta ail, and relattively little descaling d (tto differentiiate from re ecently relea ased hatchery y fish). A ph hotograph comparing c Y Yearling sp pring/summ mer Chinookk to a Holdoverr fall Chinoo ok is shown n below. Size can parrtly be used d to identify a Holdoverr fall Chinoo ok, as these e fish are tyypically gre eater than 160mm. Ho owever, a few Ho oldover fall Chinook C ma ay be as sm mall as 135 5mm. Thesse fish may be smaller than some spring s relea ases of hatcchery yearlling fall Chinook. Size e alone is not a foo ol proof indic cator. Finallly, Holdove er fall Chino ook are typically obserrved in April and d May. ompares a Yearling Y Sp p/Su Chinoo ok (top) to Holdover ye earling The figurre below co fall Chino ook (bottom m) size, morrphology an nd timing are useful fo or identifying g “HO” fish. 62 E: If fish do not meet the above-m mentioned ccriteria, con ntact FPC fo or NOTE instruc ctions as to o which code is approp priate. Gear Co ode: Gear Co ode will be carried c forw ward into the Catch C Deta ail data entrry tab from the Catch data a entry tab. Most often, it will w not need to be editted on the Catc ch Detail da ata entry tab. Howeverr, some sub b-batches will w require a separate Gear G Code e (e.g., GBT sam mples). To change the e Gear Code, click on the drop d down menu and sselect the a appropriate Gear Code. The ode of “MT” cannot be entered at the SMP ssites at dam ms, an errorr Gear Co message e will display. The Gea ar Code off “00” should only be u used on dayys where no sample was take en. Multiplie er and Sam mple Rate: For each h sub-batch, you may choose the sample rate in one e of two ways s. First, the e Multiplierr dropdown listt provides a list of som me of the more e common sample s rate es from which users may m choose the ate multiplie er (i.e., sam mple appropria rate) for a given sub b-batch. Th he multiplierr’s correspo onding sam mple rate will automaticcally appea ar in the Sam mple Rate field d. Alternatively, users s may enterr the samplle rate direcctly into the e Sample Rate field d. If you enter a sample ra ate directly, use a miniimum of fou ur digits to tthe right off the decima al point (e.g g. enter 0.0 0083 for a 0 0.83% samp ple rate). Iff your sa ample rate has more th han four dig gits, the use er must rou und their sa ample 63 ra ate to six dig gits to the right r of the d decimal point (e.g., sa ample rate o of 45.2% is 0.0221238 894, rounde ed to 0.0221 124). When W you ch hoose a Mu ultiplier from m the drop down men nu or directly en ntered a Sa ample Rate e, press [En nter] or [Ta ab] to move e to the nexxt field. Once a samp ple rate is chosen, c the e collection counts will be automa atically ca alculated (a as integers) when sam mple counts are entered (see belo ow). FP PC32.net now validate es whether the Samplle Code (fro om Catch ttab) matches the number of sub-batche es and sam mple rate da ata that are entered in Catch Dettail. For ex xample, if a Sample C Code of “1” is entered into the atch tab bu ut two sub-b batches witth different sample rates are ente ered into Ca Ca atch Detail, a “Samplle Code Va alidation A Alert” will ap ppear. If/wh hen this ha appens, sim mply finish the t current record and d choose Sa ave/New fo ollowed by y Cancel. Switch S back to the Ca atch tab and d edit the S Sample Cod de to re eflect that tw wo sample rates were used for th his batch (e.g., Sample e Code = “10”). Sample rates r for ea ach sub-battch appear in the Sub--batch Sample Rate Look kup Table lo ocated in th he upper rig ght corner off the Catch h Detail tab. If a mista ake is mad de on the sample rate r for a subbatch, s it can be e edited, but only after all of the reco ords for that subbatc ch have be een entered using the Catch Deta ail data en ntry tab (se ee instructiions below w). To Chan nge a Samp ple Rate affter all Catc ch Detail R Records ha ave been E Entered: single-cliick on the sample s rate e in the Sub b-batch Sample Rate Lookup T Table and it becomes editable. Type in the correct ssample rate e and presss the Enterr key. A dialog bo ox appears asking if yo ou want to cchange the e sample ra ate. Choose e Yes. 64 Non-Con nd Sample e Count: Enter the e number off non-condition fish sa ampled. Th his number includes sa ample mortalitie es. NE EW: If lamp prey juvenilles are sam mpled above e the samp ple gate (e.g g., during se eparator cle ean-out procedures, re emoved from dewateriing screenss, etc.), these individuals should d be identifiied to species (if possible) and re ecorded in Catch Dettail (non-co ondition sam mple count)) as a separate sub-ba atch, with ear code of GC, and ta ank “none”. Any morta alities a 100% sample rate, ge as ssociated with w these la amprey sho ould also be e recorded. If species ID is not po ossible, use e species co ode LU whe en recordin ng in Catch h Detail. Est. Collection: FPC32.n net automattically calcu ulates this fiield by divid ding Sample Rate into o Sample Count. Th his number is then rou nded to the e nearest hu undredth place. Using intteger multip pliers instea ad of samplle rates willl reduce an ny rounding errors that may y appear in the calculated quantityy. The Estiimated Colllection is a calculate ed number and a should not be editted EXCEP PT when en ntering Separator Mortalitiies (see Fa acility Mortts. below). The Est. C Collection ccan only be e overwritten if a sam mple rate of 100% is ch hosen. Num Exa am for Des scal: The Num m Exam forr Descal is a calculate ed field (Num Exam Descal = Sam mple Count - Sample S Mo orts). This equation asssumes thatt 100% of th he non-condition sample (excluding sample s morrtalities) wa as examined for desca aling. If thiss is not 65 the case, you may enter the correct Num Exam for Descaling after entering the Sample Count and Sample Morts. If you over-write the calculated value for Num Exam for Descaling, this must be the last entry before hitting the Save/New button. The automatic field validation logic displays an error message if the Sample Count minus Sample Morts is less than the number examined for descaling. Fish collected for GBT (Gear Code = “GB”) are not to be examined for descaling. For sub-batches with Gear Code “GB”, the default Num. Exam for Descal is 0. Fry and Lamprey juveniles are not to be examined for descaling. The default Num Exam for Descal is 0 when Species Codes (AB, AP, AS, or MP) or when Special Species “FR” are selected. Num Descaled: Enter the number of fish descaled from the non-condition fish that were examined for descaling. A fish that has greater than 20% descaling on one side is considered descaled. The auto field validation logic checks to see if Number Descaled is greater than Num Exam for Descal, if so, an error message is displayed. Sample Morts: For each sub-batch, enter the number of SMP related sampling mortalities for each species/age/rearing disposition. This includes all fish that are dead in the sample tank(s) or those GBT fish that died after being sampled from the separator. Separator mortalities get entered in a special way (see Facility Morts. section below). Do NOT enter a single mortality in more than one place. This quantity is subtracted from Sample Count, and the result is the Num Exam for Descaling. Mortalities are NOT examined for descaling. NOTES: If a mortality is externally marked (elastomer tagged or freeze branded) the following steps must be taken: o Enter the mort as a regular mortality o Enter a comment in the comment field (Catch data entry tab) describing the external mark of the mort. Use the following format for the comment in the Catch data entry tab: CH1-AD ELRE 3 mort. (This indicates that three of the clipped yearling Chinook that had a red elastomer tag on the left side were mortalities) o Enter the marked mort as a marked live fish in the Mark / Recaptures data entry tab. At BON and JDA, all mortalities should be considered sample mortalities EXCEPT when it is clear that the fish has been dead for a significant period of time prior to entering the sample tank. These fish 66 should be entered as Facility Mortalities. Assigning these mortalities as Facility Mortalities should be approved by The Fish Passage Center. Facility Morts: In a sub-batch, enter the daily number of facility related mortalities (e.g. transportation raceways, separator morts.), for each species/age/rearing disposition. For raceway and other non-separator mortalities, enter the number of mortalities directly into the Facility Morts field for the appropriate species/age/rearing disposition combination. For Separator Morts, use the following protocol. Separator Mortalities should be entered as a separate sub-batch. For this subbatch, enter a Sample Rate of “1”. For each Species/Age/Clip/CWT combination, enter a Non-Cond. Sample Count of “0” and enter the number of mortalities in the Estimated Collection and the Facility Mortality fields. This way, the separator mortalities will be considered facility mortalities and included in the collection count, but not in the sample count. This field does not appear at the SMP trap sites. NOTES: If a mortality is externally marked (elastomer tagged or freeze branded) the following steps must be taken: o Enter the mort as a regular mortality o Enter a comment in the comment field (Catch data entry tab) describing the external mark of the mort. Use the following format for the comment in the Catch data entry tab: CH1-AD ELRE 3 mort. (This indicates that three of the clipped yearling Chinook that had a red elastomer tag on the left side were mortalities) o Enter the marked mort as a marked live fish in the Mark / Recaptures data entry tab. At BON and JDA, all mortalities should be considered sample mortalities EXCEPT when it is clear that the fish has been dead for a significant period of time prior to entering the sample tank. These fish should be entered as Facility Mortalities. Assigning these mortalities as Facility Mortalities should be approved by The Fish Passage Center. Research Morts: For each Species/Age/Clip/CWT combination, enter the daily number of fish taken out of the SMP sample and sacrificed by non-SMP researchers. For example, mortalities from USGS radio telemetry marking should be entered as Research Mortalities. PIT Tag Morts: This field is only used at RIS, WTB, LEW, IMN, and GRN. Enter the number of mortalities due to SMP PIT tagging operations. 67 Promoted Summary Condition Fish: Individual fish examined for fish condition that have been entered through the touch screen and/or edited through the Condition tab need to be Summarized and Promoted to the Catch Detail, Incidental Catch, and Mark Recaptures tab. This is done by using the Promote All button found in the Summary Cond. tab. To learn more about the Summary Condition tab and the promotion of condition fish into the Catch Detail data entry tab see Section VIII.G. The Condition Summary tab summarizes the condition fish by Species/Subbatch groups (Sub-batch/Tank/Species/Age/Mark type/CWT). The Promote All button adds the total condition fish sample to Catch Detail under the fields Cond. Sample Count, Num Cond. fish examined for descaling, and Num. Cond. fish descaled. These fields cannot be edited. To change the number of condition fish sampled or descaled, the fish condition sub-batch records must be edited in the Conditions tab. When data are entered into Catch Detail prior to promotion, the Sample Rate(s) for the condition fish sub-batch(es) are automatically assigned based on what was entered into Catch Detail. If data were not entered into Catch Detail prior to promotion, the sample rate(s) assigned to the condition fish sub-batch(es) are the default sample rate(s) from the Settings screen. If these sample rates were not used, you must edit the sample rates for the condition subbatches prior to promotion. The sample rate for each of the sub-batches in the review panel is applied to the Cond. Sample Count to produce the Estimated Cond. Collection (this field cannot be edited). The program adds the Cond. Sample Count and Non-Cond Sample Count together to produce the Total Count. After promoting, the Total Collection is estimated. This estimate is based on the Total Sample Count and the Sample Rate. Depending on what Sample Rate is used, there are times when this Total Collection is NOT equal to the sum of the Condition and Non-Condition Collections, due to rounding. The program then adds the fields Num. Examined for Descal and Num. Cond. Exam for Descal., producing Total Num. Exam. for Descal. The program also adds the Num. Descaled and the Num. Cond. Descaled, producing Total Num. Descaled. NOTE: None of these Condition fields or TOTAL fields can be edited. In order to change the numbers, the individual fish records for condition fish must be edited using the Conditions data entry tab and re-promoted via the Condition Summary data entry tab. VIII.B.2 – Editing or Deleting Catch Detail Records: You can only edit one record from the Catch Detail data entry tab at a time. To edit a record, you must first select the record from the data grid at the bottom of the screen by double-clicking on the record. The data from the selected record will populate the data entry panel and can be edited. The arrow next to the record is the best indicator of the selected record. At this point, edits can be made to the record. Once edits are made, choose the Save Record button. 68 To delete e a record, single-click k on the reccord you wish to delete e and choo ose the Delete button. If De elete is cho osen, you w will get a pro ompt confirrming that the record is to be deletted, select Yes and th hat record w will be remo oved from th he local database e. VIII.C. V Incidenta al Catch h Tab. The T Inciden ntal Catch tab t is for re ecording da aily sample counts and d mortalitiess of in ncidental sp pecies (i.e., non-targett species). SMP targe et species a are to be en ntered using the Ca atch Detail tab. Since e the data g grid has so few column ns, there arre no frrozen fields s in the Incidental Cattch data en ntry tab. VIII.C.1 – Definittions and d Data En ntry Before any data can n be entere ed or edited d in the Inciidental Cattch data en ntry tab, atch they in ntend to add d/edit data to by seleccting the the user must speciify which ba onding batch in the Catch data en ntry tab. Once a batch h has been correspo selected in the Catc ch tab, you may navig gate to the IIncidental Catch tab. To create e a new rec cord in the Incidental Catch data a entry tab,, choose Ne ew. This activates s the data entry e panel at the top o of the scree en. When the first reco ord is created, Site and Batch B are ca arried over from the C Catch data e entry tab. T The user should enter a sepa arate detaile ed record fo or each inccidental spe ecies that w was identified d in the sam mple. To edit a record, se elect the rec cord from th he data entry grid at th he bottom o of the screen. Each recorrd has a seq quence num mber to ma ake the editting processs easier 69 for the us ser. A sele ected record d has an arrrow on the left. The u user may sccroll to the right to evaluate e the data to o make surre it is the ccorrect reco ord for editin ng. If the data nee ed to be edited, click on the record rd (i.e., row)) of data to be edited a and choose Edit. E The data d from th he record th hen populatte the data entry pane el at the top of the e screen an nd are edita able. Once e necessaryy changes a are made, cchoose Save. For ease of navigation, the Tab K Keys can be e used to m move betwee en fields ht and Leftt arrow key ys can be u used to movve the cursor within a data and Righ field. Below is a table of the t fields off data that a are entered d into the In ncidental C Catch tab along witth the defau ult settings for each fie eld, prior to data entry. Following this table is a list of the fields and instructionss of the type es of data th hat should be entered into i each fie eld and how w. Field d Name Site Batch h Sequ uence Spec cies Code All nu umber fields Defaultt Settings Set in setting dialog Computted based on system date For eac ch batch, the ffirst incidenta al catch record d sequence sstarts at 1 and d continues se equentially. Default is none. Spe cies is a requ uired field. All number fields are e initially set to o zero. These fields includ de sample count, condittion count, tottal count and sample mortalities. Species Code: Click on the Specie es Code dro op down lisst within the e cell and se elect the appropria ate species s and specie es code. T The list is so orted alphabetically byy Incidenttal Species s Name, NO OT Inciden ntal Specie es Code. 70 Incidental Code BM BS BL BH CP CC A1 A5 A9 J1 J5 J4 J0 J3 J2 CM UM A2 A6 AA CR LD SD AD AE AF BK KO LK LP LR MA OT Incidental Species Name Bass, Large Mouth Bass, Small Mouth Bluegill and Pumpkinseed Bullhead Carp Channel Cat Adult Chinook Adult Hatchery Chinook Adult Wild Chinook Chinook Jack (12-22 in.) Chinook Jack – Hatchery Chinook Jack – Wild Chinook Minijack (6-12 in.) Chinook Minijack – Hatchery Chinook Minijack - Wild Chiselmouth Chum Coho Adult Coho Adult – Hatchery Coho Adult – Wild Crappie species Dace – Long Nose Dace – Speckled Kelt Adult Kelt Adult - Hatchery Kelt Adult – Wild Killifish, Banded Kokanee Lamprey Adult (Brook) Lamprey Adult (Pacific) Lamprey Adult (River) Madtom, Tadpole Other species not listed Incidental Code PM PE SQ PI SR SC SA SJ RS SP A4 A8 AC A3 A7 AB SK SN SG BU LU MU SU TT BT NT LT CT RT WE WA LW MW Incidental Species Name Peamouth Perch Pike Minnow, Northern Salmon, Pink (juv) Sand Roller Sculpin species Shad Adult Shad Juvenile Shiner, Redside Siberian Prawn Sockeye Adult Sockeye Adult – Hatchery Sockeye Adult - Wild Steelhead Adult Steelhead Adult – Hatchery Steelhead Adult – Wild Stickleback, 3 Spine Sturgeon, Green Sturgeon, White Sucker, Bridgelip Sucker, Largescale Sucker, Mountain Sucker, Other Tench Trout – Brook Trout – Brown Trout – Bull Trout – Cutthroat Trout – Rainbow Walleye Warmouth Whitefish – Lake Whitefish - Mountain Notes: If you see a Bull Trout “LT”, it is important that you minimize handling and return it to the river as soon as possible. If you enter “Other Species, OT”, be sure to indicate what this was in your comment(s) for the batch (Catch Tab). Sample Count: Enter the number of incidental fish of each particular Species Code found in the sample tank. Sample Morts: Enter the number of incidental mortalities found in the sample. Only required for lamprey adults (“LP”, “LK”, and “LR”). Promoted Summary Condition Fish: Individual incidental species that were examined as part of the condition sample and entered with the Touch Screen (and/or edited through the Condition tab) need to be Summarized and Promoted to the Incidental Catch data entry tab. 71 This is done by using the Promote All button found in the Summary Cond. Tab. This button, when selected, summarizes the incidental condition fish by Species/Subbatch groups and populates the total sample count for each incidental fish species under the field Cond. Count. This field cannot be edited. To change this Cond. Count field, individual records must be edited in the Conditions data entry tab and re-promoted via the Summary Cond. data entry tab. To learn more about the Summary Condition tab and the promotion of condition fish into the Incidental Catch data entry tab see Section VIII.G. VIII.C.2 – Editing or Deleting Incidental Catch Records: You can only edit one record from the Incidental Catch data entry tab at a time. To edit a record, you must first select the record from the data grid at the bottom of the screen by either double-clicking on the record. The selected record automatically populate the data entry panel. The arrow next to the record is the best indicator of the selected record. At this point, edits can be made to the record. Once edits are made, choose the Save button. If no edits are necessary, choose the Cancel button To delete a record, single-click on the record you with to delete (make sure the record is highlighted and has an arrow next to it) and choose the Delete button. You will get a prompt confirming that the record is to be deleted, select Yes and that record will be removed from the local database. VIII.D. Mark Recapture Tab. In the lower data grid, the Subbatch, Sequence, Tank, Species Code, and Age Code fields are frozen on the left to help the user identify the row as they scroll to the right. Data are entered for each Sub-batch, Tank, Species Code, Age Code, and Mark Type combination that were tallied as part of non-condition sampling. 72 VIII.D.1 – Definittions and d Data En ntry Before any data can n be entere ed or edited d in the Marrk Recaptu ures data entry tab, atch they in ntend to add d/edit data to by seleccting the the user must speciify which ba onding batch in the Catch data en ntry tab. Once a batch h has been correspo selected in the Catc ch tab, you may navig gate to the M Mark Reca aptures data entry tab. e a new rec cord in the Mark Reca aptures datta entry tab b, choose N New. To create This activ vates the data entry panel at the top of the sscreen. When the firsst record is created, Site and d Batch are e carried ovver from the e Catch datta entry tab b. The user should enter a separate detailed d reccord for eacch Sub-batc ch, Tank, S Species Code, Age Code, and a Mark Type T combination. To edit a record, do ouble-click on o the reco ord from the e data entryy grid at the e bottom of the screen. Each h record ha as a sequen nce numberr to make th he editing p process f the reccord then p populate the e data entryy panel easier for the user. The data from at the top p of the scrreen and arre editable. Once nece essary cha anges are m made, choose Save. S For ease e of nav vigation, the e Tab Keys s can be ussed to move e between fields and Right and Left arrow w keys can be used to o move the cursor d field. within a data Below is a table of the t fields off data that a are entered d into the M Mark Recap ptures data entrry tab along g with the default settin ngs for eacch field, prio or to data entry. Following g this table is a list of the t fields and instructiions of the ttypes of da ata that should be entered into each fie eld and how w. 73 Field d Name Site Sequence Subbatch Tank Species Code Age Mark type Bran nd location Bran nd code Bran nd orientation n Tag number Tag color Clip code Supplemental cod de Leng gth All number n fields Deffault Settings s Set in setting dia alog For each subbattch, sequence e starts at 1 a and continues seq quentially. Wh hen a new sub bbatch is starrted, sequencce starrts over at 1 Starts at 1. The value of subb batch for the next record iss the sam me as the prevvious entry, u until the user cchanges the valu ue. Deffault is none. The value off tank for the next record iss the sam me as the prevvious entry, u until the user cchanges the valu ue. Deffault is none. Species is a required field. The value o of e spe ecies code is tthe same as tthe previous e entry, until the use er changes the e value. Deffault is none. This field is o only used for Chinook. Deffault is none. Deffault is none. Deffault is none. Deffault is none. Fielld is blank. Deffault is none. Deffault is none. Fielld is blank. Fielld is blank. Mos st number fiellds are initially set to zero. These fieldss include tally, con ndition count a and total coun nt. Sub Batch: This field d facilitates the reportin ng of marke ed fish in sa amples carrried out using different sample rates and/or mechanism m s, within on ne batch or sampling p period. The defa ault is “1”. Make M sure you y are aw ware of whicch sub-batcch the markked fish were sam mpled in forr each entry y in the Ma rk Recaptu ures data e entry tab. W When entering records in the Mark Recaptures R s tab, the su ub-batch will be carrie ed f each new record, until u it is cha anged by th he user. forward for ap: Tank/Tra The Tank field only appears att LGS, LMN N, and MCN N. Enter “A A” or “B” to designate the tank from f which the marked d fish was ssampled. T The Trap fie eld is to only be used u by the e IMN Trap.. Enter “A” or “B” to d designate trap. Species Code: Click on the Specie es Code dro op down lisst and select the e appropria ate species code from the list box. Only choose “RT” for Rainbow Trou ut if you encounte er marked rainbow r trout. de: Age Cod This field d is to be us sed for Chinook only. Click on “0 earling Chinook or 0” for subye “1” for ye earling Chin nook. See Section S VI II.B.1 for a morpholog gical diagram and methodo ology to disttinguish bettween yearrling and su ubyearling C Chinook. 74 Mark Type: Click on the Mark Type T drop down d list an nd select the type of external marrk observed or group off d on a fish o fish with identical mark m types/a attributes. C Current valid marrk types are e: TES: NOT The loca ation of Ela astomer tag gs are built into the Ma ark Type co ode (“EL” or “ER”)). You do NOT N need tto enter a T Tag/Brand Location ffor Elastom mer tags (se ee below) Coded Wire W tags and a PIT tag gs are intern nal marks th hat are not included in this entry e screen n. Recaptu ured PIT tag gged fish arre reported directly to PTAG GIS and not entered in nto FPC32.net. Brand Location: Click on the Brand Loc drop down d menu u and selectt a location code c for Frreeze Brand and Phottonic Tags s only. The e location of o Elastome er tags is no ow designated in the Mark M Type drop d down list (see above). Field validation logic checks to see e what mark e messa age is type was enttered. An error ocation cod des are use ed displayed if the wrong lo g mark type e. for the wrong An n error mes ssage is als so displayed d if Mark Ty ype is a Flo oy tag or a Visual Imp plant tag an nd da ata entry is attempted in this field d. Brand Code: C This is fo or Freeze Brands B (i.e.., Mark Typ pe = “FB”) o only. Select the brand from the drop dow wn list. Brand Orientation O : This field d is only use ed with Fre eeze Brand ds (i.e., Marrk Type = ““FB”). Clickk on the drop dow wn list and select s an orrientation. Examples include: 12 2 o’clock = 1, 3 o’clock = 2, 6 o’cloc ck = 3, 9 o’c clock = 4. An n error mes ssage is dis splayed if th he mark typ pe is anythin ng other tha an “FB”, an nd data entry is attemp pted here. Tag Num mber: This field d is for Floy y and Visua al Implant T Tags only ((i.e., Mark Type = “FL L” or “VI”). If it is discernible; enter the t tag num mber in thiss field. n error mes ssage is dis splayed if M Mark Type iss FB, EL orr ER, and d data entry An is attempted here. 75 or: Tag Colo This field d is for Elas stomer Tag gs only (i.e.., Mark Type = “EL” or “ER R”). Click on n the Tag C Color drop down listt and selectt the approp priate colorr code. Leave blank for num mbered VI tags. t de entry is attempted a fo for any If a color cod otther mark ty ype, an erro or message e is displayed. Clip Cod de: Click on the Clip Co ode drop do own list and d select the appro opriate code for the clipped fins, and clipped fiin combinations on ma arked fish. Se elect N/A when w the fis sh is unclipp ped Supplem mental Cod de: Leave blank. Tally Tottal: For eac ch Sub-battch, Tank, Species C Code, Age C Code, and Mark Type com mbination, enter total number sam mpled (non n-condition sample onlly). If entering individual fish f records s (e.g. indivvidual freeze e brand fish h) then ente er “1”. ed Summary Conditio on fish: Promote Individua al Mark Rec capture rec cords from fish that we ere examined as part of the condition n sample an nd entered with the To ouch Scree en (and/or e edited throu ugh the Conditio on tab) need to be Sum mmarized and Promo oted to the Mark Reca aptures data entrry tab. This s is done by y using the Promote A All button fo ound in the e Summarry Cond. Tab. This button, when n selected, summarize es the Mark k Recaptu ures into Su ubbatch/Ta ank/Specie es Code/Ag ge Code/an nd Mark Ty ype groups and a populates the Con nd. Count ffield in the M Mark Reca aptures datta entry tab This field canno ot be edited d. To chang ge this Con nd. Count ffield, individ dual records must m be edited in the Conditions C s data entryy tab data a and re-prom moted via the Summary Cond d. data entrry tab. To llearn more about the S Summary Conditio on tab and the promotion of cond dition fish in nto the Mark k Recaptures data entry tab b see Sectio on VIII.G. VIII.D.2 2 – Editing g or Dele eting Mark k Recaptures Rec cords: You can only edit one record from the Ma ark Recapttures data e entry tab att a time. To edit a record, firs st double-click on the record you wish to edit. The data a entry panel (to op of screen n) will autom matically be e populated d with that rrecord’s datta. At this pointt, edits can be made to o the record rd. Once ed dits are mad de, choose the Save buttton. If no edits e are ne ecessary, cchoose the Cancel buttton. e a record, single-click k on the reccord you with to delete e and choosse the To delete Delete button. You u will get a prompt p confirming thatt the record d is to be de eleted, es and that record will be remove d from the local datab base. select ye 76 VIII.E. Transportation Tab. The Transportation data entry tab is for transportation sites only (i.e., LGR, LGS, LMN, and MCN) and is intended for target salmonid species only. Each record entered into the Transportation data entry tab is broken into groups, based on Species Code, Age Code, Tank, Special Species (EF and FR), Clipped/Unclipped, and Coded Wire Tag combinations. The numbers for Bypassed, Trucked, and Barged are derived from the Collection Totals minus total mortalities (sample, facility, and research) for each Species Code, Age, Tank, Special Species (EF and FR), Clipped/Unclipped, and Coded Wire Tag combination. Since the data grid has so few columns, there are no frozen fields in the Transportation data entry tab. VIII.E.1 – Definitions and Data Entry Before any data can be entered or edited in the Transportation data entry tab, the user must specify which batch they intend to add/edit data to by selecting the corresponding batch in the Catch data entry tab. Once a batch has been selected in the Catch tab, you may navigate to the Transportation data entry tab. To create a new record in the Transportation data entry tab, choose New. This activates the data entry panel at the top of the screen. When the first record is created, Site and Batch are carried over from the Catch data entry tab. The user should enter a separate detailed record for each Species Code, Age Code, Tank, Special Species (EF and FR only), Clipped/Unclipped, and Coded Wire Tag combination. FPC32.net allows users to import the different Species Code, Age Code, Tank, Special Species (EF and Fry), Clipped/Unclipped, and CWT combinations from the Catch Detail tab into the Transportation tab. This saves time, as it is no longer necessary to enter every possible combination again. However, only data in Catch Detail for that particular batch are imported. This means that additional Species Code, Age Code, Tank, Special Species (EF and Fry), Clipped/Unclipped, and CWT combinations from previous days may need to be entered, when every-other-day transportation is in place. Furthermore, if condition data have not been promoted to Catch Detail, some Species Code, Age Code, Tank, Special Species (EF and Fry), Clipped/Unclipped, and CWT combinations may not be present. 77 To edit a record, do ouble-click on o the reco ord from the e data entryy grid at the e bottom of the screen. Each h record ha as a sequen nce numberr to make th he editing p process easier for the user. The data from f the reccord then p populate the e data entryy panel at the top p of the scrreen and arre editable. Once nece essary cha anges are m made, choose the Save bu utton. For ease e of navvigation, the e Tab Keys s can be ussed to move between fields and Righ ht and Leftt arrow key ys can be u used to movve the a field. cursor within a data t fields off data that a are entered d into the Transportattion data Below is a table of the entry tab b along with h the default settings fo or each field d, prior to d data entry. Following g this table is a list of the t fields and instructiions of the ttypes of da ata that should be entered into each fie eld and how w. Field d Name Site Batc ch Sequence Tank Species code Age code Fin clipped c Coded wire tag Defa ault Settings Set in setting dialo og Com mputed based on system da ate For each e batch, th he first incide ental catch reccord sequencce starts at 1 and continue s sequentiallyy. Defa ault is none. T The value of ttank for the next record is the same e as the prevvious entry, un ntil the user changes the vvalue. Defa ault is set to C Chinook (CH).. The value o of species cod de for the next n record is the same ass the previouss entry, until th he user chan nges the value e. Species co ode is a required field. Defa ault is set to 1 . The value o of age code fo or the next reccord is the same s as the p previous entryy, until the user changes th he value e. Defa ault is none. Defa ault is none. 78 Field d Name Special species code e All number n fields Defa ault Settings Defa ault is none. All number fields are initially se et to zero. Th hese fields incclude number bypassed d, number trucked, number barged. Tank: At LGS, LMN, and MCN choos se “A” or “B B” to design nate the corrrect tank. C Choose “N/A” to designate fish f from the separato r. The Tan nk toggle ha as been turned off for LGR. Species Code: Click on the Specie es Code dro op down lisst and es code from m the choose the approprriate specie list. Special Species Code: Click on the Specia al Species drop down list and cho oose one o of the follow wing codes: “F FR” and “EF F”. See Sec ction VIII.B B.1 for a de etailed discu ussion of ea ach of these Specia al Species Codes. Du ue to NOAA A sampling at LGR, en ntering sep parate recorrds for Erod ded Fin “E EF” steelhea ad is not po ossible. Th he only Spe ecial Species Code to o be us sed at LGR R is “FR” forr Fry. Age Cod de: Age Cod de is used for f Chinook only. Cho oose “0” for subyearlin ngs and “1”” for yearlings s. For other species th his field is u unavailable. ped: Fin Clipp Choose “Y” “ if the fis sh has an adipose a or vventral fin cclip. Choosse “N” if there are no adipose or ventral fin clips. CWT: Choose “Y” “ if there is a coded wire tag an nd you have e been requ uested by F FPC to check forr a coded wire w tag on that particu ular speciess. Choose ““N” only if yyou have checked for a coded d wire tag and a there iss there is no ot a tag. Otherwise ch hoose “N/A”. Num Bypassed: Enter the e number off fish bypas ssed for eacch Species s Code, Ag ge Code, Tank, Special Species (E EF and Fry)), Clipped/U Unclipped, and CWT combinatio on. See Section VII.I for a detailed d disc cussion of how to get these numbers from net reports. FPC32.n Num Tru ucked: Enter the e number off fish trucke ed for each Species C Code, Age Code, Tan nk, Special Species (E EF and Fry)), Clipped/U Unclipped, and CWT combinatio on. See 79 Section VII.I for a detailed discussion of how to get these numbers from FPC32.net reports. Num Barged: Enter the number of fish barged for each Species Code, Age Code, Tank, Special Species (EF and Fry), Clipped/Unclipped, and CWT combination. See Section VII.I for a detailed discussion of how to get these numbers from FPC32.net reports. VIII.E.2 – Editing or Deleting Transportation Records: You can only edit one record from the Transportation data entry tab at a time. To edit a record, double-click on the record you with to edit. The data entry panel (top of screen) is populated with that record’s data. At this point, edits can be made to the record. Once edits are made, choose the Save button. If no edits are necessary, choose the Cancel button. To delete a record, single-click on the record you wish to delete and choose the Delete button. You will get a prompt confirming that the record is to be deleted, select Yes and that record will be removed from the local database. VIII.F. Conditions Tab. The Conditions data entry tab allows users to edit/browse individual fish from the condition sub-sample that were entered through the touch screen. For convenience, the Sub-batch, Sequence, Tank, Species/Age Code, Special Species Code, Coded Wire Tag, Mark Type (clip code), and Elastomer Code are frozen on the left side of the data grid to help the user identify the row as they scroll to the right. VIII.F.1 – Definitions and Data Entry Before any data can be entered or edited in the Conditions data entry tab, the user must specify which batch they intend to add/edit data to by selecting the corresponding batch in the Catch data entry tab. Once a batch has been selected in the Catch tab, you may navigate to the Conditions data entry tab. To enter new fish condition records through the Conditions tab, choose New. Enter a fish condition record for an individual fish and choose the Save/New button. Upon entering your last entry, you must choose the Cancel button after choosing Save/New for that record. Subbatch, Species and Length are required for each individual fish condition record. To edit a record, double-click on the record you wish to edit. Each record has a sequence number to make the editing process easier for the user. The data from the record then populate the data entry panel at the top of the screen and are editable. Once necessary changes are made, choose the Save button. For ease of navigation, the Tab Keys can be used to move between fields and Right and Left arrow keys can be used to move the cursor within a data field. 80 Below is a table of the t fields off data that a are entered d into the Conditions data entry tab b along with h the default settings fo or each field d, prior to d data entry. Following g this table is a list of the t fields and instructiions of the ttypes of da ata that should be entered into each fie eld and how w. Field Nam me Site Sequence e Sub-batch Tank/Trap Species Code C Age Mark type e Coded Wire W Tag Special species code Elastome er code Color cod de Descaling g Weight Default Settings S Set in settting dialog For each subbatch, seq quence startss at 1 and con ntinues sequentia ally. When a n new subbatch h is started, se equence startts over at 1 Starts at 1. 1 The value of subbatch ffor the next re ecord is the ssame as the pre evious entry, u until the user changes the value. Default is none. The vvalue of tank ffor the next re ecord is the same as the pre evious entry, u until the user changes the value. Default is none. Speciies code is po opulated when the user chooses a value from tthe Species o or Miscellaneo ous Incidenta al pull down men nus. Default is none. This ffield is only ussed for Chino ook. Default is none. Default is none. Default is none. Default is none. Default is none. Default is none. Weight is a number fie ld and is initia ally set to blank. The user may enter a we eight to the ne earest 10th o of a gram (up to 100 gramss) 81 me Field Nam Length Comment Fields Default Settings S Length is a number fie ld and is initia ally set to blan nk. The user may enter a fork length to th he nearest millimeter (up to 1,000 millimeterrs) General Comment C and d Special Com mment are texxt fields. Use ers can put up p to two comm ments into the ese fields, witth a semicolo on separating g the differen t comments. Site and d Batch: The Site and Batch h fields cannot be edite ed. They a are set in th he Setting d dialog box. Site e contains the three character co ode for the remote site e entering th he daily batch, su ub batch an nd fish cond dition data. The batch h number co ontains: two o digits for the ye ear and thre ee digits for the day off the year 1 1-366 (YYD DDD). Sub Batch: This is th he sub-batc ch number associated a with each iindividual fiish. Each ssubbatch has an individ dual sample e rate. Sam mple rates ffor each sub-batch are e entered e Catch De etail tab. under the Tank: At LGS, LMN, and MCN choos se “A” or “B B” to design nate the corrrect tank. C Choose “N/A” to designate fish f from the separato r. Species Code: Click on the Specie es Code dro op down lisst and choo ose the appropriate Sp pecies om the list and a the Spe ecies Code e field will b be populate ed. Species s Code Code fro is a required field an nd is intend ded to be ussed for targ get salmonid species. For es code includes the a age of the in ndividual sa ampled, with “CH1” Chinook,, the specie for Chino ook yearling g and “CH0 0” for Chinook subyearrling. Species list for LG GR, LGS, and LMN L Speecies list for BO ON, JDA, and d MCN (in ncorporating llamprey juven niles) Miscella aneous Incidental: The Misc cellaneous s Incidenta al codes include several s non-salmonid incidental i fish code es. This dro op down me enu optionss are listed d alphabetic cal by incidental species name, n NOT T incidental species code. 82 Inciden ntal Code e BM BS BL BH CP CC CM UM CR LD SD BK LK LP LR MA OT PM PE SQ PI SR dental Speciies Incide ental Incid Name Co de Bass, La arge Mouth SC C Bass, Small Mouth SA A Bluegill and Pumpkin nseed SJ Bullhead d RS S Carp SP P Channel Cat SK K Chiselm mouth SN N Chum SG G Crappie species BU U Dace – Long Nose LU U Dace – Speckled MU Killifish, Banded SU U Lamprey y Adult (Brook) TT T Lamprey y Adult (Paciffic) BT T Lamprey y Adult (Riverr) NT T Madtom m, Tadpole LT T Other sp pecies not listted CT T Peamou uth RT T Perch W WE Pike Min nnow, Northern W WA Salmon, Pink (juv) LW W Sand Ro oller MW W Incidental Species Name Sculpin n species Shad A Adult Shad JJuvenile Shinerr, Redside Siberia an Prawn Stickle eback, 3 Spine e Sturge eon, Green Sturge eon, White Sucker, Bridgelip Sucker, Largescale Sucker, Mountain Sucker, Other Tench Trout – Brook Trout – Brown Trout – Bull Trout – Cutthroat Trout – Rainbow Walleyye Warmo outh Whiteffish – Lake Whiteffish - Mountain otes: No If you see e a Bull Tro out “LT”, it iss importantt that you m minimize handling and return it to the riiver as soon as possib ble. If you enc counter an “Other Spe ecies, OT”, be sure to indicate wh hat this was in yo our commen nt(s) for the e batch (Catch Tab). Special Species Code: Click on the Specia al Species drop down listt and choos se one of th he following g codes “EF F”, “LF” and d “HO”. See Section VIII.B..1 for a deta ailed discussio on of each of o these Sp pecial Species Codes. Note: SMP sites s no longer take condition data fo or Fry “FR”. Therefore e, “FR” is no o longer an option in th his drop do own list. All Fry sample ed should b be en ntered as non-conditio on fish, usin ng the Catc ch Detail tab. Mark Type: The Mark Type dro op down listt includes cchoices for what type e of clip a fish f has (ad dipose, adip pose and left ventrral, etc.). Use U “N/A” if individual ccondition fish does s not have any a type of clip. 83 Elas. Co ode: The Elas s. Code dro op down listt includes cchoices for a fish witth an Elasto omer tag and a its locattion. Color Co ode: The Colo or Code drop down lis st allows the e user to choose the color of the Elasto omer tag. ng: Descalin The Descaling drop p down list includes th hree choices for desca aling including: Pa artial Desc cale for fish with desca aling greate er than 5% but less tha an 20% De escale for fish f that are e >20% desscaled De escale Pre edator for fish that are descaled a and have clear predator marks. E: If Desca ale Pred is chosen, c at least one o of the Preda ator check-boxes NOTE sh hould be ch hecked (see e Predator Checkbox xes below) Weight: Enter the e weight of the fish in the t Weightt field. Weight is NOT T a mandato ory field for condition fish. Weight W is measured in grams and d can range e from 0.1 to o 999.9 grams. Weights W are e accepted to the nearrest tenth o of a gram. Sp pecies Code CH0 CH1 ST SO CO MP P, AP, AS, AB B Weigh ht Range 0 tto 150 0 tto 150 0 tto 375 0 tto 199 0 tto 175 0 tto 20 net has pre--defined we eight range es for each o dition monito oring FPC32.n of the cond target sp pecies. If a weight is entered e thatt is outside of this rang ge, the reco ord can still be sa aved. How wever, when n these data a are imporrted into the e Condition n tab, the suspect value will w appear Red R in the D Data Revie ew Grid. T This is intended to s weight. It is up to the e user to de ecide if this weight is alert the user to an anomalous e. The tablle above prrovides the pre-defined d weight ra anges wrong orr acceptable that are used u for da ata validatio on for each of the targe et species. 84 Length Enter the e fork length h of the fish h in the Len ngth field. Length is a required d field for cond dition fish (except ( miiscellaneou us inciden ntals). Leng gth is meassured to the neare est millimetter and can range from m 1 to 999 m mm FL (no decimal pla ace is allowed for f length). Species Code CH0 CH1 ST SO CO MP, AP, AB AS Len gth Ran nge 61 to o 250 61 to o 250 61 to o 350 61 to o 200 61 to o 250 70 to o 250 30 to o 75 FPC32.n net has pre--defined len ngth rangess for each o of the condition monito oring target sp pecies. If a length is entered that is outside of this rang ge, the reco ord can still be sa aved. How wever, when n these data a are imporrted into the e Condition n tab, the suspect value will w appear Red R in the D Data Revie ew Grid. T This is intended to s length. It is up to the user to deccide if this llength is alert the user to an anomalous e. The tablle above prrovides the pre-defined d length ran nges that wrong orr acceptable are used d for data va alidation forr target spe ecies. If an anomalo ous length is identified d for an individual reco ord as part of the va alidation pro ocess, dele ete this anomalous len ngth and lea ave the leng gth field blank (as opp posed to atttempting to o correct the e length). O Once the le ength is eleted, a Le ength-value Alert Buttton will fla ash Red nexxt to the len ngth de fie eld. If anomalous s lengths arre deleted ffrom conditiion fish, the e field will h have a va alue of 0. Iff your on-site database es use thesse length data, you will need to be sure to filter these e 0’s out beffore calcula ating summ mary statisticcs. 85 Predatorr Checkboxes: There are three che eckboxes fo ound near t he Predato or label. Th hese includ de: Bird, d Lamprey y. If a fish has h marking g due to a p predator or predators, check Fish, and all of the boxes thatt apply. NOTE E: Detailed d definition ns of each of these p predator co onditions a are prrovided in a separate e manual. heckboxes s: Injury Ch There are five checkboxes found near the e Injury lab bel. These include: H Head, Eye, Ope erc., Body, and Fin. Check all o of the boxess that applyy for an inju ured fish. If a fish has h specific c and/or oth her injuries that site pe ersonnel wa ant to recorrd, use the Spec cial Comment field. TIP: To save tim me, when entering e a ccomment intto the Spec cial Comm ment field, us se predefine ed codes fo or particula r conditionss. Also, up p to two com mments ca an be entered into this s field, as lo ong as they are separa ated by a se emicolon. NOTE E: Detailed d definition ns of each of these in njuries are provided in a se eparate ma anual. 86 xes: Disease Checkbox There are six check kboxes foun nd near the e Disease la abel. Thesse include: Fungus, aris, BKD, Parasite, Deformity, D , and Otherr. Check all boxes tha at apply Columna for a dise eased fish. If the fish has a disea ase other th han one of these, checck the Other bo ox and type e in a comm ment in the S Special Co omment fie eld. TIP: To save tim me, when entering e a ccomment intto the Spec cial Comm ment field, us se predefine ed codes fo or particula r conditionss. Also, up p to two com mments ca an be entered into this s field, as lo ong as they are separa ated by a se emicolon. NOTE E: Detailed d definition ns of each of these diseases arre provided d in a se eparate ma anual. onditions Checkboxe C es: Other Co There are five checkboxes tha at are desig nated as O Other Cond ditions. These include: Pop Eye, Fin Hemm., Pink Fin, Fin Disco ol, and Eye e Hemm.. C Check all of the bo oxes that ap pply. NOTE E: Detailed d definition ns of each of these diseases arre provided d in a se eparate ma anual. 87 General Commentt: Enter any specific comments c about a the fissh that you u may think are importa ant and e Special C Comment ffield. have nott been entered into the TIP: To save tim me, when entering e a ccomment intto the Gene eral Comm ment fie eld, use pre edefined codes for parrticular cond ditions. Alsso, up to tw wo co omments ca an be enterred into eacch commen nt field, as lo ong as theyy are se eparated by y a semicolo on. VIII.F.2 – Editing g or Deletting Cond dition Re ecords: To edit a single reco ord in the Conditions C data entryy tab, double e-click on the record yo ou wish to edit. e The data entry p panel (top of screen) iss populated with that reco ord’s data. At A this poin nt, edits can n be made tto the recorrd. Edits sh hould only be made m to the ese records s when you are absolu utely sure th hat there wa as an error in data d entry. For examp ple, if an anomalous le ength is iden ntified for a an individua al record, de elete this an nomalous le ength and leave the le ength field b blank (as opposed to attempting to corre ect the leng gth). Once edits are m made, choosse the Save buttton. If no edits e are ne ecessary, cchoose the Cancel buttton. FPC32.n net also allo ows the use er to edit the e Sub-batc ch number and/or Tan nk for multiple records r at once. o To do d this, first check the box in the E Edit column of the data grid d for all the records you u wish to ed dit. Second d, select the Edit butto on. Change the Sub-ba atch and/orr Tank to th he correct vvalue for the e records to o be edited. Press P the Update U Sub b-batch buttton to edit the sub-sub-batch forr the records and/or a the Update U Tan nk/Trap bu utton to editt the Tank/T Trap for the e records. 88 e a record, single-click k on the reccord you wish to delete e and choo ose the To delete Delete button. You u will get a prompt p confirming thatt the record d is to be de eleted, select Ye es and that record will be remove ed from the local datab base. VIII.G. V Summar S ry Cond. Tab. The T Summa ary Cond. tab t allows users u to vie ew summarrized fish co ondition reccords th hat are grou uped by key y fields (listted below) ffor promotion into the Catch Dettail, In ncidental Catch, C and Mark Reca aptures tab bs. The condition fish in the data a grid are grouped by: Sub-batch h, Tank, Sp pecies, Clip p Code, CW WT, Specia al Species, Elastomer E tags, t and Elastomer E tag t colors. Upon pro omotion, the e Catch De etail, In ncidental Catch, C and Mark Reca aptures tab bs all receivve differentt subsets off these summarized d condition data. d For example, e th he records ffor the incid dental speccies are ed to the In ncidental Ca atch tab. C Clicking the e Promote A All button a adds the only promote d records to o the approp priate data entry tab. For conven nience, the Subsummarized batch, b Tank k, Species,, Clip Code e, CWT, Sp pecial Spec cies, Elast.., and Colo or codes are frozen on the left to o help the user u identifyy the row ass they scrolll to the righ ht. VIII.G.1 – Definittions No data are entered d or edited into the Su ummary Co ond. tab. T This tab is specifica ally used to promote th he condition n fish data into the Cattch Detail, Incidenttal Catch, and a Mark Recaptures R s data entryy tabs. Befo ore promoting, the user mus st specify which w batch they intend d to promotte data for b g the by selecting correspo onding batch in the Catch data en ntry tab. Once a batch h has been selected in the Catc ch tab, you may navig gate to the S Summary C Cond. data a entry 89 tab. Upo on successfful promotio on, the use r will hear a prompt an nd see a re ed pushpin icon in i the uppe er-right of th heir screen.. pes of data tthat can be e found in Below if a list of the fields and instructionss of the typ d. each field Site and d Batch: The Site and Batch h fields cannot be edite ed. Site is set in the S Setting dia alog box. Batch is set when data d entry for f the batc h is first sta arted, generally with th he touch screen. Site contains the three characterr code for the remote site enterin ng. The Batch nu umber conttains: two digits for the e year and tthree digits for the dayy of the year 1-36 66 (YYDDD D). Catch Detail Sub Batches: B The curre ent selected batch’s sub-batch numbers and d associate ed sample rrates are displayed d in this sm mall data grid at the top p of the tab window. T These data are not editable. It is for refference onlly. During e entry of the e non-condiition sample es into Catch Detail, the user entered d a sample rate for eacch of the su ub batches from which da ata were entered. This s data grid a allows the user to see e these noncondition n sub-batch hes and their corresponding samp ple rates. T This is help pful because it indicates s what sample rate(s) will be applied to the ccondition re ecords upon pro omotion. Th his data grid d will only b be populate ed if data fo or non-cond dition fish were enttered into Catch C Detaiil, it is otherwise blankk. 90 Conditio ons Sub-Ba atches: When en ntering cond dition data via v the toucch screen, tthe user en nters a sub--batch number for f each fish condition record. Th he sub-batcch numberss for the condition fish are listed in this s data grid, along with the corresp ponding de efault sample rate that was assigned to these sub b-batches, as entered in the Setttings tab. If data for non-c condition fis sh were enttered into C Catch Detail, the samp ple rate(s) e entered into Catc ch Detail will w automatiically overw write these ccondition sample ratess. Note: If all fish sampled s we ere conditio on fish, the user must ccheck to make sure the default sa ample rates s from the S Settings ta ab were corrrect for thiss batch be efore promo oting condittion fish into o the Catch h Detail, In ncidental C Catch, an nd Mark/Re ecap tabs. To correct them, rightt-click in the e Sample R Rate cell in the Condition Sub-B Batches bo ox at the top p of the scre een (A in th he figure be elow). This s allows you u to manually enter the e sample ra ate for that pa articular sub b-batch (mu ust be betw ween 0.0 an nd 1.0). Yo ou will be prrompted wiith a messa age asking if you wantt this samplle rate to be e applied to o all re ecords of this sub-batc ch. Click Ye es. Once tthis is done e for each o of the su ub-batches,, click on th he Promote e All button n. When co ondition sam mple da ata are inco orporated in nto the Catc ch Detail ta ab, the sam mple countss for co ondition fish h will appea ar in the Co ond. Samplle Count fie eld of the d data grid. If data were entered d in Catch Detail, the sample rattes in the tw wo review g grids must match for each of the sub b-batches. If you noticce that the sample rate in either of these two data d grids do d not matcch, you musst change tthe sample rate in Catch Detail. See Section VIIII.B.1 abovve for instru uctions on h how to do th his. A VIII.H. V Fish F Con ndition Touch T S Screen. The T Fish Co ondition To ouch Scree en allows u users to entter individua al fish cond dition data. To T open the touch scre een to enterr fish condittion recordss for a new w batch (with h the Setting S dialo og Fish Co ondition To ouch Scree en Only checkbox che ecked), dou uble-click on the FPC3 32.net icon. The touch screen w will open on the computer’s deskto op. To T open the touch scre een to enterr fish condittion recordss using an existing batch re ecord: (with h the Settin ng dialog Fish F Condittion Touch h Screen O Only checkb box unchecked) double-clic ck on the FP PC32.net iccon. Right cclick on the e FPC32.ne et icon in th he system tray t and choose Open n Main Form m. From th he Main Fo orm, choose e the 91 Catch C data entry tab and select th he batch yo ou want to w work with. C Choose File | Open Condition C Touch T Scre een. VIII.H.1 – Data Entry E Seq quence fo or the Fish Condition Touc ch Screen: 1. Ope en the fish condition c to ouch screen n. A dialog g box appea ars with thre ee butttons: 1) The e Batch En nd Day Tod day button creates a b batch with tthe enddate e correspon nding to tod day’s date, 2) the Battch End Da ay Tomorro ow buttton creates a batch with the end--date corressponding to o tomorrow’’s date, and d 3) the Battch End Da ay Yesterda ay creates a batch witth the end-d date corrresponding to yesterda ay’s date. 2. Clic ck on the ap ppropriate Batch B End Day button n to create the desired d batch. If a batch alrea ady exists with w any of these end-dates, a pu ush-pin icon n app pears next to t the already existing batch’s Ba atch End D Day button. Once you have done e this, the Fish F Condittion Touch h Screen w will appear. 92 Touch h screen for LGR, LGS, a and LMN Touch screen for BO ON, JDA, and d MCN (incorrporates con ndition monittoring for lam mprey juvenilles). 93 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. Press New. Th he backgrou und panel tturns white,, meaning tthat the com mputer will accept data a. If the ba ackground p panel is gra ay, the com mputer will b beep whe en you pres ss a button because it is not in the New or E Edit mode. Whe ere applica able, select the Tank fo or the sub-b batch you a are currentlly sam mpling. Turn On the sc cale and ad dd the tray ((the scale a automatically tares or ompensate for the weiight of the ttray), place e the fish in the tray, calibrates to co and d press the Print button on the sccale. Notte: You do not need to o place the tray on the e scale betw ween fish bu ut you may y need to Tare T the sca ale occasionally betwe een fish) Ente er the fish Length L using the toucch screen n number pad d. Press the apprropriate Species, Clip p, Conditio on, and Tag gging butto ons. If a Special Co omment ne eeds to be entered, prress the Sp pecial Com mment buttton and type the comm ment using the touch sscreen keyb board. The e user can only enter two comments or cod des in this ffield, each sseparated b by a sem micolon. If a General Comment C needs to be entered, press the Ge eneral Com mment buttton and type the comm ment using the touch sscreen keyb board. The e user can only enter two comments or cod des in this ffield, each sseparated b by a sem micolon. Press the Save e/New buttton to save the individu ual fish record and sta art on the nex xt fish. Return the fish h to the byp pass to whe ere ever it n needs to go. peat Steps 4 through 9 for each subsequen nt fish. Rep Afte er the recorrd for the last fish is sa aved, you m must choose e the Canc cel button prio or to exporting data. VIII.H.2 2 – Fish Condition C Touch S Screen – F Function Buttons These fu unction butto ons appearr in the lowe er center and right corrner of the ttouch screen. The following describe es the funcctions of eacch of the bu uttons in this section of o the touch h screen. Number Pad: The focu us of the number pad is s automaticcally set to the length ffield for enttering fish lengtths. To cha ange the fo ocus of this number pa ad to the we eight field, tthe user must sele ect either Enter E Weight or Clearr Weight. IIf a comment button iss chosen, 94 numbers s can be entered into the commen nt field by u using this number pad. The CE butto on clears the e number that are in th he field tha at is currently in focus. nel: Exit Pan When the e Exit Pane el button is s chosen, a pop-up me enu will appear. This pop-u up menu ha as three opttions: Exit, Hide n. Choose Exit to exit the touch screen Screen, and Return and close e the FPC3 32.net program. Choo ose Hide Sc creen to close the e touch scre een and retturn to the M Main Form m. Choose Return R to return r to the e touch scre een for add ditional data entrry. New: The New w button allo ows the use er to enter n new record ds. After pressing the New button, th he background panel turns t white and the Ne ew button d disappears,, indicating g that data entry is allo owed. Once e the first re ecord has b been entere ed the user mus st press the e Save/New w button to save the re ecord. Save/Ne ew: The Save/New buttton allows the user to ssave the cu urrent recorrd and automatically starts a new reco ord for the n next fish. T The Sub-ba atch and Ta ank of the previous record automatica ally appear for each ne ew record. You must correct the Sub--batch and//or Tank ea ach time yo ou switch Sub-batches s or Tanks s. Edit: The Editt button allo ows the use er to edit the e record sh hown in the record bro owsing panel (fo ound in the lower left corner of the e touch scre een). Afterr pressing the Edit button, th he background panel turns t white, indicating that data e entry is allowed. Once editing is com mplete the user u must p press the Sa ave button to save the e changes to the reco ord. Delete: The Dele ete button allows a the user u to dele ete the curre he record ent record shown in th browsing g panel. Next: The Nex xt button allo ows the use er to naviga ate to the n next record in the fish ccondition record se et (each rec cord is show wn in the re ecord browssing panel)). The Next button cannot be used if a record is active a (i.e., d data entry/e editing is alllowed). Previous s: The Prev vious butto on allows th he user to n navigate to tthe previou us record in the fish condition n record sett (each reco ord is show wn in the reccord browsing panel). The Previous s button ca annot be use ed if a reco ord is active e (i.e., data entry/editin ng is allowed) Cancel: The Can ncel button is used to cancel c ente ering a new w record or tto cancel ed diting a record. 95 Export The Export button saves s the condition c re ecords to an n .XML file named with h the site and batc ch number. The locatio on where th his file is sa aved is specified in the e Setting dialog bo ox for your wet w lab com mputer. Up pon successsful export, the user w will hear a prompt and a see an icon under the data re eview panel. VIII.H.3 3 – Fish Condition C Touch S Screen - R Record Browsing Panel The Record Brows sing Panel of the Fish h Condition n Touch Sc creen is fou und in the lowerr left cornerr of the touc ch screen. This form displays the current re ecord being entered (or ed dited) or it shows s the llast record entered. A B C The Top Section (A A in above figure) of th he Record Browsing Panel disp plays the Tank/Tra ap, Species, Special Species, C Clip Codes s, Elastome er Code, Elastom mer Color, CWT, C Gene eral Comm ment, and S Special Com mment. k/Trap: Tank This will w be eithe er “A” or “B B”, where ap pplicable. If no Tanks s are presen nt, this field will w be blank. Spec cies Code: Spec cies Code is a Requirred Field fo or condition fish. Therefore, the text box for Sp pecies Cod de will appe ear yellow w when a new w record is created, un ntil a Spec cies Code is chosen by b the user. When a S Species Co ode is chose en, this field will w have the two letterr code of that species. If the indivvidual fish iis a Chino ook, there will w be a thirrd digit corrresponding to the Age e Code (“0”” for subye earlings and d “1” for yearlings). This field is u used for tarrget species and incide entals that are a entered d with the F Fish Condittion Touch h Screen. For a detailled explana ation of eac ch of the Sp pecies Cod des, see Se ection VIII.B B.1 (Targ get Species) and Sectiion VIII.C.1 1 (Incidenta al Species) above. 96 Special Species: This field is where the Special Species Code is displayed. There are three possible Special Species Codes for condition fish: 1) “HO” for yearling Chinook holdovers, 2) “EF” for eroded fish steelhead, and 3) “LF” for Lyons Ferry yearling fall Chinook. Clip Code: This field is where any clip codes will be displayed. There are five possible clip codes: 1) “AD” for adipose clip, 2) “LV” for left ventral clip, 3) “RV” for right ventral clip, 4) “AR” for adipose and right ventral clip, and 5) “AL” for adipose and left ventral clip. This field is blank if the fish is not clipped. Elastomer: This field is where any Elastomer tag information is displayed. There are two possible codes for this field: 1) “ER” for an Elastomer tag on the right or 2) “EL” for an Elastomer tag on the left. This field is blank if the fish does not have an Elastomer tag. Color: This field is where the Elastomer Tag Color is displayed. Below is a list of the different color codes. This field is blank if the fish does not have an Elastomer tag. BL – blue RE – red GR – green OR – orange YE – yellow PI – pink PU – purple OT – other CWT: This field indicates the presence “Y” or absence “N” of a Coded Wire Tag. Currently, only LGR, LGS, and LMN examine condition fish for CWT. For these sites, the default value for CWT is “blank” for clipped Chinook, coho, and sockeye. The default value for CWT is “N” for unclipped Chinook, coho, and sockeye, unless the user enters “Y”. For steelhead, the default CWT is “blank”, regardless of clip status. General Comment: The user can enter General Comments about the fish when entering fish condition records. This is where these General Comments are displayed. Two separate comments can be entered, each separated by a semicolon. Special Comment: The user can enter Special Comments about the fish when entering fish condition records. This is where these Special Comments are displayed. Two separate comments can be entered, each separated by a semicolon. The Middle Section (B in above figure) of the Record Browsing Panel is where the fish condition information is displayed. Fish condition information is divided into four types of conditions, including: 1) Predator, 2) Injury, 3) Other Condition, and 4) Disease. In addition to these conditions, there are fields for the Weight and Length of each condition fish. 97 Predator: This row is where any Predator data are displayed. If any of the predator buttons are pushed, that predator type is displayed in this row. Possible entries in this row include: 1) Bird, 2) Fish, and 3) Lamprey. Injury: This row is where any Injury data are displayed. If any of the injury buttons are pushed, that injury will be displayed in this row. Possible entries in this row include: 1) Head Injury, 2) Eye Injury, 3) Operculum Injury, 4) Body Injury, and 5) Fin Injury. Other Cond: This row is where any Miscellaneous Injuries are displayed. If any of the misc. injury buttons are pushed, that misc. injury will be displayed in this row. Possible entries in this row include: 1) Pop Eye, 2) Fin Hemorrhage, 3) Pink Fin, 4) Fin Discoloration, and 5) Eye Hemorrhage.. Disease: This row is where any Disease data are displayed. If any of the disease buttons are pushed, that disease will be displayed in this row. Possible entries in this row include: 1) Fungus, 2) Columnaris, 3) BKD, 4) Parasite, 5) Deformity, and 6) Other. Weight: The Weight field holds the weight (grams) of the fish that was entered via the scale. Even though Weight is NOT a Required Field for condition fish, the text box for Weight will appear yellow when a new record is created, until a Weight is entered by the user. There can be 5 digits in the weight field including three numbers before the decimal point, a decimal point, and one number after the decimal point. The weight field can have data values in the hundreds (up to 999.9 grams). Weight is not mandatory at BO2 or JDA. Length: The Length field holds the length (millimeters) of the fish, which was entered via the number pad. Length is a Required Field for condition fish. Therefore, the text box for Length will appear yellow when a new record is created, until a Length is entered by the user. There can be 3 digits in the length field. There are no decimals in this field. Length can have data values in the hundreds (up to 999 mm). Length is mandatory at all sites where condition data are collected. The Bottom Section (C in above figure) of the Record Browsing Panel displays the Site, Batch, Date, S/batch, and Sequence number. Site: This site field is where the Site is displayed. Site was chosen in the Settings dialog box. 98 Batch: The Batch field is where the Batch number is displayed. This batch number is a five digit number, where the first two digits correspond to the year (e.g., 09) and the last three digits correspond to the sample end date in Julian Days. This number was generated based on which Batch End Day button that was selected when initially opening the touch screen. Date: The Date field is where the batch end date is displayed. The batch end date corresponds to which Batch End Day button was selected when initially opening the touch screen. Sub-batch: This field is where the Sub-batch number is displayed. Up to 999 subbatches can be displayed in this field. Sequence: This field is where the Sequence number of the individual fish record is displayed. Each sub-batch starts with a sequence number of 1 and each record is incremented by one. If a record is deleted, that sequence number is deleted with it. The deleted sequence number cannot be used again in the current sub-batch. VIII.H.4 – Fish Condition Touch Screen - Tallies The Touch Screen Tallies are found in the upper right corner of the touch screen. These are the total number of condition fish that have been sampled. Condition fish are broken into several categories based on: 1) Species, 2) Clipped/Unclipped, 3) Tank, 4) Special Species, and 5) Incidentals “Tank A and None” and “Tank B” Tallies (A in figure below): Each of the target salmonid species are tallied based on whether they were sampled in Tank A (or None) or Tank B and whether they were Clipped (AD, RV, LV, AR, AL) or Unclipped. If the site does not have a tank, the species/clip type tallies are displayed in the Tank A and None display. Special Species Tallies (B in figure below): Each of the Special Species are tallied based on whether they were sampled in Tank A, Tank B, or None (for those sites without tanks). These fish are included in the “Tank and None” and “Tank B” tallies above. Total Incidental Tally (C in figure to below): This tally is the total number of Miscellaneous Incidental Species that are entered via the touch screen. Total Sampled Tally (D in figure below): This tally is the total number of fish (Salmonids and Miscellaneous Incidentals) that have been entered via the touch screen for a single batch. 99 A B C D Touch screen tallies for LGR, LGS, and a LMN for 20 013 Touch screen tallies for BON, JDA A, and MCN foor 2013 (incorpoorates lampreyy juveniles) VIII.H.5 5 – Fish Condition C Touch S Screen – C Condition n, Specie es, and Mark Type Buttons The cond dition, spec cies, and ma ark type bu uttons on th he Fish Con ndition Tou uch Screen are a found in n the upperr left and ce entral portio on of the tou uch screen. These buttons are a grouped d in section ns and some e are also g grouped byy color. The ese buttons have h many functions. Some of th he buttons ttoggle on a and off, som me move the comp puter focus to a speciffic field, som me clear a ffield or field ds, some op pen a pop-up screen s with additional selections, s and some select the a appropriate e subbatch and tank. The condition button gro oupings incllude: 1) Ela astomer Lo ocation or, 2) Gene eral Comments, Sub--batch, and d Tank, 3) D Disease/Pa arasite and Colo condition ns, 4) Injuriies, 5) Misc cellaneous s Condition ns, 6) Desc caling, 7) Predatio on, 8) Mark k Types, 9) Length an nd Weight ffunctions, 1 10) Species s, Special Species, and a Inciden ntal Specie es codes. 100 Touch sc creen specie es and conditions for LG R, LGS, and LMN. Note – LGR does not have Tank B Buttons Touch scrreen species s and conditiions for BON N, JDA, and M MCN (incorp porating cond dition mo onitoring forr lamprey juv veniles). Notte – MCN tou uch screen h has buttons ffor Tank A an nd Tank B in same locatio on as LGS a nd LMN touc ch screen. 101 ation and Color: C Elasttomer Loca If the condition fish f has an Elastomerr tag, the usser pressess the appropriate Colorr/Location button. Th hese button ns toggle o on and off. If a user se elects the wrong g button, simply selectt the correcct button or select the same butto on to remov ve that Elas stomer, tag g location, a and tag colo or. Gene eral Comments, Sub--batch, Tan nk, and Sp pecial Comments: e buttons allow a the us ser to enter the approp priate Sub-b batch, Tan nk, and These Comm ments for each e individ dual fish. When n the user selects s Gen n. Commen nts a popup p appears w with the gen neral comm ment text fie eld and a ke eyboard. U Users are allowed to enter two co omments per fie eld separatted by a semicolon. P Pressing Su ubmit enterrs the comm ments into th he databas se. The Clr. Gen. Com mments buttton clears the Genera al Comm ments text field. When n the user begins b ente ering data, S Sub-batch defaults to o “1”. To ch hange the Sub-batch, the user sh hould push the Sub-ba atch button n. Each tim me the batch butto on is presse ed, the Sub b-batch number increa ases by 1. If the Sub-b user presses p the e Sub-batc ch button to oo many tim mes, the use er can presss the Clr Sub-b batch butto on to return n the Sub-b batch numb ber to 1. e Tank A o or Tank B b button for th he Wherre applicablle, the userr selects the appro opriate tank k. The Tank A and Ta ank B butto ons toggle on and off. Once Tank k A or Tank k B is selectted for a sin ngle fish, th hat tank is ccarried on to o 102 subse equent fish until a diffe erent tank o or sub-batch is chosen n by the use er. These e Tank butttons are hid dden for BO O2, JDA, an nd LGR. When n the user selects s Spe ecial Comm ments a popup appears with the general comm ment text fie eld and a ke eyboard (se ee Generall Commentts keyboard d above e). The inttent of this s field is fo or sites to u use it for o other condiitions that they t would d like to ke eep track o of, but don’’t have butttons for. IIt is recom mmended th hat sites co ome up with h two-letter codes for tthese conditions and le et FPC kno ow what the ese codes a are and wha at they stan nd for. FPC C will use these e codes with h developin ng the site-sspecific too ols for site-sspecific data abases. Users s are allowe ed to enter two comme ents per fie eld separate ed by a sem micolon. Press sing Submiit enters the e commentts into the d database. Disea ase/Parasite Conditio ons: These e buttons allow a the us ser to enter the followin ng Disease es/Parasite es: Fung gus, Colum mnaris, BKD D, Parasite e, Deformitty and Othe er. These condition button ns toggle on o and off. If a button is pressed d by mistake e, simply prress it again n to make th hat disease e/parasite g o away. Users are alllowed to ch hoose as many y Diseases as the fish has. Defin nitions and d example es of each o of these Disea ase/Parasiite conditio ons can be e found in C Condition Sampling Proto ocol docum ment. Injury y Conditions: These e buttons allow a the us ser to enter the followin ng Injuries: Head Inj. Eye Inj., Operc, O Bod dy Inj., and Fin Inj. These condition buttons toggle on n and off. If a bu utton is pre essed by miistake, simp ply press it again to m make that injjury go away y. Users are e allowed to o choose as many Injuries as the fish has. Defin nitions and d examples s of these IInjury cond ditions can n be found d in the Cond dition Samp pling Proto ocol docum ment. 103 Misce ellaneous Conditions s: These e buttons allow a the us ser to enter the followin ng Miscella aneous Cond ditions: Po op Eye, Fin n Hemm., P Pink Fin, Fin Discol., and Eye H Hemm. These e condition buttons toggle on an nd off. If a b button is pressed by m mistake, simply press it again a to make that misscellaneouss injury go a away. Userrs are allowed to choos se as many y Miscellan neous Conditions as the fish ha as. nitions and d examples s of these O Other cond ditions can n be found d in the Defin Cond dition Samp pling Proto ocol docum ment. Desc caling: These e buttons allow a the us ser to enter the followin ng Descaling Conditiions: Partia al Descale e (3% to 19% % descaled d), Descale ed (≥20% descaled), D Descale Pred (descaled ≥20% and clear preda ator marks)). If the wro ong descaling button n is pressed by mistak ke, simply p press it aga ain to make that desca aling go away y or push a different de escaling buttton to overrwrite the e erroneous sselection with the t correct selection. Only one d descaling ttype is allo owed per ffish recorrd. Definittions and examples e o of these De escaling ca ategories c can be found d in the Co ondition Sa ampling Prrotocol doc cument. Preda ator Condiitions: These e buttons allow a the us ser to enter the followin ng Predatio on conditio ons: Bird, Fish, and Lamprey. These con ndition butto ons toggle on and off.. If a n is pressed by mistak ke, simply p press it aga ain to make that Preda ator type button go aw way. Users s are allowe ed to choos e as many Predator ttypes as the e fish has. Definitions and exam mples of th hese Preda ation cond ditions can be d in the Co ondition Sa ampling Prrotocol doc cument. found Mark k Types: These e buttons allow a the us ser to enter the followin ng mark typ pes: LV (le eft ventra al), RV (righ ht ventral), and CWT ((coded wire e tag). 104 For th hose sites that t examin ne Chinook,, Coho, and d Sockeye ffor coded-w wiretags, the CWT button b is only pressed when an unclipped fissh has a CW WT. This will pllace a “Y” in the Reco ord Browsi ng Panel. For these species, the default CWT in the Rec cord Brows sing Panel is “N”. If th he CWT bu utton is presssed by mista ake, simply press it aga ain to togg gle it to the o off “N” posiition. L and RV buttons are e pressed w with a fish h has a Left V Ventral Clip “LV” or The LV a Rig ght Ventral Clip “RV”. If a fish ha as both a vventral clip a and an adip pose clip, the us ser would first f select the adipose e clip by sellecting the ccorrespond ding Species-AD buttton (see be elow). Then n the user w would selecct the corressponding Ventrral Clip buttton (LV or RV). R When n this is don ne, the Clip p Code in th he Reco ord Browsing Panel will w display a an “AR” (A Adipose-Rig ght Vent) o or “AL” (Adip pose-Left Vent). V For example, fo or a subyea arling Chino ook with an n adipose clip and a left ve entral clip, the user wo ould press C CH0-AD and then presss the LV button n C Mark button clears s Clip Cod de and CWT T fields. Att sites wherre The Clr. condiition fish are e examined d for CWT, the 1st clickk of Clr. Ma ark clears tthe Clip nd Code e while the 2 click of Clr. Mark m makes CW WT “blank”. Weig ght and Len ngth: The Enter E Weig ght and Entter Length buttons allow the use er to return focus of the nu umber key pad to the correspond ding field. T This allowss the user to o use the numb ber pad to enter e in the data into th he desired field. The C Clr. Weightt and Clr. Length L butttons clear the values in the weigh ht or length h fields and also return n focus of th he number key pad to o the corresponding fie eld. cies, Specia al Species s, and Misc cellaneous Incidentall Species: Spec These e buttons allow a the us ser to enter the followin ng Species s data: 1) C CH1-AD for ye earling Chin nook with an adipose cclip, 2) CH1 1 for unclipp ped yearling Chino ook, 3) CH0 0-AD for su ubyearling C Chinook witth an adipose clip, 4) C CH0 for unclip pped subye earling Chin nook, 5) ST T-AD for ste eelhead with h an adiposse clip, 6) ST T for an unc clipped stee elhead, 7) C CO-AD for a coho with h an adipose clip, 8) CO fo or an unclip pped coho, 9) SO-AD ffor a socke eye with an adipose cliip, and 10) SO S for an un nclipped so ockeye. In a addition to these, BON N, JDA, and d MCN will be e doing con ndition mon nitoring for llamprey juvveniles. Th he species ccodes for juven nile lamprey y are: 1) AB B for Ammo ocoete (Brook), 2) AP for Ammoccoete (Paciffic), 3) AS for f Ammocoete (Unkn nown), and 4) MP for M Macropthalm mia (Paciffic). The Species Code is a required field a and only on ne species button can be b pushed for f each fish h. If the wrrong specie es button is pressed byy mista ake, simply press the correct c speccies button to overwritte the mista ake. 105 Fish F Condition n Touch Screeen species codes for ALL sittes Additional sp pecies codes fo for lamprey juvveniles at BON N, JDA, aand MCN The Special S Species butto ons include: 1) HO for yearling Ch hinook hold dovers, 3) EF F for eroded d fin steelhe ead (unclipp ped only), a and 3) LF fo or Lyons Fe erry yearliing fall Chin nook. Thes se buttons ttoggle on a and off. Th he user is only allowed to enter one specia al species ccode for each fish. If tthe wrong S Special cies button is pressed by mistake e, simply pre ess it again n to make th hat Spec Spec cial Species s value go away or pu ush a differe ent Special Species b button to overw write the errroneous selection with h the correcct selection. Only one e Spec cial Species s type is allowed perr fish recorrd. In add dition to the e five targett salmonid species, th he user can also choosse the Misc. Incidenta al Species button. Fo r a list of th he species ccodes see tthe ction VIII.H H.3. When this button is pressed, a popspecies code listings in Sec ppears with a button fo or each of th aneous Inc cidental Sp pecies, he Miscella up ap listed in alphabe etical order of the com mon name (not the sp pecies code e). The user simply s pres sses the ap ppropriate sspecies buttton and the e popup disa appears, return ning the use er to the ma ain touch sccreen. The e selected incidental sspecies code appears in the Specie es field on the Record d Browsing g Panel. 106 107 IX X. Valid dation n IX X.A. Au utomatic c Data Validatio V on and A Alerts. Throughout T FPC32.nett, there are many auto omatic data a validation process tha at occur fo or several fiields when data are en ntered. Ma any of these e validation n process re esult in Alert/Error A Messages that alert the user to a possible e error in datta entry. It’ss im mportant to note, howe ever, that FPC32.net F w was design ned to allow w the user to o save all data that are entered d by the us ser, regardle ess of whetther the datta were a w were entered in error. The details d for many m of the various da ata checking g algorithms are explained in the detaile ed instructio ons for ente ering data in n Section V VIII. Howevver, th here are too o many valiidation proc cedures thrroughout FP PC32.net to o guarantee e that we have covere ed them all. The T Alert/Errror Messa ages fall intto a couple of basic ca ategories. B Below is a detailed explanation of the vario ous Alert/E Error Messa ages that a user may encounter when C32.net, followed by exxamples of each. entering data with FPC IX.A.1 – Suspec ct Data En ntry Alertt – Red Dot When a user u is ente ering a com mbination off data that a are outside of the valid dation criteria, a Red Dot will w appear on the susspect data e entry. This alerts the u user that somethin ng on the cu urrent data entry scree en does no ot agree with h the current validation n criteria an nd warrants s further invvestigation. Exam mple 1: Imp proper Gea ar Code, Sa ample Cod de, Sample e Hours Comb bination: When n creating a record in the t Catch ttab, this use er entered a Gear Code of “GC”,, a Sample e Code of “1 1”, and a Sa ample Hou urs of “2”. T The data va alidation proce ess assume es that Sam mple Hours s would be ““24” when G Gear Code e “GC” and Sample S Code “1” are entered. e T Therefore, a an alert Red d Dot is pro ovided to alert the t user to the suspec ct combinattion. mple 2: Imp proper Spe ecies, Spec cial Specie es Combination: Exam When n creating a record in the t Catch D Detail tab, this user en ntered a record with a Spe ecies of “CH” and Spe ecial Speciies of “EF”.. Since Special Spec cies “EF” is limited to stee elhead, a Re ed Dot app pears, along g with a Sp pecial Spec cies Valid dation Alertt to alert the e user of th he suspect combinatio on. For morre details 108 on wh hich Specie es, Special Species ccombination ns are valid d, see Secttion VIII.B B.1 – Special Species s Code. mple 3: Imp proper Sam mple Code,, Sub-batch Combina ation: Exam When n creating a record in the t Catch ttab, this use er entered a Sample C Code of “1”. However, H when w enterin ng data in tthe Catch D Detail tab, tthe user cre eated a secon nd sub-batc ch with a different sam mple rate. T This promptted a Red D Dot and a Sam mple Code e Validation n Alert to a alert the use er of the suspect comb bination. In this s case, the user should continue data entry for this reccord and sa ave the record. Then, be efore entering the nextt record, the e user shou uld navigate e back to C tab an nd edit Sam mple Code to “10”. the Catch IX.A.2 – Suspec ct Data En ntry Alertt – Red Fiield in Da ata Revie ew Grid FPC32.n net has valid dation on Length L and Weight da ata for cond dition fish. If a user enters a Length or Weight tha at is outside e of a pre-d determined range for that species, the field for that entry will appear Red in the e Data Rev view Grid o of the Conditio on tab. Forr details on these leng th and weig ght ranges, see Sectio on VII.F.1-W Weight and Section VIII.F.1-Leng V gth above. These ale erts are inte ended to alert the user to ano omalous Le ength and W Weight esttimates thatt warrant re eview. It is up to the user to keep or dellete these a anomalous estimates. FPC does s not recomm mend chang ging anomalous Leng gth or Weiight estima ates. If an anomalo ous Length h or Weigh ht is entere ed for an in ndividual, F FPC recom mmends simply deleting d the e anomalo ous estimate. Exam mple 1: Ano omalous Length L Entrry: When n creating a record forr a condition n fish, the u user entered a Length h of “500” for a yearling Ch hinook. Thiis length is outside the e expected range for yyearling Chino ook fork len ngths (see Section S VIIII.F.1-Leng gth), which prompted tthis field to be Red in the Data Reviiew Grid. 109 IX.A.3 – Data En ntry Errorr Messag ge For SMP P sites at the e dams, en ntering flow and spill da ata is mand datory for e each batch. When W enteriing flow and d spill data using the C Catch tab, the sum of Turbine Discharg ge (or PH1 and PH2 Discharge D for BO2 an nd RIS) and d Total Spill must not exceed Total Discharge. If a user en nters data tthat violate this rule, a Data Entry Errror Screen n will appea ar informing g the user that the flow w and spill d data are in violatio on of this ru ule. In this case, the u user must m make the prroper correcction before th hese data can be save ed. Exam mple 1: Flow w and Spilll Data Enttry: This user u entere ed a Total Discharge D of “200”, a Turb Disc charge of “1 199” and a Tottal Spill of “10”, “ which prompted a Data Enttry Error M Message (see above e figure). In n this case,, the user m must click o on the OK b button and m makes the prroper correction before e the record d can be sa aved. IX.A.4 – Data Re eminders s When en ntering data a with FPC3 32.net, therre are some e pieces of data that a are entered once o by the e user and are a automa atically repe eated for su ubsequent e entries by the prrogram. If the t user forrgets to entter these pie eces of datta on the firrst entry, it can become cumb bersome to o correct the e data. In o order to avo oid this, FPC32.net has built--in Data Re eminders th hat alert use ers to enterr these data a when ente ering their initia al records. 110 Exam mple 1: Enttering a Ta ank: At LG GS, LMN, and MCN, each e time a user startss data entryy for a new subba atch in Catc ch Detail, a Data Rem minder will appear rem minding the em to enter a Tank. This T is beca ause Tank is repeated for all subssequent reccords, until the t subbatc ch is changed or the user change es to a new w Tank. Thiis mess sage is also o used in the e Conditio on Touch S Screen for tthese sites.. IX X.B. FP PC32.ne et Valida ation Rep ports. Itt is importan nt that you validate yo our data beffore sending anything to the Fish Passage P Ce enter. There are severral reports tthat can be e generated d to validate e data entry. Data can be validated by comparing t hese reporrts to your h hand logs. Below is ach of the reports r that can be gen nerated witth FPC32.net and a brief descrription of ea v Some valid dation inforrmation is a also provide ed in how they can be used validation. Section S VII..J above. IX.B.1 – Daily Su ummary Report: The batc ch header in nformation is found at the top of tthe Daily S Summary R Report. This repo ort does not separate condition a and non-con ndition fish.. Target sp pecies (salmonids and lam mprey) are split s into thre ree groups: 1) Clipped, 2) Unclipp ped, and h Species re epresents a column in n the reportt. Each column has 3) Combined. Each r of data a. These ro ows are as follows: 1) Sample Co ount, 2) Co ollection several rows Count, 3) Num Exam m for Desc, 4) Num D Descaled, 5)) Facility Morts, 6) Sam mple Morts, 7)) Research Morts, 8) PIT-tag P Morrts, 9) Num m Bypassed, 10) Num T Trucked, 11) Num Barged, an nd 13) Descaling Pctg g. (%). 111 IX.B.2 – Mark Re ecapture Report: The Mark Recapture Report is the same e as what h has been ge enerated byy previous versions of o FPC32. This T report summarize es all fish th hat had Elasstomer tags and does not separate s co ondition and d non-condition fish. R Running this report ering non-c condition fis sh with Elasstomer tagss (prior to promoting co ondition after ente fish) is th he best way y to validate e data entryy into the M Mark Recap ptures data a entry tab. 112 IX.B.3 – Incidental Catch h Report The Incid dental Catch Report the same a as what hass been gen nerated by p previous versions of FPC32. This reporrt summarizzes all incid dental fish, regardless of whether they were collected c as s part of the e condition or non-con ndition sample. Running this report after entering non-con ndition incid dentals (prior to promo oting al fish from the conditio on sample)) is the bestt way to vallidate data entry incidenta into the Incidental Catch C data a entry tab. 113 IX.B.4 – Fish Co ondition Report R The Fish h Condition n Report is s designed similarly to the Daily S Summary Report. This repo ort summarrizes the pre evalence o f each of th he condition ns from the condition n sample. Target T salm monid species are splitt into three groups: 1) Clipped, 2) Unclip pped, and 3) 3 Combined d. Each sp pecies repre esents a co olumn in the e report. Each column has se everal rows s of data. T These rowss are as follo ows: 1) Num Sampled d, 2) Descalling 20% orr greater, 3) Injury, 4) Predation, 5) Disease e or Parasite,, and 6) Tottal With Co onditions. T This report iis NOT mea ant to be ussed for validation n, it is simp ply a summa ary of the cconditions sseen for a p particular da ay’s sample. Condition fish f with the e Other Co onditions (Fin Hemm., Pop Eye, P Pink Fin, Fin Disco ol., and Eye e Hemm.) are a NOT inccluded in th he Injury row w. IX.B.5 – Individu ual Fish Condition C n Report The Indiv vidual Fish h Condition Report liists each fissh that wass sampled a as part of the condition sample via the to ouch screen n. This report was inte ended for re eview of condition n data in ord der to deterrmine obvio ous errors ffrom data e entry (e.g., anomalous lengths or weights,, incorrect sspecies, etcc.). Conditiion fish are e sorted by sub batch, tank, and sequence. The ccondition da ata are divid ded into five groups: 1) 1 Disease//Parasite, 2) 2 Injuries, 3 3) Predatorr, 4) Other C Conditions, and 5) Descaling. The rep port uses co odes for eacch of the co onditions w within these gs. A detailed listing of these cod des and the eir meaning can be fou und grouping below. 114 Disea ase/Parasite e FU – fungus f CO – columnaris KD – BKD PA – parasite DE – deformity OD – other diseas se Injuries: HI – head in njury ury EI – eye inju OP – opercculum injury BI – body in njury FI – fin injurry Preda ator: PB – bird predato or PF – fish predato or PL – lamprey pre edator PO – other preda ator Otherr Conditions s PE – popeye FH – fin f hemorrha age FP – pink p fin FD – fin f discolora ation EH – eye hemorrh hage Descaling: PD – partia l descaling ((5-19%) DS – desca aled (≥20%) DP – desca aled by preda ator (≥20% w with pred. m marks) IX.B.6 – Daily Ba atch/Tank Report The Daily Batch/Ta ank Reportt is arrange ed in a matrrix fashion, similar to the hand m of the e sites. The e batch hea ader information is fou und at the to op of the logs for many report. This T report separates s fish f that we ere sampled d as part off the conditiion sample from f those that t were sampled s as part of the non-condittion sample e. There are four summary s sections s to the t report, iincluding: 1 1) Tank A, 2 2) Tank B, 3 3) Tank None, an nd 4) Comb bined. Each h Species/C Clip combin nation repre esents a co olumn in the reporrt. Each co olumn has several s row ws of data. These rowss are as follows: 1) Non-Con nd Sample Count, C 2) Exam E Desc (Non-Cond d), 3) Non-C Cond Descaled, 4) Condition n Sample Count, C 5) Co ondition De escaled, 6) Total Samp ple Count, 7) Total Collection, 8) Samp ple Morts, 9) 9 Facility M Morts, 10) R Research Morts, 11) PIIT-tag Morts, 12 2) Num Byp passed, 13)) Num Truccked, 14) Num Barged d, and 15) D Descaling Pctg. (%). Running this report after entering non-con ndition fish into the Ca atch Detail data entry tab b (prior to prromoting co ondition fish h) is the best way to validate data a entry of non-cond dition data. Also, afterr promoting g condition fish, this re eport can be e used to determin ne final colle ection coun nts for data entry of salmonid spe ecies into th he Transpo ortation datta entry tab b (see Sect ion VII.I ab bove).Lamp prey juveniles are not includ ded in this report (see e Section IX X.B.8 below w). 115 s Ferry or Holdover H yearling y falll Chinook are includ ded in the C Chinook **Lyons 1 colum mns, depen nding on whether w they were un nclipped, C CWT, or cliipped** IX.B.7 – Special Species Daily Ba atch/Tank k Report The Special Specie es Daily Ba atch/Tank Report hass all the same data an nd is arranged d in a simila ar manner as a the Daily y Batch/Ta ank Report. Howeverr, this report on nly summarrizes Lyons Ferry and Holdover yyearling fall Chinook. Running this report after ente ering non-c condition fissh into the C Catch Deta ail data entrry tab (prior to promoting condition c fis sh) is the best way to validate da ata entry of Lyons d Holdover yearling fa all Chinook data from tthe non-con ndition sam mple. Ferry and E: Collectio on counts frrom this rep port are NO OT to be use ed for entryy into the NOTE Trans sportation data entry tab, as the ese fish are already inccluded in th he tallies of Ch hinook 1 from the Daily y Batch/Ta ank Reportt (see Sectiion VII.I ab bove). 116 IX.B.8 – Lampre ey Batch/T Tank Rep port The Lam mprey Batc ch/Tank Re eport is arra anged in a ssimilar fash hion as the Daily Batch/Ta ank Report. However, this report only sum mmarizes da ata for lamp prey juveniles s, separated d by tank (T Tank A, Tank B, Tank k None, and Combine ed). Running this report after entering/promotiing lampreyy juveniles into the Ca atch Detail da ata entry tab is the bes st way to va alidate thesse data. 117 IX X.C. FP PC Week kly Valid dation. The T FPC validates two random ba atches from m every wee ek by comp paring the hand logs with w the elec ctronic batc ch reports fo or any discrrepancies. For every batch with a discrepancy y the FPC validates two o additiona al batches fo or the same e week. Th he FPC th hen contactts the appro opriate site via e-mail requesting that necesssary correcctions be made m and co orrected ba atches be re eposted. S See Section n VII.L for rreposting in nstructions. When rep posting batc ches sites a are required d to include e a description of what w data ha ave been changed and d why. FPC C WILL NO OT UPDATE BATCHE ES UNLESS U PR ROPER DO OCUMENTA ATION IS R RECEIVED. IX X.D. FP PC Valid dation Sp preadsh heets. In n addition to o weekly va alidation, th he FPC will send all sittes a set off validation spreadsheetts generate ed form our SQL datab base. This will be don ne weekly. These e data in yo our electronic batches. If spreadsheetts should be checked against the discrepancie es are found then follo ow normal rreposting prrocedures ((see Sectio on VII.L). Rows R for days with no data are inc cluded, and d batch num mbers are included in each ro ow to facilitate the use e of pivot tables in spre eadsheet programs to o subtotal an nd grand to otal the cou unts by spec cies rearing g dispositio on, batch nu umber, etc. IX X.E. En nd of Ye ear Valid dation. When W sampling for the year is com mpleted, ea ach site must send an e-mail to notify the FPC F staff that the samp ple season has ended d. This e-m mail should sstate the fin nal batch number. If necessary n this t e-mail will w also req quest a yea arly validatio on spreadssheet ncluding the e data from the site forr the entire year, which should m match the sittes own in data records s. After you u have valid dated your end-of-yea ar data against the FPC C validation sp preadsheets s and all co orrections h have been m made, you must send us an email m stating that your data are fina alized. 118 IX.F. Project by Project Details for SMP Reporting Requirements The Statement of Work Report for the contract Smolt Monitoring by Non-Federal Entities (Project # 1987-127-00) includes several milestones that pertain to the use of the FPC32.net data entry program. Below is a summary of these milestones for the various SMP projects. 1. For Bonneville Dam (Work Elements N-Q) and John Day Dam (Work Elements R-T) the Statement of Work Report for the contract Smolt Monitoring by Non-Federal Entities (Project # 1987-127-00) state the following: Milestone N-C. Sample Fish Daily and Collect Data. [SMP personnel at Bonneville Dam will] sample fish daily throughout the monitoring season at the JMF. Collect species, condition, and external mark detail from all sampled fish. Collect detailed condition and length data from a subsample of the sample. Count and identify all incidental species caught in the samples. Tally, review, enter into computer and transmit all data to FPC daily. During periods of low fish collection, August to October, 24 hour daily samples may be held and sampled every other day. Milestone N-D. Project Operations and Flow Data Collection. [SMP personnel at Bonneville Dam will] collect, record, and verify daily USACOE project operations and flow data and facility fish mortality within the bypass/collection system. Milestone N-E. Summarize and Verify All Sample Data on Days Collected [at Bonneville Dam]. Milestone O-A. Transmission of Project Operations. [SMP personnel at Bonneville Dam will] transmit daily Corps project operations, flow data, fish transport numbers, facility mortalities, percent descaling and average fork length data daily or every other day during low collections periods from August to October. Ensure prompt transfer of data. Notify FPC by phone whenever we cannot transmit data by 1400 hours on weekdays and/or critical weekends via FPC32. Advise and discuss problems with FPC when they occur. Milestone R-C. Sample Fish Daily and Collect Data. [SMP personnel at John Day Dam will] sample fish daily throughout the monitoring season at the JMF. Collect species, condition, and external mark detail from all sampled fish. Collect detailed condition and length data from a subsample of the sample. Count and identify all incidental species caught in the samples. Tally, review, enter into computer and transmit all data to FPC daily. During periods of low fish collection, August to October, 24 hour daily samples may be held and sampled every other day. Milestone R-D Summarize and Verify All Sample Data on Days Collected [at John Day Dam]. Milestone R-E. Project Operations and Flow Data Collection. [SMP personnel at John Day Dam will] collect, record, and verify daily USACOE 119 project operations and flow data and facility fish mortality within the bypass/collection system. Milestone S-A. Transmission of Project Data. [SMP personnel at John Day Dam will] transmit daily Corps project operations, flow data, fish transport numbers, facility mortalities, percent descaling and average fork length data daily or every other day during low collections periods from August to October. Ensure prompt transfer of data. Notify FPC by phone whenever we cannot transmit data by 1400 hours on weekdays and/or critical weekends via FPC32. Advise and discuss problems with FPC when they occur. 2. For Rock Island Dam (Work Elements V and W) the Statement of Work Report for the contract Smolt Monitoring by Non-Federal Entities (Project # 1987-127-00) state the following: Milestone V-C. Collect Fish for Examination. Fish will be collected continuously during the monitoring period. Fish will be examined during regular work hours (0800-1630 hrs), unless large numbers of fish are entering the flume of the bypass trap, in which case with would be removed and recorded as the appropriate sample days catch. Fish will be delivered via the bypass elevator in a 12’ x 4/ x 3/5’ aluminum holding talk which will be plumbed for continuous flow of river water. Small samples of fish will be re-anesthetized using a light buffered solution of MS-222 before being moved into the sampling trailer and placed in a full strength buffered solution of MS-222. Fish will be identified by species and examined for marks indicating hatchery origin and descaling. Anesthetized with will recover in a separate holding tank and be released after they have recovered from anesthesia. Milestone V-D. Collect Biological Data. Collect biological data from salmonid migrants captured in the collection facility from 1 April to 31 August 2013. Data will be recorded daily to include by species, total count, adipose fin-clipped/unclipped status, CWT presence/absence, other external or internal marks or tags, smolt condition, and descaling. Milestone W-B. Transmit Data. Transmit daily project operations, flow data, fish transport numbers, facility mortalities, percent descaling and average fork length data daily. Ensure prompt transfer of data. Notify FPC by phone whenever we cannot transmit data by 1400 hours on weekdays and/or critical weekends via FPC32. Advise and discuss problems with FPC when they occur. 3. For Lower Granite Dam (Work Elements AI and AJ), Lower Monumental Dam (Work Elements AO and AP), and McNary Dam (Work Elements AL and AM) the Statement of Work Report for the contract Smolt Monitoring by NonFederal Entities (Project # 1987-127-00) state the following: Milestone AI-C. Sample Fish Daily and Collect Data. [SMP personnel at Lower Granite Dam will] sample fish daily throughout the monitoring season at the JMF. Collect species, condition, and external mark detail from all sampled fish. Collect detailed condition and length data from a subsample of the sample. Count and identify all incidental species caught in the samples. Tally, review, enter into computer and transmit all data to FPC daily. During periods of low fish collection, August to October, 24 hour daily samples may be held and sampled every other day. 120 Milestone AI-D. Summarize and Verify All Sample Data on Days Collected [at Lower Granite Dam]. Milestone AI-E. Project Operations and Flow Data Collection. [SMP personnel at Lower Granite Dam will] collect, record, and verify daily USACOE project operations and flow data and facility fish mortality within the bypass/collection system. Milestone AJ-A. Transmission of Project Data. [SMP personnel at Lower Granite Dam will] transmit daily Corps project operations, flow data, fish transport numbers, facility mortalities, percent descaling and average fork length data daily or every other day during low collections periods from August to October. Ensure prompt transfer of data. Notify FPC by phone whenever we cannot transmit data by 1400 hours on weekdays and/or critical weekends via FPC32. Advise and discuss problems with FPC when they occur. Milestone AO-C. Sample Fish Daily and Collect Data. [SMP personnel at Lower Monumental Dam will] sample fish daily throughout the monitoring season at the JMF. Collect species, condition, and external mark detail from all sampled fish. Collect detailed condition and length data from a subsample of the sample. Count and identify all incidental species caught in the samples. Tally, review, enter into computer and transmit all data to FPC daily. During periods of low fish collection, August to October, 24 hour daily samples may be held and sampled every other day. Milestone AO-D. Summarize and Verify All Sample Data on Days Collected [at Lower Monumental Dam]. Milestone AO-E. Project Operations and Flow Data Collection. [SMP personnel at Lower Monumental Dam will] collect, record, and verify daily USACOE project operations and flow data and facility fish mortality within the bypass/collection system. Milestone AP-A. Transmission of Project Data. [SMP personnel at Lower Monumental Dam will] transmit daily Corps project operations, flow data, fish transport numbers, facility mortalities, percent descaling and average fork length data daily or every other day during low collections periods from August to October. Ensure prompt transfer of data. Notify FPC by phone whenever we cannot transmit data by 1400 hours on weekdays and/or critical weekends via FPC32. Advise and discuss problems with FPC when they occur. Milestone AL-C. Sample Fish Daily and Collect Data. [SMP personnel at McNary Dam will] sample fish daily throughout the monitoring season at the JMF. Collect species, condition, and external mark detail from all sampled fish. Collect detailed condition and length data from a subsample of the sample. Count and identify all incidental species caught in the samples. Tally, review, enter into computer and transmit all data to FPC daily. During periods of low fish collection, August to October, 24 hour daily samples may be held and sampled every other day. Milestone AL-C. Summarize and Verify All Sample Data on Days Collected [at McNary Dam]. Milestone AL-E. Project Operations and Flow Data Collection. [SMP personnel at McNary Dam will] collect, record, and verify daily USACOE 121 project operations and flow data and facility fish mortality within the bypass/collection system. Milestone AM-A. Transmission of Project Data. [SMP personnel at McNary Dam will] transmit daily Corps project operations, flow data, fish transport numbers, facility mortalities, percent descaling and average fork length data daily or every other day during low collections periods from August to October. Ensure prompt transfer of data. Notify FPC by phone whenever we cannot transmit data by 1400 hours on weekdays and/or critical weekends via FPC32. Advise and discuss problems with FPC when they occur. 4. For Little Goose Dam (Work Elements D and E) the Statement of Work Report for the contract Smolt Monitoring by Non-Federal Entities (Project # 1987-127-00) states the following: Milestone D-C. Sample Fish Daily and Collect Data. [SMP personnel at Little Goose Dam will] sample fish daily throughout the monitoring season at the JMF. Collect species, condition, and external mark detail from all sampled fish. Collect detailed condition and length data from a subsample of the sample. Count and identify all incidental species caught in the samples. Tally, review, enter into computer and transmit all data to FPC daily. During periods of low fish collection, August to October, 24 hour daily samples may be held and sampled every other day. Milestone D-D. Summarize and Verify All Sample Data on Days Collected [at Little Goose Dam]. Milestone D-E. Project Operations and Flow Data Collection. [SMP personnel at Little Goose Dam will] collect, record, and verify daily USACOE project operations and flow data and facility fish mortality within the bypass/collection system. Milestone E-A. Transmission of Project Data. [SMP personnel at Little Goose Dam will] transmit daily Corps project operations, flow data, fish transport numbers, facility mortalities, percent descaling and average fork length data daily or every other day during low collections periods from August to October. Ensure prompt transfer of data. Notify FPC by phone whenever we cannot transmit data by 1400 hours on weekdays and/or critical weekends via FPC32. Advise and discuss problems with FPC when they occur. 5. For Lower Grande Ronde River Trap (Work Elements J and L) the Statement of Work Report for the contract Smolt Monitoring by Non-Federal Entities (Project # 1987-127-00) states the following: Milestone J-C. Operate Trap for Collection of Data. [SMP personnel at the Lower Grande Ronde River Trap will] operate trap 5 nights/week March 5-May 26. This will mean lowering the trap to begin the sample period at 6:00 pm on Sunday and cessation on Friday morning at 9:00 am. Collect data on daily catch, hatchery and wild population composition, descaling, recaptures of PIT tagged parr and average length by species. Collect limited species data on incidental fish captured. Monitor fish injury rates and mortality due to trapping and sampling procedures and modify as necessary to minimize injury and mortality rates. Milestone J-D. Transmit Collection Data. [SMP personnel at the Lower Grande Ronde River Trap will] electronically transmit salmonid collection 122 data to FPC daily in a standard format determined by FPC. This will be done from a site several miles upriver that has standard phone access. Milestone L-A. Transmit of Project Data. [SMP personnel at the Lower Grand Ronde Trap will] transmit electronically PIT tag tagging files within 24 hours. Transmit flow data, facility mortalities, percent descaling daily. Notify FPC by phone whenever we cannot transmit data by 1400 hours on weekdays and/or critical weekends via FPC32. Advise and discuss problems with FPC when they occur. 6. For the Salmon River Trap (Work Elements AB and AF) and Snake River Trap (Work Elements AC and AG) the Statement of Work Report for the contract Smolt Monitoring by Non-Federal Entities (Project # 1987-127-00) states the following: Milestone AB-C. Operate Trap for Collection of Data. [SMP personnel at the Salmon River Trap will] operate trap 5 nights/week March 5-May 26. This will mean lowering the trap to begin the sample period at 6:00 pm on Sunday and cessation on Friday morning at 9:00 am. Collect data on daily catch, hatchery and wild population composition, descaling, recaptures of PIT tagged parr and average length by species. Collect limited species data on incidental fish captured. Monitor fish injury rates and mortality due to trapping and sampling procedures and modify as necessary to minimize injury and mortality rates. Milestone AB-D. Transmit Collection Data. [SMP personnel at the Salmon River Trap will] electronically transmit salmonid collection data to FPC daily in a standard format determined by FPC. This will be done from a site several miles upriver that has standard phone access. Milestone AF-A. Transmit of Project Data. [SMP personnel at the Salmon River Trap will] transmit electronically PIT tag tagging files within 24 hours. Transmit flow data, facility mortalities, percent descaling daily. Notify FPC by phone whenever we cannot transmit data by 1400 hours on weekdays and/or critical weekends via FPC32. Advise and discuss problems with FPC when they occur. Milestone AC-C. Operate Trap for Collection of Data. [SMP personnel at the Snake River Trap will] operate trap 5 nights/week March 5-May 26. This will mean lowering the trap to begin the sample period at 6:00 pm on Sunday and cessation on Friday morning at 9:00 am. Collect data on daily catch, hatchery and wild population composition, descaling, recaptures of PIT tagged parr and average length by species. Collect limited species data on incidental fish captured. Monitor fish injury rates and mortality due to trapping and sampling procedures and modify as necessary to minimize injury and mortality rates. Milestone AC-D. Transmit Collection Data. [SMP personnel at the Snake River Trap will] electronically transmit salmonid collection data to FPC daily in a standard format determined by FPC. This will be done from a site several miles upriver that has standard phone access. Milestone AG-A. Transmit of Project Data. [SMP personnel at the Snake River Trap will] transmit electronically PIT tag tagging files within 24 hours. Transmit flow data, facility mortalities, percent descaling daily. Notify FPC by phone whenever we cannot transmit data by 1400 hours on 123 weekdays and/or critical weekends via FPC32. Advise and discuss problems with FPC when they occur. 124 X Priinting Daily Repor R rts and d Send ding Da ata to FP PC X.A. X Ge enerating g and Prrinting R Reports There T are se everal differrent reports s available with the FP PC32.net re emote data entry program (se ee Section IX.B for a detailed d disscussion of each). To T generate e a report, click c on the Catch tab and select a batch. C Choose Rep ports and choose the report you y want to o generate from the drrop down lisst. Once a report is selected it may m take a few f momen nts for the rreport to op pen. A repo ort will open n in a separate Re eport Viewiing Window w. Perrcent Zoom Save Report As A Next/Previous N Page P Print The T Report Viewing Window W has s several b uttons at th he top that allow the user to perfo orm differen nt functionss. Below B is a brief b descrip ption of thes se buttons a and their fu unctions. 125 Next/Pre evious Pag ge – The Ne ext/Previou us Page bu uttons allow ws the user to view the next or previous s report pag ges. In add dition, this ssection of th he Report V Viewing Window w informs the e user how w many page es the chossen report iis. If the arrrow buttons are a blue, then the repo ort consistss of more th han one pag ge. Th he Single Arrow A butto ons advancce the reporrt to the nexxt or prrevious pag ge Th he Skip butttons advan nce the rep port to the b beginning orr end pa ages Printing Reports – The Print button allo ws the use er to print th he report. T The Print button op pens the Prrint Dialog Box. From m here, the e user can sselect a prin nter, choose a print range and choo ose the num mber of cop pies to be prrinted. Save Re eport As – Clicking C the e Save Rep port As buttton opens a drop dow wn list. This drop p down lists s the formats that are a available fo or saving th he report. T These include: 1) Adobe (P PDF), 2) Co omma Sepa arated Valu ue (CSV), 3 3) Excel (XL LS), 4) Rich Tex xt Format (R RTF), 5) Image (TIFF) , or 6) Web b Archive (h html). Once e the user has chosen a format f for the exported d report, a Save as dialog box ap ppears. From this s dialog box x, navigate to where yyou want to save the re eport and n name the report. 126 Percent Zoom – Th he Percentt Zooms allows the usser to selecct a zoom percenta age to view report deta ails on scree en. X.B. X Sending SMP S Data a and Ha and Log gs to the e FPC New N batch data d (i.e., XML X files) arre sent to th he FPC in o one of two w ways: 1) through email m or 2) via a http uploa ad. Copies s of the han d logs musst also be su ubmitted (vvia fax or e-mail) to the FPC. Sending g New Batc ches Via E--mail New batc ches should d be sent via e-mail to o [email protected] with the appropria ate .XML file attach hed. The FPC F will nott receive th his e-mail un nless your e-mail addrress has been cleared by the e FPC data center stafff. Contact the FPC D Data Staff if you need to add a a new e-mail e addrress from w which bathe es may be ssent. t not want to send the e final .XML L file to the FPC by na avigating to their eIf users to mail prog gram and attaching it to t an e-maiil, FPC32.n net has a feature that a allows users to send the fin nal .XML file with the p push of a b button. How wever, this ffeature only work ks with use ers who hav ve Microso oft Outlook k configured d in their offfice 127 computers and have e constant internet acccess. If you are not using Micro osoft Outlook, you will ne eed to send d the .XML files using the proced dure above. To use th his new fea ature, you must m type sm [email protected] into the e e-mail field in the Settings s tab (see picture p below w). Once tthis feature has been a activated, a Send button will be added d to the Cattch data en ntry tab on tthe Main Form. Once e the en pressed and the fin nal .XML file e is written,, you Save as Batch buttton has bee may choose to send d the batch automatica ally through h FPC32.ne et by pushin ng this Send button. A pro ompt will ap ppear asking g you if you u want to se end an e-m mail, choose Yes. Y Uploadin ng New Ba atches Via HTTP – Insstead of e-m mail, new b batches can n also be uploaded d via the we eb. To uplo oad a new b batch, first you must n navigate to http://ww ww.fpc.org/s smpupload//SMP_Postting.asp witth your internet browse er. To log in, en nter Login: guest and d password d: nicegue est. sword authe entication requires r you u to acceptt cookies, b but you can set The pass Internet Explorer to accept just cookies from FPC iif you wish. To change the privacy settings s in Internet Ex xplorer, go to Tools/In nternet/Priv vacy then cclick on the Edit button under Web Sittes. Add th he domain ffpc.org and d select Alw ways Allow. 128 . Once you u have logg ged in, you will be dire ected to the e SMP Batc ch Upload Page where yo ou may uplo oad up to 4 files at oncce. 129 Choose Browse B to browse to the location n of the .XM ML file you w wish to uplo oad and click the OK button.. Once you u have uplo oaded all the e files you w with to uplo oad, click on the Upload Files s button. You Y will rece eive a message aboutt the numbe er of files that were e successfu ully uploade ed. You can select the e Refresh List button to check which file es were uplloaded. No ote: Only FPC32.net F files f with th he suffix .XM ML can be u uploaded to o this sitte. If you accidentally a attempt to upload a n non-FPC32.net file alo ong with FP PC32.net files, the .XM ML file will load and the results pa age will sho ow you the number of o .XML files that uploa aded succe essfully, alo ong with an error ect file type((s). message for the incorre ote: Althou ugh up to 4 files can be e uploaded at one time e, there is a limit to No the size of ea ach file and d a limit to the total size of the file es that are up ploaded. Currently, C a single file ccannot be m more than 1 1.5 Mb in size and the total uplo oad is limite ed to 3.1 Mb b. If you arre having trouble uploa ading an XML file, che eck the file size. If the e file is larg ger than 1.5 5 Mb, contact the .X da ata staff at FPC. No ote: If you are having trouble uplloading filess via the we eb, try send ding the file e to the FPC via e-ma ail (smp@fp pc.org). See above forr instruction ns. Sending S Ha and Logs to o the FPC – After batcches (i.e., X XML file) ha ave been submitted to o the FPC, SMP perso onnel must also send a copy of th heir hand lo og. There a are two ways w to do this: t Fax: Hand logs can be fax xed to FPC at 503-230 0-7559 E-ma ail: Hand logs can now w be e-maile ed as an atttachment tto the FPC. Emaile ed hang logs must be in PDF form mat and sho ould be sen nt to [email protected]. 130 E-mailed hand logs can be sent in the same e-mail as the batch file (i.e., XML). 131 XI. What’s New with FPC32.net (2013) In 2013, the FPC will continue to support two editions of FPC32.net for SMP data entry. These editions are TouchScreenSetup3.msi and TouchScreenSetup3_lamprey.msi. The TouchScreenSetup3.msi edition will be used by site personnel at LGR, LGS, LMN, RIS, WTB, LEW, and GRN. There were no significant changes to this edition of FPC32.net for the 2013 sampling season. To make sure you are running the most up-to date version (and edition), we suggest that all sites uninstall FPC32.net from their machines and download the newest version of TouchScreenSetup3.msi from the FTP site (ftp://ftp.fpc.org/FPC32.net/). See Section VI.C. for instructions on how to do this. If you are using a computer with Windows 7 operating system, you may need to follow instructions that allow the user to gain Full Control of SQL Express. These instructions have been added to this manual (see Section VI.D.) The TouchScreenSetup3_lamprey.msi edition will be used by SMP site personnel at BON, JDA, and MCN. There were no significant changes to this edition of FPC32.net for the 2013 sampling season. To make sure you are running the most up-to date version (and edition), we suggest that all sites uninstall FPC32.net from their machines and download the newest version of TouchScreenSetup3_lamprey.msi from the FTP site (ftp://ftp.fpc.org/FPC32.net/). See Section VI.C. for instructions on how to do this. If you are using a computer with Windows 7 operating system, you may need to follow instructions that allow the user to gain Full Control of SQL Express. These instructions have been added to this manual (see Section VI.D.) XI.A. Procedure to Allow Full Control for Windows 7 Operating System When FPC32.net is installed on a machine with Windows 7 operating system, the user may experience problems when trying to save new records. These problems may occur each time FPC32.net is uninstalled and reinstalled. The FPC staff has found that this is often a permissions issue that can affect whether SQL Express database files can be written to by the current user. The 2013 manual has been updated to provide instructions on how to remedy these issues. These instructions can be found in Section VI.D., starting on page 21. XI.B. Lamprey Condition Monitoring (Pred Bird vs. Body Injury) (BON, JDA, and MCN) U.S. Fish and Wildlife has asked that the FPC crews at BON, JDA, and MCN work with them to better differentiate between body injuries causes by birds (i.e., Pred Bird) and those caused by the project (i.e., Body Injury). To that effect, they have 132 asked that crews c take pictures p of Bird Marks versus Body Injuries and share them with w the FPC C as you go o along. FP PC will workk with USFW WS toward ds better de efining th hese two ca ategories. In n addition, USFWS U wo ould like to get a better idea of wh hat “uncerta ain injuries”” may lo ook like for juvenile j lam mprey. To this effect, USFWS assks that, wh hen an injurry is uncertain, crrews at BON, JDA, an nd MCN are e to enter th hat injury an nd then entter a “UI” in nto the Special Comments field as a a way to flag it. Cre ews are also o asked to take a picture of un ncertain inju ury if possib ble. 133 XII Notes ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ 134 ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ____________________________________________________________________ ___________________________________________________________________ 135 THIS PAGE WAS INTENTIONALLY LEFT BLANK 136 ------------------------------------------------------------------------------------------------------------------------ FPC32.NET MANUA AL ACKN NOWLED DGEMENT FOR RM I, the unders signed, ack knowledge that t I have read the FP PC32.net m manual. Name: N (Plea ase Print) __________ _ __________ _________ __________ _ Signature: S __________ _ __________ __________ ____ Date:_ _________ __ Please P copy y this form and a mail a completed c and signed d form to: Fish F Passag ge Center Attn: A Brando on Chockley y th t 1827 NE 44 Ave, Suitte 240 Portland P OR R 97213 Fax: F 503-230-7559 ------------------------------------------------------------------------------------------------------------------------ 137