StreamNet

EscData Table

This table includes all adult return indices except Spawner/Recruit Estimates and all harvest data 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

SampMethID The method used to physically sample the fish. smallint 2

CalcMethID The method by which the count was calculated. smallint 2

CountValue The numeric value for the time span identified by BegDate and EndDate real 4

CountDate The count date is used to identify the specific date from which the peak count was derived datetime 8

TimesSurveyed This number identifies the actual number of times the survey was conducted during the survey season. smallint 2

MilesSurveyed This number identifies the actual miles surveyed. real 4

CountPerMile This number identifies the actual or computer calculated count per mile for a survey area. This can be used for any “per mile” count (e.g. redds/mile, carcass/mile, fish/mile, etc.). real 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

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

CountCom Comments related to the count 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

*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*
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
SampMethID	The method used to physically sample the fish.	smallint	2
CalcMethID	The method by which the count was calculated.	smallint	2
CountValue	The numeric value for the time span identified by BegDate and EndDate	real	4
CountDate	The count date is used to identify the specific date from which the peak count was derived	datetime	8
TimesSurveyed	This number identifies the actual number of times the survey was conducted during the survey season.	smallint	2
MilesSurveyed	This number identifies the actual miles surveyed.	real	4
CountPerMile	This number identifies the actual or computer calculated count per mile for a survey area. This can be used for any “per mile” count (e.g. redds/mile, carcass/mile, fish/mile, etc.).	real	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
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
CountCom	Comments related to the count	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

EscData Table

Revised Wednesday September 28 2005