This table contains hatchery release information for anadromous fishes and has a many to one relationship with the Trend table via the TrendID field (NOT UPDATED SINCE 1999).
| Field Name | Field Description | Data Type | Field Size* | TrendID | A unique StreamNet code identifying the particular trend | int | 4 | BeginDate | The full beginning date for the count time period | datetime | 8 | EndDate | The full ending date for the count time period | datetime | 8 | TagCode | The tag code of the coded wire tag | char | 12 | CalcMethID | The method by which the count was calculated. | smallint | 2 | RelAgency | Acronym for agency which released the fish | char | 4 | BroodYear | The year in which the returning fish spawn and eggs were fertilized | smallint | 2 | RelYear | The year the fish were released | smallint | 2 | RelTypeID | Purpose for the release | smallint | 2 | NoCWT | The number of fish released with coded wire tags | int | 4 | NoShedCWT | The number of fish that shed their coded wire tags | int | 4 | NoUnTag | The number of fish released without coded wire tags | int | 4 | Weight | The average weight of fish in the release group (grams/fish) | real | 4 | Length | The average length of fish in the release group (mm fork length) | int | 4 | RefID | Unique StreamNet reference ID number for the data source. Cross reference to the Reference table. | int | 4 | CountCom | Comments related to the count | text | 16 | DataEntry | Compiler's name and/or other data entry source information. | varchar | 50 | AgencyID | Code for agency that entered the data | smallint | 2 | NullFlag | If true (-1) indicates a null value for the defined time period. | bit | 1 | UpdDate | The date and time the record was created or updated by agency compiler. | smalldatetime | 4 | TotalRel | Total number of fish released | int | 4 |
*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.