Table: SF_BIOSAMP_CATCH_EST
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34608 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Biosample data for Study Fleet catch estimation project
DescriptionBiosample data for Study Fleet catch estimation project
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 |
SPECIES_ITIS
VARCHAR2 |
Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES |
GRADE_CODE
VARCHAR2 |
ACCSP grade code description of fish products cut or part ; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES |
MARKET_CODE
VARCHAR2 |
ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES |
DISPOSITION_CODE
VARCHAR2 |
ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS |
UOM
VARCHAR2 |
Unit of measurement; supporting table FVTR.FVTR_UNIT_OF_MEASURE |
CATCH_AMOUNT
NUMBER |
Estimated catch amount |
WEIGHT_TYPE_CODE
VARCHAR2 |
Method used to weight sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES |
COMMENTS
VARCHAR2 |
Additional information |
RECORDER
VARCHAR2 |
Technician who collected sample |
START_HAUL_DATE_GMT
DATE |
Start of haul date in Greenwich Mean Time |
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_CATCH_EST |
---|---|
Short Name: | SF_BIOSAMP_CATCH_EST |
Status: | Completed |
Abstract: |
Biosample data for Study Fleet catch estimation project |
Notes: |
Loaded by batch 9250, 09-01-2016 14:18 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NERS |
Description: |
Biosample data for Study Fleet catch estimation project |
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
|
SPECIES_ITIS | VARCHAR2 | Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES | |
100
|
GRADE_CODE | VARCHAR2 | ACCSP grade code description of fish products cut or part ; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES | |
100
|
MARKET_CODE | VARCHAR2 | ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES | |
100
|
DISPOSITION_CODE | VARCHAR2 | ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS | |
100
|
UOM | VARCHAR2 | Unit of measurement; supporting table FVTR.FVTR_UNIT_OF_MEASURE | |
100
|
CATCH_AMOUNT | NUMBER | Estimated catch amount | |
100
|
WEIGHT_TYPE_CODE | VARCHAR2 | Method used to weight sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES | |
100
|
COMMENTS | VARCHAR2 | Additional information | |
100
|
RECORDER | VARCHAR2 | Technician who collected sample | |
100
|
START_HAUL_DATE_GMT | DATE | Start of haul date in Greenwich Mean Time |
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: | Yes |
Status: | Active |
Description: |
Trip effort number where sample was collected |
General Data Type: | VARCHAR2 |
SPECIES_ITIS
Seq. Order: | 3 |
---|---|
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 |
GRADE_CODE
Seq. Order: | 4 |
---|---|
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 |
MARKET_CODE
Seq. Order: | 5 |
---|---|
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 |
DISPOSITION_CODE
Seq. Order: | 6 |
---|---|
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 |
Foreign Key Relations: |
NERS.FVTR_DISPOSITIONS |
UOM
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Unit of measurement; supporting table FVTR.FVTR_UNIT_OF_MEASURE |
General Data Type: | VARCHAR2 |
CATCH_AMOUNT
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 9 |
Scale: | 1 |
Status: | Active |
Description: |
Estimated catch amount |
General Data Type: | NUMBER |
WEIGHT_TYPE_CODE
Seq. Order: | 9 |
---|---|
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 |
Foreign Key Relations: |
NERS.SF_BIOSAMP_WEIGHT_TYPES |
COMMENTS
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 250 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Additional information |
General Data Type: | VARCHAR2 |
RECORDER
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Technician who collected sample |
General Data Type: | VARCHAR2 |
START_HAUL_DATE_GMT
Seq. Order: | 12 |
---|---|
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 |
Catalog Details
Catalog Item ID: | 34608 |
---|---|
GUID: | gov.noaa.nmfs.inport:34608 |
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 |