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

Summary

Abstract

Data for fecundity subsamples taken from ovarian subsamples

Description

Data for fecundity subsamples taken from ovarian subsamples

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
FISH_ID_CODE
VARCHAR2
Unique code for each sampled fish.
MASS_OF_SUBSAMPLE
NUMBER
Mass in grams of the ovarian subsample
OVARY_LOBE
CHAR
Ovary lobe for a subsample: RIGHT or LEFT
LOCATION_IN_OVARY
CHAR
Region within ovary subsample was taken: ANTERIOR, MIDDLE, POSTERIOR
OOCYTE_COUNT
NUMBER
Count of individual oocytes in an ovarian subsample
COMMENTS
VARCHAR2
Comments field for the fecundity subsample
IMAGE_QUALITY
NUMBER
Qualitative score of the quality of the image(s) taken for image processing of a fecundity subsample: 1 = GOOD, 2 = ADEQUATE, or 3 = POOR (not usable)
SUBSAMPLE
NUMBER
Individual sequential identifier for fecundity subsamples; unique within each specimen
OOCYTE_ID
NUMBER
No longer used.

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: OOCYTE
Short Name: OOCYTE
Status: Completed
Abstract:

Data for fecundity subsamples taken from ovarian subsamples

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Data for fecundity subsamples taken from ovarian subsamples

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key FISH_ID_CODE VARCHAR2 Unique code for each sampled fish.
100
MASS_OF_SUBSAMPLE NUMBER Mass in grams of the ovarian subsample
100
OVARY_LOBE CHAR Ovary lobe for a subsample: RIGHT or LEFT
100
LOCATION_IN_OVARY CHAR Region within ovary subsample was taken: ANTERIOR, MIDDLE, POSTERIOR
100
OOCYTE_COUNT NUMBER Count of individual oocytes in an ovarian subsample
100
COMMENTS VARCHAR2 Comments field for the fecundity subsample
100
IMAGE_QUALITY NUMBER Qualitative score of the quality of the image(s) taken for image processing of a fecundity subsample: 1 = GOOD, 2 = ADEQUATE, or 3 = POOR (not usable)
100
Primary Key SUBSAMPLE NUMBER Individual sequential identifier for fecundity subsamples; unique within each specimen
100
OOCYTE_ID NUMBER No longer used.

Attribute Details

FISH_ID_CODE

CC ID: 362249
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: Yes
Status: Active
Description:

Unique code for each sampled fish.

General Data Type: VARCHAR2
Foreign Key Relations:

FISH_ORGANISM.FISH_ID_CODE

MASS_OF_SUBSAMPLE

CC ID: 362250
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 4
Status: Active
Description:

Mass in grams of the ovarian subsample

General Data Type: NUMBER

OVARY_LOBE

CC ID: 362251
Seq. Order: 3
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Ovary lobe for a subsample: RIGHT or LEFT

General Data Type: CHAR

LOCATION_IN_OVARY

CC ID: 362252
Seq. Order: 4
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Region within ovary subsample was taken: ANTERIOR, MIDDLE, POSTERIOR

General Data Type: CHAR

OOCYTE_COUNT

CC ID: 362253
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Count of individual oocytes in an ovarian subsample

General Data Type: NUMBER

COMMENTS

CC ID: 362254
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 500
Required: No
Primary Key: No
Status: Active
Description:

Comments field for the fecundity subsample

General Data Type: VARCHAR2

IMAGE_QUALITY

CC ID: 362255
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Qualitative score of the quality of the image(s) taken for image processing of a fecundity subsample: 1 = GOOD, 2 = ADEQUATE, or 3 = POOR (not usable)

General Data Type: NUMBER

SUBSAMPLE

CC ID: 362256
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 2
Scale: 0
Status: Active
Description:

Individual sequential identifier for fecundity subsamples; unique within each specimen

General Data Type: NUMBER

OOCYTE_ID

CC ID: 362257
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

No longer used.

General Data Type: NUMBER

Catalog Details

Catalog Item ID: 35894
GUID: gov.noaa.nmfs.inport:35894
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-12
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-12-12
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-12-12