Slide Menu
Search Help Show/Hide Menu

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