StreamNet

Age Table

The purpose of this table is to store age distribution information. This table is a child of the HatcheryReturns, EscData and SRData tables, linked via ASNID.

Field Name Field Description Data Type Field Size*

ASNID Age Structure Number ID - Provides link to age structure data (if available). int 4

Sex Sex of the fish tinyint 1

FWAge Freshwater age of fish smallint 2

OceanAge Ocean age of fish smallint 2

TotalAge Total Age (gravel + freshwater + ocean) smallint 2

CountValue Number of fish from group with indicated age structure. Can be actual or extrapolated values. int 4

NumberSampled Number of fish sampled to determine age structure of the group. (N) smallint 2

LengthType Type of lengths represented in the MeanLenth, MinLenght, MaxLength, and LengthSD fields. smallint 2

MeanLength Mean length of the fish in the group. float 8

LengthSD Standard deviation of the length of the fish in the group. float 8

MinLength Minimum length of the fish in the group. smallint 2

MaxLength Maximum length of the fish in the group. smallint 2

RefID Unique StreamNet reference ID number for the data source. Cross reference to the Reference table. int 4

Comments Use this field to document unusual conditions, to provide more detail on the AsMethod or AsSource fields, etc. 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

Hook Temporary field used by regional staff for record updates varchar 4

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

Field Name	Field Description	Data Type	Field Size*
ASNID	Age Structure Number ID - Provides link to age structure data (if available).	int	4
Sex	Sex of the fish	tinyint	1
FWAge	Freshwater age of fish	smallint	2
OceanAge	Ocean age of fish	smallint	2
TotalAge	Total Age (gravel + freshwater + ocean)	smallint	2
CountValue	Number of fish from group with indicated age structure. Can be actual or extrapolated values.	int	4
NumberSampled	Number of fish sampled to determine age structure of the group. (N)	smallint	2
LengthType	Type of lengths represented in the MeanLenth, MinLenght, MaxLength, and LengthSD fields.	smallint	2
MeanLength	Mean length of the fish in the group.	float	8
LengthSD	Standard deviation of the length of the fish in the group.	float	8
MinLength	Minimum length of the fish in the group.	smallint	2
MaxLength	Maximum length of the fish in the group.	smallint	2
RefID	Unique StreamNet reference ID number for the data source. Cross reference to the Reference table.	int	4
Comments	Use this field to document unusual conditions, to provide more detail on the AsMethod or AsSource fields, etc.	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
Hook	Temporary field used by regional staff for record updates	varchar	4

Age Table

Revised Wednesday September 28 2005