HatchRetData Table

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
BeginDate	The full beginning date for the count time period	datetime	8
EndDate	The full ending date for the count time period	datetime	8
Sex	Sex of the fish	tinyint	1
SampMethID	The method used to physically sample the fish.	smallint	2
CalcMethID	The method by which the count was calculated.	smallint	2
Spawned	The number of the total return that were spawned	int	4
NonViable	The number of the total return that were non viable spawners	int	4
Morts	The number of the total return that died prior to spawning.	int	4
RetToStream	The number of the total return that were returned to the stream	int	4
PutUpStream	The number of the total return that were transferred upstream	int	4
Other	The number of the total return that died prior to spawning.	int	4
Total	The total number of fish that returned	int	4
Eggs	The total egg take for the year.	int	4
RefID	Unique StreamNet reference ID number for the data source. Cross reference to the Reference table.	int	4
ASNID	Age Structure Number ID - Provides link to age structure data (if available).	int	4
AsCode	The age structure code.	tinyint	1
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
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
ToDo	ignore	varchar	80

*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.

Revised Wednesday September 28 2005