Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Life History Program > Life History Estimates > Pristipomoides filamentosus Size at Maturity St... >

Column Notes for P. filamentosus Size at Maturity Study

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:23693  |  Updated: February 13, 2025  |  Published / External 
Summary
Item Identification
Keywords
Physical Location
Entity Info
Data Attributes
Support Roles
Extents
Catalog Details

Summary

Abstract

Entity describes what types of information can be found in the Pristipomoides filamentosus Size at Maturity Study Data Set.

Description

P. filamentosus Size at Maturity Study.

Entity Information

Entity Type
Spreadsheet

Data Attribute / Type Description
HistoBoxNum
Number 		The Histo Box Number the slide is stored in.
FishDataNum
Varchar2 		The Fish Data Number of the histological slide, this number is the unique identifier and can be linked to the Bottomfish Sampling Data Data set to obtain additional information such as location caught etc.
DateCaught
DATE 		The date the fish was caught.
FLcm
Number 		The fork length of the fish in centimeters.
HistoSex
VARCHAR2 		The sex of the fish determined by analysis of the histological slide.
SexMat
varchar2 		The sexual maturity of the fish determined after analysis of the histological slide; fish is either mature (MAT), or immature (IMM).
NadStage
Number 		The maturation stage for each fish. It is a numerical scale ranging from 1 to 6.5 for Pristipomoides filamentosus.
AtreticStage
Number 		The atretic stage of each histological slide. This stage is for females ONLY. Describes what stage of oocytes are undergoing atresia using a numerical scale.
AtreticScore
Number 		The atretic score. Atretic score is the amount of atresia occurring, can be 0, 1, or 2.
HistoComments
VARCHAR2 		Any comments associated with the histological classification of the fish. i.e. explaining maturation stage, atretic stage, and atretic score.
GonadWeightG
Number 		The gonad weight of the fish in grams.
MacroSex
VARCHAR2 		The sex of the fish determined macroscopically.
SpecimenNotes
VARCHAR2 		Any notes associated with the specimen in general.
MonthNum
Number 		The month number the fish was caught.
BodyWtKG
Number 		The body weight of the fish in kilograms.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Extents

Time Frame 1
2013-09-16 - Present

Item Identification

Title: Column Notes for P. filamentosus Size at Maturity Study
Status: In Work
Abstract:

Entity describes what types of information can be found in the Pristipomoides filamentosus Size at Maturity Study Data Set.
Purpose:

Explain the column notes of the Pristipomoides filamentosus Size at Maturity Study Data Set.

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None FRMD
None gonad
None LHP
None maturation
None median size at 50% maturity
None paka
None PIFSC
None Pristipomoides filamentosus
None size at maturity

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None MHI

Physical Location

Organization: Pacific Islands Fisheries Science Center
City: Honolulu
State/Province: HI
Country: USA

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Description:

P. filamentosus Size at Maturity Study.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 HistoBoxNum Number The Histo Box Number the slide is stored in.
100
 Primary Key FishDataNum Varchar2 The Fish Data Number of the histological slide, this number is the unique identifier and can be linked to the Bottomfish Sampling Data Data set to obtain additional information such as location caught etc.
100
 DateCaught DATE The date the fish was caught.
100
 FLcm Number The fork length of the fish in centimeters.
100
 HistoSex VARCHAR2 The sex of the fish determined by analysis of the histological slide.
100
 SexMat varchar2 The sexual maturity of the fish determined after analysis of the histological slide; fish is either mature (MAT), or immature (IMM).
100
 NadStage Number The maturation stage for each fish. It is a numerical scale ranging from 1 to 6.5 for Pristipomoides filamentosus.
100
 AtreticStage Number The atretic stage of each histological slide. This stage is for females ONLY. Describes what stage of oocytes are undergoing atresia using a numerical scale.
100
 AtreticScore Number The atretic score. Atretic score is the amount of atresia occurring, can be 0, 1, or 2.
100
 HistoComments VARCHAR2 Any comments associated with the histological classification of the fish. i.e. explaining maturation stage, atretic stage, and atretic score.
100
 GonadWeightG Number The gonad weight of the fish in grams.
100
 MacroSex VARCHAR2 The sex of the fish determined macroscopically.
100
 SpecimenNotes VARCHAR2 Any notes associated with the specimen in general.
100
 MonthNum Number The month number the fish was caught.
100
 BodyWtKG Number The body weight of the fish in kilograms.

Attribute Details

HistoBoxNum

CC ID: 190184
Seq. Order: 1
Data Storage Type: Number
Max Length: 4
Min Length: 0
Required: Yes
Primary Key: No
Precision: 4
Status: Active
Description:

The Histo Box Number the slide is stored in.
General Data Type: Number
Unit of Measure: 4

FishDataNum

CC ID: 190185
Seq. Order: 2
Data Storage Type: Varchar2
Max Length: 100
Required: Yes
Primary Key: Yes
Status: Active
Description:

The Fish Data Number of the histological slide, this number is the unique identifier and can be linked to the Bottomfish Sampling Data Data set to obtain additional information such as location caught etc.

General Data Type: Character

DateCaught

CC ID: 190186
Seq. Order: 3
Data Storage Type: DATE
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

The date the fish was caught.
Null Value Meaning:

The date the fish was caught is unknown.

FLcm

CC ID: 190187
Seq. Order: 4
Data Storage Type: Number
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

The fork length of the fish in centimeters.

HistoSex

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

The sex of the fish determined by analysis of the histological slide.

General Data Type: Character
Unit of Measure: 1
Case Restriction: Upper
Allowed Values: F, M, U

SexMat

CC ID: 190189
Seq. Order: 6
Data Storage Type: varchar2
Max Length: 3
Required: Yes
Primary Key: No
Status: Active
Description:

The sexual maturity of the fish determined after analysis of the histological slide; fish is either mature (MAT), or immature (IMM).
Case Restriction: Upper
Allowed Values: MAT, IMM

NadStage

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

The maturation stage for each fish. It is a numerical scale ranging from 1 to 6.5 for Pristipomoides filamentosus.

AtreticStage

CC ID: 190191
Seq. Order: 8
Data Storage Type: Number
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

The atretic stage of each histological slide. This stage is for females ONLY. Describes what stage of oocytes are undergoing atresia using a numerical scale.
General Data Type: Number
Null Value Meaning:

There is no atresia occurring or the fish is a Male.

AtreticScore

CC ID: 190192
Seq. Order: 9
Data Storage Type: Number
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

The atretic score. Atretic score is the amount of atresia occurring, can be 0, 1, or 2.

General Data Type: Number
Null Value Meaning:

The fish is a male.
Allowed Values: 0,1,2

HistoComments

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

Any comments associated with the histological classification of the fish. i.e. explaining maturation stage, atretic stage, and atretic score.

General Data Type: Character

GonadWeightG

CC ID: 190194
Seq. Order: 11
Data Storage Type: Number
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

The gonad weight of the fish in grams.
General Data Type: Number
Null Value Meaning:

The gonad weight was not recorded or is unknown.

MacroSex

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

The sex of the fish determined macroscopically.

Allowed Values: M,F,U

SpecimenNotes

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

Any notes associated with the specimen in general.

MonthNum

CC ID: 190197
Seq. Order: 14
Data Storage Type: Number
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

The month number the fish was caught.

BodyWtKG

CC ID: 190198
Seq. Order: 15
Data Storage Type: Number
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

The body weight of the fish in kilograms.
Null Value Meaning:

The body weight was not recorded or is unknown.

Support Roles

This Catalog Item has no Support Roles that are currently in effect.
View Historical Support Roles

Extents

Extent Group 1

Extent Group 1 / Time Frame 1

CC ID: 190202
Time Frame Type: Continuing
Start: 2013-09-16

Catalog Details

Catalog Item ID: 23693
GUID: gov.noaa.nmfs.inport:23693
Metadata Record Created By: Meagan A Sundberg
Metadata Record Created: 2015-03-10 18:33+0000
Metadata Record Last Modified By: Michael Chang
Metadata Record Last Modified: 2025-02-13 22:57+0000
Metadata Record Published: 2025-02-13
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year