Slide Menu
Search Help Show/Hide Menu

Item Identification

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

stock by year with PBR, status, total mortality and whether updated

Entity Information

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

stock by year with PBR, status, total mortality and whether updated

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
REPORTID NUMBER link to SAR_REPORTLIST id
100
YEAR NUMBER year of SAR
100
PBR NUMBER Potential Biological Removal
100
TOTAL_M NUMBER Total average annual mortality
100
STRATEGIC VARCHAR2 stock status is strategic Y or N
100
UPDATED VARCHAR2 report was updated Y or N

Attribute Details

REPORTID

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

link to SAR_REPORTLIST id

General Data Type: NUMBER

YEAR

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

year of SAR

General Data Type: NUMBER

PBR

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

Potential Biological Removal

General Data Type: NUMBER

TOTAL_M

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

Total average annual mortality

General Data Type: NUMBER

STRATEGIC

CC ID: 380431
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

stock status is strategic Y or N

General Data Type: VARCHAR2

UPDATED

CC ID: 380432
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

report was updated Y or N

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 36748
GUID: gov.noaa.nmfs.inport:36748
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2017-02-10 15:06+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