FISH_ORGANISM
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:35891 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | FISH_ORGANISM |
---|---|
Short Name: | FISH_ORGANISM |
Status: | Completed |
Abstract: |
Basic biological data collected for each specimen. The initial record for a specimen is created in this table along with the assigning of the unique FISH_ID_CODE |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
Basic biological data collected for each specimen. The initial record for a specimen is created in this table along with the assigning of the unique FISH_ID_CODE |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
FISH_ID_CODE | VARCHAR2 | Unique code for each sampled fish. First two letters indicate source. Next three species (taken from Latin name), see FLDRPILOT.SPECIES.ABBREVIATION. Followed by sequentially assigned numbers. |
100
|
TRIP_IDENTIFIER_BARCODE | VARCHAR2 | Unique code for linking fish to catch information for Study Fleet obtained specimens see TRIP_DATA.TRIP_IDENTIFIER_BARCODE. This code is specific to the gear haul level. | |
100
|
SOURCE | VARCHAR2 | Program source for the fish samples. Catch data is linked and formatted dependent upon the source. SF=Study Fleet, CP=Other Cooperative Research Programs with data in SVSDBS, HB=Trawl Survey on the Bigelow vessel, MA=MA DMF trawl survey, LL=Cooperative research longline survey, RI=URI GSO trawl survey, BG=Samples from Bigelow trawl survey but taken from a subsample and lack an individual record in SVDBS, | |
100
|
HAUL_NUMBER | NUMBER | Not used | |
100
|
WORK_UP_DATE | DATE | Date that fish were actually dissected for samples, may differ from catch date. | |
100
|
TOTAL_LENGTH | NUMBER | Measured total length of specimen in mm | |
100
|
TOTAL_MASS | NUMBER | Measured total (round) mass of specimen in grams | |
100
|
SEX | CHAR | Sex of individual specimen: M = male, F = female, or U= unknown | |
100
|
GONAD_MASS | NUMBER | Measured weight of both gonads from a specimen in grams (g) | |
100
|
GONAD_LENGTH1 | NUMBER | Measured length of the first gonad (longest axis) from a specimen in mm | |
100
|
GONAD_CLASS | CHAR | Stage of maturation of the fish being sampled. See SVDBS.FSCS_MATURITY_CODES for descriptions: I = immature, D = developing, R = ripe, U = ripe & running, S = Spent, T = Resting. Additional codes for some species include: F = first time maturing, A = partially spent, and X = skip spawner | |
100
|
LIVER_MASS | NUMBER | Measured weight of entire liver from a specimen in grams (g) | |
100
|
NUMBER_OF_OTOLITHS | NUMBER | Number of sagittal otoliths taken from a specimen for ageing (1 or 2). Structure taken dependent on species. One of either FISH_ORGANISM.NUMBER_OF_OTOLITHS and FISH_ORGANISM.SCALES can not be null. | |
100
|
SCALES | CHAR | Binary (Y/N) flag indicating if scales taken for ageing. Structure taken dependent on species. One of either FISH_ORGANISM.NUMBER_OF_OTOLITHS and FISH_ORGANISM.SCALES can not be null. | |
100
|
HISTOLOGY | CHAR | Binary (Y/N) flag indicating if a gonad histology subsample was taken from a specimen. This subsample is also used for fecundity and other data. | |
100
|
AGE | NUMBER | Not used. See FLDRPILOT.AGE | |
100
|
NUMBER_OF_ANNULI | NUMBER | Not used. See FLDRPILOT.AGE | |
100
|
MARGIN_TYPE | NUMBER | Not used. See FLDRPILOT.AGE | |
100
|
CONFIDENCE | NUMBER | Not used. See FLDRPILOT.AGE | |
100
|
REGION | CHAR | Not used | |
100
|
TEMPERATURE | NUMBER | Temperature of specimen in degrees Celsius. | |
100
|
ELECTRODE_DISTANCE | NUMBER | Distance in mm between electrodes for bioelectrical impedance analysis (BIA) probes | |
100
|
RESISTANCE | NUMBER | Resistance of the tissue in ohms collected by the bioelectrical impedance analysis (BIA) instrument | |
100
|
REACTANCE | NUMBER | Reactance of the tissue in ohms collected by the bioelectrical impedance analysis (BIA) instrument | |
100
|
COMMENTS | VARCHAR2 | Comment field for the specimen | |
100
|
LENGTH_TYPE | CHAR | Primary length type taken, fork or total length, which is species dependent | |
100
|
GONAD_LENGTH2 | NUMBER | Measured length of the second gonad (longest axis) from a specimen in mm | |
100
|
DNA | CHAR | Binary (Y/N) flag indicating if a genetics sample was taken from a specimen | |
100
|
SURVEYID | VARCHAR2 | Cruise code for trawl survey collected specimens. Matches with CRUISE6 column in SVDBS. See FLDRPILOT.EBSFD_FSCS_UNION.CRUISE6 | |
100
|
STATIONNUMBER | NUMBER | Station number for trawl survey collected specimens. Matches with STATION column in SVDBS. See FLDRPILOT.EBSFD_FSCS_UNION.STATION | |
100
|
FISHNUMBER | NUMBER | A unique identifier for each fish sampled for trawl survey collected specimens. Matches with INDID column in SVDBS. See FLDRPILOT.EBSFD_FSCS_UNION.INDID | |
100
|
LOCATION | VARCHAR2 | Station specimens were obtained at for samples obtained from URI trawl survey | |
100
|
PICTURES_TAKEN | CHAR | Binary (Y/N) flag indicating if any photographs were taken of the specimen. | |
100
|
PROBABLE_STOCK | VARCHAR2 | Stock region the specimen was intended to be obtained from and is confirmed using the catch location data obtained later. | |
100
|
TAG_NUMBER | NUMBER | Not used | |
100
|
CLASPER_LENGTH | NUMBER | Not used | |
100
|
CLASPER_LENGTH2 | NUMBER | Not used | |
100
|
SPERM_PACKETS | CHAR | Not used | |
100
|
UPPER_OVIDUCT_DIAMETER | NUMBER | Not used | |
100
|
SHELL_GLAND_MASS | NUMBER | Not used | |
100
|
SHELL_GLAND_WIDTH | NUMBER | Not used | |
100
|
UTERUS_LENGTH | NUMBER | Not used | |
100
|
UTERUS_WIDTH | NUMBER | Not used | |
100
|
LARGEST_EGG_DIAMETER | NUMBER | Not used | |
100
|
EPIDIDYMIS_WIDTH | NUMBER | Not used | |
100
|
AMPULA_EPIDIDYMIS_DIAMETER | NUMBER | Not used | |
100
|
VERTS | CHAR | Not used | |
100
|
SPINE | CHAR | Not used | |
100
|
FORK_LENGTH | NUMBER | Measured fork length of specimen in mm |
Attribute Details
FISH_ID_CODE
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | Yes |
Primary Key: | Yes |
Status: | Active |
Description: |
Unique code for each sampled fish. First two letters indicate source. Next three species (taken from Latin name), see FLDRPILOT.SPECIES.ABBREVIATION. Followed by sequentially assigned numbers. |
General Data Type: | VARCHAR2 |
TRIP_IDENTIFIER_BARCODE
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique code for linking fish to catch information for Study Fleet obtained specimens see TRIP_DATA.TRIP_IDENTIFIER_BARCODE. This code is specific to the gear haul level. |
General Data Type: | VARCHAR2 |
SOURCE
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Program source for the fish samples. Catch data is linked and formatted dependent upon the source. SF=Study Fleet, CP=Other Cooperative Research Programs with data in SVSDBS, HB=Trawl Survey on the Bigelow vessel, MA=MA DMF trawl survey, LL=Cooperative research longline survey, RI=URI GSO trawl survey, BG=Samples from Bigelow trawl survey but taken from a subsample and lack an individual record in SVDBS, |
General Data Type: | VARCHAR2 |
HAUL_NUMBER
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
Not used |
General Data Type: | NUMBER |
WORK_UP_DATE
Seq. Order: | 5 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date that fish were actually dissected for samples, may differ from catch date. |
General Data Type: | DATE |
TOTAL_LENGTH
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
Measured total length of specimen in mm |
General Data Type: | NUMBER |
TOTAL_MASS
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 1 |
Status: | Active |
Description: |
Measured total (round) mass of specimen in grams |
General Data Type: | NUMBER |
SEX
Seq. Order: | 8 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sex of individual specimen: M = male, F = female, or U= unknown |
General Data Type: | CHAR |
GONAD_MASS
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 3 |
Status: | Active |
Description: |
Measured weight of both gonads from a specimen in grams (g) |
General Data Type: | NUMBER |
GONAD_LENGTH1
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Measured length of the first gonad (longest axis) from a specimen in mm |
General Data Type: | NUMBER |
GONAD_CLASS
Seq. Order: | 11 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Stage of maturation of the fish being sampled. See SVDBS.FSCS_MATURITY_CODES for descriptions: I = immature, D = developing, R = ripe, U = ripe & running, S = Spent, T = Resting. Additional codes for some species include: F = first time maturing, A = partially spent, and X = skip spawner |
General Data Type: | CHAR |
LIVER_MASS
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 3 |
Status: | Active |
Description: |
Measured weight of entire liver from a specimen in grams (g) |
General Data Type: | NUMBER |
NUMBER_OF_OTOLITHS
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
Number of sagittal otoliths taken from a specimen for ageing (1 or 2). Structure taken dependent on species. One of either FISH_ORGANISM.NUMBER_OF_OTOLITHS and FISH_ORGANISM.SCALES can not be null. |
General Data Type: | NUMBER |
SCALES
Seq. Order: | 14 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Binary (Y/N) flag indicating if scales taken for ageing. Structure taken dependent on species. One of either FISH_ORGANISM.NUMBER_OF_OTOLITHS and FISH_ORGANISM.SCALES can not be null. |
General Data Type: | CHAR |
HISTOLOGY
Seq. Order: | 15 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Binary (Y/N) flag indicating if a gonad histology subsample was taken from a specimen. This subsample is also used for fecundity and other data. |
General Data Type: | CHAR |
AGE
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Not used. See FLDRPILOT.AGE |
General Data Type: | NUMBER |
NUMBER_OF_ANNULI
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Not used. See FLDRPILOT.AGE |
General Data Type: | NUMBER |
MARGIN_TYPE
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 2 |
Scale: | 0 |
Status: | Active |
Description: |
Not used. See FLDRPILOT.AGE |
General Data Type: | NUMBER |
CONFIDENCE
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 1 |
Scale: | 0 |
Status: | Active |
Description: |
Not used. See FLDRPILOT.AGE |
General Data Type: | NUMBER |
REGION
Seq. Order: | 20 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Not used |
General Data Type: | CHAR |
TEMPERATURE
Seq. Order: | 21 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 1 |
Status: | Active |
Description: |
Temperature of specimen in degrees Celsius. |
General Data Type: | NUMBER |
ELECTRODE_DISTANCE
Seq. Order: | 22 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 0 |
Status: | Active |
Description: |
Distance in mm between electrodes for bioelectrical impedance analysis (BIA) probes |
General Data Type: | NUMBER |
RESISTANCE
Seq. Order: | 23 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 1 |
Status: | Active |
Description: |
Resistance of the tissue in ohms collected by the bioelectrical impedance analysis (BIA) instrument |
General Data Type: | NUMBER |
REACTANCE
Seq. Order: | 24 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 1 |
Status: | Active |
Description: |
Reactance of the tissue in ohms collected by the bioelectrical impedance analysis (BIA) instrument |
General Data Type: | NUMBER |
COMMENTS
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 500 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Comment field for the specimen |
General Data Type: | VARCHAR2 |
LENGTH_TYPE
Seq. Order: | 26 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Primary length type taken, fork or total length, which is species dependent |
General Data Type: | CHAR |
GONAD_LENGTH2
Seq. Order: | 27 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Measured length of the second gonad (longest axis) from a specimen in mm |
General Data Type: | NUMBER |
DNA
Seq. Order: | 28 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Binary (Y/N) flag indicating if a genetics sample was taken from a specimen |
General Data Type: | CHAR |
SURVEYID
Seq. Order: | 29 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Cruise code for trawl survey collected specimens. Matches with CRUISE6 column in SVDBS. See FLDRPILOT.EBSFD_FSCS_UNION.CRUISE6 |
General Data Type: | VARCHAR2 |
STATIONNUMBER
Seq. Order: | 30 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Station number for trawl survey collected specimens. Matches with STATION column in SVDBS. See FLDRPILOT.EBSFD_FSCS_UNION.STATION |
General Data Type: | NUMBER |
FISHNUMBER
Seq. Order: | 31 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
A unique identifier for each fish sampled for trawl survey collected specimens. Matches with INDID column in SVDBS. See FLDRPILOT.EBSFD_FSCS_UNION.INDID |
General Data Type: | NUMBER |
LOCATION
Seq. Order: | 32 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Station specimens were obtained at for samples obtained from URI trawl survey |
General Data Type: | VARCHAR2 |
PICTURES_TAKEN
Seq. Order: | 33 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Binary (Y/N) flag indicating if any photographs were taken of the specimen. |
General Data Type: | CHAR |
PROBABLE_STOCK
Seq. Order: | 34 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Stock region the specimen was intended to be obtained from and is confirmed using the catch location data obtained later. |
General Data Type: | VARCHAR2 |
TAG_NUMBER
Seq. Order: | 35 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Not used |
General Data Type: | NUMBER |
CLASPER_LENGTH
Seq. Order: | 36 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Not used |
General Data Type: | NUMBER |
CLASPER_LENGTH2
Seq. Order: | 37 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Not used |
General Data Type: | NUMBER |
SPERM_PACKETS
Seq. Order: | 38 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Not used |
General Data Type: | CHAR |
UPPER_OVIDUCT_DIAMETER
Seq. Order: | 39 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
Not used |
General Data Type: | NUMBER |
SHELL_GLAND_MASS
Seq. Order: | 40 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 3 |
Status: | Active |
Description: |
Not used |
General Data Type: | NUMBER |
SHELL_GLAND_WIDTH
Seq. Order: | 41 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Not used |
General Data Type: | NUMBER |
UTERUS_LENGTH
Seq. Order: | 42 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Not used |
General Data Type: | NUMBER |
UTERUS_WIDTH
Seq. Order: | 43 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Not used |
General Data Type: | NUMBER |
LARGEST_EGG_DIAMETER
Seq. Order: | 44 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Not used |
General Data Type: | NUMBER |
EPIDIDYMIS_WIDTH
Seq. Order: | 45 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Not used |
General Data Type: | NUMBER |
AMPULA_EPIDIDYMIS_DIAMETER
Seq. Order: | 46 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Not used |
General Data Type: | NUMBER |
VERTS
Seq. Order: | 47 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Not used |
General Data Type: | CHAR |
SPINE
Seq. Order: | 48 |
---|---|
Data Storage Type: | CHAR |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Not used |
General Data Type: | CHAR |
FORK_LENGTH
Seq. Order: | 49 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 0 |
Status: | Active |
Description: |
Measured fork length of specimen in mm |
General Data Type: | NUMBER |
Catalog Details
Catalog Item ID: | 35891 |
---|---|
GUID: | gov.noaa.nmfs.inport:35891 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-12-07 13:27+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-12-07 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-12-07 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-12-07 |