Table: SF_BIOSAMP_LENWGT_CONV
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34613 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Biosample length weight conversion data
DescriptionBiosample length weight conversion 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 |
STAT_AREA
VARCHAR2 |
Statistical area where sampling occurred; support table NERS.FVTR_FISHING_AREAS |
FISH_ID
NUMBER |
Unigue fish identifier per trip |
SPECIES_ITIS
VARCHAR2 |
Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES |
DISPOSITION_CODE
VARCHAR2 |
ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS |
GRADE_CODE_1
VARCHAR2 |
Initial ACCSP grade code description of fish products cut or part; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES |
MARKET_CODE_1
VARCHAR2 |
Initial ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES |
LENGTH_CM_1
NUMBER |
Initial length of sample in centimeters |
LENGTH_TYPE_1
VARCHAR2 |
Initial length measurement type; support table NERS.SF_BIOSAMP_LENGTH_TYPES |
WEIGHT_KG_1
NUMBER |
Initial weight of sample in kilograms |
WEIGHT_TYPE_1
VARCHAR2 |
Initial Method used to weigh sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES |
GRADE_CODE_2
VARCHAR2 |
Secondary ACCSP grade code description of fish products cut or part ; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES |
MARKET_CODE_2
VARCHAR2 |
Secondary ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES |
LENGTH_CM_2
NUMBER |
Secondary length of sample in centimeters |
LENGTH_TYPE_2
VARCHAR2 |
Secondary length measurement type; support table NERS.SF_BIOSAMP_LENGTH_TYPES |
WEIGHT_KG_2
NUMBER |
Secondary weight of sample in kilograms |
WEIGHT_TYPE_2
VARCHAR2 |
Secondary Method used to weigh sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES |
RECORDER
VARCHAR2 |
Staff member who collected sample |
START_HAUL_DATE_GMT
DATE |
Start haul date in Greenwich Mean Time |
COMMENTS
VARCHAR2 |
Additional information |
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_LENWGT_CONV |
---|---|
Short Name: | SF_BIOSAMP_LENWGT_CONV |
Status: | Completed |
Abstract: |
Biosample length weight conversion data |
Notes: |
Loaded by batch 9250, 09-01-2016 14:18 |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Schema Name: | NERS |
Description: |
Biosample length weight conversion 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
|
STAT_AREA | VARCHAR2 | Statistical area where sampling occurred; support table NERS.FVTR_FISHING_AREAS | |
100
|
FISH_ID | NUMBER | Unigue fish identifier per trip | |
100
|
SPECIES_ITIS | VARCHAR2 | Integrated Taxonomic Information System Code; support table NERS.FVTR_SPECIES | |
100
|
DISPOSITION_CODE | VARCHAR2 | ACCSP code for intended use or disposal of species; support table NERS.FVTR_DISPOSITIONS | |
100
|
GRADE_CODE_1 | VARCHAR2 | Initial ACCSP grade code description of fish products cut or part; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES | |
100
|
MARKET_CODE_1 | VARCHAR2 | Initial ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES | |
100
|
LENGTH_CM_1 | NUMBER | Initial length of sample in centimeters | |
100
|
LENGTH_TYPE_1 | VARCHAR2 | Initial length measurement type; support table NERS.SF_BIOSAMP_LENGTH_TYPES | |
100
|
WEIGHT_KG_1 | NUMBER | Initial weight of sample in kilograms | |
100
|
WEIGHT_TYPE_1 | VARCHAR2 | Initial Method used to weigh sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES | |
100
|
GRADE_CODE_2 | VARCHAR2 | Secondary ACCSP grade code description of fish products cut or part ; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES | |
100
|
MARKET_CODE_2 | VARCHAR2 | Secondary ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES | |
100
|
LENGTH_CM_2 | NUMBER | Secondary length of sample in centimeters | |
100
|
LENGTH_TYPE_2 | VARCHAR2 | Secondary length measurement type; support table NERS.SF_BIOSAMP_LENGTH_TYPES | |
100
|
WEIGHT_KG_2 | NUMBER | Secondary weight of sample in kilograms | |
100
|
WEIGHT_TYPE_2 | VARCHAR2 | Secondary Method used to weigh sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES | |
100
|
RECORDER | VARCHAR2 | Staff member who collected sample | |
100
|
START_HAUL_DATE_GMT | DATE | Start haul date in Greenwich Mean Time | |
100
|
COMMENTS | VARCHAR2 | Additional information |
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 |
STAT_AREA
Seq. Order: | 3 |
---|---|
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: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | Yes |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Unigue fish identifier per trip |
General Data Type: | NUMBER |
SPECIES_ITIS
Seq. Order: | 5 |
---|---|
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 |
DISPOSITION_CODE
Seq. Order: | 6 |
---|---|
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 |
GRADE_CODE_1
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Initial ACCSP grade code description of fish products cut or part; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES |
General Data Type: | VARCHAR2 |
MARKET_CODE_1
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Initial ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES |
General Data Type: | VARCHAR2 |
LENGTH_CM_1
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 1 |
Status: | Active |
Description: |
Initial length of sample in centimeters |
General Data Type: | NUMBER |
LENGTH_TYPE_1
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Initial length measurement type; support table NERS.SF_BIOSAMP_LENGTH_TYPES |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
NERS.SF_BIOSAMP_LENGTH_TYPES |
WEIGHT_KG_1
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 4 |
Status: | Active |
Description: |
Initial weight of sample in kilograms |
General Data Type: | NUMBER |
WEIGHT_TYPE_1
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Initial Method used to weigh sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
NERS.SF_BIOSAMP_WEIGHT_TYPES |
GRADE_CODE_2
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Secondary ACCSP grade code description of fish products cut or part ; support table FVTR.ACCSP_SAFIS_GRADE_CATEGORIES |
General Data Type: | VARCHAR2 |
MARKET_CODE_2
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Secondary ACCSP market code description of species size or count category; support table FVTR.ACCSP_SAFIS_MARKET_CATEGORIES |
General Data Type: | VARCHAR2 |
LENGTH_CM_2
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 1 |
Status: | Active |
Description: |
Secondary length of sample in centimeters |
General Data Type: | NUMBER |
LENGTH_TYPE_2
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Secondary length measurement type; support table NERS.SF_BIOSAMP_LENGTH_TYPES |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
NERS.SF_BIOSAMP_LENGTH_TYPES |
WEIGHT_KG_2
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 4 |
Status: | Active |
Description: |
Secondary weight of sample in kilograms |
General Data Type: | NUMBER |
WEIGHT_TYPE_2
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Secondary Method used to weigh sample; support table NERS.SF_BIOSAMP_WEIGHT_TYPES |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
NERS.SF_BIOSAMP_WEIGHT_TYPES |
RECORDER
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Staff member who collected sample |
General Data Type: | VARCHAR2 |
START_HAUL_DATE_GMT
Seq. Order: | 20 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Start haul date in Greenwich Mean Time |
General Data Type: | DATE |
COMMENTS
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 250 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Additional information |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 34613 |
---|---|
GUID: | gov.noaa.nmfs.inport:34613 |
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 |