Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Northeast Cooperative Research Program (NCRP) > Northeast Electronic Reporting System (NERS) >

Table: SF_BIOSAMP_CATCH_EST

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

Summary

Abstract

Biosample data for Study Fleet catch estimation project

Description

Biosample data for Study Fleet catch estimation project

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TRIP_ID
NUMBER 		Unique trip identifier generated in FLDRS software
EFFORT_NUM
VARCHAR2 		Trip effort number where sample was collected
SPECIES_ITIS
VARCHAR2 		Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES
GRADE_CODE
VARCHAR2 		ACCSP grade code description of fish products cut or part ; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES
MARKET_CODE
VARCHAR2 		ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES
DISPOSITION_CODE
VARCHAR2 		ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS
UOM
VARCHAR2 		Unit of measurement; supporting table FVTR.FVTR_UNIT_OF_MEASURE
CATCH_AMOUNT
NUMBER 		Estimated catch amount
WEIGHT_TYPE_CODE
VARCHAR2 		Method used to weight sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES
COMMENTS
VARCHAR2 		Additional information
RECORDER
VARCHAR2 		Technician who collected sample
START_HAUL_DATE_GMT
DATE 		Start of haul date in Greenwich Mean Time

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: SF_BIOSAMP_CATCH_EST
Short Name: SF_BIOSAMP_CATCH_EST
Status: Completed
Abstract:

Biosample data for Study Fleet catch estimation project
Notes:

Loaded by batch 9249, 09-01-2016 13:11

Entity Information

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

Biosample data for Study Fleet catch estimation project

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key TRIP_ID NUMBER Unique trip identifier generated in FLDRS software
100
 Primary Key EFFORT_NUM VARCHAR2 Trip effort number where sample was collected
100
 Primary Key SPECIES_ITIS VARCHAR2 Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES
100
 Primary Key GRADE_CODE VARCHAR2 ACCSP grade code description of fish products cut or part ; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES
100
 Primary Key MARKET_CODE VARCHAR2 ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES
100
 Primary Key DISPOSITION_CODE VARCHAR2 ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS
100
 Primary Key UOM VARCHAR2 Unit of measurement; supporting table FVTR.FVTR_UNIT_OF_MEASURE
100
 CATCH_AMOUNT NUMBER Estimated catch amount
100
 WEIGHT_TYPE_CODE VARCHAR2 Method used to weight sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES
100
 COMMENTS VARCHAR2 Additional information
100
 RECORDER VARCHAR2 Technician who collected sample
100
 START_HAUL_DATE_GMT DATE Start of haul date in Greenwich Mean Time

Attribute Details

TRIP_ID

CC ID: 347929
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 14
Scale: 0
Status: Active
Description:

Unique trip identifier generated in FLDRS software
General Data Type: NUMBER

EFFORT_NUM

CC ID: 347933
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 5
Required: Yes
Primary Key: Yes
Status: Active
Description:

Trip effort number where sample was collected
General Data Type: VARCHAR2

SPECIES_ITIS

CC ID: 347934
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 11
Required: Yes
Primary Key: Yes
Status: Active
Description:

Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES
General Data Type: VARCHAR2

GRADE_CODE

CC ID: 347935
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
Primary Key: Yes
Status: Active
Description:

ACCSP grade code description of fish products cut or part ; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES
General Data Type: VARCHAR2

MARKET_CODE

CC ID: 347936
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
Primary Key: Yes
Status: Active
Description:

ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES
General Data Type: VARCHAR2

DISPOSITION_CODE

CC ID: 347927
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 3
Required: Yes
Primary Key: Yes
Status: Active
Description:

ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS
General Data Type: VARCHAR2
Foreign Key Relations:

NERS.FVTR_DISPOSITIONS

UOM

CC ID: 347937
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 2
Required: Yes
Primary Key: Yes
Status: Active
Description:

Unit of measurement; supporting table FVTR.FVTR_UNIT_OF_MEASURE
General Data Type: VARCHAR2

CATCH_AMOUNT

CC ID: 347938
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 9
Scale: 1
Status: Active
Description:

Estimated catch amount
General Data Type: NUMBER

WEIGHT_TYPE_CODE

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

Method used to weight sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES
General Data Type: VARCHAR2
Foreign Key Relations:

NERS.SF_BIOSAMP_WEIGHT_TYPES

COMMENTS

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

Additional information
General Data Type: VARCHAR2

RECORDER

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

Technician who collected sample
General Data Type: VARCHAR2

START_HAUL_DATE_GMT

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

Start of haul date in Greenwich Mean Time
General Data Type: DATE

Catalog Details

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