Table: DOMESTIC_SPECIES
Alaska Fisheries Science Center
Entity
(ENT)
| ID: 9557
| Published / External
Created: 2009-06-29
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 9556
ID: 9557
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Table: DOMESTIC_SPECIES |
---|---|
Short Name | DOMESTIC_SPECIES |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
A table which provides all of the three-digit numeric codes assigned by the NMFS Observer Program, complete with their common name, scientific name, associated RACE Division species code, and the maximum and minimum weights and lengths typically reported by observers. |
* Purpose | |
Notes |
Loaded by batch 2364, 06-29-2009 18:15 |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | Alaska Fisheries Science Center |
---|---|
• » City | Seattle |
• » State/Province | WA |
• Country | USA |
• » Location Description |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | Y |
Alias | |
Schema Name | NORPAC |
» Description |
A table which provides all of the three-digit numeric codes assigned by the NMFS Observer Program, complete with their common name, scientific name, associated RACE Division species code, and the maximum and minimum weights and lengths typically reported by observers. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | Yes | SPECIES_NO | NUMBER | A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a SPECIES_NAME and a SCIENTIFIC_NAME. |
100 | Yes | No | SPECIES_NAME | VARCHAR2 | The common name of the marine organism. |
100 | No | No | PROHIB | VARCHAR2 | A one-digit alpha code indicating whether the species is allowed to be retained in the Alaska groundfish fishery and the West Coast Pacific whiting fishery, where: Y = Yes; N = No. |
100 | No | No | GENKEY | VARCHAR2 | The prohibited species grouping associated with the SPECIES_NAME. This fieldis NULL unless PROHIB = "Y". The groupings are: HALIBUT, KINGCRAB, OTHCRAB,SALMON. |
100 | No | No | RACE_SPECIE_NUM | VARCHAR2 | A 5-digit numeric code assigned by the RACE division that is associated withthe SPECIES_NAME |
100 | No | No | SCIENTIFIC_NAME | VARCHAR2 | The scientific name associated with the common SPECIES_NAME. |
100 | No | No | MAX_WT | NUMBER | The maximum weight expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_SPCOMP_DETAIL table. |
100 | No | No | MIN_WT | NUMBER | The minimum weight expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_SPCOMP_DETAIL table. |
100 | No | No | MAX_LEN | NUMBER | The maximum length expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC_DOMESTIC_LENGTH table. |
100 | No | No | MIN_LEN | NUMBER | The minimum length expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_LENGTH table. |
100 | Yes | No | NICKNAME | VARCHAR2 | Nickname is the same as the common SPECIES_NAME. |
100 | No | No | AGGREGATION | VARCHAR2 | Indicates species aggregation and possible species_no in the aggregation. |
100 | No | No | AGE_TRAY | NUMBER | For internal use by Age Determination Unit. |
100 | No | No | AGE_TRAY_X | VARCHAR2 | For internal use by Age Determination Unit. |
100 | No | No | AGE_TRAY_Y | VARCHAR2 | For internal use by Age Determination Unit. |
100 | No | No | AGE_TRAY_GOA | NUMBER | For internal use by Age Determination Unit. |
100 | No | No | AGE_TRAY_GOA_X | VARCHAR2 | For internal use by Age Determination Unit. |
100 | No | No | AGE_TRAY_GOA_Y | VARCHAR2 | For internal use by Age Determination Unit. |
Attribute Details
Attribute Name | SPECIES_NO |
---|---|
Seq. Order | 1 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a SPECIES_NAME and a SCIENTIFIC_NAME. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SPECIES_NAME |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 60 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The common name of the marine organism. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PROHIB |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A one-digit alpha code indicating whether the species is allowed to be retained in the Alaska groundfish fishery and the West Coast Pacific whiting fishery, where: Y = Yes; N = No. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GENKEY |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The prohibited species grouping associated with the SPECIES_NAME. This fieldis NULL unless PROHIB = "Y". The groupings are: HALIBUT, KINGCRAB, OTHCRAB,SALMON. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RACE_SPECIE_NUM |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A 5-digit numeric code assigned by the RACE division that is associated withthe SPECIES_NAME |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SCIENTIFIC_NAME |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 41 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The scientific name associated with the common SPECIES_NAME. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MAX_WT |
---|---|
Seq. Order | 7 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 11 |
Scale | 2 |
Status | Active |
Description |
The maximum weight expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_SPCOMP_DETAIL table. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MIN_WT |
---|---|
Seq. Order | 8 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 11 |
Scale | 2 |
Status | Active |
Description |
The minimum weight expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_SPCOMP_DETAIL table. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MAX_LEN |
---|---|
Seq. Order | 9 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
The maximum length expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC_DOMESTIC_LENGTH table. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MIN_LEN |
---|---|
Seq. Order | 10 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 0 |
Status | Active |
Description |
The minimum length expected for an individual of this species. This value comes from several sources, the primary one being the NORPAC.DOMESTIC_LENGTH table. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NICKNAME |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR2 |
Max Length | 60 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Nickname is the same as the common SPECIES_NAME. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AGGREGATION |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | 60 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates species aggregation and possible species_no in the aggregation. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AGE_TRAY |
---|---|
Seq. Order | 13 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
Scale | 0 |
Status | Active |
Description |
For internal use by Age Determination Unit. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AGE_TRAY_X |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
For internal use by Age Determination Unit. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AGE_TRAY_Y |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
For internal use by Age Determination Unit. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AGE_TRAY_GOA |
---|---|
Seq. Order | 16 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
Scale | 0 |
Status | Active |
Description |
For internal use by Age Determination Unit. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AGE_TRAY_GOA_X |
---|---|
Seq. Order | 17 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
For internal use by Age Determination Unit. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AGE_TRAY_GOA_Y |
---|---|
Seq. Order | 18 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
For internal use by Age Determination Unit. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 9557 |
---|---|
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 Workflow State | Published / External |
Metadata Last Review Date | 2016-05-18 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2017-05-18 |
Tags |
---|