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_REQUEST_SAMPLES

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

Summary

Abstract

Data collected for biosample requests

Description

Data collected for biosample requests

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SBR_REQUEST_ID
VARCHAR2 		Unique biosample request identification number
PROGRAM_CODE
NUMBER 		Biosample program project code;supporting table NERS.SF_BIOSAMP_PROGRAM_CODES
TOTE_ID
VARCHAR2 		Tote identifier where sample was stored
TRANSFER_BIN
VARCHAR2 		Bin identifier sample was transported in
ELB_EFFORT_NUM
VARCHAR2 		Trip effort number where sample was collected
SPECIES_ITIS
VARCHAR2 		Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES
MARKET_CODE
VARCHAR2 		ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES
GRADE_CODE
VARCHAR2 		ACCSP grade code description of fish products cut or part; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES
DISPOSITION_CODE
VARCHAR2 		ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS
WEIGHT_LBS
NUMBER 		Weight of sample in pounds
WEIGHT_TYPE
VARCHAR2 		Method used to weight sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES
MARKET_PRICE_LB
NUMBER 		Price paid per pound for sample
COMMENTS
VARCHAR2 		Additional information
SF_SAMPLE_COLLECTOR
VARCHAR2 		Staff member who collected sample
UOE
VARCHAR2 		Staff member who issued BSR request
DOE
DATE 		Date of entry into database
CATCH_TYPE_CODE
NUMBER 		The allowed ways to which the catch can be retained for research; support table NERS.SF_BIOSAMP_CATCH_TYPES
SAMPLE_COUNT
NUMBER 		Number of individuals purchased in sample

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

Data collected for biosample requests
Notes:

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

Entity Information

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

Data collected for biosample requests

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key SBR_REQUEST_ID VARCHAR2 Unique biosample request identification number
100
 Primary Key PROGRAM_CODE NUMBER Biosample program project code;supporting table NERS.SF_BIOSAMP_PROGRAM_CODES
100
 Primary Key TOTE_ID VARCHAR2 Tote identifier where sample was stored
100
 TRANSFER_BIN VARCHAR2 Bin identifier sample was transported in
100
 ELB_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 MARKET_CODE VARCHAR2 ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES
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 DISPOSITION_CODE VARCHAR2 ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS
100
 WEIGHT_LBS NUMBER Weight of sample in pounds
100
 WEIGHT_TYPE VARCHAR2 Method used to weight sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES
100
 MARKET_PRICE_LB NUMBER Price paid per pound for sample
100
 COMMENTS VARCHAR2 Additional information
100
 SF_SAMPLE_COLLECTOR VARCHAR2 Staff member who collected sample
100
 UOE VARCHAR2 Staff member who issued BSR request
100
 DOE DATE Date of entry into database
100
 Primary Key CATCH_TYPE_CODE NUMBER The allowed ways to which the catch can be retained for research; support table NERS.SF_BIOSAMP_CATCH_TYPES
100
 SAMPLE_COUNT NUMBER Number of individuals purchased in sample

Attribute Details

SBR_REQUEST_ID

CC ID: 347987
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 15
Required: Yes
Primary Key: Yes
Status: Active
Description:

Unique biosample request identification number
General Data Type: VARCHAR2

PROGRAM_CODE

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

Biosample program project code;supporting table NERS.SF_BIOSAMP_PROGRAM_CODES
General Data Type: NUMBER

TOTE_ID

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

Tote identifier where sample was stored
General Data Type: VARCHAR2

TRANSFER_BIN

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

Bin identifier sample was transported in
General Data Type: VARCHAR2

ELB_EFFORT_NUM

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

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

SPECIES_ITIS

CC ID: 348001
Seq. Order: 6
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

MARKET_CODE

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

GRADE_CODE

CC ID: 348003
Seq. Order: 8
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

DISPOSITION_CODE

CC ID: 348004
Seq. Order: 9
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

WEIGHT_LBS

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

Weight of sample in pounds
General Data Type: NUMBER

WEIGHT_TYPE

CC ID: 347989
Seq. Order: 11
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

MARKET_PRICE_LB

CC ID: 347990
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 7
Scale: 2
Status: Active
Description:

Price paid per pound for sample
General Data Type: NUMBER

COMMENTS

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

Additional information
General Data Type: VARCHAR2

SF_SAMPLE_COLLECTOR

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

Staff member who collected sample
General Data Type: VARCHAR2

UOE

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

Staff member who issued BSR request
General Data Type: VARCHAR2

DOE

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

Date of entry into database
General Data Type: DATE

CATCH_TYPE_CODE

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

The allowed ways to which the catch can be retained for research; support table NERS.SF_BIOSAMP_CATCH_TYPES
General Data Type: NUMBER

SAMPLE_COUNT

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

Number of individuals purchased in sample
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 34591
GUID: gov.noaa.nmfs.inport:34591
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