This table contains hatchery return information and has a many to one relationship with the Trend table.
| Field Name | Field Description | Data Type | Field Size* | TrendID | A unique StreamNet code identifying the particular trend | int | 4 | KeyDate | Earliest date fish are recorded or collection starts | smalldatetime | 4 | CaptureLocationID | Location of hatchery, trap, dam, or stream where fish were caught. | varchar | 13 | BegFt | Beginning foot of this CaptureLocationID where the fish returned to. | int | 4 | BeginDate | The beginning date for the count time period when fish returned. | smalldatetime | 4 | EndDate | Latest date fish returned. | smalldatetime | 4 | Males | Male fish returned | int | 4 | Females | Number of female fish that returned. | int | 4 | Jacks | The number of jack salmon that returned. | int | 4 | Unknown | Number of unsexed fish captured at the location. | int | 4 | Total | The total number of fish that returned | int | 4 | RefID | The primary reference number describing the source of the hatchery return information | int | 4 | ASNID | Age Structure Number ID - Provides link to age structure data (if available). | int | 4 | AsCode | The age structure code. | tinyint | 1 | AsSource | Indicates group of fish used to determine the age structure for groups where AsCode = 2. | varchar | 100 | AsMethod | Method by which ages were derived. | tinyint | 1 | BeginSpawn | The beginning date for when the fish were spawned. | smalldatetime | 4 | EndSpawn | Ending date that fish were spawned. | smalldatetime | 4 | MalesSpawned | Male fish spawned | int | 4 | FemalesSpawned | Number of female fish that were spawned. | int | 4 | FemalesNonviable | Number of female fish that were nonviable to spawn. | int | 4 | JacksSpawned | The number of jack salmon that were spawned. | int | 4 | Morts | The number of the total return that died prior to spawning. | int | 4 | EggsTaken | The total egg take for the year. | int | 4 | Comments | Additional information or comments. | text | 16 | DataEntry | Compiler's name and/or other data entry source information. | varchar | 50 | AgencyID | Agency identifier code. | 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 | LastModifiedBy | Network ID of regional staff or compiler that last updated record. | varchar | 50 | LastModifiedOn | Date regional staff or compiler last updated record | datetime | 8 | EndFt | Ending foot of reach where the fish returned. | int | 4 |
*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.