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_REPORTTEXT

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

Summary

Abstract

Table of text choices

Description

Table of text choices

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TEXTID
NUMBER 		unique record identifier
REPORTID
NUMBER 		link to SAR_REPORTLIST id
STOCKDEF1
VARCHAR2 		text for stock definition section
POPNSIZE
VARCHAR2 		text for population size section
NMIN
VARCHAR2 		text for abundance estimate minimum section
TREND
VARCHAR2 		text for trend section
PRODUCTIVITY
VARCHAR2 		text for productivity section
PBR
VARCHAR2 		text for PBR section
DOE
DATE 		date of record entry
UOE
VARCHAR2 		user of record entry
STATUSOFSTOCK
VARCHAR2 		text for status of stock 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_REPORTTEXT
Short Name: SAR_REPORTTEXT
Status: Completed
Abstract:

Table of text choices

Entity Information

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

Table of text choices

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 TEXTID NUMBER unique record identifier
100
 REPORTID NUMBER link to SAR_REPORTLIST id
100
 STOCKDEF1 VARCHAR2 text for stock definition section
100
 POPNSIZE VARCHAR2 text for population size section
100
 NMIN VARCHAR2 text for abundance estimate minimum section
100
 TREND VARCHAR2 text for trend section
100
 PRODUCTIVITY VARCHAR2 text for productivity section
100
 PBR VARCHAR2 text for PBR section
100
 DOE DATE date of record entry
100
 UOE VARCHAR2 user of record entry
100
 STATUSOFSTOCK VARCHAR2 text for status of stock section

Attribute Details

TEXTID

CC ID: 380441
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

REPORTID

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

link to SAR_REPORTLIST id
General Data Type: NUMBER

STOCKDEF1

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

text for stock definition section
General Data Type: VARCHAR2

POPNSIZE

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

text for population size section
General Data Type: VARCHAR2

NMIN

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

text for abundance estimate minimum section
General Data Type: VARCHAR2

TREND

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

text for trend section
General Data Type: VARCHAR2

PRODUCTIVITY

CC ID: 380447
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 2000
Required: No
Primary Key: No
Status: Active
Description:

text for productivity section
General Data Type: VARCHAR2

PBR

CC ID: 380448
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 2000
Required: No
Primary Key: No
Status: Active
Description:

text for PBR section
General Data Type: VARCHAR2

DOE

CC ID: 380449
Seq. Order: 9
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: 380450
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

user of record entry
General Data Type: VARCHAR2

STATUSOFSTOCK

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

text for status of stock section
General Data Type: VARCHAR2

Catalog Details

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