Table: SF_BIOSAMP_REQUEST_SAMPLES
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34617 | Updated: August 9, 2022 | Published / External
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 9250, 09-01-2016 14:18 |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Schema Name: | NERS |
| Description: |
Data collected for biosample requests |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
SBR_REQUEST_ID | VARCHAR2 | Unique biosample request identification number |
|
100
|
|
PROGRAM_CODE | NUMBER | Biosample program project code;supporting table NERS.SF_BIOSAMP_PROGRAM_CODES |
|
100
|
|
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
|
|
SPECIES_ITIS | VARCHAR2 | Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES |
|
100
|
|
MARKET_CODE | VARCHAR2 | ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES |
|
100
|
|
GRADE_CODE | VARCHAR2 | ACCSP grade code description of fish products cut or part; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES |
|
100
|
|
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
|
|
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: 348197
| 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: 348207
| 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: 348208
| 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: 348209
| 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: 348210
| 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: 348211
| 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: 348212
| 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: 348213
| 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: 348214
| 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: 348198
| 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: 348199
| 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: 348200
| 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: 348201
| 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: 348202
| 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: 348203
| 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: 348204
| 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: 348205
| 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: 348206
| 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: | 34617 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:34617 |
| 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 |