| Field Name | Field Description | Data Type | Field Size* | ASNID | Age Structure Number ID - Provides link to age structure data (if available). | int | 4 | Sex | Sex of the fish | tinyint | 1 | TotalAge | Total Age (gravel + freshwater + ocean) | smallint | 2 | OceanAge | Ocean age of fish | smallint | 2 | NonSpawnRun | Half-pounder or feeding run designation used for steelhead & cutthroat. | tinyint | 1 | NominalBY | Brood year of the fish determined from aging | smallint | 2 | NullFlag | If true (-1) indicates a null value for the defined time period. | bit | 1 | ActualPerAS | smallint | 2 | TotalPerAS | int | 4 | ExpMeth | Method used to expand the observed age data ActualPerAS to get TotalPerAS. | nvarchar | 60 | LengthTypeID | Code for type of lengths represented in the MeanLenth, MinLenght, MaxLength, and LengthSD fields. | tinyint | 1 | LengthMin | Minimum length in age sample. | smallint | 2 | LengthMean | Mean length of age sample. | real | 4 | LengthMax | Maximum length in age sample. | smallint | 2 | LengthSD | Standard deviation of the length of the fish in the group. | real | 4 | WeightMin | smallint | 2 | WeightMean | real | 4 | WeightMax | smallint | 2 | WeightSD | real | 4 | Comments | Additional information or comments. | ntext | 16 | RefID | The primary reference number describing the source of the age information | int | 4 | DataEntry | Compiler's name and/or other data entry source information. | nvarchar | 100 | CompilerID | Code for Agency that compiled this record | tinyint | 1 | UpdDate | The date and time the record was created or updated by agency compiler. | datetime | 8 | AgencyID | Agency identifier code. | smallint | 2 | 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.