FISH_ORGANISM
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:35891 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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
DescriptionBasic 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
Data Attribute / Type | Description |
---|---|
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. |
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. |
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, |
HAUL_NUMBER
NUMBER |
Not used |
WORK_UP_DATE
DATE |
Date that fish were actually dissected for samples, may differ from catch date. |
TOTAL_LENGTH
NUMBER |
Measured total length of specimen in mm |
TOTAL_MASS
NUMBER |
Measured total (round) mass of specimen in grams |
SEX
CHAR |
Sex of individual specimen: M = male, F = female, or U= unknown |
GONAD_MASS
NUMBER |
Measured weight of both gonads from a specimen in grams (g) |
GONAD_LENGTH1
NUMBER |
Measured length of the first gonad (longest axis) from a specimen in mm |
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 |
LIVER_MASS
NUMBER |
Measured weight of entire liver from a specimen in grams (g) |
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. |
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. |
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. |
AGE
NUMBER |
Not used. See FLDRPILOT.AGE |
NUMBER_OF_ANNULI
NUMBER |
Not used. See FLDRPILOT.AGE |
MARGIN_TYPE
NUMBER |
Not used. See FLDRPILOT.AGE |
CONFIDENCE
NUMBER |
Not used. See FLDRPILOT.AGE |
REGION
CHAR |
Not used |
TEMPERATURE
NUMBER |
Temperature of specimen in degrees Celsius. |
ELECTRODE_DISTANCE
NUMBER |
Distance in mm between electrodes for bioelectrical impedance analysis (BIA) probes |
RESISTANCE
NUMBER |
Resistance of the tissue in ohms collected by the bioelectrical impedance analysis (BIA) instrument |
REACTANCE
NUMBER |
Reactance of the tissue in ohms collected by the bioelectrical impedance analysis (BIA) instrument |
COMMENTS
VARCHAR2 |
Comment field for the specimen |
LENGTH_TYPE
CHAR |
Primary length type taken, fork or total length, which is species dependent |
GONAD_LENGTH2
NUMBER |
Measured length of the second gonad (longest axis) from a specimen in mm |
DNA
CHAR |
Binary (Y/N) flag indicating if a genetics sample was taken from a specimen |
SURVEYID
VARCHAR2 |
Cruise code for trawl survey collected specimens. Matches with CRUISE6 column in SVDBS. See FLDRPILOT.EBSFD_FSCS_UNION.CRUISE6 |
STATIONNUMBER
NUMBER |
Station number for trawl survey collected specimens. Matches with STATION column in SVDBS. See FLDRPILOT.EBSFD_FSCS_UNION.STATION |
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 |
LOCATION
VARCHAR2 |
Station specimens were obtained at for samples obtained from URI trawl survey |
PICTURES_TAKEN
CHAR |
Binary (Y/N) flag indicating if any photographs were taken of the specimen. |
PROBABLE_STOCK
VARCHAR2 |
Stock region the specimen was intended to be obtained from and is confirmed using the catch location data obtained later. |
TAG_NUMBER
NUMBER |
Not used |
CLASPER_LENGTH
NUMBER |
Not used |
CLASPER_LENGTH2
NUMBER |
Not used |
SPERM_PACKETS
CHAR |
Not used |
UPPER_OVIDUCT_DIAMETER
NUMBER |
Not used |
SHELL_GLAND_MASS
NUMBER |
Not used |
SHELL_GLAND_WIDTH
NUMBER |
Not used |
UTERUS_LENGTH
NUMBER |
Not used |
UTERUS_WIDTH
NUMBER |
Not used |
LARGEST_EGG_DIAMETER
NUMBER |
Not used |
EPIDIDYMIS_WIDTH
NUMBER |
Not used |
AMPULA_EPIDIDYMIS_DIAMETER
NUMBER |
Not used |
VERTS
CHAR |
Not used |
SPINE
CHAR |
Not used |
FORK_LENGTH
NUMBER |
Measured fork length of specimen in mm |
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: | 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 |