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_BIOSAMPLE_EXT

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

Summary

Abstract

Specialized data collected on biosamples

Description

Specialized data collected on biosamples

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TRIP_ID
NUMBER 		Unique trip identifier generated in FLDRS software
FISH_ID
NUMBER 		Unique fish identifier per trip
BIOSAMPLE_TYPE
VARCHAR2 		Type of biological sample collected; supporting table NERS.SF_BIOSAMP_BIOSAMP_TYPES
BIOSAMPLE_VALUE
VARCHAR2 		Sample value
BIOSAMPLE_ID
VARCHAR2 		Unique sample identifier
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_BIOSAMPLE_EXT
Short Name: SF_BIOSAMP_BIOSAMPLE_EXT
Status: Completed
Abstract:

Specialized data collected on biosamples
Notes:

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

Entity Information

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

Specialized data collected on biosamples

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 FISH_ID NUMBER Unique fish identifier per trip
100
 Primary Key BIOSAMPLE_TYPE VARCHAR2 Type of biological sample collected; supporting table NERS.SF_BIOSAMP_BIOSAMP_TYPES
100
 BIOSAMPLE_VALUE VARCHAR2 Sample value
100
 Primary Key BIOSAMPLE_ID VARCHAR2 Unique sample identifier
100
 COMMENTS VARCHAR2 Additional information

Attribute Details

TRIP_ID

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

FISH_ID

CC ID: 347916
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 3
Scale: 0
Status: Active
Description:

Unique fish identifier per trip
General Data Type: NUMBER

BIOSAMPLE_TYPE

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

Type of biological sample collected; supporting table NERS.SF_BIOSAMP_BIOSAMP_TYPES
General Data Type: VARCHAR2
Foreign Key Relations:

NERS.SF_BIOSAMP_BIOSAMPLE_TYPE

BIOSAMPLE_VALUE

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

Sample value
General Data Type: VARCHAR2

BIOSAMPLE_ID

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

Unique sample identifier
General Data Type: VARCHAR2

COMMENTS

CC ID: 347919
Seq. Order: 6
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: 34580
GUID: gov.noaa.nmfs.inport:34580
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