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

Summary

Abstract

Biosample data

Description

Biosample 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 9250, 09-01-2016 14:18

Entity Information

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

Biosample 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
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
Primary Key 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

CC ID: 348105
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: 348110
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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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