Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fisheries Sampling Branch (FSB) > Observer and At Sea Monitor Database (OBDBS) >

View: OBSPECCONV

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

Item Identification

Title:	View: OBSPECCONV
Short Name:	OBSPECCONV
Status:	Completed
Abstract:	Observer Species Conversion Table
Notes:	Loaded by batch 9053, 07-27-2016 19:10

Entity Information

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	OBDBS
Description:	Observer Species Conversion Table

Data Attributes

Attribute Summary

	Name	Type	Description
100	NESPP3	VARCHAR2	Northeast commercial fish species NESPP3 codes. *Note these do not translate to the species level for the 6000-series of NESPP4 codes (i.e., there are multiple species NESPP3 code for all NESPP3 codes between 600 and 699). Collected for ASM where applicable.
100	NESPP4_OBS	VARCHAR2	Northeast commercial fish species NESPP4 codes contained in OBSPP and OBIAL and consistent with NESPP4 definitions contained in OBSPEC. *Note these NESPP4 codes do not necessarily correspond with CFDBS NESPP4 codes.
100	COMNAME	VARCHAR2	Common name for the species.
100	MKTNM_OBSPEC	VARCHAR2	Contains data from the MARKET column in the OBSPEC table for the corresponding NESPP4.
100	CATDISP_CODE	VARCHAR2	Catch Disposition from OBSPP and OBIAL tables (0 = discarded, 1 = kept, 9 = unknown).
100	CATDISP_DESC	VARCHAR2	Text description of the CATDISP_CODE column.
100	DRFLAG_CODE	VARCHAR2	Dressed Round from OBSPP and OBIAL tables (0 = unknown, 1 = dressed, 2 = round, 3 = finned).
100	DRFLAG_DESC	VARCHAR2	Text description of the DRFLAG_CODE field.
100	GRADE_CODE	VARCHAR2	Contains grade code that corresponds with NESPP4\|\|CATDISP\|\|DRFLAG combination from OBDBS. Rationale for the assignment of the GRADE_CODE is provided in GRADE_ASSIGN_COMMENT.
100	GRADE_DESC	VARCHAR2	Text description of the GRADE_CODE field.
100	NESPP4_REASSIGN	VARCHAR2	The reassigned NESPP4 code which corresponds to the species and assigned GRADE_CODE in SPECIES_ITIS_NE.
100	NESPP4_OUTPUT	VARCHAR2	The CFDBS NESPP4 code corresponding to the round grade code for a given species.
100	SPECIES_ITIS	VARCHAR2	The Integrated Taxonomic Information System (ITIS) serial number for a species.
100	SCIENTIFIC_NAME	VARCHAR2	The scientific name for a species.
100	MARKET_CODE	VARCHAR2	Market code to indicate the market category for a species sold to a dealer.
100	MARKET_DESC	VARCHAR2	Text description of the MARKET_CODE field.
100	UOM	VARCHAR2	Unit of measure.
100	CF_LNDLB_LIVLB	NUMBER	Conversion factor to raise the reported pounds landed to the live pounds landed for a given species.
100	CF_RPTQTY_LNDLB	NUMBER	Conversion factor to raise the reported quantity to the pounds landed for a given species.
100	CONV_FLAG	NUMBER	Indicates where the translation of the NESPP4_OBS\|\|CATDISP_CODE\|\|DRFLAG_CODE combination could be matched to an existing SPECIES_ITIS\|\|GRADE_CODE\|\|MARKET_CODE\|\|UOM record in the SPECIES_ITIS_NE table (1 = match, 0 = no match).
100	GRADE_ASSIGN_COMMENT	VARCHAR2	Provides description of the logic used to translate the NESPP4_OBS\|\|CATDISP_CODE\|\|DRFLAG_CODE combination to a CFDBS GRADE_CODE.
100	MKT_ASSIGN_COMMENT	VARCHAR2	Contains any notes related to finding a matching SPECIES_ITIS\|\|GRADE_CODE\|\|MARKET_CODE\|\|UOM record in the SPECIES_ITIS_NE table for the species and grade.

Name

Type

Description

100

NESPP3

VARCHAR2

Northeast commercial fish species NESPP3 codes. *Note these do not translate to the species level for the 6000-series of NESPP4 codes (i.e., there are multiple species NESPP3 code for all NESPP3 codes between 600 and 699). Collected for ASM where applicable.

100

NESPP4_OBS

VARCHAR2

Northeast commercial fish species NESPP4 codes contained in OBSPP and OBIAL and consistent with NESPP4 definitions contained in OBSPEC. *Note these NESPP4 codes do not necessarily correspond with CFDBS NESPP4 codes.

100

COMNAME

VARCHAR2

Common name for the species.

100

MKTNM_OBSPEC

VARCHAR2

Contains data from the MARKET column in the OBSPEC table for the corresponding NESPP4.

100

CATDISP_CODE

VARCHAR2

Catch Disposition from OBSPP and OBIAL tables (0 = discarded, 1 = kept, 9 = unknown).

100

CATDISP_DESC

VARCHAR2

Text description of the CATDISP_CODE column.

100

DRFLAG_CODE

VARCHAR2

Dressed Round from OBSPP and OBIAL tables (0 = unknown, 1 = dressed, 2 = round, 3 = finned).

100

DRFLAG_DESC

VARCHAR2

Text description of the DRFLAG_CODE field.

100

GRADE_CODE

VARCHAR2

Contains grade code that corresponds with NESPP4||CATDISP||DRFLAG combination from OBDBS. Rationale for the assignment of the GRADE_CODE is provided in GRADE_ASSIGN_COMMENT.

100

GRADE_DESC

VARCHAR2

Text description of the GRADE_CODE field.

100

NESPP4_REASSIGN

VARCHAR2

The reassigned NESPP4 code which corresponds to the species and assigned GRADE_CODE in SPECIES_ITIS_NE.

100

NESPP4_OUTPUT

VARCHAR2

The CFDBS NESPP4 code corresponding to the round grade code for a given species.

100

SPECIES_ITIS

VARCHAR2

The Integrated Taxonomic Information System (ITIS) serial number for a species.

100

SCIENTIFIC_NAME

VARCHAR2

The scientific name for a species.

100

MARKET_CODE

VARCHAR2

Market code to indicate the market category for a species sold to a dealer.

100

MARKET_DESC

VARCHAR2

Text description of the MARKET_CODE field.

100

UOM

VARCHAR2

Unit of measure.

100

CF_LNDLB_LIVLB

NUMBER

Conversion factor to raise the reported pounds landed to the live pounds landed for a given species.

100

CF_RPTQTY_LNDLB

NUMBER

Conversion factor to raise the reported quantity to the pounds landed for a given species.

100

CONV_FLAG

NUMBER

Indicates where the translation of the NESPP4_OBS||CATDISP_CODE||DRFLAG_CODE combination could be matched to an existing SPECIES_ITIS||GRADE_CODE||MARKET_CODE||UOM record in the SPECIES_ITIS_NE table (1 = match, 0 = no match).

100

GRADE_ASSIGN_COMMENT

VARCHAR2

Provides description of the logic used to translate the NESPP4_OBS||CATDISP_CODE||DRFLAG_CODE combination to a CFDBS GRADE_CODE.

100

MKT_ASSIGN_COMMENT

VARCHAR2

Contains any notes related to finding a matching SPECIES_ITIS||GRADE_CODE||MARKET_CODE||UOM record in the SPECIES_ITIS_NE table for the species and grade.

Attribute Details

NESPP3

CC ID: 334889

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Northeast commercial fish species NESPP3 codes. *Note these do not translate to the species level for the 6000-series of NESPP4 codes (i.e., there are multiple species NESPP3 code for all NESPP3 codes between 600 and 699). Collected for ASM where applicable.
General Data Type:	VARCHAR2

NESPP4_OBS

CC ID: 334900

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Northeast commercial fish species NESPP4 codes contained in OBSPP and OBIAL and consistent with NESPP4 definitions contained in OBSPEC. *Note these NESPP4 codes do not necessarily correspond with CFDBS NESPP4 codes.
General Data Type:	VARCHAR2

COMNAME

CC ID: 334904

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	35
Required:	No
Primary Key:	No
Status:	Active
Description:	Common name for the species.
General Data Type:	VARCHAR2

MKTNM_OBSPEC

CC ID: 334905

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Contains data from the MARKET column in the OBSPEC table for the corresponding NESPP4.
General Data Type:	VARCHAR2

CATDISP_CODE

CC ID: 334906

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Catch Disposition from OBSPP and OBIAL tables (0 = discarded, 1 = kept, 9 = unknown).
General Data Type:	VARCHAR2

CATDISP_DESC

CC ID: 334907

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Text description of the CATDISP_CODE column.
General Data Type:	VARCHAR2

DRFLAG_CODE

CC ID: 334908

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Dressed Round from OBSPP and OBIAL tables (0 = unknown, 1 = dressed, 2 = round, 3 = finned).
General Data Type:	VARCHAR2

DRFLAG_DESC

CC ID: 334909

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Text description of the DRFLAG_CODE field.
General Data Type:	VARCHAR2

GRADE_CODE

CC ID: 334910

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Contains grade code that corresponds with NESPP4\|\|CATDISP\|\|DRFLAG combination from OBDBS. Rationale for the assignment of the GRADE_CODE is provided in GRADE_ASSIGN_COMMENT.
General Data Type:	VARCHAR2

GRADE_DESC

CC ID: 334890

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	25
Required:	No
Primary Key:	No
Status:	Active
Description:	Text description of the GRADE_CODE field.
General Data Type:	VARCHAR2

NESPP4_REASSIGN

CC ID: 334891

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	Yes
Primary Key:	No
Status:	Active
Description:	The reassigned NESPP4 code which corresponds to the species and assigned GRADE_CODE in SPECIES_ITIS_NE.
General Data Type:	VARCHAR2

NESPP4_OUTPUT

CC ID: 334892

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	Yes
Primary Key:	No
Status:	Active
Description:	The CFDBS NESPP4 code corresponding to the round grade code for a given species.
General Data Type:	VARCHAR2

SPECIES_ITIS

CC ID: 334893

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	11
Required:	No
Primary Key:	No
Status:	Active
Description:	The Integrated Taxonomic Information System (ITIS) serial number for a species.
General Data Type:	VARCHAR2

SCIENTIFIC_NAME

CC ID: 334894

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	45
Required:	No
Primary Key:	No
Status:	Active
Description:	The scientific name for a species.
General Data Type:	VARCHAR2

MARKET_CODE

CC ID: 334895

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Market code to indicate the market category for a species sold to a dealer.
General Data Type:	VARCHAR2

MARKET_DESC

CC ID: 334896

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	25
Required:	No
Primary Key:	No
Status:	Active
Description:	Text description of the MARKET_CODE field.
General Data Type:	VARCHAR2

UOM

CC ID: 334897

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Unit of measure.
General Data Type:	VARCHAR2

CF_LNDLB_LIVLB

CC ID: 334898

Seq. Order:	18
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Status:	Active
Description:	Conversion factor to raise the reported pounds landed to the live pounds landed for a given species.
General Data Type:	NUMBER

CF_RPTQTY_LNDLB

CC ID: 334899

Seq. Order:	19
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Status:	Active
Description:	Conversion factor to raise the reported quantity to the pounds landed for a given species.
General Data Type:	NUMBER

CONV_FLAG

CC ID: 334901

Seq. Order:	20
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Status:	Active
Description:	Indicates where the translation of the NESPP4_OBS\|\|CATDISP_CODE\|\|DRFLAG_CODE combination could be matched to an existing SPECIES_ITIS\|\|GRADE_CODE\|\|MARKET_CODE\|\|UOM record in the SPECIES_ITIS_NE table (1 = match, 0 = no match).
General Data Type:	NUMBER

GRADE_ASSIGN_COMMENT

CC ID: 334902

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	200
Required:	No
Primary Key:	No
Status:	Active
Description:	Provides description of the logic used to translate the NESPP4_OBS\|\|CATDISP_CODE\|\|DRFLAG_CODE combination to a CFDBS GRADE_CODE.
General Data Type:	VARCHAR2

MKT_ASSIGN_COMMENT

CC ID: 334903

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	201
Required:	No
Primary Key:	No
Status:	Active
Description:	Contains any notes related to finding a matching SPECIES_ITIS\|\|GRADE_CODE\|\|MARKET_CODE\|\|UOM record in the SPECIES_ITIS_NE table for the species and grade.
General Data Type:	VARCHAR2

Catalog Details

Catalog Item ID:	33573
GUID:	gov.noaa.nmfs.inport:33573
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2016-07-27 19:10+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2016-07-28
Owner Org:	NEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2016-07-28
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2017-07-28