Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Biosample length weight conversion data

Description

Biosample 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 9249, 09-01-2016 13:11

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NERS
Description:

Biosample length weight conversion data

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key 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
Primary Key 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

CC ID: 347964
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

CC ID: 347971
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

CC ID: 347974
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

CC ID: 347975
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

CC ID: 347976
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

CC ID: 347959
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

CC ID: 347977
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

CC ID: 347978
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

CC ID: 347979
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

CC ID: 347960
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

CC ID: 347965
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

CC ID: 347962
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

CC ID: 347966
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

CC ID: 347967
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

CC ID: 347968
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

CC ID: 347961
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

CC ID: 347969
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

CC ID: 347963
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

CC ID: 347970
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

CC ID: 347972
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

CC ID: 347973
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: 34587
GUID: gov.noaa.nmfs.inport:34587
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