Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: RUNS_DAT
Short Name: RUNS_DAT
Status: Completed
Abstract:

The data table RUNS_DAT identifies anadromous fish runs that are listed as threatened, endangered, sensitive-critical, or candidate by a state or federal authority. See the Browse_Graphic section for a link to the entity-relationship diagram, which describes the way this table relates to other attribute tables in the ESI data structure. | Description Source: Research Planning, Inc.

Notes:

Converted from FGDC using 'fgdc_to_inport_xml_entity.pl' script.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
EL_SPE VARCHAR Concatenation of ELEMENT and SPECIES_ID. This item links records in the RUNS_DAT table to records in the STATUS table. | Description Source: Research Planning, Inc.
100
SPECIES Unknown Species common name. This field may also include the season in which the species is running [for example, "Chinook Salmon (Spring)"]. | Description Source: Research Planning, Inc.
100
RUN Unknown Location of the run in which the species is listed as threatened, endangered, sensitive-critical, or a candidate. | Description Source: Research Planning, Inc.
100
OR VARCHAR Threatened or endangered status for the state of Oregon. | Description Source: Research Planning, Inc.
100
WA VARCHAR Threatened or endangered status for the state of Washington | Description Source: Research Planning, Inc.
100
FEDERAL VARCHAR Threatened or endangered status for the Federal Endangered Species Act | Description Source: Research Planning, Inc.
100
ESA_YEAR VARCHAR Year the species was listed by the Federal Endangered Species Act. | Description Source: Research Planning, Inc.

Attribute Details

EL_SPE

CC ID: 541231
Seq. Order: 1
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Concatenation of ELEMENT and SPECIES_ID. This item links records in the RUNS_DAT table to records in the STATUS table. | Description Source: Research Planning, Inc.

Allowed Values: E#####: Where E is the first character of ELEMENT and the next five characters are SPECIES_ID (e.g. ELEMENT = 'BIRD' and SPECIES_ID = 1; EL_SPE = 'B00001'). |

SPECIES

CC ID: 541232
Seq. Order: 2
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Species common name. This field may also include the season in which the species is running [for example, "Chinook Salmon (Spring)"]. | Description Source: Research Planning, Inc.

Allowed Values: Acceptable values change from atlas to atlas

RUN

CC ID: 541233
Seq. Order: 3
Data Storage Type: Unknown
Required: No
Primary Key: No
Status: Active
Description:

Location of the run in which the species is listed as threatened, endangered, sensitive-critical, or a candidate. | Description Source: Research Planning, Inc.

Allowed Values: Acceptable values change from atlas to atlas

OR

CC ID: 541234
Seq. Order: 4
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Threatened or endangered status for the state of Oregon. | Description Source: Research Planning, Inc.

Allowed Values: E: Listed as endangered by the state of Oregon | T: Listed as threatened by the state of Oregon | S-C: Listed as a sensitive-critical species by the state of Oregon | NL: Not listed by the state of Oregon |

WA

CC ID: 541235
Seq. Order: 5
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Threatened or endangered status for the state of Washington | Description Source: Research Planning, Inc.

Allowed Values: Cand.: Listed as candidate species by the state of Washington | NL: Not listed by the state of Washington |

FEDERAL

CC ID: 541236
Seq. Order: 6
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Threatened or endangered status for the Federal Endangered Species Act | Description Source: Research Planning, Inc.

Allowed Values: E: Listed as endangered by the Federal Endangered Species Act | T: Listed as threatened by the Federal Endangered Species Act | Cand.: Listed as candidate species by the Federal Endangered Species Act | NL: Not listed by the Federal Endangered Species Act |

ESA_YEAR

CC ID: 541237
Seq. Order: 7
Data Storage Type: VARCHAR
Required: No
Primary Key: No
Status: Active
Description:

Year the species was listed by the Federal Endangered Species Act. | Description Source: Research Planning, Inc.

Allowed Values: YYYYMM: YYYY for year and optionally MM for month | 0: Species is not federally ranked |

Catalog Details

Catalog Item ID: 42617
GUID: gov.noaa.nmfs.inport:42617
Metadata Record Created By: Tyler Christensen
Metadata Record Created: 2017-04-06 11:28+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2017-08-07
Owner Org: ORR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year