MitAgency Table

Table which relates project participant information to the mitagency table.

Field Name Field Description Data Type Field Size*
ParticipantID StreamNet agency ID int 4
AgencyID StreamNet agency ID smallint 2
Agency The participating agency name. varchar 255
TypeID Code for type of planner or participant tinyint 1
Acronym Acronym for the primary agency. varchar 20

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


Revised Wednesday September 28 2005