Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Resource Evaluation and Assessment Division > Protected Species Branch > Impacts and Analysis > SAR data >

Table: SAR_BYCATCH

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:36742  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Bycatch data from observed fisheries

Description

Bycatch data from observed fisheries

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ID
NUMBER 		unique record identifier
SPECIES
NUMBER 		numeric species code
FISHERY
VARCHAR2 		fishery code
YEAR
NUMBER 		year
M_OBSERVED
NUMBER 		observed mortality in number of animals
M_ESTIMATED
NUMBER 		estimated mortality in number of animals
CV
NUMBER 		coefficient of variation of mortality estimate
DOE
DATE 		date of record entry
UOE
VARCHAR2 		user of record entry
COMMENTS
VARCHAR2 		notes
METHODOLOGY
VARCHAR2 		short description of etimation technique
CITATION
VARCHAR2 		reference to use
USETHISONE
VARCHAR2 		unused
SI_OBSERVED
NUMBER 		serious injuries observed in number of animals
SI_ESTIMATED
NUMBER 		serious injuries estimated in number of animals
SIANDM_ESTIMATED
NUMBER 		sum of Si estimated and M estimated
REPORT_ID
NUMBER 		id from sar_reportist
REPORTTEXT
VARCHAR2 		text to put in SAR section

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: Table: SAR_BYCATCH
Short Name: SAR_BYCATCH
Status: Completed
Abstract:

Bycatch data from observed fisheries

Entity Information

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

Bycatch data from observed fisheries

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 ID NUMBER unique record identifier
100
 SPECIES NUMBER numeric species code
100
 FISHERY VARCHAR2 fishery code
100
 YEAR NUMBER year
100
 M_OBSERVED NUMBER observed mortality in number of animals
100
 M_ESTIMATED NUMBER estimated mortality in number of animals
100
 CV NUMBER coefficient of variation of mortality estimate
100
 DOE DATE date of record entry
100
 UOE VARCHAR2 user of record entry
100
 COMMENTS VARCHAR2 notes
100
 METHODOLOGY VARCHAR2 short description of etimation technique
100
 CITATION VARCHAR2 reference to use
100
 USETHISONE VARCHAR2 unused
100
 SI_OBSERVED NUMBER serious injuries observed in number of animals
100
 SI_ESTIMATED NUMBER serious injuries estimated in number of animals
100
 SIANDM_ESTIMATED NUMBER sum of Si estimated and M estimated
100
 REPORT_ID NUMBER id from sar_reportist
100
 REPORTTEXT VARCHAR2 text to put in SAR section

Attribute Details

ID

CC ID: 380380
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

unique record identifier
General Data Type: NUMBER

SPECIES

CC ID: 380381
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

numeric species code
General Data Type: NUMBER

FISHERY

CC ID: 380382
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

fishery code
General Data Type: VARCHAR2

YEAR

CC ID: 380383
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

year
General Data Type: NUMBER

M_OBSERVED

CC ID: 380384
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

observed mortality in number of animals
General Data Type: NUMBER

M_ESTIMATED

CC ID: 380385
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

estimated mortality in number of animals
General Data Type: NUMBER

CV

CC ID: 380386
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

coefficient of variation of mortality estimate
General Data Type: NUMBER

DOE

CC ID: 380387
Seq. Order: 8
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

date of record entry
General Data Type: DATE

UOE

CC ID: 380388
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

user of record entry
General Data Type: VARCHAR2

COMMENTS

CC ID: 380389
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 120
Required: No
Primary Key: No
Status: Active
Description:

notes
General Data Type: VARCHAR2

METHODOLOGY

CC ID: 380390
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 120
Required: No
Primary Key: No
Status: Active
Description:

short description of etimation technique
General Data Type: VARCHAR2

CITATION

CC ID: 380391
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 120
Required: No
Primary Key: No
Status: Active
Description:

reference to use
General Data Type: VARCHAR2

USETHISONE

CC ID: 380392
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

unused
General Data Type: VARCHAR2

SI_OBSERVED

CC ID: 380393
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

serious injuries observed in number of animals
General Data Type: NUMBER

SI_ESTIMATED

CC ID: 380394
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

serious injuries estimated in number of animals
General Data Type: NUMBER

SIANDM_ESTIMATED

CC ID: 380395
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

sum of Si estimated and M estimated
General Data Type: NUMBER

REPORT_ID

CC ID: 380396
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

id from sar_reportist
General Data Type: NUMBER

REPORTTEXT

CC ID: 380397
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

text to put in SAR section
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 36742
GUID: gov.noaa.nmfs.inport:36742
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2017-02-10 15:05+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-02-10
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-02-10
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-02-10