Slide Menu
Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu

Item Identification

Title: Table: ATL_LOV_MATURITY
Short Name: ATL_LOV_MATURITY
Status: Completed
Abstract:

This entity represents the valid maturity values which may be applied to a species and recorded in the Fish_Inv_Specimen table

Notes:

Loaded by batch 4574, 05-03-2013 17:18

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: NPRB_1017
Description:

This entity represents the valid maturity values which may be applied to a species and recorded in the Fish_Inv_Specimen table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key MATURITY_SEQ NUMBER Sequence generated unique identifier of a maturity record.
100
CODE VARCHAR2 Alpha-Numeric code identifying the level of maturity.
100
DESCRIPTION VARCHAR2 Descriptive text of the maturity level.

Attribute Details

MATURITY_SEQ

CC ID: 112071
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated unique identifier of a maturity record.

General Data Type: NUMBER

CODE

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

Alpha-Numeric code identifying the level of maturity.

General Data Type: VARCHAR2

DESCRIPTION

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

Descriptive text of the maturity level.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 19017
GUID: gov.noaa.nmfs.inport:19017
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2013-05-03 17:18+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18