StreamNet

MitProject Table

This table contains the core fields for organizing tables related to mitagation and habitat restoration projects.

Field Name Field Description Data Type Field Size*

ProjID StreamNet Primary key for the projects database that uniquely identifies a project int 4

Date Date data on project submitted or updated datetime 8

FrequencyID How often the project data are updated smallint 2

ProjectName Official name of project varchar 255

Purpose Statement of primary Purpose or general description of the project. text 16

TotalCost Total expenditures for the project for the year for this participant money 8

Subbasin2001ID Subbasin code defined in 2001 by StreamNet for Subbasins defined by NPCC. smallint 2

Subbasin1990ID Subbasin code defined in 1990 by NPCC smallint 2

SubbasinID Subbasin code defined in 1990 by NPCC, but now named Subbasin1990ID. smallint 2

BeginYear Year the project was implemented smallint 2

EndYear Year the project was or will be completed smallint 2

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

StatusID The status of the project tinyint 1

Anonymous This field is for indicating whether any participant associated with the project wants their information kept confidential bit 1

SourcePerson Name of person who supplied the data for the database. Should be a good contact to find further information about the project varchar 75

SourceAgencyID Agency the SourcePerson was with when the data were supplied int 4

Limiting Limiting factors addressed by the project text 16

TimeFrame Time frames expected benefits were expected to occur by. text 16

Analysis Things that facilitated, complicated, or would help the project text 16

Comments Additional information or comments. text 16

AddUpd Indicates whether a record has been added or updated. bit 1

*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*
ProjID	StreamNet Primary key for the projects database that uniquely identifies a project	int	4
Date	Date data on project submitted or updated	datetime	8
FrequencyID	How often the project data are updated	smallint	2
ProjectName	Official name of project	varchar	255
Purpose	Statement of primary Purpose or general description of the project.	text	16
TotalCost	Total expenditures for the project for the year for this participant	money	8
Subbasin2001ID	Subbasin code defined in 2001 by StreamNet for Subbasins defined by NPCC.	smallint	2
Subbasin1990ID	Subbasin code defined in 1990 by NPCC	smallint	2
SubbasinID	Subbasin code defined in 1990 by NPCC, but now named Subbasin1990ID.	smallint	2
BeginYear	Year the project was implemented	smallint	2
EndYear	Year the project was or will be completed	smallint	2
RefID	Unique StreamNet reference ID number for the data source. Cross reference to the Reference table.	int	4
StatusID	The status of the project	tinyint	1
Anonymous	This field is for indicating whether any participant associated with the project wants their information kept confidential	bit	1
SourcePerson	Name of person who supplied the data for the database. Should be a good contact to find further information about the project	varchar	75
SourceAgencyID	Agency the SourcePerson was with when the data were supplied	int	4
Limiting	Limiting factors addressed by the project	text	16
TimeFrame	Time frames expected benefits were expected to occur by.	text	16
Analysis	Things that facilitated, complicated, or would help the project	text	16
Comments	Additional information or comments.	text	16
AddUpd	Indicates whether a record has been added or updated.	bit	1

MitProject Table

Revised Wednesday September 28 2005