Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Data Management Systems (DMS) > Benthic Habitat Database >

Table: BENCAT

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

Item Identification

Title:	Table: BENCAT
Short Name:	BENCAT
Status:	Completed
Abstract:	Benthic Species Catch Table
Notes:	Loaded by batch 8234, 03-07-2016 15:12

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	BENTHIC
Description:	Benthic Species Catch Table

Data Attributes

Attribute Summary

	Name	Type	Description
100	RECID	NUMBER	Unique record identifier assigned to record. For Woods Hole data, this record id was extracted from the original benthic files loaded into ORACLE. For Sandy Hook data, this record id was assigned sequentially while loading the SH data into the benthic tables.
100	CRUISE_ID	VARCHAR2	Cruise ID formatted as 4 digit year, 2 character vessel code, and 2 character cruise number. This id was created from the original Woods Hole and Sandy Hook benthic codes for vessel and cruise.
100	STATION	VARCHAR2	Station number. For Sandy Hook data, this is a consecutive station number, 1 thru last station.
100	REPLICATE_NUMBER	VARCHAR2	Grab sample replicate number. Number of replicates that were taken.
100	FIXED_SITE	VARCHAR2	Fixed site designation used primarily for repeatedly sampled fixed monitoring sites. Used in Sandy Hook data only.
100	STRATUM	VARCHAR2	Stratum Code. A predefined area where a net dredge, or other piece of gear was deployed. Code consists of 2 characters. The benthic stratum codes match the offshore regular stratum group (Group 01) in the NEFSC offshore bottom trawl surveys. (SVDBS)
100	H_STRATUM	VARCHAR2	Hathaway stratum code.
100	GEAR_CODE	VARCHAR2	A two character field indicating the gear used for the particular sample. See table BENGEAR for gear code descriptions.
100	VESSEL_CODE	VARCHAR2	A two character vessel code as taken from the original Woods Hole or Sandy Hook benthic data. See table BENVESS for vessel code descriptions.
100	SCINAME	VARCHAR2	Scientific name for specimen.
100	NODC_CODE	VARCHAR2	NODC code for species.
100	WH_SPECIES_CODE	VARCHAR2	Species code assigned in the original Woos Hole benthic data. Code consists of 2-digit phylum, 1-digit class, 2-digit order, 2-digit family, 2-digit genus, 2-digit species. See table BENTXN for list of benthic taxonomic codes.
100	CATCHWGT	NUMBER	Weight of catch. For Woods Hole catch data (BENCAT), this weight is the expanded catch weight using the expansion factors from table BENCONV. For Woods Hole catalog data (BENCATALOG), this weight is not expanded.
100	CATCHNUM	NUMBER	Number of individuals in catch. For Woods Hole catch data (BENCAT), this weight is the expanded catch number using the expansion factors from table BENCONV. For Woods Hole catalog data (BENCATALOG), this number is not expanded.
100	CONDITION	VARCHAR2	Condition of Animal. 0 = dead, 1 = alive. This code is only used for Woods Hole data.
100	ORIGINAL_BENTHIC_KEY	VARCHAR2	Original benthic key, for Woods Hole data 2 character year, 2 character vessel code, 2 character cruise number, 4 character station, 2 character gear code, 2 character collection (replicate). For Sandy Hook data, 6 character cruise number (CRC), 4 character station (CON), 2 character grab (GRAB).
100	DATA_SOURCE	VARCHAR2	Laboratory where sampling program was directed and data processed. (SH=Sandy Hook, WH=Woods Hole)
100	CATALOG	VARCHAR2	For Woods Hole data, indicates if this sample is also in the benthic catalog. C indicates a record for this sample is in the benthic catalog, BENCATALOG.
100	DOE	DATE	Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
100	UOE	VARCHAR2	The Oracle username of the individual who entered the new record.
100	DOC	DATE	Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
100	UOC	VARCHAR2	The Oracle username of the individual who changed the current record.

Name

Type

Description

100

RECID

NUMBER

Unique record identifier assigned to record. For Woods Hole data, this record id was extracted from the original benthic files loaded into ORACLE. For Sandy Hook data, this record id was assigned sequentially while loading the SH data into the benthic tables.

100

CRUISE_ID

VARCHAR2

Cruise ID formatted as 4 digit year, 2 character vessel code, and 2 character cruise number. This id was created from the original Woods Hole and Sandy Hook benthic codes for vessel and cruise.

100

STATION

VARCHAR2

Station number. For Sandy Hook data, this is a consecutive station number, 1 thru last station.

100

REPLICATE_NUMBER

VARCHAR2

Grab sample replicate number. Number of replicates that were taken.

100

FIXED_SITE

VARCHAR2

Fixed site designation used primarily for repeatedly sampled fixed monitoring sites. Used in Sandy Hook data only.

100

STRATUM

VARCHAR2

Stratum Code. A predefined area where a net dredge, or other piece of gear was deployed. Code consists of 2 characters. The benthic stratum codes match the offshore regular stratum group (Group 01) in the NEFSC offshore bottom trawl surveys. (SVDBS)

100

H_STRATUM

VARCHAR2

Hathaway stratum code.

100

GEAR_CODE

VARCHAR2

A two character field indicating the gear used for the particular sample. See table BENGEAR for gear code descriptions.

100

VESSEL_CODE

VARCHAR2

A two character vessel code as taken from the original Woods Hole or Sandy Hook benthic data. See table BENVESS for vessel code descriptions.

100

SCINAME

VARCHAR2

Scientific name for specimen.

100

NODC_CODE

VARCHAR2

NODC code for species.

100

WH_SPECIES_CODE

VARCHAR2

Species code assigned in the original Woos Hole benthic data. Code consists of 2-digit phylum, 1-digit class, 2-digit order, 2-digit family, 2-digit genus, 2-digit species. See table BENTXN for list of benthic taxonomic codes.

100

CATCHWGT

NUMBER

Weight of catch. For Woods Hole catch data (BENCAT), this weight is the expanded catch weight using the expansion factors from table BENCONV. For Woods Hole catalog data (BENCATALOG), this weight is not expanded.

100

CATCHNUM

NUMBER

Number of individuals in catch. For Woods Hole catch data (BENCAT), this weight is the expanded catch number using the expansion factors from table BENCONV. For Woods Hole catalog data (BENCATALOG), this number is not expanded.

100

CONDITION

VARCHAR2

Condition of Animal. 0 = dead, 1 = alive. This code is only used for Woods Hole data.

100

ORIGINAL_BENTHIC_KEY

VARCHAR2

Original benthic key, for Woods Hole data 2 character year, 2 character vessel code, 2 character cruise number, 4 character station, 2 character gear code, 2 character collection (replicate). For Sandy Hook data, 6 character cruise number (CRC), 4 character station (CON), 2 character grab (GRAB).

100

DATA_SOURCE

VARCHAR2

Laboratory where sampling program was directed and data processed. (SH=Sandy Hook, WH=Woods Hole)

100

CATALOG

VARCHAR2

For Woods Hole data, indicates if this sample is also in the benthic catalog. C indicates a record for this sample is in the benthic catalog, BENCATALOG.

100

DOE

DATE

Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).

100

UOE

VARCHAR2

The Oracle username of the individual who entered the new record.

100

DOC

DATE

Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).

100

UOC

VARCHAR2

The Oracle username of the individual who changed the current record.

Attribute Details

RECID

CC ID: 301274

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	8
Scale:	0
Status:	Active
Description:	Unique record identifier assigned to record. For Woods Hole data, this record id was extracted from the original benthic files loaded into ORACLE. For Sandy Hook data, this record id was assigned sequentially while loading the SH data into the benthic tables.
General Data Type:	NUMBER

CRUISE_ID

CC ID: 301285

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Cruise ID formatted as 4 digit year, 2 character vessel code, and 2 character cruise number. This id was created from the original Woods Hole and Sandy Hook benthic codes for vessel and cruise.
General Data Type:	VARCHAR2

STATION

CC ID: 301289

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Station number. For Sandy Hook data, this is a consecutive station number, 1 thru last station.
General Data Type:	VARCHAR2

REPLICATE_NUMBER

CC ID: 301290

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Grab sample replicate number. Number of replicates that were taken.
General Data Type:	VARCHAR2

FIXED_SITE

CC ID: 301291

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Fixed site designation used primarily for repeatedly sampled fixed monitoring sites. Used in Sandy Hook data only.
General Data Type:	VARCHAR2

STRATUM

CC ID: 301292

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Stratum Code. A predefined area where a net dredge, or other piece of gear was deployed. Code consists of 2 characters. The benthic stratum codes match the offshore regular stratum group (Group 01) in the NEFSC offshore bottom trawl surveys. (SVDBS)
General Data Type:	VARCHAR2

H_STRATUM

CC ID: 301293

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Hathaway stratum code.
General Data Type:	VARCHAR2

GEAR_CODE

CC ID: 301294

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	A two character field indicating the gear used for the particular sample. See table BENGEAR for gear code descriptions.
General Data Type:	VARCHAR2

VESSEL_CODE

CC ID: 301295

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	A two character vessel code as taken from the original Woods Hole or Sandy Hook benthic data. See table BENVESS for vessel code descriptions.
General Data Type:	VARCHAR2

SCINAME

CC ID: 301275

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	40
Required:	No
Primary Key:	No
Status:	Active
Description:	Scientific name for specimen.
General Data Type:	VARCHAR2

NODC_CODE

CC ID: 301276

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	NODC code for species.
General Data Type:	VARCHAR2

WH_SPECIES_CODE

CC ID: 301277

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	Species code assigned in the original Woos Hole benthic data. Code consists of 2-digit phylum, 1-digit class, 2-digit order, 2-digit family, 2-digit genus, 2-digit species. See table BENTXN for list of benthic taxonomic codes.
General Data Type:	VARCHAR2

CATCHWGT

CC ID: 301278

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	9
Scale:	3
Status:	Active
Description:	Weight of catch. For Woods Hole catch data (BENCAT), this weight is the expanded catch weight using the expansion factors from table BENCONV. For Woods Hole catalog data (BENCATALOG), this weight is not expanded.
General Data Type:	NUMBER

CATCHNUM

CC ID: 301279

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	8
Scale:	0
Status:	Active
Description:	Number of individuals in catch. For Woods Hole catch data (BENCAT), this weight is the expanded catch number using the expansion factors from table BENCONV. For Woods Hole catalog data (BENCATALOG), this number is not expanded.
General Data Type:	NUMBER

CONDITION

CC ID: 301280

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Condition of Animal. 0 = dead, 1 = alive. This code is only used for Woods Hole data.
General Data Type:	VARCHAR2

ORIGINAL_BENTHIC_KEY

CC ID: 301281

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	14
Required:	No
Primary Key:	No
Status:	Active
Description:	Original benthic key, for Woods Hole data 2 character year, 2 character vessel code, 2 character cruise number, 4 character station, 2 character gear code, 2 character collection (replicate). For Sandy Hook data, 6 character cruise number (CRC), 4 character station (CON), 2 character grab (GRAB).
General Data Type:	VARCHAR2

DATA_SOURCE

CC ID: 301282

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Laboratory where sampling program was directed and data processed. (SH=Sandy Hook, WH=Woods Hole)
General Data Type:	VARCHAR2

CATALOG

CC ID: 301283

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	For Woods Hole data, indicates if this sample is also in the benthic catalog. C indicates a record for this sample is in the benthic catalog, BENCATALOG.
General Data Type:	VARCHAR2

DOE

CC ID: 301284

Seq. Order:	19
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
General Data Type:	DATE

UOE

CC ID: 301286

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	The Oracle username of the individual who entered the new record.
General Data Type:	VARCHAR2

DOC

CC ID: 301287

Seq. Order:	21
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
General Data Type:	DATE

UOC

CC ID: 301288

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	The Oracle username of the individual who changed the current record.
General Data Type:	VARCHAR2

Catalog Details

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