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 Cooperative Research Study Fleet (SF)... >

Table: SF_BIOSAMP_LENGTH_FREQ

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

Summary

Abstract

Biosample length frequency data

Description

Biosample length frequency data

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
DISPOSITION_CODE
VARCHAR2 		ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS
SPECIES_ITIS
VARCHAR2 		Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES
LENGTH_CM
NUMBER 		Length in centimeters
COUNT
NUMBER 		Number of individuals at length
LENGTH_TYPE
VARCHAR2 		Type of length measurement used; supporting table NERS.SF_BIOSAMP_LENGHT_TYPES
RECORDER
VARCHAR2 		Staff member who collected sample
STAT_AREA
VARCHAR2 		Statistical area where sampling occurred; support table NERS.FVTR_FISHING_AREAS
START_HAUL_DATE_GMT
DATE 		Start haul date in Greenwich Mean Time
SEX_CODE
NUMBER 		Species sex type; support table NERS.SF_BIOSAMP_SEX_CODES
COMMENTS
VARCHAR2 		Additional information

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

Biosample length frequency data
Notes:

Loaded by batch 9250, 09-01-2016 14:18

Entity Information

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

Biosample length frequency data

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 DISPOSITION_CODE VARCHAR2 ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS
100
 Primary Key SPECIES_ITIS VARCHAR2 Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES
100
 Primary Key LENGTH_CM NUMBER Length in centimeters
100
 COUNT NUMBER Number of individuals at length
100
 LENGTH_TYPE VARCHAR2 Type of length measurement used; supporting table NERS.SF_BIOSAMP_LENGHT_TYPES
100
 RECORDER VARCHAR2 Staff member who collected sample
100
 STAT_AREA VARCHAR2 Statistical area where sampling occurred; support table NERS.FVTR_FISHING_AREAS
100
 START_HAUL_DATE_GMT DATE Start haul date in Greenwich Mean Time
100
 Primary Key SEX_CODE NUMBER Species sex type; support table NERS.SF_BIOSAMP_SEX_CODES
100
 COMMENTS VARCHAR2 Additional information

Attribute Details

TRIP_ID

CC ID: 348158
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: 348161
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

DISPOSITION_CODE

CC ID: 348155
Seq. Order: 3
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

SPECIES_ITIS

CC ID: 348162
Seq. Order: 4
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

LENGTH_CM

CC ID: 348163
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 6
Scale: 1
Status: Active
Description:

Length in centimeters
General Data Type: NUMBER

COUNT

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

Number of individuals at length
General Data Type: NUMBER

LENGTH_TYPE

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

Type of length measurement used; supporting table NERS.SF_BIOSAMP_LENGHT_TYPES
General Data Type: VARCHAR2
Foreign Key Relations:

NERS.SF_BIOSAMP_LENGTH_TYPES

RECORDER

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

Staff member who collected sample
General Data Type: VARCHAR2

STAT_AREA

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

Statistical area where sampling occurred; support table NERS.FVTR_FISHING_AREAS
General Data Type: VARCHAR2

START_HAUL_DATE_GMT

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

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

SEX_CODE

CC ID: 348157
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 38
Status: Active
Description:

Species sex type; support table NERS.SF_BIOSAMP_SEX_CODES
General Data Type: NUMBER
Foreign Key Relations:

NERS.SF_BIOSAMP_SEX_CODES

COMMENTS

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

Additional information
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 34611
GUID: gov.noaa.nmfs.inport:34611
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-09-01 14:18+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