This table contains information about the current fish stocks the hatchery is either producing, or has the potential to produce. The table has a many to one relationship to the Hatchery table.
| Field Name | Field Description | Data Type | Field Size* | HatchID | The hatch(ery) ID, foreign key to table Hatchery | smallint | 2 | SpecieID | The species ID. Cross reference to the Specie table. | smallint | 2 | RunID | The run ID. Cross reference to Run table. | tinyint | 1 | SubRunID | The subrun ID, foreign key to table SubRun | tinyint | 1 | ProductionID | Code for production type | tinyint | 1 | InitRetYear | The initial return year for the hatchery stock from the IHOT reports | int | 4 | StockName | Name of the fish stock.Information in this field will be used to generate StockID codes for future versions of the Exchange format. | varchar | 255 | StockID | ID code for fish stocks. | tinyint | 1 | RefID | The primary reference number describing the source of the hatchery production information | int | 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 |
*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.