Metadata Rubric

100%

6 / 6

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

View: OBSPEC

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Observer Species Support Table

Description

Observer Species Support Table

Entity Type
Data View

Data Attribute / Type	Description
NESPP4 VARCHAR2	Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.
COMNAME VARCHAR2	Common name for the species.
MARKET VARCHAR2	Indicator if species code is for specific market category such as fins, liver, cheeks.
SCINAME VARCHAR2	Latin name for species.
PARTS VARCHAR2	Indicator if species code specifies part rather than whole. 1 = yes.
IAL VARCHAR2	Flag = 1 if species may appear on ial log in IAL table, 2 if uncommon species that may appear on ial log in IAL table
SPP VARCHAR2	Flag = 1 if species can appear on species record.
INC VARCHAR2	Flag = 1 if species can appear in incidental take table.
TARGET VARCHAR2	Flag = 1 if target species.
CETACEAN VARCHAR2	Flag = 1 if cetacean species.
TURTLE VARCHAR2	Flag = 1 if turtle species.
PINNIPED VARCHAR2	Flag = 1 if pinniped species.
SIGHT VARCHAR2	Flag = 1 if sighting appears on sighting log..
ROUND VARCHAR2	SPP: Indicator of type of weight. 0=unknown;.1=dressed, 2=round. Older data included 3=finned. Formerly Wgtmktcd. Prior to April 1994 all are 0 (unknown). OBSPEC: Flag = 1 or null if species can appear as round.
CRUSTACEAN VARCHAR2	Flag = 1 if crustacean.
SEXGT0 VARCHAR2	Indicator of whether sex should be defaulted to zero if not entered. For internal use.
SPECIES_ITIS VARCHAR2	The Integrated Taxonomic Information System (ITIS) serial number for a species.
SPECCOMMENTS VARCHAR2	Additional information on identified species.

Data Attribute / Type

Description

NESPP4
VARCHAR2

Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.

COMNAME
VARCHAR2

Common name for the species.

MARKET
VARCHAR2

Indicator if species code is for specific market category such as fins, liver, cheeks.

SCINAME
VARCHAR2

Latin name for species.

PARTS
VARCHAR2

Indicator if species code specifies part rather than whole. 1 = yes.

IAL
VARCHAR2

Flag = 1 if species may appear on ial log in IAL table, 2 if uncommon species that may appear on ial log in IAL table

SPP
VARCHAR2

Flag = 1 if species can appear on species record.

INC
VARCHAR2

Flag = 1 if species can appear in incidental take table.

TARGET
VARCHAR2

Flag = 1 if target species.

CETACEAN
VARCHAR2

Flag = 1 if cetacean species.

TURTLE
VARCHAR2

Flag = 1 if turtle species.

PINNIPED
VARCHAR2

Flag = 1 if pinniped species.

SIGHT
VARCHAR2

Flag = 1 if sighting appears on sighting log..

ROUND
VARCHAR2

SPP: Indicator of type of weight. 0=unknown;.1=dressed, 2=round. Older data included 3=finned. Formerly Wgtmktcd. Prior to April 1994 all are 0 (unknown). OBSPEC: Flag = 1 or null if species can appear as round.

CRUSTACEAN
VARCHAR2

Flag = 1 if crustacean.

SEXGT0
VARCHAR2

Indicator of whether sex should be defaulted to zero if not entered. For internal use.

SPECIES_ITIS
VARCHAR2

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

SPECCOMMENTS
VARCHAR2

Additional information on identified species.

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: OBSPEC
Short Name:	OBSPEC
Status:	Completed
Abstract:	Observer Species Support Table
Notes:	Loaded by batch 8950, 07-06-2016 08:24

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

Attribute Summary

	Name	Type	Description
100	NESPP4	VARCHAR2	Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.
100	COMNAME	VARCHAR2	Common name for the species.
100	MARKET	VARCHAR2	Indicator if species code is for specific market category such as fins, liver, cheeks.
100	SCINAME	VARCHAR2	Latin name for species.
100	PARTS	VARCHAR2	Indicator if species code specifies part rather than whole. 1 = yes.
100	IAL	VARCHAR2	Flag = 1 if species may appear on ial log in IAL table, 2 if uncommon species that may appear on ial log in IAL table
100	SPP	VARCHAR2	Flag = 1 if species can appear on species record.
100	INC	VARCHAR2	Flag = 1 if species can appear in incidental take table.
100	TARGET	VARCHAR2	Flag = 1 if target species.
100	CETACEAN	VARCHAR2	Flag = 1 if cetacean species.
100	TURTLE	VARCHAR2	Flag = 1 if turtle species.
100	PINNIPED	VARCHAR2	Flag = 1 if pinniped species.
100	SIGHT	VARCHAR2	Flag = 1 if sighting appears on sighting log..
100	ROUND	VARCHAR2	SPP: Indicator of type of weight. 0=unknown;.1=dressed, 2=round. Older data included 3=finned. Formerly Wgtmktcd. Prior to April 1994 all are 0 (unknown). OBSPEC: Flag = 1 or null if species can appear as round.
100	CRUSTACEAN	VARCHAR2	Flag = 1 if crustacean.
100	SEXGT0	VARCHAR2	Indicator of whether sex should be defaulted to zero if not entered. For internal use.
100	SPECIES_ITIS	VARCHAR2	The Integrated Taxonomic Information System (ITIS) serial number for a species.
100	SPECCOMMENTS	VARCHAR2	Additional information on identified species.

Name

Type

Description

100

NESPP4

VARCHAR2

Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.

100

COMNAME

VARCHAR2

Common name for the species.

100

MARKET

VARCHAR2

Indicator if species code is for specific market category such as fins, liver, cheeks.

100

SCINAME

VARCHAR2

Latin name for species.

100

PARTS

VARCHAR2

Indicator if species code specifies part rather than whole. 1 = yes.

100

IAL

VARCHAR2

Flag = 1 if species may appear on ial log in IAL table, 2 if uncommon species that may appear on ial log in IAL table

100

SPP

VARCHAR2

Flag = 1 if species can appear on species record.

100

INC

VARCHAR2

Flag = 1 if species can appear in incidental take table.

100

TARGET

VARCHAR2

Flag = 1 if target species.

100

CETACEAN

VARCHAR2

Flag = 1 if cetacean species.

100

TURTLE

VARCHAR2

Flag = 1 if turtle species.

100

PINNIPED

VARCHAR2

Flag = 1 if pinniped species.

100

SIGHT

VARCHAR2

Flag = 1 if sighting appears on sighting log..

100

ROUND

VARCHAR2

100

CRUSTACEAN

VARCHAR2

Flag = 1 if crustacean.

100

SEXGT0

VARCHAR2

Indicator of whether sex should be defaulted to zero if not entered. For internal use.

100

SPECIES_ITIS

VARCHAR2

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

100

SPECCOMMENTS

VARCHAR2

Additional information on identified species.

Attribute Details

NESPP4

CC ID: 331181

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.
General Data Type:	VARCHAR2

COMNAME

CC ID: 331191

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

MARKET

CC ID: 331192

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator if species code is for specific market category such as fins, liver, cheeks.
General Data Type:	VARCHAR2

SCINAME

CC ID: 331193

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	45
Required:	No
Primary Key:	No
Status:	Active
Description:	Latin name for species.
General Data Type:	VARCHAR2

PARTS

CC ID: 331194

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator if species code specifies part rather than whole. 1 = yes.
General Data Type:	VARCHAR2

IAL

CC ID: 331195

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag = 1 if species may appear on ial log in IAL table, 2 if uncommon species that may appear on ial log in IAL table
General Data Type:	VARCHAR2

SPP

CC ID: 331196

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag = 1 if species can appear on species record.
General Data Type:	VARCHAR2

INC

CC ID: 331197

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag = 1 if species can appear in incidental take table.
General Data Type:	VARCHAR2

TARGET

CC ID: 331198

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag = 1 if target species.
General Data Type:	VARCHAR2

CETACEAN

CC ID: 331182

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag = 1 if cetacean species.
General Data Type:	VARCHAR2

TURTLE

CC ID: 331183

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag = 1 if turtle species.
General Data Type:	VARCHAR2

PINNIPED

CC ID: 331184

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag = 1 if pinniped species.
General Data Type:	VARCHAR2

SIGHT

CC ID: 331185

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag = 1 if sighting appears on sighting log..
General Data Type:	VARCHAR2

ROUND

CC ID: 331186

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	SPP: Indicator of type of weight. 0=unknown;.1=dressed, 2=round. Older data included 3=finned. Formerly Wgtmktcd. Prior to April 1994 all are 0 (unknown). OBSPEC: Flag = 1 or null if species can appear as round.
General Data Type:	VARCHAR2

CRUSTACEAN

CC ID: 331187

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag = 1 if crustacean.
General Data Type:	VARCHAR2

SEXGT0

CC ID: 331188

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether sex should be defaulted to zero if not entered. For internal use.
General Data Type:	VARCHAR2

SPECIES_ITIS

CC ID: 331189

Seq. Order:	17
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

SPECCOMMENTS

CC ID: 331190

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
Description:	Additional information on identified species.
General Data Type:	VARCHAR2

Catalog Item ID:	33351
GUID:	gov.noaa.nmfs.inport:33351
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2016-07-06 08:24+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

View: OBSPEC

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

NESPP4

COMNAME

MARKET

SCINAME

PARTS

IAL

SPP

INC

TARGET

CETACEAN

TURTLE

PINNIPED

SIGHT

ROUND

CRUSTACEAN

SEXGT0

SPECIES_ITIS

SPECCOMMENTS

Catalog Details