HISTOLOGY
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:35893 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionData 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
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
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
|
![]() |
SAMPLE_ID | NUMBER | Sequential identifier assigned for each subsample (slide) examined for each specimen |
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. |
General Data Type: | VARCHAR2 |
Foreign Key Relations: |
FISH_ORGANISM.FISH_ID_CODE |
MAOS
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |