Slide Menu
Jump to Section...
Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
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 

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