Slide Menu
Search Help Show/Hide Menu

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

Rubric Score Primary Key? 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

CC ID: 699050
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

CC ID: 699051
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

CC ID: 699052
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

CC ID: 699053
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

CC ID: 699054
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

CC ID: 699055
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

CC ID: 699056
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

CC ID: 699057
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

CC ID: 699058
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

CC ID: 699059
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

CC ID: 699060
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

CC ID: 699061
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

CC ID: 699062
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

CC ID: 699063
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

CC ID: 699064
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

CC ID: 699065
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

CC ID: 699066
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

CC ID: 699067
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

CC ID: 699068
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

CC ID: 699069
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

CC ID: 699070
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

CC ID: 699071
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

CC ID: 699072
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

CC ID: 699073
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

CC ID: 699074
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

CC ID: 699075
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

CC ID: 699076
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

CC ID: 699077
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

CC ID: 699078
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

CC ID: 699079
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

CC ID: 699080
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

CC ID: 699081
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

CC ID: 699082
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

CC ID: 699083
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

CC ID: 699084
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

CC ID: 699085
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

CC ID: 699086
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

CC ID: 699087
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

CC ID: 699088
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

CC ID: 699089
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

CC ID: 699090
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

CC ID: 699091
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

CC ID: 699092
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

CC ID: 699093
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

CC ID: 699094
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

CC ID: 699095
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

CC ID: 699096
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

CC ID: 699097
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

CC ID: 699098
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

CC ID: 699099
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

CC ID: 699100
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

CC ID: 699101
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

CC ID: 699102
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

CC ID: 699103
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

CC ID: 699104
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

CC ID: 699105
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

CC ID: 699106
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

CC ID: 699107
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

CC ID: 699108
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

CC ID: 699109
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

CC ID: 699110
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

CC ID: 699111
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

CC ID: 699112
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

CC ID: 699113
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

CC ID: 699114
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

CC ID: 699115
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

CC ID: 699116
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

CC ID: 699117
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

CC ID: 699118
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

CC ID: 699119
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

CC ID: 699120
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

CC ID: 699121
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

CC ID: 699122
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

CC ID: 699123
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: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2017-11-30
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2018-12-01