Metadata Rubric

67%

4 / 6

ORR Metadata Library > Environmental Sensitivity Index > Bristol Bay, 2004 > Bristol Bay, Alaska Subarea ESI: NESTS (Nest Po... >

STATUS

Entity (ENT) | Office of Response and Restoration (ORR)
GUID: gov.noaa.nmfs.inport:42486 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Data Attributes

Catalog Details

Abstract

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

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.
STATE VARCHAR	Two-letter state abbreviation \| Description Source: Research Planning, Inc.
COUNTRY VARCHAR	Two-letter country abbreviation \| 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.
I VARCHAR	International threatened or endangered status \| 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.
I_DATE VARCHAR	Publication date of source material used to assign international status values for each species, if used. \| Description Source: Research Planning, Inc.
EL_SPE VARCHAR	Concatenation of ELEMENT and SPECIES_ID. This item links the STATUS data table to the BIORES and SPECIES data tables. \| Description Source: Research Planning, Inc.

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.

STATE
VARCHAR

Two-letter state abbreviation | Description Source: Research Planning, Inc.

COUNTRY
VARCHAR

Two-letter country abbreviation | 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.

I
VARCHAR

International threatened or endangered status | 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.

I_DATE
VARCHAR

Publication date of source material used to assign international status values for each species, if used. | Description Source: Research Planning, Inc.

EL_SPE
VARCHAR

Concatenation of ELEMENT and SPECIES_ID. This item links the STATUS data table to the BIORES and SPECIES data tables. | Description Source: Research Planning, Inc.

No Child Items for this record.

No contact information is available for this record.

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

Title:	STATUS
Short Name:	STATUS
Status:	Completed
Abstract:	The data table STATUS identifies the species that are listed as either 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.

Attribute Summary

	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	STATE	VARCHAR	Two-letter state abbreviation \| Description Source: Research Planning, Inc.
100	COUNTRY	VARCHAR	Two-letter country abbreviation \| 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	I	VARCHAR	International threatened or endangered status \| 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	I_DATE	VARCHAR	Publication date of source material used to assign international 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 the STATUS data table to the BIORES and SPECIES data tables. \| Description Source: Research Planning, Inc.

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

STATE

VARCHAR

Two-letter state abbreviation | Description Source: Research Planning, Inc.

100

COUNTRY

VARCHAR

Two-letter country abbreviation | Description Source: Research Planning, Inc.

100

VARCHAR

State threatened or endangered status | Description Source: Research Planning, Inc.

100

VARCHAR

Federal threatened or endangered status | Description Source: Research Planning, Inc.

100

VARCHAR

International threatened or endangered status | 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

I_DATE

VARCHAR

Publication date of source material used to assign international 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 the STATUS data table to the BIORES and SPECIES data tables. | Description Source: Research Planning, Inc.

Attribute Details

ELEMENT

CC ID: 540304

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: 540305

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

STATE

CC ID: 540306

Seq. Order:	3
Data Storage Type:	VARCHAR
Required:	No
Primary Key:	No
Status:	Active
Description:	Two-letter state abbreviation \| Description Source: Research Planning, Inc.
Allowed Values:	Any character: Two-letter state abbreviation \|

COUNTRY

CC ID: 540307

Seq. Order:	4
Data Storage Type:	VARCHAR
Required:	No
Primary Key:	No
Status:	Active
Description:	Two-letter country abbreviation \| Description Source: Research Planning, Inc.
Allowed Values:	Any character: Two-letter country abbreviation \|

S

CC ID: 540308

Seq. Order:	5
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 \|

F

CC ID: 540309

Seq. Order:	6
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 \|

I

CC ID: 540310

Seq. Order:	7
Data Storage Type:	VARCHAR
Required:	No
Primary Key:	No
Status:	Active
Description:	International threatened or endangered status \| Description Source: Research Planning, Inc.
Allowed Values:	E: Endangered on international list \| T: Threatened on international list \| C: Species of Special Concern \|

S_DATE

CC ID: 540311

Seq. Order:	8
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:	Numeric: mmyyyy \|

F_DATE

CC ID: 540312

Seq. Order:	9
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:	Numeric: mmyyyy \|

I_DATE

CC ID: 540313

Seq. Order:	10
Data Storage Type:	VARCHAR
Required:	No
Primary Key:	No
Status:	Active
Description:	Publication date of source material used to assign international status values for each species, if used. \| Description Source: Research Planning, Inc.
Allowed Values:	Numeric: mmyyyy \|

EL_SPE

CC ID: 540314

Seq. Order:	11
Data Storage Type:	VARCHAR
Required:	No
Primary Key:	No
Status:	Active
Description:	Concatenation of ELEMENT and SPECIES_ID. This item links the STATUS data table to the BIORES and SPECIES 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 (eg. ELEMENT = 'BIRD' and SPECIES_ID = 1; EL_SPE = 'B00001'). \|

Catalog Item ID:	42486
GUID:	gov.noaa.nmfs.inport:42486
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

STATUS

Summary

Entity Information

Child Items

Contact Information

Item Identification

Data Attributes

Attribute Summary

Attribute Details

ELEMENT

SPECIES_ID

STATE

COUNTRY

S

F

I

S_DATE

F_DATE

I_DATE

EL_SPE

Catalog Details