Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
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 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Observer Species Conversion Table

Description

Observer Species Conversion Table

Entity Information

Entity Type
Data View

Data Attribute / Type Description
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.
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.
COMNAME
VARCHAR2 		Common name for the species.
MKTNM_OBSPEC
VARCHAR2 		Contains data from the MARKET column in the OBSPEC table for the corresponding NESPP4.
CATDISP_CODE
VARCHAR2 		Catch Disposition from OBSPP and OBIAL tables (0 = discarded, 1 = kept, 9 = unknown).
CATDISP_DESC
VARCHAR2 		Text description of the CATDISP_CODE column.
DRFLAG_CODE
VARCHAR2 		Dressed Round from OBSPP and OBIAL tables (0 = unknown, 1 = dressed, 2 = round, 3 = finned).
DRFLAG_DESC
VARCHAR2 		Text description of the DRFLAG_CODE field.
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.
GRADE_DESC
VARCHAR2 		Text description of the GRADE_CODE field.
NESPP4_REASSIGN
VARCHAR2 		The reassigned NESPP4 code which corresponds to the species and assigned GRADE_CODE in SPECIES_ITIS_NE.
NESPP4_OUTPUT
VARCHAR2 		The CFDBS NESPP4 code corresponding to the round grade code for a given species.
SPECIES_ITIS
VARCHAR2 		The Integrated Taxonomic Information System (ITIS) serial number for a species.
SCIENTIFIC_NAME
VARCHAR2 		The scientific name for a species.
MARKET_CODE
VARCHAR2 		Market code to indicate the market category for a species sold to a dealer.
MARKET_DESC
VARCHAR2 		Text description of the MARKET_CODE field.
UOM
VARCHAR2 		Unit of measure.
CF_LNDLB_LIVLB
NUMBER 		Conversion factor to raise the reported pounds landed to the live pounds landed for a given species.
CF_RPTQTY_LNDLB
NUMBER 		Conversion factor to raise the reported quantity to the pounds landed for a given species.
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).
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.
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.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

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

Rubric Score Primary Key? 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