Slide Menu
System Maintenance Notice, Monday, December 5, 2022 @ 1pm-5pm Eastern. The Operations Team will be performing system maintenance. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

Item Identification

Title: POPULATION_SUMMARIES_ARCV
Short Name: POPULATION_SUMMARIES_ARCV
Status: Planned
Abstract:

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

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: SPS
Description:

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

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
AGE_DETERMINATION_SAMPLE_SIZE NUMBER Number of samples used in age structure determination.
100
RECORD_HISTORY CLOB An accumulated set of statements describing how THIS RECORD has been edited over time including WHEN and by WHOM.
100
RECORD_JOURNAL_NOTE VARCHAR2 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.
100
RECORD_APPROVED_BY_PERSON VARCHAR2 If there is a certification process for these records, name of person who certified approval of the particular record.
100
RECORD_APPROVED_ON_DATE DATE If there is a certification process for these records, date that the particular record was approved or officially certified.
100
RECORD_COMPUTER_LOAD_BY_USER VARCHAR2 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.
100
RECORD_COMPUTER_LOAD_ON_DATE TIMESTAMP(4) 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.
100
RECORD_CREATED_BY_PERSON VARCHAR2 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.
100
RECORD_CREATED_ON_DATE TIMESTAMP(4) The date, or approximate date, that the person with content knowledge originated this record PRIOR to its being entered into the database.
100
RECORD_EFFECTIVE_DATE DATE If necessary, the date that the individual record becomes effective. Prior to this date the record is not valid.
100
RECORD_EXPIRATION_DATE DATE 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.
100
RECORD_LAST_EDITED_BY_USER VARCHAR2 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.
100
RECORD_LAST_EDITED_ON_DATE TIMESTAMP(4) The last date that the particular record was modified. This date is dynamically captured by the database trigger any time the record is edited.
100
RECORD_NUMBER_OF_EDITS NUMBER 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.
100
RECORD_SOFT_DELETED VARCHAR2 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.
100
RECORD_STEWARDSHIP VARCHAR2 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.
100
RECORD_CHANGE_COMMENT CLOB 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.
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
Primary Key POPSUMARCV_DB_ID NUMBER 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.
100
SPS_ARCHIVE_DB_ID NUMBER 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.
100
DETAIL_DB_ID NUMBER Foreign key to the detailed population record.
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
ESU_MAP VARCHAR2 The ESU name used for map display purposes only.
100
MAP_RUN VARCHAR2 The running timing of the population used for map display purposes only.
100
ESU_DB_ID NUMBER Foreign key to the ESU lookup table.
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
PUB_POP_ID NUMBER Foreign key to population name lookup table. This column has been deprecated.
100
SPECIES_DEFINITION_DB_ID NUMBER 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.
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
POPULATION_DB_ID NUMBER 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.
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.

Attribute Details

AGE_DETERMINATION_SAMPLE_SIZE

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

RECORD_HISTORY

CC ID: 324183
Data Storage Type: CLOB
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: CLOB

RECORD_JOURNAL_NOTE

CC ID: 324184
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

RECORD_APPROVED_BY_PERSON

CC ID: 324185
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

RECORD_APPROVED_ON_DATE

CC ID: 324186
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: DATE

RECORD_COMPUTER_LOAD_BY_USER

CC ID: 324187
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

RECORD_COMPUTER_LOAD_ON_DATE

CC ID: 324188
Data Storage Type: TIMESTAMP(4)
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: TIMESTAMP(4)

RECORD_CREATED_BY_PERSON

CC ID: 324189
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

RECORD_CREATED_ON_DATE

CC ID: 324190
Data Storage Type: TIMESTAMP(4)
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: TIMESTAMP(4)

RECORD_EFFECTIVE_DATE

CC ID: 324191
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: DATE

RECORD_EXPIRATION_DATE

CC ID: 324192
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: DATE

RECORD_LAST_EDITED_BY_USER

CC ID: 324193
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

RECORD_LAST_EDITED_ON_DATE

CC ID: 324194
Data Storage Type: TIMESTAMP(4)
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: TIMESTAMP(4)

RECORD_NUMBER_OF_EDITS

CC ID: 324195
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: NUMBER

RECORD_SOFT_DELETED

CC ID: 324196
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

RECORD_STEWARDSHIP

CC ID: 324197
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

RECORD_CHANGE_COMMENT

CC ID: 324198
Data Storage Type: CLOB
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: CLOB

TOTAL_SPAWNERS_WITHOUT_JACKS

CC ID: 324199
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: 324200
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: 324201
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

POPSUMARCV_DB_ID

CC ID: 324202
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Status: Active
Description:

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.

General Data Type: NUMBER

SPS_ARCHIVE_DB_ID

CC ID: 324203
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
Description:

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.

General Data Type: NUMBER

DETAIL_DB_ID

CC ID: 324204
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
Description:

Foreign key to the detailed population record.

General Data Type: NUMBER

RECOVERY_DOMAIN

CC ID: 324205
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: 324206
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

ESU_MAP

CC ID: 324207
Data Storage Type: VARCHAR2
Max Length: 131
Required: No
Primary Key: No
Status: Active
Description:

The ESU name used for map display purposes only.

General Data Type: VARCHAR2

MAP_RUN

CC ID: 324208
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: VARCHAR2

ESU_DB_ID

CC ID: 324209
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Foreign key to the ESU lookup table.

General Data Type: NUMBER

MAJOR_POPULATION_GROUP

CC ID: 324210
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: 324211
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: 324212
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

PUB_POP_ID

CC ID: 324213
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: NUMBER

SPECIES_DEFINITION_DB_ID

CC ID: 324214
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: NUMBER

GENUS

CC ID: 324215
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: 324216
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: 324217
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: 324218
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: 324219
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: NUMBER

END_YEAR

CC ID: 324220
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

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

General Data Type: NUMBER

BROOD_YEAR

CC ID: 324221
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: 324222
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: 324223
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: 324224
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: 324225
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: 324226
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: 324227
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: 324228
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: 324229
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: 324230
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: 324231
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: 324232
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: 324233
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: 324234
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: 324235
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: 324236
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: 324237
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: 324238
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: 324239
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: 324240
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: 324241
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: 324242
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: 324243
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: 324244
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: 324245
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: 324246
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: 324247
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

POPULATION_DB_ID

CC ID: 324248
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

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.

General Data Type: NUMBER

TOTAL_SPAWNERS_WITH_JACKS

CC ID: 324249
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: 324250
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: 324251
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: 324252
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: 324253
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: 324254
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: 324255
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: 324256
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: 324257
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: 324258
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: 324259
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: 324260
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

Catalog Details

Catalog Item ID: 32695
GUID: gov.noaa.nmfs.inport:32695
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2016-05-09 14:19+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-11
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-11
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-11