Slide Menu
Search Help Show/Hide Menu

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