Population data and references for the Salmon Population Summary (SPS) Database
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:35856 | Updated: November 21, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
The data contained in the SPS database are primarily summary data, compiled at the
population level. The database also includes a limited number of series representing the
aggregate returns to groups of populations (e.g., Lower Granite Dam counts) or counts of
spawners within a subsection of a population where expansions to the population level were
not feasible. The information used to develop the population level estimates comes from a
variety of sources, but mostly originates from the monitoring programs conducted by state
and tribal fishery agencies. The Technical Recovery Teams and NWFSC staff have processed
this information to provide an estimate of spawning abundance at the population level. A
variety of different types of information (e.g., redd counts, dam counts, carcass surveys,
tag recoveries, scale analysis) forms the basis of the information in the database, and
where possible the database provides references to these information sources. It is
important to recognize that spawning abundance values and other information in the SPS
database are not 'facts' that are known with certainty. Rather, they are estimates based on
a variety of sources of information, some known with greater precision or accuracy than
others. Ideally, these estimates would be characterized by a known level of statistical
uncertainty. However, for the most part such a statistical characterization is either not
possible or has not been attempted, and the database reports only the best estimates of the
values. In all cases there is some degree of uncertainty surrounding these estimates. The
NWFSC intends to work with our state and tribal partners to keep the SPS database as
up-to-date as possible, and new annual estimates will be added as they become available.
Disclaimer: Due to the wide variety of data sources that go into the SPS database, the
NWFSC does not guarantee the accuracy of any of the data in the SPS database. In
particular, neither the U.S. Government, nor any agency or employee thereof, makes any
warranties, expressed or implied, with respect to the accuracy of the data, including but
not limited to the implied warranties or merchantability and fitness for any particular
purpose. In no event shall the U.S. Government, nor any agency or employee thereof, be
liable for any direct, indirect, or consequential damage flowing from the use of the data
in the SPS database.
DescriptionThe data contained in the SPS database are primarily summary data, compiled at
the population level. The database also includes a limited number of series representing
the aggregate returns to groups of populations (e.g., Lower Granite Dam counts) or counts
of spawners within a subsection of a population where expansions to the population level
were not feasible. The information used to develop the population level estimates comes
from a variety of sources, but mostly originates from the monitoring programs conducted by
state and tribal fishery agencies. The Technical Recovery Teams and NWFSC staff have
processed this information to provide an estimate of spawning abundance at the population
level. A variety of different types of information (e.g., redd counts, dam counts, carcass
surveys, tag recoveries, scale analysis) forms the basis of the information in the
database, and where possible the database provides references to these information sources.
It is important to recognize that spawning abundance values and other information in the
SPS database are not 'facts' that are known with certainty. Rather, they are estimates
based on a variety of sources of information, some known with greater precision or accuracy
than others. Ideally, these estimates would be characterized by a known level of
statistical uncertainty. However, for the most part such a statistical characterization is
either not possible or has not been attempted, and the database reports only the best
estimates of the values. In all cases there is some degree of uncertainty surrounding these
estimates. The NWFSC intends to work with our state and tribal partners to keep the SPS
database as up-to-date as possible, and new annual estimates will be added as they become
available. Disclaimer: Due to the wide variety of data sources that go into the SPS
database, the NWFSC does not guarantee the accuracy of any of the data in the SPS database.
In particular, neither the U.S. Government, nor any agency or employee thereof, makes any
warranties, expressed or implied, with respect to the accuracy of the data, including but
not limited to the implied warranties or merchantability and fitness for any particular
purpose. In no event shall the U.S. Government, nor any agency or employee thereof, be
liable for any direct, indirect, or consequential damage flowing from the use of the data
in the SPS database.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
RECOVERY_DOMAIN
VARCHAR2 |
After listing 27 Pacific salmon Evolutionarily Significant Units (ESUs) as threatened or endangered under the Endangered Species Act, NMFS initiated a coast wide process to develop recovery plans for these species. An important part of this process was the creation of geographically based Technical Recovery Teams (TRTs) and recovery areas (domains). |
ESU_NAME
VARCHAR2 |
A group of Pacific salmon or steelhead trout that is (1) substantially reproductively isolated from other conspecific units and (2) represents an important component of the evolutionary legacy of the species. |
MAJOR_POPULATION_GROUP
VARCHAR2 |
A group of salmon populations that are geographically and genetically cohesive. The MPG is a level of organization between demographically independent populations and the ESU or DPS. |
COMMON_POPULATION_NAME
VARCHAR2 |
Name of population as people may commonly refer to it. |
NWR_POPULATION_NAME
VARCHAR2 |
Name of the population as defined by NMFS: A group of fish of the same species that spawns in a particular locality at a particular season and does not interbreed substantially with fish from any other group. |
GENUS
VARCHAR2 |
The name of the genus that the population belongs to. |
SPECIES
VARCHAR2 |
The name of the specie that the population belongs to. |
STREAM_NAME
VARCHAR2 |
Name of the River or drainage identifying or containing the population. |
RUN_TIMING
VARCHAR2 |
The season of the year for the return of the population to its anadromous waters. i.e. Spring, Summer, Winter or Fall |
START_YEAR
NUMBER |
The earliest year that viable salmonid population statistics are reported for this population. |
END_YEAR
NUMBER |
The latest year that viable salmonid population statistics are reported for this population. |
BROOD_YEAR
NUMBER |
The year that adults enter to the river to spawn. |
VIABILITY_TYPE
VARCHAR2 |
The type-classification of this particular population viability figure. |
RUN
VARCHAR2 |
The Season of the Year represented by this viability figure for the population. |
NUMBER_OF_SPAWNERS
NUMBER |
The total number of fish returning to spawn in the data collection year. |
SPAWNER_NOTES
VARCHAR2 |
Comments or other helpful information about the observation of spawners in this viability computation. |
FRACWILD
NUMBER |
The fraction of the total spawners that are the progeny of naturally-spawning fish. |
HATCHERY_FRACTION
NUMBER |
A value between 0 and 1 that is the fraction of natural origin spawners. Natural origin spawners are spawners whose parents spawned in the wild. The fracWild is equal to one minus the fraction of first generation hatchery fish spawning in a given year. If all hatchery fish are marked, this value is the fraction of unmarked fish observed in a given year. |
HATCHERY_FRACTION_NOTES
VARCHAR2 |
Comments or other information about the observed or estimated Hatchery fraction of the fish in this viability computation. |
EFFECTIVE_CATCH
NUMBER |
The number of additional wild fish that would have returned to spawn in a given year had there not been a catch (harvest). |
AGE_1_RETURNS
NUMBER |
The fraction of fish who are defined as having an age of 1 that returned to spawn in a given year. |
AGE_2_RETURNS
NUMBER |
The fraction of fish who are defined as having an age of 2 that returned to spawn in a given year. |
AGE_3_RETURNS
NUMBER |
The fraction of fish who are defined as having an age of 3 that returned to spawn in a given year. |
AGE_4_RETURNS
NUMBER |
The fraction of fish who are defined as having an age of 4 that returned to spawn in a given year. |
AGE_5_RETURNS
NUMBER |
The fraction of fish who are defined as having an age of 5 that returned to spawn in a given year. |
AGE_6_RETURNS
NUMBER |
The fraction of fish who are defined as having an age of 6 that returned to spawn in a given year. |
AGE_7_RETURNS
NUMBER |
The fraction of fish who are defined as having an age of 7 that returned to spawn in a given year. |
AGE_1_HARVEST
NUMBER |
Proportion of catch composed of age-1 fish. Deprecated. |
AGE_2_HARVEST
NUMBER |
Proportion of catch composed of age-2 fish. Deprecated. |
AGE_3_HARVEST
NUMBER |
Proportion of catch composed of age-3 fish. Deprecated. |
AGE_4_HARVEST
NUMBER |
Proportion of catch composed of age-4 fish. Deprecated. |
AGE_5_HARVEST
NUMBER |
Proportion of catch composed of age-5 fish. Deprecated. |
AGE_6_HARVEST
NUMBER |
Proportion of catch composed of age-6 fish. Deprecated. |
AGE_7_HARVEST
NUMBER |
Proportion of catch composed of age-7 fish. Deprecated. |
REGIME
NUMBER |
Regime is an index of environmental conditions (usually intended as a measure of ocean survival) that should be entered as a decimal number centered on 1. It is used as a multiplier to adjust recruitment to average environmental conditions. When conditions are worse than average (regime < 1), recruits are adjusted upwards, when they are better than average (regime > 1), recruits are adjusted downwards. |
AGE_NOTES
VARCHAR2 |
Comments or other information giving further description of the population's age or age-structure. |
ABUND_COUNT_EXTERNAL_FILE_1_LI
VARCHAR2 |
A web-link to any pertinent external document that relates to this population and year. |
ABUND_COUNT_EXTERNAL_FILE_2_LI
VARCHAR2 |
A web-link to a second pertinent external document that relates to this population and year. |
TOTAL_SPAWNERS_WITH_JACKS
NUMBER |
Estimated total number of fish contributing to spawning in a particular year. Includes both natural origin and hatchery origin returns, adults and jack age classes. |
NATURAL_SPAWNERS_WITH_JACKS
NUMBER |
Estimated number of natural origin (parents spawned in the wild) spawners contributing to spawning in a particular year. Includes both adults and jacks of natural origin. |
NATURAL_ADULT_ANNUAL_RUN_4_6
NUMBER |
Estimated number of adult spawners of natural origin in a particular year. |
JACK_FRAC_OF_HATCHERY_SPAWNERS
NUMBER |
If available, estimate of the relative proportion of hatchery returns to the spawning ground that are jacks (i.e., age 3 fish for stream type chinook populations, age 2 fish for ocean type chinook populations). |
ADULT_NATURAL_HARVEST_RATE
NUMBER |
The estimated proportion of adult returns removed by harvest in a particular run year. Assumes that all adult age classes are harvested at the same rate. Steelhead and yearling type chinook estimates reflect in-river fisheries. Snake River Fall chinook estimates also include an adjustment to incorporate an index of annual ocean impacts. |
NAT_NO_ORIGIN_BROOD_STOCK
NUMBER |
Fish of natural origin removed from the returning run for use as hatchery brood stock. |
ADULT_BROOD_RETURNS
NUMBER |
Total future adult returns produced from spawning in a particular brood year. Expressed as returns to the spawning grounds. For chinook, adult brood year returns from year n are calculated as the sum of age 4 returns in year (n+4), age 5 returns in year (n+5) and age 6 returns in year (n+6). |
SAR_ADJUSTED_ADULT_BRD_RETURNS
NUMBER |
Total brood year returns proportionally adjusted to reflect an average annual smolt to adult return rate over a specified range of years. For Interior Columbia analyses, the average SARs are generally calculated for outmigration years 1980 to the most recent complete brood year (e.g., 2001). |
LINK_REFERENCE_S
NUMBER |
Natural log of the ratio of returns to parent spawners. In the ICTRT analyses, both terms are expressed as adults to the spawning grounds. |
ADJUSTED_LINK_REFERENCE_S
NUMBER |
Natural log return/spawner proportionally adjusted to reflect an average SAR.??? For Interior Columbia analyses, the average SARs are generally |
HATCHERY_RETURN
NUMBER |
The number of returning fish that were reared in a hatchery. Currently this data is not provided. |
AGE_DATA_TYPE
VARCHAR2 |
Indicates how age was estimated for a group of fish. Currently this data is not collected. Acceptable values: 1) If population-scale carcass sample size is = 20, apply the Annual Population Age Structure. 2) Else, if population-scale carcass sample size is = 19, apply the Annual Aggregate MPG Age Structure. 3) Else, if MPG-scale carcass sample size is = 19, apply the Long-Term (i.e.19601997) Population Average Age Structure. |
AGE_DETERMINATION_SAMPLE_SIZE
NUMBER |
Number of samples used in age structure determination. |
TOTAL_SPAWNERS_WITHOUT_JACKS
NUMBER |
Estimated number of natural origin (parents spawned in the wild) spawners contributing to spawning in a particular year. Includes only adults of natural origin, excluding jacks. |
CONTACT_AGENCY
VARCHAR2 |
Agency, Tribe or other entity, or person responsible for these data that is the best contact for questions that may arise about this data record. |
NMFS_POPID
NUMBER |
The foreign key to pull in the Population Name for the source database. |
AGE_TITLE
VARCHAR2 |
The recognized title for a piece of reference material. |
AGE_AUTHOR
VARCHAR2 |
The name of the author of a piece of reference material. |
AGE_PUBYEAR
VARCHAR2 |
If the reference material is published, the four-digit year in which the reference material was published. |
AGE_PUBLISHER
VARCHAR2 |
If the reference material is published, the name of the publisher of the reference material. |
AGE_REF_NOTES
VARCHAR2 |
Any comments or other information about the reference material or its publication or use. |
CATCH_TITLE
VARCHAR2 |
The recognized title for a piece of reference material. |
CATCH_AUTHOR
VARCHAR2 |
The name of the author of a piece of reference material. |
CATCH_PUBYEAR
VARCHAR2 |
If the reference material is published, the four-digit year in which the reference material was published. |
CATCH_PUBLISHER
VARCHAR2 |
If the reference material is published, the name of the publisher of the reference material. |
CATCH_REF_NOTES
VARCHAR2 |
Any comments or other information about the reference material or its publication or use. |
SPAWNER_TITLE
VARCHAR2 |
The recognized title for a piece of reference material. |
SPAWNER_AUTHOR
VARCHAR2 |
The name of the author of a piece of reference material. |
SPAWNER_PUBYEAR
VARCHAR2 |
If the reference material is published, the four-digit year in which the reference material was published. |
SPAWNER_PUBLISHER
VARCHAR2 |
If the reference material is published, the name of the publisher of the reference material. |
SPAWNER_REF_NOTES
VARCHAR2 |
Any comments or other information about the reference material or its publication or use. |
WILD_FRAC_TITLE
VARCHAR2 |
The recognized title for a piece of reference material. |
WILD_FRAC_AUTHOR
VARCHAR2 |
The name of the author of a piece of reference material. |
WILD_FRAC_PUBYEAR
VARCHAR2 |
If the reference material is published, the four-digit year in which the reference material was published. |
WILD_FRAC_PUBLISHER
VARCHAR2 |
If the reference material is published, the name of the publisher of the reference material. |
WILD_FRAC_REF_NOTES
VARCHAR2 |
Any comments or other information about the reference material or its publication or use. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (NWFSC) for inquiries on this record.
Item Identification
Title: | Population data and references for the Salmon Population Summary (SPS) Database |
---|---|
Short Name: | Population data and references for the Salmon Population Summary (SPS) Database |
Status: | Planned |
Abstract: |
The data contained in the SPS database are primarily summary data, compiled at the population level. The database also includes a limited number of series representing the aggregate returns to groups of populations (e.g., Lower Granite Dam counts) or counts of spawners within a subsection of a population where expansions to the population level were not feasible. The information used to develop the population level estimates comes from a variety of sources, but mostly originates from the monitoring programs conducted by state and tribal fishery agencies. The Technical Recovery Teams and NWFSC staff have processed this information to provide an estimate of spawning abundance at the population level. A variety of different types of information (e.g., redd counts, dam counts, carcass surveys, tag recoveries, scale analysis) forms the basis of the information in the database, and where possible the database provides references to these information sources. It is important to recognize that spawning abundance values and other information in the SPS database are not 'facts' that are known with certainty. Rather, they are estimates based on a variety of sources of information, some known with greater precision or accuracy than others. Ideally, these estimates would be characterized by a known level of statistical uncertainty. However, for the most part such a statistical characterization is either not possible or has not been attempted, and the database reports only the best estimates of the values. In all cases there is some degree of uncertainty surrounding these estimates. The NWFSC intends to work with our state and tribal partners to keep the SPS database as up-to-date as possible, and new annual estimates will be added as they become available. Disclaimer: Due to the wide variety of data sources that go into the SPS database, the NWFSC does not guarantee the accuracy of any of the data in the SPS database. In particular, neither the U.S. Government, nor any agency or employee thereof, makes any warranties, expressed or implied, with respect to the accuracy of the data, including but not limited to the implied warranties or merchantability and fitness for any particular purpose. In no event shall the U.S. Government, nor any agency or employee thereof, be liable for any direct, indirect, or consequential damage flowing from the use of the data in the SPS database. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | SPS |
Description: |
The data contained in the SPS database are primarily summary data, compiled at the population level. The database also includes a limited number of series representing the aggregate returns to groups of populations (e.g., Lower Granite Dam counts) or counts of spawners within a subsection of a population where expansions to the population level were not feasible. The information used to develop the population level estimates comes from a variety of sources, but mostly originates from the monitoring programs conducted by state and tribal fishery agencies. The Technical Recovery Teams and NWFSC staff have processed this information to provide an estimate of spawning abundance at the population level. A variety of different types of information (e.g., redd counts, dam counts, carcass surveys, tag recoveries, scale analysis) forms the basis of the information in the database, and where possible the database provides references to these information sources. It is important to recognize that spawning abundance values and other information in the SPS database are not 'facts' that are known with certainty. Rather, they are estimates based on a variety of sources of information, some known with greater precision or accuracy than others. Ideally, these estimates would be characterized by a known level of statistical uncertainty. However, for the most part such a statistical characterization is either not possible or has not been attempted, and the database reports only the best estimates of the values. In all cases there is some degree of uncertainty surrounding these estimates. The NWFSC intends to work with our state and tribal partners to keep the SPS database as up-to-date as possible, and new annual estimates will be added as they become available. Disclaimer: Due to the wide variety of data sources that go into the SPS database, the NWFSC does not guarantee the accuracy of any of the data in the SPS database. In particular, neither the U.S. Government, nor any agency or employee thereof, makes any warranties, expressed or implied, with respect to the accuracy of the data, including but not limited to the implied warranties or merchantability and fitness for any particular purpose. In no event shall the U.S. Government, nor any agency or employee thereof, be liable for any direct, indirect, or consequential damage flowing from the use of the data in the SPS database. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
RECOVERY_DOMAIN | VARCHAR2 | After listing 27 Pacific salmon Evolutionarily Significant Units (ESUs) as threatened or endangered under the Endangered Species Act, NMFS initiated a coast wide process to develop recovery plans for these species. An important part of this process was the creation of geographically based Technical Recovery Teams (TRTs) and recovery areas (domains). | |
100
|
ESU_NAME | VARCHAR2 | A group of Pacific salmon or steelhead trout that is (1) substantially reproductively isolated from other conspecific units and (2) represents an important component of the evolutionary legacy of the species. | |
100
|
MAJOR_POPULATION_GROUP | VARCHAR2 | A group of salmon populations that are geographically and genetically cohesive. The MPG is a level of organization between demographically independent populations and the ESU or DPS. | |
100
|
COMMON_POPULATION_NAME | VARCHAR2 | Name of population as people may commonly refer to it. | |
100
|
NWR_POPULATION_NAME | VARCHAR2 | Name of the population as defined by NMFS: A group of fish of the same species that spawns in a particular locality at a particular season and does not interbreed substantially with fish from any other group. | |
100
|
GENUS | VARCHAR2 | The name of the genus that the population belongs to. | |
100
|
SPECIES | VARCHAR2 | The name of the specie that the population belongs to. | |
100
|
STREAM_NAME | VARCHAR2 | Name of the River or drainage identifying or containing the population. | |
100
|
RUN_TIMING | VARCHAR2 | The season of the year for the return of the population to its anadromous waters. i.e. Spring, Summer, Winter or Fall | |
100
|
START_YEAR | NUMBER | The earliest year that viable salmonid population statistics are reported for this population. | |
100
|
END_YEAR | NUMBER | The latest year that viable salmonid population statistics are reported for this population. | |
100
|
BROOD_YEAR | NUMBER | The year that adults enter to the river to spawn. | |
100
|
VIABILITY_TYPE | VARCHAR2 | The type-classification of this particular population viability figure. | |
100
|
RUN | VARCHAR2 | The Season of the Year represented by this viability figure for the population. | |
100
|
NUMBER_OF_SPAWNERS | NUMBER | The total number of fish returning to spawn in the data collection year. | |
100
|
SPAWNER_NOTES | VARCHAR2 | Comments or other helpful information about the observation of spawners in this viability computation. | |
100
|
FRACWILD | NUMBER | The fraction of the total spawners that are the progeny of naturally-spawning fish. | |
100
|
HATCHERY_FRACTION | NUMBER | A value between 0 and 1 that is the fraction of natural origin spawners. Natural origin spawners are spawners whose parents spawned in the wild. The fracWild is equal to one minus the fraction of first generation hatchery fish spawning in a given year. If all hatchery fish are marked, this value is the fraction of unmarked fish observed in a given year. | |
100
|
HATCHERY_FRACTION_NOTES | VARCHAR2 | Comments or other information about the observed or estimated Hatchery fraction of the fish in this viability computation. | |
100
|
EFFECTIVE_CATCH | NUMBER | The number of additional wild fish that would have returned to spawn in a given year had there not been a catch (harvest). | |
100
|
AGE_1_RETURNS | NUMBER | The fraction of fish who are defined as having an age of 1 that returned to spawn in a given year. | |
100
|
AGE_2_RETURNS | NUMBER | The fraction of fish who are defined as having an age of 2 that returned to spawn in a given year. | |
100
|
AGE_3_RETURNS | NUMBER | The fraction of fish who are defined as having an age of 3 that returned to spawn in a given year. | |
100
|
AGE_4_RETURNS | NUMBER | The fraction of fish who are defined as having an age of 4 that returned to spawn in a given year. | |
100
|
AGE_5_RETURNS | NUMBER | The fraction of fish who are defined as having an age of 5 that returned to spawn in a given year. | |
100
|
AGE_6_RETURNS | NUMBER | The fraction of fish who are defined as having an age of 6 that returned to spawn in a given year. | |
100
|
AGE_7_RETURNS | NUMBER | The fraction of fish who are defined as having an age of 7 that returned to spawn in a given year. | |
100
|
AGE_1_HARVEST | NUMBER | Proportion of catch composed of age-1 fish. Deprecated. | |
100
|
AGE_2_HARVEST | NUMBER | Proportion of catch composed of age-2 fish. Deprecated. | |
100
|
AGE_3_HARVEST | NUMBER | Proportion of catch composed of age-3 fish. Deprecated. | |
100
|
AGE_4_HARVEST | NUMBER | Proportion of catch composed of age-4 fish. Deprecated. | |
100
|
AGE_5_HARVEST | NUMBER | Proportion of catch composed of age-5 fish. Deprecated. | |
100
|
AGE_6_HARVEST | NUMBER | Proportion of catch composed of age-6 fish. Deprecated. | |
100
|
AGE_7_HARVEST | NUMBER | Proportion of catch composed of age-7 fish. Deprecated. | |
100
|
REGIME | NUMBER | Regime is an index of environmental conditions (usually intended as a measure of ocean survival) that should be entered as a decimal number centered on 1. It is used as a multiplier to adjust recruitment to average environmental conditions. When conditions are worse than average (regime < 1), recruits are adjusted upwards, when they are better than average (regime > 1), recruits are adjusted downwards. | |
100
|
AGE_NOTES | VARCHAR2 | Comments or other information giving further description of the population's age or age-structure. | |
100
|
ABUND_COUNT_EXTERNAL_FILE_1_LI | VARCHAR2 | A web-link to any pertinent external document that relates to this population and year. | |
100
|
ABUND_COUNT_EXTERNAL_FILE_2_LI | VARCHAR2 | A web-link to a second pertinent external document that relates to this population and year. | |
100
|
TOTAL_SPAWNERS_WITH_JACKS | NUMBER | Estimated total number of fish contributing to spawning in a particular year. Includes both natural origin and hatchery origin returns, adults and jack age classes. | |
100
|
NATURAL_SPAWNERS_WITH_JACKS | NUMBER | Estimated number of natural origin (parents spawned in the wild) spawners contributing to spawning in a particular year. Includes both adults and jacks of natural origin. | |
100
|
NATURAL_ADULT_ANNUAL_RUN_4_6 | NUMBER | Estimated number of adult spawners of natural origin in a particular year. | |
100
|
JACK_FRAC_OF_HATCHERY_SPAWNERS | NUMBER | If available, estimate of the relative proportion of hatchery returns to the spawning ground that are jacks (i.e., age 3 fish for stream type chinook populations, age 2 fish for ocean type chinook populations). | |
100
|
ADULT_NATURAL_HARVEST_RATE | NUMBER | The estimated proportion of adult returns removed by harvest in a particular run year. Assumes that all adult age classes are harvested at the same rate. Steelhead and yearling type chinook estimates reflect in-river fisheries. Snake River Fall chinook estimates also include an adjustment to incorporate an index of annual ocean impacts. | |
100
|
NAT_NO_ORIGIN_BROOD_STOCK | NUMBER | Fish of natural origin removed from the returning run for use as hatchery brood stock. | |
100
|
ADULT_BROOD_RETURNS | NUMBER | Total future adult returns produced from spawning in a particular brood year. Expressed as returns to the spawning grounds. For chinook, adult brood year returns from year n are calculated as the sum of age 4 returns in year (n+4), age 5 returns in year (n+5) and age 6 returns in year (n+6). | |
100
|
SAR_ADJUSTED_ADULT_BRD_RETURNS | NUMBER | Total brood year returns proportionally adjusted to reflect an average annual smolt to adult return rate over a specified range of years. For Interior Columbia analyses, the average SARs are generally calculated for outmigration years 1980 to the most recent complete brood year (e.g., 2001). | |
100
|
LINK_REFERENCE_S | NUMBER | Natural log of the ratio of returns to parent spawners. In the ICTRT analyses, both terms are expressed as adults to the spawning grounds. | |
100
|
ADJUSTED_LINK_REFERENCE_S | NUMBER | Natural log return/spawner proportionally adjusted to reflect an average SAR.??? For Interior Columbia analyses, the average SARs are generally | |
100
|
HATCHERY_RETURN | NUMBER | The number of returning fish that were reared in a hatchery. Currently this data is not provided. | |
100
|
AGE_DATA_TYPE | VARCHAR2 | Indicates how age was estimated for a group of fish. Currently this data is not collected. Acceptable values: 1) If population-scale carcass sample size is = 20, apply the Annual Population Age Structure. 2) Else, if population-scale carcass sample size is = 19, apply the Annual Aggregate MPG Age Structure. 3) Else, if MPG-scale carcass sample size is = 19, apply the Long-Term (i.e.19601997) Population Average Age Structure. | |
100
|
AGE_DETERMINATION_SAMPLE_SIZE | NUMBER | Number of samples used in age structure determination. | |
100
|
TOTAL_SPAWNERS_WITHOUT_JACKS | NUMBER | Estimated number of natural origin (parents spawned in the wild) spawners contributing to spawning in a particular year. Includes only adults of natural origin, excluding jacks. | |
100
|
CONTACT_AGENCY | VARCHAR2 | Agency, Tribe or other entity, or person responsible for these data that is the best contact for questions that may arise about this data record. | |
100
|
NMFS_POPID | NUMBER | The foreign key to pull in the Population Name for the source database. | |
100
|
AGE_TITLE | VARCHAR2 | The recognized title for a piece of reference material. | |
100
|
AGE_AUTHOR | VARCHAR2 | The name of the author of a piece of reference material. | |
100
|
AGE_PUBYEAR | VARCHAR2 | If the reference material is published, the four-digit year in which the reference material was published. | |
100
|
AGE_PUBLISHER | VARCHAR2 | If the reference material is published, the name of the publisher of the reference material. | |
100
|
AGE_REF_NOTES | VARCHAR2 | Any comments or other information about the reference material or its publication or use. | |
100
|
CATCH_TITLE | VARCHAR2 | The recognized title for a piece of reference material. | |
100
|
CATCH_AUTHOR | VARCHAR2 | The name of the author of a piece of reference material. | |
100
|
CATCH_PUBYEAR | VARCHAR2 | If the reference material is published, the four-digit year in which the reference material was published. | |
100
|
CATCH_PUBLISHER | VARCHAR2 | If the reference material is published, the name of the publisher of the reference material. | |
100
|
CATCH_REF_NOTES | VARCHAR2 | Any comments or other information about the reference material or its publication or use. | |
100
|
SPAWNER_TITLE | VARCHAR2 | The recognized title for a piece of reference material. | |
100
|
SPAWNER_AUTHOR | VARCHAR2 | The name of the author of a piece of reference material. | |
100
|
SPAWNER_PUBYEAR | VARCHAR2 | If the reference material is published, the four-digit year in which the reference material was published. | |
100
|
SPAWNER_PUBLISHER | VARCHAR2 | If the reference material is published, the name of the publisher of the reference material. | |
100
|
SPAWNER_REF_NOTES | VARCHAR2 | Any comments or other information about the reference material or its publication or use. | |
100
|
WILD_FRAC_TITLE | VARCHAR2 | The recognized title for a piece of reference material. | |
100
|
WILD_FRAC_AUTHOR | VARCHAR2 | The name of the author of a piece of reference material. | |
100
|
WILD_FRAC_PUBYEAR | VARCHAR2 | If the reference material is published, the four-digit year in which the reference material was published. | |
100
|
WILD_FRAC_PUBLISHER | VARCHAR2 | If the reference material is published, the name of the publisher of the reference material. | |
100
|
WILD_FRAC_REF_NOTES | VARCHAR2 | Any comments or other information about the reference material or its publication or use. |
Attribute Details
RECOVERY_DOMAIN
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
After listing 27 Pacific salmon Evolutionarily Significant Units (ESUs) as threatened or endangered under the Endangered Species Act, NMFS initiated a coast wide process to develop recovery plans for these species. An important part of this process was the creation of geographically based Technical Recovery Teams (TRTs) and recovery areas (domains). |
General Data Type: | VARCHAR2 |
ESU_NAME
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A group of Pacific salmon or steelhead trout that is (1) substantially reproductively isolated from other conspecific units and (2) represents an important component of the evolutionary legacy of the species. |
General Data Type: | VARCHAR2 |
MAJOR_POPULATION_GROUP
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A group of salmon populations that are geographically and genetically cohesive. The MPG is a level of organization between demographically independent populations and the ESU or DPS. |
General Data Type: | VARCHAR2 |
COMMON_POPULATION_NAME
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of population as people may commonly refer to it. |
General Data Type: | VARCHAR2 |
NWR_POPULATION_NAME
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of the population as defined by NMFS: A group of fish of the same species that spawns in a particular locality at a particular season and does not interbreed substantially with fish from any other group. |
General Data Type: | VARCHAR2 |
GENUS
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 200 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The name of the genus that the population belongs to. |
General Data Type: | VARCHAR2 |
SPECIES
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The name of the specie that the population belongs to. |
General Data Type: | VARCHAR2 |
STREAM_NAME
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 100 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of the River or drainage identifying or containing the population. |
General Data Type: | VARCHAR2 |
RUN_TIMING
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The season of the year for the return of the population to its anadromous waters. i.e. Spring, Summer, Winter or Fall |
General Data Type: | VARCHAR2 |
START_YEAR
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Scale: | 0 |
Status: | Active |
Description: |
The earliest year that viable salmonid population statistics are reported for this population. |
General Data Type: | NUMBER |
END_YEAR
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Scale: | 0 |
Status: | Active |
Description: |
The latest year that viable salmonid population statistics are reported for this population. |
General Data Type: | NUMBER |
BROOD_YEAR
Seq. Order: | 20 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The year that adults enter to the river to spawn. |
General Data Type: | NUMBER |
VIABILITY_TYPE
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The type-classification of this particular population viability figure. |
General Data Type: | VARCHAR2 |
RUN
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The Season of the Year represented by this viability figure for the population. |
General Data Type: | VARCHAR2 |
NUMBER_OF_SPAWNERS
Seq. Order: | 23 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The total number of fish returning to spawn in the data collection year. |
General Data Type: | NUMBER |
SPAWNER_NOTES
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Comments or other helpful information about the observation of spawners in this viability computation. |
General Data Type: | VARCHAR2 |
FRACWILD
Seq. Order: | 25 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The fraction of the total spawners that are the progeny of naturally-spawning fish. |
General Data Type: | NUMBER |
HATCHERY_FRACTION
Seq. Order: | 26 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A value between 0 and 1 that is the fraction of natural origin spawners. Natural origin spawners are spawners whose parents spawned in the wild. The fracWild is equal to one minus the fraction of first generation hatchery fish spawning in a given year. If all hatchery fish are marked, this value is the fraction of unmarked fish observed in a given year. |
General Data Type: | NUMBER |
HATCHERY_FRACTION_NOTES
Seq. Order: | 27 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Comments or other information about the observed or estimated Hatchery fraction of the fish in this viability computation. |
General Data Type: | VARCHAR2 |
EFFECTIVE_CATCH
Seq. Order: | 28 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The number of additional wild fish that would have returned to spawn in a given year had there not been a catch (harvest). |
General Data Type: | NUMBER |
AGE_1_RETURNS
Seq. Order: | 29 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The fraction of fish who are defined as having an age of 1 that returned to spawn in a given year. |
General Data Type: | NUMBER |
AGE_2_RETURNS
Seq. Order: | 30 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The fraction of fish who are defined as having an age of 2 that returned to spawn in a given year. |
General Data Type: | NUMBER |
AGE_3_RETURNS
Seq. Order: | 31 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The fraction of fish who are defined as having an age of 3 that returned to spawn in a given year. |
General Data Type: | NUMBER |
AGE_4_RETURNS
Seq. Order: | 32 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The fraction of fish who are defined as having an age of 4 that returned to spawn in a given year. |
General Data Type: | NUMBER |
AGE_5_RETURNS
Seq. Order: | 33 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The fraction of fish who are defined as having an age of 5 that returned to spawn in a given year. |
General Data Type: | NUMBER |
AGE_6_RETURNS
Seq. Order: | 34 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The fraction of fish who are defined as having an age of 6 that returned to spawn in a given year. |
General Data Type: | NUMBER |
AGE_7_RETURNS
Seq. Order: | 35 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The fraction of fish who are defined as having an age of 7 that returned to spawn in a given year. |
General Data Type: | NUMBER |
AGE_1_HARVEST
Seq. Order: | 36 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Proportion of catch composed of age-1 fish. Deprecated. |
General Data Type: | NUMBER |
AGE_2_HARVEST
Seq. Order: | 37 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Proportion of catch composed of age-2 fish. Deprecated. |
General Data Type: | NUMBER |
AGE_3_HARVEST
Seq. Order: | 38 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Proportion of catch composed of age-3 fish. Deprecated. |
General Data Type: | NUMBER |
AGE_4_HARVEST
Seq. Order: | 39 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Proportion of catch composed of age-4 fish. Deprecated. |
General Data Type: | NUMBER |
AGE_5_HARVEST
Seq. Order: | 40 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Proportion of catch composed of age-5 fish. Deprecated. |
General Data Type: | NUMBER |
AGE_6_HARVEST
Seq. Order: | 41 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Proportion of catch composed of age-6 fish. Deprecated. |
General Data Type: | NUMBER |
AGE_7_HARVEST
Seq. Order: | 42 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Proportion of catch composed of age-7 fish. Deprecated. |
General Data Type: | NUMBER |
REGIME
Seq. Order: | 43 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Regime is an index of environmental conditions (usually intended as a measure of ocean survival) that should be entered as a decimal number centered on 1. It is used as a multiplier to adjust recruitment to average environmental conditions. When conditions are worse than average (regime < 1), recruits are adjusted upwards, when they are better than average (regime > 1), recruits are adjusted downwards. |
General Data Type: | NUMBER |
AGE_NOTES
Seq. Order: | 44 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Comments or other information giving further description of the population's age or age-structure. |
General Data Type: | VARCHAR2 |
ABUND_COUNT_EXTERNAL_FILE_1_LI
Seq. Order: | 45 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 500 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A web-link to any pertinent external document that relates to this population and year. |
General Data Type: | VARCHAR2 |
ABUND_COUNT_EXTERNAL_FILE_2_LI
Seq. Order: | 46 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 500 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A web-link to a second pertinent external document that relates to this population and year. |
General Data Type: | VARCHAR2 |
TOTAL_SPAWNERS_WITH_JACKS
Seq. Order: | 48 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Estimated total number of fish contributing to spawning in a particular year. Includes both natural origin and hatchery origin returns, adults and jack age classes. |
General Data Type: | NUMBER |
NATURAL_SPAWNERS_WITH_JACKS
Seq. Order: | 49 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Estimated number of natural origin (parents spawned in the wild) spawners contributing to spawning in a particular year. Includes both adults and jacks of natural origin. |
General Data Type: | NUMBER |
NATURAL_ADULT_ANNUAL_RUN_4_6
Seq. Order: | 50 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Estimated number of adult spawners of natural origin in a particular year. |
General Data Type: | NUMBER |
JACK_FRAC_OF_HATCHERY_SPAWNERS
Seq. Order: | 51 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
If available, estimate of the relative proportion of hatchery returns to the spawning ground that are jacks (i.e., age 3 fish for stream type chinook populations, age 2 fish for ocean type chinook populations). |
General Data Type: | NUMBER |
ADULT_NATURAL_HARVEST_RATE
Seq. Order: | 52 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The estimated proportion of adult returns removed by harvest in a particular run year. Assumes that all adult age classes are harvested at the same rate. Steelhead and yearling type chinook estimates reflect in-river fisheries. Snake River Fall chinook estimates also include an adjustment to incorporate an index of annual ocean impacts. |
General Data Type: | NUMBER |
NAT_NO_ORIGIN_BROOD_STOCK
Seq. Order: | 53 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Fish of natural origin removed from the returning run for use as hatchery brood stock. |
General Data Type: | NUMBER |
ADULT_BROOD_RETURNS
Seq. Order: | 54 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Total future adult returns produced from spawning in a particular brood year. Expressed as returns to the spawning grounds. For chinook, adult brood year returns from year n are calculated as the sum of age 4 returns in year (n+4), age 5 returns in year (n+5) and age 6 returns in year (n+6). |
General Data Type: | NUMBER |
SAR_ADJUSTED_ADULT_BRD_RETURNS
Seq. Order: | 55 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Total brood year returns proportionally adjusted to reflect an average annual smolt to adult return rate over a specified range of years. For Interior Columbia analyses, the average SARs are generally calculated for outmigration years 1980 to the most recent complete brood year (e.g., 2001). |
General Data Type: | NUMBER |
LINK_REFERENCE_S
Seq. Order: | 56 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Natural log of the ratio of returns to parent spawners. In the ICTRT analyses, both terms are expressed as adults to the spawning grounds. |
General Data Type: | NUMBER |
ADJUSTED_LINK_REFERENCE_S
Seq. Order: | 57 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Natural log return/spawner proportionally adjusted to reflect an average SAR.??? For Interior Columbia analyses, the average SARs are generally |
General Data Type: | NUMBER |
HATCHERY_RETURN
Seq. Order: | 58 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The number of returning fish that were reared in a hatchery. Currently this data is not provided. |
General Data Type: | NUMBER |
AGE_DATA_TYPE
Seq. Order: | 59 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Indicates how age was estimated for a group of fish. Currently this data is not collected. Acceptable values: 1) If population-scale carcass sample size is = 20, apply the Annual Population Age Structure. 2) Else, if population-scale carcass sample size is = 19, apply the Annual Aggregate MPG Age Structure. 3) Else, if MPG-scale carcass sample size is = 19, apply the Long-Term (i.e.19601997) Population Average Age Structure. |
General Data Type: | VARCHAR2 |
AGE_DETERMINATION_SAMPLE_SIZE
Seq. Order: | 60 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of samples used in age structure determination. |
General Data Type: | NUMBER |
TOTAL_SPAWNERS_WITHOUT_JACKS
Seq. Order: | 61 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Estimated number of natural origin (parents spawned in the wild) spawners contributing to spawning in a particular year. Includes only adults of natural origin, excluding jacks. |
General Data Type: | NUMBER |
CONTACT_AGENCY
Seq. Order: | 62 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 200 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Agency, Tribe or other entity, or person responsible for these data that is the best contact for questions that may arise about this data record. |
General Data Type: | VARCHAR2 |
NMFS_POPID
Seq. Order: | 63 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The foreign key to pull in the Population Name for the source database. |
General Data Type: | NUMBER |
AGE_TITLE
Seq. Order: | 64 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The recognized title for a piece of reference material. |
General Data Type: | VARCHAR2 |
AGE_AUTHOR
Seq. Order: | 65 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 400 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The name of the author of a piece of reference material. |
General Data Type: | VARCHAR2 |
AGE_PUBYEAR
Seq. Order: | 66 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 45 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
If the reference material is published, the four-digit year in which the reference material was published. |
General Data Type: | VARCHAR2 |
AGE_PUBLISHER
Seq. Order: | 67 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 200 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
If the reference material is published, the name of the publisher of the reference material. |
General Data Type: | VARCHAR2 |
AGE_REF_NOTES
Seq. Order: | 68 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Any comments or other information about the reference material or its publication or use. |
General Data Type: | VARCHAR2 |
CATCH_TITLE
Seq. Order: | 69 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The recognized title for a piece of reference material. |
General Data Type: | VARCHAR2 |
CATCH_AUTHOR
Seq. Order: | 70 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 400 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The name of the author of a piece of reference material. |
General Data Type: | VARCHAR2 |
CATCH_PUBYEAR
Seq. Order: | 71 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 45 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
If the reference material is published, the four-digit year in which the reference material was published. |
General Data Type: | VARCHAR2 |
CATCH_PUBLISHER
Seq. Order: | 72 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 200 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
If the reference material is published, the name of the publisher of the reference material. |
General Data Type: | VARCHAR2 |
CATCH_REF_NOTES
Seq. Order: | 73 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Any comments or other information about the reference material or its publication or use. |
General Data Type: | VARCHAR2 |
SPAWNER_TITLE
Seq. Order: | 74 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The recognized title for a piece of reference material. |
General Data Type: | VARCHAR2 |
SPAWNER_AUTHOR
Seq. Order: | 75 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 400 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The name of the author of a piece of reference material. |
General Data Type: | VARCHAR2 |
SPAWNER_PUBYEAR
Seq. Order: | 76 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 45 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
If the reference material is published, the four-digit year in which the reference material was published. |
General Data Type: | VARCHAR2 |
SPAWNER_PUBLISHER
Seq. Order: | 77 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 200 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
If the reference material is published, the name of the publisher of the reference material. |
General Data Type: | VARCHAR2 |
SPAWNER_REF_NOTES
Seq. Order: | 78 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Any comments or other information about the reference material or its publication or use. |
General Data Type: | VARCHAR2 |
WILD_FRAC_TITLE
Seq. Order: | 79 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The recognized title for a piece of reference material. |
General Data Type: | VARCHAR2 |
WILD_FRAC_AUTHOR
Seq. Order: | 80 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 400 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The name of the author of a piece of reference material. |
General Data Type: | VARCHAR2 |
WILD_FRAC_PUBYEAR
Seq. Order: | 81 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 45 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
If the reference material is published, the four-digit year in which the reference material was published. |
General Data Type: | VARCHAR2 |
WILD_FRAC_PUBLISHER
Seq. Order: | 82 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 200 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
If the reference material is published, the name of the publisher of the reference material. |
General Data Type: | VARCHAR2 |
WILD_FRAC_REF_NOTES
Seq. Order: | 83 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Any comments or other information about the reference material or its publication or use. |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 35856 |
---|---|
GUID: | gov.noaa.nmfs.inport:35856 |
Metadata Record Created By: | Jeffrey W Cowen |
Metadata Record Created: | 2016-12-02 15:28+0000 |
Metadata Record Last Modified By: | Jeffrey W Cowen |
Metadata Record Last Modified: | 2022-11-21 19:59+0000 |
Metadata Record Published: | 2017-11-30 |
Owner Org: | NWFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2017-11-30 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2018-11-30 |