Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Population and Ecosystems Monitoring and Analys... > Population Biology Branch > Enhanced Biological Sampling Data >

HISTOLOGY

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:35893  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Data collected from gonad histology slides with characters and values unique to each sex and species. Table structure, columns, and species-sex specific values under development still.

Description

Data collected from gonad histology slides with characters and values unique to each sex and species. Table structure, columns, and species-sex specific values under development still.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
FISH_ID_CODE
VARCHAR2 		Unique code for each sampled fish.
MAOS
VARCHAR2 		Most advanced oocyte stage
POF
NUMBER 		Under development
POF_PRESENCE
CHAR 		Under development
CYSTS
CHAR 		Under development
ATRESIA
VARCHAR2 		Under development
ATRESIA_TYPE
VARCHAR2 		Under development
TUNICA_THICKNESS_CATEGORY
CHAR 		Under development
TUNICA_THICKNESS
NUMBER 		Under development
STROMA
VARCHAR2 		Under development
COMMENTS
VARCHAR2 		Comments field for the gonad histology slide
HISTOLOGY_GONAD_CLASS
CHAR 		Under development
CYSTS_COMMENT
VARCHAR2 		Under development
OVARY_LOBE
CHAR 		Ovary lobe for a subsample: RIGHT or LEFT
OVARY_LOCATION
CHAR 		Region within ovary subsample was taken: ANTERIOR, MIDDLE, POSTERIOR
SLIDE_QUALITY
VARCHAR2 		Quality of slide: null or UNREADABLE
PICTURES_TAKEN
CHAR 		Binary (Y/N) flag indicating if any photographs were taken of the gonad histology section
SAMPLE_ID
NUMBER 		Sequential identifier assigned for each subsample (slide) examined for each specimen

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

Data collected from gonad histology slides with characters and values unique to each sex and species. Table structure, columns, and species-sex specific values under development still.

Entity Information

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

Data collected from gonad histology slides with characters and values unique to each sex and species. Table structure, columns, and species-sex specific values under development still.

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
 MAOS VARCHAR2 Most advanced oocyte stage
100
 POF NUMBER Under development
100
 POF_PRESENCE CHAR Under development
100
 CYSTS CHAR Under development
100
 ATRESIA VARCHAR2 Under development
100
 ATRESIA_TYPE VARCHAR2 Under development
100
 TUNICA_THICKNESS_CATEGORY CHAR Under development
100
 TUNICA_THICKNESS NUMBER Under development
100
 STROMA VARCHAR2 Under development
100
 COMMENTS VARCHAR2 Comments field for the gonad histology slide
100
 HISTOLOGY_GONAD_CLASS CHAR Under development
100
 CYSTS_COMMENT VARCHAR2 Under development
100
 OVARY_LOBE CHAR Ovary lobe for a subsample: RIGHT or LEFT
100
 OVARY_LOCATION CHAR Region within ovary subsample was taken: ANTERIOR, MIDDLE, POSTERIOR
100
 SLIDE_QUALITY VARCHAR2 Quality of slide: null or UNREADABLE
100
 PICTURES_TAKEN CHAR Binary (Y/N) flag indicating if any photographs were taken of the gonad histology section
100
 Primary Key SAMPLE_ID NUMBER Sequential identifier assigned for each subsample (slide) examined for each specimen

Attribute Details

FISH_ID_CODE

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

MAOS

CC ID: 362232
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Most advanced oocyte stage
General Data Type: VARCHAR2

POF

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

Under development
General Data Type: NUMBER

POF_PRESENCE

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

Under development
General Data Type: CHAR

CYSTS

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

Under development
General Data Type: CHAR

ATRESIA

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

Under development
General Data Type: VARCHAR2

ATRESIA_TYPE

CC ID: 362237
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Under development
General Data Type: VARCHAR2

TUNICA_THICKNESS_CATEGORY

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

Under development
General Data Type: CHAR

TUNICA_THICKNESS

CC ID: 362239
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 3
Status: Active
Description:

Under development
General Data Type: NUMBER

STROMA

CC ID: 362240
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Under development
General Data Type: VARCHAR2

COMMENTS

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

Comments field for the gonad histology slide
General Data Type: VARCHAR2

HISTOLOGY_GONAD_CLASS

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

Under development
General Data Type: CHAR

CYSTS_COMMENT

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

Under development
General Data Type: VARCHAR2

OVARY_LOBE

CC ID: 362244
Seq. Order: 14
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

OVARY_LOCATION

CC ID: 362245
Seq. Order: 15
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

SLIDE_QUALITY

CC ID: 362246
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Quality of slide: null or UNREADABLE
General Data Type: VARCHAR2

PICTURES_TAKEN

CC ID: 362247
Seq. Order: 17
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 gonad histology section
General Data Type: CHAR

SAMPLE_ID

CC ID: 362248
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Status: Active
Description:

Sequential identifier assigned for each subsample (slide) examined for each specimen
General Data Type: NUMBER

Catalog Details

Catalog Item ID: 35893
GUID: gov.noaa.nmfs.inport:35893
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