Search Help Show/Hide Menu
Metadata Rubric
67%
4 / 6
View Report
ORR Metadata Library > Environmental Sensitivity Index > Columbia River (Washington/Oregon), 2004 > Columbia River ESI: FISHL (Fish Lines) >

STATUS

Entity (ENT)  |  Office of Response and Restoration (ORR)
GUID: gov.noaa.nmfs.inport:42625  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Data Attributes
Catalog Details

Summary

Abstract

The data table STATUS identifies the species that are listed as threatened or endangered 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.

Entity Information

Data Attribute / Type Description
ELEMENT
VARCHAR 		Major categories of biological data | Description Source: Research Planning, Inc.
SPECIES_ID
NUMBER 		Numeric identifier for each species that is unique within each element and refers to a nationwide master ESI species list maintained at NOAA. | Description Source: Research Planning, Inc.
S
VARCHAR 		State threatened or endangered status | Description Source: Research Planning, Inc.
F
VARCHAR 		Federal threatened or endangered status | Description Source: Research Planning, Inc.
STATE
Unknown 		Two-letter state abbreviation | Description Source: Research Planning, Inc.
S_DATE
VARCHAR 		Publication date of source material used to assign state status values for each species, if used. | Description Source: Research Planning, Inc.
F_DATE
VARCHAR 		Publication date of source material used to assign federal status values for each species, if used. | Description Source: Research Planning, Inc.
EL_SPE
VARCHAR 		Concatenation of ELEMENT and SPECIES_ID. This item links records in the STATUS data table to records in the BIORES, SPECIES, and RUNS_DAT data tables. | Description Source: Research Planning, Inc.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (ORR) for inquiries on this record.

Item Identification

Title: STATUS
Short Name: STATUS
Status: Completed
Abstract:

The data table STATUS identifies the species that are listed as threatened or endangered 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
 ELEMENT VARCHAR Major categories of biological data | Description Source: Research Planning, Inc.
100
 SPECIES_ID NUMBER Numeric identifier for each species that is unique within each element and refers to a nationwide master ESI species list maintained at NOAA. | Description Source: Research Planning, Inc.
100
 S VARCHAR State threatened or endangered status | Description Source: Research Planning, Inc.
100
 F VARCHAR Federal threatened or endangered status | Description Source: Research Planning, Inc.
100
 STATE Unknown Two-letter state abbreviation | Description Source: Research Planning, Inc.
100
 S_DATE VARCHAR Publication date of source material used to assign state status values for each species, if used. | Description Source: Research Planning, Inc.
100
 F_DATE VARCHAR Publication date of source material used to assign federal status values for each species, if used. | Description Source: Research Planning, Inc.
100
 EL_SPE VARCHAR Concatenation of ELEMENT and SPECIES_ID. This item links records in the STATUS data table to records in the BIORES, SPECIES, and RUNS_DAT data tables. | Description Source: Research Planning, Inc.

Attribute Details

ELEMENT

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

Major categories of biological data | Description Source: Research Planning, Inc.
Allowed Values: BIRD: Birds | FISH: Fish | HABITAT: Habitats and Plants | INVERT: Invertebrates | M_MAMMAL: Marine Mammals | REPTILE: Reptiles and Amphibians | T_MAMMAL: Terrestrial Mammals |

SPECIES_ID

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

Numeric identifier for each species that is unique within each element and refers to a nationwide master ESI species list maintained at NOAA. | Description Source: Research Planning, Inc.
Allowed Values: 1 - N

S

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

State threatened or endangered status | Description Source: Research Planning, Inc.
Allowed Values: E: Endangered on state list | T: Threatened on state list | C: Species of Special Concern | *: Refer to the table RUNS_DAT for threatened or endangered status. |

F

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

Federal threatened or endangered status | Description Source: Research Planning, Inc.
Allowed Values: E: Endangered on federal list | T: Threatened on federal list | C: Species of Special Concern | *: Refer to the table RUNS_DAT for threatened or endangered status. |

STATE

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

Two-letter state abbreviation | Description Source: Research Planning, Inc.
Allowed Values: Acceptable values change from atlas to atlas

S_DATE

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

Publication date of source material used to assign state status values for each species, if used. | Description Source: Research Planning, Inc.
Allowed Values: YYYYMM: YYYY for year and optionally MM for month |

F_DATE

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

Publication date of source material used to assign federal status values for each species, if used. | Description Source: Research Planning, Inc.
Allowed Values: YYYYMM: YYYY for year and optionally MM for month |

EL_SPE

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

Concatenation of ELEMENT and SPECIES_ID. This item links records in the STATUS data table to records in the BIORES, SPECIES, and RUNS_DAT data tables. | 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'). |

Catalog Details

Catalog Item ID: 42625
GUID: gov.noaa.nmfs.inport:42625
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: 2022-08-09 17:11+0000
Metadata Record Published: 2017-08-07
Owner Org: ORR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-08-07
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-08-07