View: CFSPP
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33432 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | View: CFSPP |
---|---|
Short Name: | CFSPP |
Status: | Completed |
Abstract: |
Commercial Fisheries Species Support Table. |
Notes: |
Loaded by batch 8988, 07-11-2016 08:41 |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | CFDBS |
Description: |
Commercial Fisheries Species Support Table. |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
SPPNM | VARCHAR2 | Species common name. | |
100
|
MKTNM | VARCHAR2 | Market category name for a particular species. | |
100
|
SPPNM8 | VARCHAR2 | Species name abbreviation. | |
100
|
SPPNM3 | VARCHAR2 | NAFO Species name abbreviation. | |
100
|
NESPP3 | VARCHAR2 | The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. See CFDBS Species Table (CFSPP) for actual codes. | |
100
|
MKTCAT | VARCHAR2 | Market category of the 3-digit species code. | |
100
|
NESPP4 | VARCHAR2 | The 4-digit Northeast Species code; the fourth digit represents market category. See CFDBS Species Table (CFSPP) for actual codes. For discard species in the CFDISCyyyy and WODISCyy views, NESPP4 is redefined as NESPP3 preceded by a 9, e.g. yellowtail flounder is 9123. | |
100
|
WASHSPP | VARCHAR2 | The Washington Species code with market category. | |
100
|
WHSPP | VARCHAR2 | The 3 digit commercial species code developed by the Woods Hole lab. See CFDBS Species Table (CFSPP) for actual codes. | |
100
|
NAFOSPP | VARCHAR2 | Northwest Atlantic Fisheries Organization (NAFO) Species code. | |
100
|
SVSPP | VARCHAR2 | Northeast Resource Surveys Species code. See SVDBS Species Table for actual codes. | |
100
|
NAFSPGRP | VARCHAR2 | NAFO Species Group. | |
100
|
NECNV | NUMBER | Northeast conversion factor for converting landed to live weight. | |
100
|
WASHCNV | NUMBER | Washington conversion factor to convert landed to live weight. | |
100
|
MINPR | NUMBER | The minimum acceptable price per pound for a particular species. | |
100
|
MAXPR | NUMBER | The maximum acceptable price per pound for a particular species. | |
100
|
DOC | DATE | The date of the last change to this record. |
Attribute Details
SPPNM
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Species common name. |
General Data Type: | VARCHAR2 |
MKTNM
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Market category name for a particular species. |
General Data Type: | VARCHAR2 |
SPPNM8
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Species name abbreviation. |
General Data Type: | VARCHAR2 |
SPPNM3
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
NAFO Species name abbreviation. |
General Data Type: | VARCHAR2 |
NESPP3
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. See CFDBS Species Table (CFSPP) for actual codes. |
General Data Type: | VARCHAR2 |
MKTCAT
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Market category of the 3-digit species code. |
General Data Type: | VARCHAR2 |
NESPP4
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The 4-digit Northeast Species code; the fourth digit represents market category. See CFDBS Species Table (CFSPP) for actual codes. For discard species in the CFDISCyyyy and WODISCyy views, NESPP4 is redefined as NESPP3 preceded by a 9, e.g. yellowtail flounder is 9123. |
General Data Type: | VARCHAR2 |
WASHSPP
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The Washington Species code with market category. |
General Data Type: | VARCHAR2 |
WHSPP
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The 3 digit commercial species code developed by the Woods Hole lab. See CFDBS Species Table (CFSPP) for actual codes. |
General Data Type: | VARCHAR2 |
NAFOSPP
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Northwest Atlantic Fisheries Organization (NAFO) Species code. |
General Data Type: | VARCHAR2 |
SVSPP
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Northeast Resource Surveys Species code. See SVDBS Species Table for actual codes. |
General Data Type: | VARCHAR2 |
NAFSPGRP
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
NAFO Species Group. |
General Data Type: | VARCHAR2 |
NECNV
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 2 |
Status: | Active |
Description: |
Northeast conversion factor for converting landed to live weight. |
General Data Type: | NUMBER |
WASHCNV
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 4 |
Scale: | 2 |
Status: | Active |
Description: |
Washington conversion factor to convert landed to live weight. |
General Data Type: | NUMBER |
MINPR
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
The minimum acceptable price per pound for a particular species. |
General Data Type: | NUMBER |
MAXPR
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
The maximum acceptable price per pound for a particular species. |
General Data Type: | NUMBER |
DOC
Seq. Order: | 17 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The date of the last change to this record. |
General Data Type: | DATE |
Catalog Details
Catalog Item ID: | 33432 |
---|---|
GUID: | gov.noaa.nmfs.inport:33432 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-07-11 08:41+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-07-11 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-07-11 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-07-11 |