Agency Table

Lookup table for agency descriptions.

Field Name Field Description Data Type Field Size*
AgencyID Agency identifier code. smallint 2
Agency Lookup table for AgencyID field. varchar 255
Acronym Acronym for the primary agency that entered the data. varchar 12
TypeID Code for agency type. smallint 2
Top10 ignore tinyint 1

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


Revised Wednesday September 28 2005