This table designates the final disposition of fish bodies processed at hatchery facilities. This table has a many to one relationship with the HatcheryReturns table via TrendID, KeyDate, and CaptureLocationID.
| 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 | Sex | Sex of the fish | tinyint | 1 | DispositionID | Code used to denote ultimate disposition of the fish. | int | 4 | BeginDate | Earliest date fish were recorded for disposition. | smalldatetime | 4 | EndDate | Latest date fish were recorded for disposition. | smalldatetime | 4 | NumberOfFish | Total number of fish (live and dead) removed from the Hatchery. | int | 4 | RefID | Unique StreamNet reference ID number for the data source. Cross reference to the Reference table. | int | 4 | Comments | Additional information or comments. | text | 16 | DataEntry | Compiler's name and/or other data entry source information. | varchar | 50 | AgencyID | Unique StreamNet ID for the 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 | 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 | CaptureLocationID | Location of hatchery, trap, dam, or stream where fish were caught. | varchar | 13 |
*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.