Search Help Show/Hide Menu
Metadata Rubric
67%
4 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Special Projects > Alternative catch monitoring of Alaskan groundf... > AFSC/FMA/NPRB Alternative Catch Monitoring Tabl... >

Table: ATL_LOV_SPECIES_GROUP

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

Summary

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SPECIES_CODE
NUMBER
PROHIB_SPECIES_GROUP_CODE
VARCHAR2
EGGS_REQUIRED_FLAG
VARCHAR2
SPECIES_COMP_SEX_REQUIRED_FLAG
VARCHAR2
WEIGHT_AND_NUMBER_REQD
VARCHAR2
COMMON_NAME
VARCHAR2
SCIENTIFIC_NAME
VARCHAR2
LENGTH_ACCEPTED_FLAG
VARCHAR2
AVIAN_SPECIES_CODE
VARCHAR2
GROUP_CODE
NUMBER
UNID_CODE
VARCHAR2

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

Title: Table: ATL_LOV_SPECIES_GROUP
Short Name: ATL_LOV_SPECIES_GROUP
Status: Completed
Notes:

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

Entity Information

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

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
67
 SPECIES_CODE NUMBER
67
 PROHIB_SPECIES_GROUP_CODE VARCHAR2
67
 EGGS_REQUIRED_FLAG VARCHAR2
67
 SPECIES_COMP_SEX_REQUIRED_FLAG VARCHAR2
67
 WEIGHT_AND_NUMBER_REQD VARCHAR2
67
 COMMON_NAME VARCHAR2
67
 SCIENTIFIC_NAME VARCHAR2
67
 LENGTH_ACCEPTED_FLAG VARCHAR2
67
 AVIAN_SPECIES_CODE VARCHAR2
67
 GROUP_CODE NUMBER
67
 UNID_CODE VARCHAR2

Attribute Details

SPECIES_CODE

CC ID: 112103
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 4
Scale: 0
Status: Active
General Data Type: NUMBER

PROHIB_SPECIES_GROUP_CODE

CC ID: 112106
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

EGGS_REQUIRED_FLAG

CC ID: 112107
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

SPECIES_COMP_SEX_REQUIRED_FLAG

CC ID: 112108
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

WEIGHT_AND_NUMBER_REQD

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

COMMON_NAME

CC ID: 112110
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 60
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

SCIENTIFIC_NAME

CC ID: 112111
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 60
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

LENGTH_ACCEPTED_FLAG

CC ID: 112112
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
General Data Type: VARCHAR2

AVIAN_SPECIES_CODE

CC ID: 112113
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

GROUP_CODE

CC ID: 112104
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
General Data Type: NUMBER

UNID_CODE

CC ID: 112105
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
General Data Type: VARCHAR2

Catalog Details

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