Table: SF_BIOSAMP_BIOSAMPLE
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34578 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Biosample data
DescriptionBiosample data
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
TRIP_ID
NUMBER |
Unique trip identifier generated in FLDRS software |
EFFORT_NUM
VARCHAR2 |
Trip effort Number where sample was collected |
START_HAUL_DATE_GMT
DATE |
Start of haul date in Greenwich Mean Time |
STAT_AREA_CODE
VARCHAR2 |
Statistical area where sampling occurred; support table NERS.FVTR_FISHING_AREAS |
FISH_ID
NUMBER |
Individual fish ID for sample |
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 |
LENGTH_TYPE
VARCHAR2 |
Type of length collected; support table NERS.SF_BIOSAMP_LENGTH_TYPES |
LENGTH_CM
NUMBER |
Length in centimeters |
WEIGHT_TYPE
VARCHAR2 |
Method used to weight sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES |
WEIGHT_KG
NUMBER |
Weight in kilograms |
SEX_CODE
NUMBER |
Species sex type; support table NERS.SF_BIOSAMP_SEX_CODES |
MATURITY_CODE
VARCHAR2 |
Reproductive maturity of species; support table NERS.SF_BIOSAMP_MATURITY_CODES |
AGE_SAMPLE_TYPE
VARCHAR2 |
Type of age sample collected; support table NERS_BIOSAMP_AGE_TYPES |
COMMENTS
VARCHAR2 |
Additional information |
RECORDER
VARCHAR2 |
Staff member who collected 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_BIOSAMPLE |
---|---|
Short Name: | SF_BIOSAMP_BIOSAMPLE |
Status: | Completed |
Abstract: |
Biosample data |
Notes: |
Loaded by batch 9249, 09-01-2016 13:11 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NERS |
Description: |
Biosample data |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
TRIP_ID | NUMBER | Unique trip identifier generated in FLDRS software | |
100
|
EFFORT_NUM | VARCHAR2 | Trip effort Number where sample was collected | |
100
|
START_HAUL_DATE_GMT | DATE | Start of haul date in Greenwich Mean Time | |
100
|
STAT_AREA_CODE | VARCHAR2 | Statistical area where sampling occurred; support table NERS.FVTR_FISHING_AREAS | |
100
|
FISH_ID | NUMBER | Individual fish ID for sample | |
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
|
LENGTH_TYPE | VARCHAR2 | Type of length collected; support table NERS.SF_BIOSAMP_LENGTH_TYPES | |
100
|
LENGTH_CM | NUMBER | Length in centimeters | |
100
|
WEIGHT_TYPE | VARCHAR2 | Method used to weight sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES | |
100
|
WEIGHT_KG | NUMBER | Weight in kilograms | |
100
|
SEX_CODE | NUMBER | Species sex type; support table NERS.SF_BIOSAMP_SEX_CODES | |
100
|
MATURITY_CODE | VARCHAR2 | Reproductive maturity of species; support table NERS.SF_BIOSAMP_MATURITY_CODES | |
100
|
AGE_SAMPLE_TYPE | VARCHAR2 | Type of age sample collected; support table NERS_BIOSAMP_AGE_TYPES | |
100
|
COMMENTS | VARCHAR2 | Additional information | |
100
|
RECORDER | VARCHAR2 | Staff member who collected sample |
Attribute Details
TRIP_ID
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 |
EFFORT_NUM
Seq. Order: | 2 |
---|---|
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 |
START_HAUL_DATE_GMT
Seq. Order: | 3 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Start of haul date in Greenwich Mean Time |
General Data Type: | DATE |
STAT_AREA_CODE
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Statistical area where sampling occurred; support table NERS.FVTR_FISHING_AREAS |
General Data Type: | VARCHAR2 |
FISH_ID
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Individual fish ID for sample |
General Data Type: | NUMBER |
SPECIES_ITIS
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 11 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES |
General Data Type: | VARCHAR2 |
MARKET_CODE
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | Yes |
Primary Key: | No |
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
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | Yes |
Primary Key: | No |
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
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
NERS.FVTR_DISPOSITIONS |
LENGTH_TYPE
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Type of length collected; support table NERS.SF_BIOSAMP_LENGTH_TYPES |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
NERS.SF_BIOSAMP_LENGTH_TYPES |
LENGTH_CM
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 1 |
Status: | Active |
Description: |
Length in centimeters |
General Data Type: | NUMBER |
WEIGHT_TYPE
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Method used to weight sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
NERS.SF_BIOSAMP_WEIGHT_TYPES |
WEIGHT_KG
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 4 |
Status: | Active |
Description: |
Weight in kilograms |
General Data Type: | NUMBER |
SEX_CODE
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Species sex type; support table NERS.SF_BIOSAMP_SEX_CODES |
General Data Type: | NUMBER |
Foreign Key Relations: |
NERS.SF_BIOSAMP_SEX_CODES |
MATURITY_CODE
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Reproductive maturity of species; support table NERS.SF_BIOSAMP_MATURITY_CODES |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
NERS.SF_BIOSAMP_MATURITY_CODES |
AGE_SAMPLE_TYPE
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Type of age sample collected; support table NERS_BIOSAMP_AGE_TYPES |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
NERS.SF_BIOSAMP_AGE_TYPES |
COMMENTS
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 250 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Additional information |
General Data Type: | VARCHAR2 |
RECORDER
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Staff member who collected sample |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 34578 |
---|---|
GUID: | gov.noaa.nmfs.inport:34578 |
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 |