POPULATION_SUMMARIES

32695

POPULATION_SUMMARIES_ARCV

Entity

Published / External

17904

SPS Abundance - Salmon spawner abundance data compilation and database management

Data Set

Planned Stores a snap shot in time of population summary data. Generally archives are created annually to support NMFS reporting requirements.

Data Table

Yes

SPS Stores a snap shot in time of population summary data. Generally archives are created annually to support NMFS reporting requirements.

ABUND_COUNT_EXTERNAL_FILE_1_LI

VARCHAR2

500

Active A web-link to any pertinent external document that relates to this population and year.

VARCHAR2

ABUND_COUNT_EXTERNAL_FILE_2_LI

VARCHAR2

500

Active A web-link to a second pertinent external document that relates to this population and year.

VARCHAR2

ADJUSTED_LINK_REFERENCE_S

NUMBER

Active Natural log return/spawner proportionally adjusted to reflect an average SAR.??? For Interior Columbia analyses, the average SARs are generally

NUMBER

ADULT_BROOD_RETURNS

NUMBER

Active 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).

NUMBER

ADULT_NATURAL_HARVEST_RATE

NUMBER

Active 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.

NUMBER

AGE_1_HARVEST

NUMBER

Active Proportion of catch composed of age-1 fish. Deprecated.

NUMBER

AGE_1_RETURNS

NUMBER

Active The fraction of fish who are defined as having an age of 1 that returned to spawn in a given year.

NUMBER

AGE_2_HARVEST

NUMBER

Active Proportion of catch composed of age-2 fish. Deprecated.

NUMBER

AGE_2_RETURNS

NUMBER

Active The fraction of fish who are defined as having an age of 2 that returned to spawn in a given year.

NUMBER

AGE_3_HARVEST

NUMBER

Active Proportion of catch composed of age-3 fish. Deprecated.

NUMBER

AGE_3_RETURNS

NUMBER

Active The fraction of fish who are defined as having an age of 3 that returned to spawn in a given year.

NUMBER

AGE_4_HARVEST

NUMBER

Active Proportion of catch composed of age-4 fish. Deprecated.

NUMBER

AGE_4_RETURNS

NUMBER

Active The fraction of fish who are defined as having an age of 4 that returned to spawn in a given year.

NUMBER

AGE_5_HARVEST

NUMBER

Active Proportion of catch composed of age-5 fish. Deprecated.

NUMBER

AGE_5_RETURNS

NUMBER

Active The fraction of fish who are defined as having an age of 5 that returned to spawn in a given year.

NUMBER

AGE_6_HARVEST

NUMBER

Active Proportion of catch composed of age-6 fish. Deprecated.

NUMBER

AGE_6_RETURNS

NUMBER

Active The fraction of fish who are defined as having an age of 6 that returned to spawn in a given year.

NUMBER

AGE_7_HARVEST

NUMBER

Active Proportion of catch composed of age-7 fish. Deprecated.

NUMBER

AGE_7_RETURNS

NUMBER

Active The fraction of fish who are defined as having an age of 7 that returned to spawn in a given year.

NUMBER

AGE_DATA_TYPE

VARCHAR2

255

Active 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.

VARCHAR2

AGE_DETERMINATION_SAMPLE_SIZE

NUMBER

Active Number of samples used in age structure determination.

NUMBER

AGE_NOTES

VARCHAR2

4000

Active Comments or other information giving further description of the population's age or age-structure.

VARCHAR2

BROOD_YEAR

NUMBER

Active The year that adults enter to the river to spawn.

NUMBER

COMMON_POPULATION_NAME

VARCHAR2

100

Active Name of population as people may commonly refer to it.

VARCHAR2

CONTACT_AGENCY

VARCHAR2

200

Active 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.

VARCHAR2

DETAIL_DB_ID

NUMBER

Yes

Active Foreign key to the detailed population record.

NUMBER

EFFECTIVE_CATCH

NUMBER

Active The number of additional wild fish that would have returned to spawn in a given year had there not been a catch (harvest).

NUMBER

END_YEAR

NUMBER

Active The latest year that viable salmonid population statistics are reported for this population.

NUMBER

ESU_DB_ID

NUMBER

Active Foreign key to the ESU lookup table.

NUMBER

ESU_MAP

VARCHAR2

131

Active The ESU name used for map display purposes only.

VARCHAR2

ESU_NAME

VARCHAR2

100

Active 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.

VARCHAR2

FRACWILD

NUMBER

Active The fraction of the total spawners that are the progeny of naturally-spawning fish.

NUMBER

GENUS

VARCHAR2

200

Active The name of the genus that the population belongs to.

VARCHAR2

HATCHERY_FRACTION

NUMBER

Active 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.

NUMBER

HATCHERY_FRACTION_NOTES

VARCHAR2

4000

Active Comments or other information about the observed or estimated Hatchery fraction of the fish in this viability computation.

VARCHAR2

HATCHERY_RETURN

NUMBER

Active The number of returning fish that were reared in a hatchery. Currently this data is not provided.

NUMBER

JACK_FRAC_OF_HATCHERY_SPAWNERS

NUMBER

Active 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).

NUMBER

LINK_REFERENCE_S

NUMBER

Active Natural log of the ratio of returns to parent spawners. In the ICTRT analyses, both terms are expressed as adults to the spawning grounds.

NUMBER

MAJOR_POPULATION_GROUP

VARCHAR2

Active 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.

VARCHAR2

MAP_RUN

VARCHAR2

Active The running timing of the population used for map display purposes only.

VARCHAR2

NATURAL_ADULT_ANNUAL_RUN_4_6

NUMBER

Active Estimated number of adult spawners of natural origin in a particular year.

NUMBER

NATURAL_SPAWNERS_WITH_JACKS

NUMBER

Active 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.

NUMBER

NAT_NO_ORIGIN_BROOD_STOCK

NUMBER

Active Fish of natural origin removed from the returning run for use as hatchery brood stock.

NUMBER

NMFS_POPID

NUMBER

Active The foreign key to pull in the Population Name for the source database.

NUMBER

NUMBER_OF_SPAWNERS

NUMBER

Active The total number of fish returning to spawn in the data collection year.

NUMBER

NWR_POPULATION_NAME

VARCHAR2

255

Active 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.

VARCHAR2

POPSUMARCV_DB_ID

NUMBER

Yes

Active Database-generated primary key (unique identifier) for each POPULATION_SUMMARIES_ARCV record, created by an internal sequence generator and used by the database to maintain referential integrity. This ID is not designed to be managed by users. This primary key constraint is named POPSUMARCV_PK.

NUMBER

POPULATION_DB_ID

NUMBER

Active A unique identifier for each record; assigned by an internal Sequence Generator and used by the database to maintain foreign-key relationships. This ID is not designed to be managed by users.

NUMBER

PUB_POP_ID

NUMBER

Active Foreign key to population name lookup table. This column has been deprecated.

NUMBER

RECORD_APPROVED_BY_PERSON

VARCHAR2

Active If there is a certification process for these records, name of person who certified approval of the particular record.

VARCHAR2

RECORD_APPROVED_ON_DATE

DATE

Active If there is a certification process for these records, date that the particular record was approved or officially certified.

DATE

RECORD_CHANGE_COMMENT

CLOB

4000

Active Unlimited narrative describing the last change/edit made to this particular record. In a post-edit summary, this text is intended to describe what was done by the latest edit job.

CLOB

RECORD_COMPUTER_LOAD_BY_USER

VARCHAR2

Active The username that loaded the record into the database. The username is dynamically captured by the database trigger when the record is inserted and saved to the database. This person may have no knowledge of content or meaning but ran the computer process that put the record into the database.

VARCHAR2

RECORD_COMPUTER_LOAD_ON_DATE

TIMESTAMP(4)

Active The date that the record was loaded into the database. This date is dynamically captured by the database trigger when the record is inserted and saved.

TIMESTAMP(4)

RECORD_CREATED_BY_PERSON

VARCHAR2

Active The name of the person who originated this record PRIOR to its being entered into the database. The name of the person to contact with administrative questions or an explanation of it content.

VARCHAR2

RECORD_CREATED_ON_DATE

TIMESTAMP(4)

Active The date, or approximate date, that the person with content knowledge originated this record PRIOR to its being entered into the database.

TIMESTAMP(4)

RECORD_EFFECTIVE_DATE

DATE

Active If necessary, the date that the individual record becomes effective. Prior to this date the record is not valid.

DATE

RECORD_EXPIRATION_DATE

DATE

Active If necessary, the date that the individual record ceases to be effective. To force a midnight expiration, this may be set by "Select to_date(to_char(sysdate +1 ,'mm/dd/yyyy')||' 23:59:59','mm/dd/yyyy hh24:mi:ss') from dual". After this date and time the record is not valid.

DATE

RECORD_HISTORY

CLOB

4000

Active An accumulated set of statements describing how THIS RECORD has been edited over time including WHEN and by WHOM.

CLOB

RECORD_JOURNAL_NOTE

VARCHAR2

4000

Active Short narrative describing the last change/edit made to this particular record. In a post-edit summary, this text is intended to describe what was done by the latest edit job.

VARCHAR2

RECORD_LAST_EDITED_BY_USER

VARCHAR2

Active The username of the last person who modified this record. This username is dynamically captured by the database trigger any time the record is edited.

VARCHAR2

RECORD_LAST_EDITED_ON_DATE

TIMESTAMP(4)

Active The last date that the particular record was modified. This date is dynamically captured by the database trigger any time the record is edited.

TIMESTAMP(4)

RECORD_NUMBER_OF_EDITS

NUMBER

Active The number of times that the particular record was modified. This count is dynamically incremented by 1 by the database trigger each time the record is edited.

NUMBER

RECORD_SOFT_DELETED

VARCHAR2

Active Flag whether or not this record has the "Deleted" status. Null means this record has NOT been deleted. "Y" means this record HAS been deleted. This flag allows "deleted" records to remain in the table for technical reasons. When the record is "Hard Deleted" it will be removed from this table and may or may not be placed in a historical table to preserve historical status.

VARCHAR2

RECORD_STEWARDSHIP

VARCHAR2

Active If a set of User-Roles are developed for these records, this allows a particular Role (which may be a collection of other Roles) to be assigned to steward individual records. When any user attempts to modify a record, a database procedure will then dynamically examine the user's Role to determine if they are authorized to edit particular records.

VARCHAR2

RECOVERY_DOMAIN

VARCHAR2

Active 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).

VARCHAR2

REGIME

NUMBER

Active 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.

NUMBER

RUN

VARCHAR2

Active The Season of the Year represented by this viability figure for the population.

VARCHAR2

RUN_TIMING

VARCHAR2

Active The season of the year for the return of the population to its anadromous waters. i.e. Spring, Summer, Winter or Fall

VARCHAR2

SAR_ADJUSTED_ADULT_BRD_RETURNS

NUMBER

Active 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).

NUMBER

SPAWNER_NOTES

VARCHAR2

4000

Active Comments or other helpful information about the observation of spawners in this viability computation.

VARCHAR2

SPECIES

VARCHAR2

Active The name of the specie that the population belongs to.

VARCHAR2

SPECIES_DEFINITION_DB_ID

NUMBER

Active A unique identifier for each record; assigned by an internal Sequence Generator and used by the database to maintain foreign-key relationships. This ID is not designed to be managed by users.

NUMBER

SPS_ARCHIVE_DB_ID

NUMBER

Yes

Active Foreign key to the SPS_ARCHIVE table to link POPULATION_SUMMARIES_ARCV records to a specific ARCHIVE_DB_ID using the SPS_ARCHIVE_PK primary key. This foreign key constraint is named SPSARCV_POPDETAIL_FK1.

NUMBER

START_YEAR

NUMBER

Active The earliest year that viable salmonid population statistics are reported for this population.

NUMBER

STREAM_NAME

VARCHAR2

100

Active Name of the River or drainage identifying or containing the population.

VARCHAR2

TOTAL_SPAWNERS_WITHOUT_JACKS

NUMBER

Active 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.

NUMBER

TOTAL_SPAWNERS_WITH_JACKS

NUMBER

Active 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.

NUMBER

VIABILITY_TYPE

VARCHAR2

Active The type-classification of this particular population viability figure.

VARCHAR2

gov.noaa.nmfs.inport:32695

Jeffrey Cowen

2016-05-09T14:19:50

SysAdmin InPortAdmin

2022-08-09T17:11:00

2016-05-11

Northwest Fisheries Science Center

NWFSC

2725 Montlake Boulevard East

Seattle

98112

USA

206-860-3200

https://www.nwfsc.noaa.gov

1001

Public

2016-05-11

1 Year

2017-05-11