32702 SALMON_POPULATION_DETAILS Entity Published / External 17904 SPS Abundance - Salmon spawner abundance data compilation and database management Data Set Planned This table stores annual information for a salmonid population. Data Table Yes SPS This table stores annual information for a salmonid population. ABUND_COUNT_EXTERNAL_FILE_1_LI VARCHAR2 500 No No Active A web-link to any pertinent external document that relates to this population and year. VARCHAR2 TOTAL_SPAWNERS_WITH_JACKS NUMBER 22 No No 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 ADULT_BROOD_RETURNS NUMBER 22 No No 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 22 No No 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 22 No No Active Proportion of catch composed of age-1 fish. Deprecated. NUMBER AGE_1_RETURNS NUMBER 22 No No 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 22 No No Active Proportion of catch composed of age-2 fish. Deprecated. NUMBER AGE_2_RETURNS NUMBER 22 No No 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 22 No No Active Proportion of catch composed of age-3 fish. Deprecated. NUMBER AGE_3_RETURNS NUMBER 22 No No 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 22 No No Active Proportion of catch composed of age-4 fish. Deprecated. NUMBER AGE_4_RETURNS NUMBER 22 No No 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 22 No No Active Proportion of catch composed of age-5 fish. Deprecated. NUMBER AGE_5_RETURNS NUMBER 22 No No 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 22 No No Active Proportion of catch composed of age-6 fish. Deprecated. NUMBER AGE_6_RETURNS NUMBER 22 No No 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 22 No No Active Proportion of catch composed of age-7 fish. Deprecated. NUMBER AGE_7_RETURNS NUMBER 22 No No 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 No No 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 22 No No Active Number of samples used in age structure determination. NUMBER AGE_NOTES VARCHAR2 4000 No No Active Comments or other information giving further description of the population's age or age-structure. VARCHAR2 BROOD_YEAR NUMBER 22 No No Active The year that adults enter to the river to spawn. NUMBER CONTACT_AGENCY VARCHAR2 200 No No 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 EFFECTIVE_CATCH NUMBER 22 No No 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 FRACWILD NUMBER 22 No No Active The fraction of the total spawners that are the progeny of naturally-spawning fish. NUMBER HATCHERY_FRACTION NUMBER 22 No No 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 No No Active Comments or other information about the observed or estimated Hatchery fraction of the fish in this viability computation. VARCHAR2 HATCHERY_RETURN NUMBER 22 No No 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 22 No No 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 NATURAL_ADULT_ANNUAL_RUN_4_6 NUMBER 22 No No Active Estimated number of adult spawners of natural origin in a particular year. NUMBER NATURAL_SPAWNERS_WITH_JACKS NUMBER 22 No No 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 22 No No Active Fish of natural origin removed from the returning run for use as hatchery broodstock. NUMBER NUMBER_OF_SPAWNERS NUMBER 22 No No Active The total number of fish returning to spawn in the data collection year. NUMBER POPULATION_DB_ID NUMBER 22 Yes No Active Foreign key to the SALMON_POPULATION_GROUPS table to link SALMON_POPULATION_DETAILS records to a specific POPULATION_DB_ID using the SP_PKX primary key. This foreign key constraint is named SPG_SPD_FK. NUMBER POP_DETAIL_DB_ID NUMBER 22 Yes Yes Active Database-generated primary key (unique identifier) for each SALMON_POPULATION_DETAILS 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 SALMON_POPULATION_DETAILS_PK. NUMBER RECORD_APPROVED_BY_PERSON VARCHAR2 40 No No 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 7 No No Active If there is a certification process for these records, date that the particular record was approved or officially certified. DATE RECORD_CHANGE_COMMENT VARCHAR2 4000 No No 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. VARCHAR2 RECORD_COMPUTER_LOAD_BY_USER VARCHAR2 40 Yes No 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) 11 Yes No 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 40 No No 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 DATE 7 No No Active The date, or approximate date, that the person with content knowledge originated this record PRIOR to its being entered into the database. DATE RECORD_EFFECTIVE_DATE DATE 7 No No 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 7 No No 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 No No 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 No No 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 40 No No 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) 11 No No 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 22 No No 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 1 No No 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 100 No No 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 REGIME NUMBER 22 No No 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 50 No No Active The Season of the Year represented by this viability figure for the population. VARCHAR2 SAR_ADJUSTED_ADULT_BRD_RETURNS NUMBER 22 No No 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 No No Active Comments or other helpful information about the observation of spawners in this viability computation. VARCHAR2 TOTAL_SPAWNERS_WITHOUT_JACKS NUMBER 22 No No 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 ABUND_COUNT_EXTERNAL_FILE_2_LI VARCHAR2 500 No No Active A web-link to a second pertinent external document that relates to this population and year. VARCHAR2 gov.noaa.nmfs.inport:32702 Jeffrey Cowen 2016-05-09T14:19:57 SysAdmin InPortAdmin 2022-08-09T17:11:00 2016-05-11 Northwest Fisheries Science Center NWFSC 2725 Montlake Boulevard East Seattle WA 98112 USA 206-860-3200 https://www.nwfsc.noaa.gov 1001 Public No 2016-05-11 1 Year 2017-05-11