Slide Menu
Search Help Show/Hide Menu

Item Identification

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

This table links the maturity code in the NORPAC.FOREIGN_AGE table with a description of the code.

Notes:

Loaded by batch 2364, 06-29-2009 18:15

Entity Information

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

This table links the maturity code in the NORPAC.FOREIGN_AGE table with a description of the code.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key MATURITY_CODE NUMBER A one-digit numeric code used to identify the developmental stage of gonads. The meaning of the maturity code depends on the species for which the information is being collected.
100
MATURITY_CODE_DEFINITION VARCHAR2 A description of the maturity level associated with this code.
100
Primary Key SPECIES NUMBER A three-digit numeric code representing a marine species. This code is associated with species name in NORPAC.DOMESTIC_SPECIES (using the column name SPECIES_NO in place of SPECIES).

Attribute Details

MATURITY_CODE

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

A one-digit numeric code used to identify the developmental stage of gonads. The meaning of the maturity code depends on the species for which the information is being collected.

General Data Type: NUMBER

MATURITY_CODE_DEFINITION

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

A description of the maturity level associated with this code.

General Data Type: VARCHAR2

SPECIES

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

A three-digit numeric code representing a marine species. This code is associated with species name in NORPAC.DOMESTIC_SPECIES (using the column name SPECIES_NO in place of SPECIES).

General Data Type: NUMBER
Foreign Key Relations:

NORPAC.DOMESTIC_SPECIES

Catalog Details

Catalog Item ID: 9577
GUID: gov.noaa.nmfs.inport:9577
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2009-06-29 18:15+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