Many to one relationship with the MitProject table via ProjID.
| Field Name | Field Description | Data Type | Field Size* | ProjID | StreamNet project ID. Cross reference to MitProject table | int | 4 | ParticipantID | Unique StreamNet codes for agency and non-agency participants. ParticipantID coded are the same as StreamNet's AgencyID codes | int | 4 | Year | Calendar or fiscal year of project funding | smallint | 2 | Anonymous | This field is for indicating whether information related to this participant may be released to the public. | bit | 1 | ProgramID | Code for the program the project is a part of | smallint | 2 | ProjectNo | Agency number associated with the project (if any) | varchar | 50 | ClassID | Duties of the participant in conducting the project. | tinyint | 1 | ResponsibilityID | Description of the level of responsibility | tinyint | 1 | TechSupport | Description of the level of responsibility | tinyint | 1 | ContactID | Code for participant's contact or project manager | smallint | 2 | Cash | Amount of money provided by this participant | money | 8 | InKind | Value of in-kind contribution provided by this participant | money | 8 | LaborCost | Cost of labor for project for year for this participant | money | 8 | EquipCost | Cost of equipment for the project for year for this participant | money | 8 | MaterCost | Cost of materials for the project for year for this participant | money | 8 | TotalCost | Total expenditures for the project for the year for this participant | money | 8 | Comments | Additional information or comments. | text | 16 |
*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.