Search Help Show/Hide Menu
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