Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Data Management Systems (DMS) > Commercial Fisheries Database Biological Sample... >

View: CFSPP

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33432 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Commercial Fisheries Species Support Table.

Description

Commercial Fisheries Species Support Table.

Entity Type
Data View

Data Attribute / Type	Description
SPPNM VARCHAR2	Species common name.
MKTNM VARCHAR2	Market category name for a particular species.
SPPNM8 VARCHAR2	Species name abbreviation.
SPPNM3 VARCHAR2	NAFO Species name abbreviation.
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.
MKTCAT VARCHAR2	Market category of the 3-digit species code.
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.
WASHSPP VARCHAR2	The Washington Species code with market category.
WHSPP VARCHAR2	The 3 digit commercial species code developed by the Woods Hole lab. See CFDBS Species Table (CFSPP) for actual codes.
NAFOSPP VARCHAR2	Northwest Atlantic Fisheries Organization (NAFO) Species code.
SVSPP VARCHAR2	Northeast Resource Surveys Species code. See SVDBS Species Table for actual codes.
NAFSPGRP VARCHAR2	NAFO Species Group.
NECNV NUMBER	Northeast conversion factor for converting landed to live weight.
WASHCNV NUMBER	Washington conversion factor to convert landed to live weight.
MINPR NUMBER	The minimum acceptable price per pound for a particular species.
MAXPR NUMBER	The maximum acceptable price per pound for a particular species.
DOC DATE	The date of the last change to this record.

Data Attribute / Type

Description

SPPNM
VARCHAR2

Species common name.

MKTNM
VARCHAR2

Market category name for a particular species.

SPPNM8
VARCHAR2

Species name abbreviation.

SPPNM3
VARCHAR2

NAFO Species name abbreviation.

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.

MKTCAT
VARCHAR2

Market category of the 3-digit species code.

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.

WASHSPP
VARCHAR2

The Washington Species code with market category.

WHSPP
VARCHAR2

The 3 digit commercial species code developed by the Woods Hole lab. See CFDBS Species Table (CFSPP) for actual codes.

NAFOSPP
VARCHAR2

Northwest Atlantic Fisheries Organization (NAFO) Species code.

SVSPP
VARCHAR2

Northeast Resource Surveys Species code. See SVDBS Species Table for actual codes.

NAFSPGRP
VARCHAR2

NAFO Species Group.

NECNV
NUMBER

Northeast conversion factor for converting landed to live weight.

WASHCNV
NUMBER

Washington conversion factor to convert landed to live weight.

MINPR
NUMBER

The minimum acceptable price per pound for a particular species.

MAXPR
NUMBER

The maximum acceptable price per pound for a particular species.

DOC
DATE

The date of the last change to this record.

No Child Items for this record.

No contact information is available for this record.

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

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 Type:	Data View
Active Version?:	Yes
Schema Name:	CFDBS
Description:	Commercial Fisheries Species Support Table.

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.

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

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

CC ID: 331976

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

CC ID: 331985

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

CC ID: 331986

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

CC ID: 331987

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

CC ID: 331988

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

CC ID: 331989

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

CC ID: 331990

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

CC ID: 331991

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

CC ID: 331992

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

CC ID: 331977

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

CC ID: 331978

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

CC ID: 331979

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

CC ID: 331980

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

CC ID: 331981

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

CC ID: 331982

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

CC ID: 331983

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

CC ID: 331984

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 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

View: CFSPP

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

SPPNM

MKTNM

SPPNM8

SPPNM3

NESPP3

MKTCAT

NESPP4

WASHSPP

WHSPP

NAFOSPP

SVSPP

NAFSPGRP

NECNV

WASHCNV

MINPR

MAXPR

DOC

Catalog Details