Metadata Rubric

100%

6 / 6

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

Table: BENCATALOG

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Benthic Species Catalog Table (Woods Hole data only)

Description

Benthic Species Catalog Table (Woods Hole data only)

Entity Type
Data Table

Data Attribute / Type	Description
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.
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.
STATION VARCHAR2	Station number. For Sandy Hook data, this is a consecutive station number, 1 thru last station.
REPLICATE_NUMBER VARCHAR2	Grab sample replicate number. Number of replicates that were taken.
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)
H_STRATUM VARCHAR2	Hathaway stratum code.
GEAR_CODE VARCHAR2	A two character field indicating the gear used for the particular sample. See table BENGEAR for gear code descriptions.
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.
SCINAME VARCHAR2	Scientific name for specimen.
NODC_CODE VARCHAR2	NODC code for species.
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.
CATCHWGT NUMBER	Weight of catch in grams. 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.
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.
CONDITION VARCHAR2	Condition of Animal. 0 = dead, 1 = alive. This code is only used for Woods Hole data.
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).
DATA_SOURCE VARCHAR2	Laboratory where sampling program was directed and data processed. (SH=Sandy Hook, WH=Woods Hole)
DOE DATE	Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS).
UOE VARCHAR2	The Oracle username of the individual who entered the new record.
DOC DATE	Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS).
UOC VARCHAR2	The Oracle username of the individual who changed the current record.

Data Attribute / Type

Description

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.

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.

STATION
VARCHAR2

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

REPLICATE_NUMBER
VARCHAR2

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

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)

H_STRATUM
VARCHAR2

Hathaway stratum code.

GEAR_CODE
VARCHAR2

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

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.

SCINAME
VARCHAR2

Scientific name for specimen.

NODC_CODE
VARCHAR2

NODC code for species.

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.

CATCHWGT
NUMBER

Weight of catch in grams. 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.

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.

CONDITION
VARCHAR2

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

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

DATA_SOURCE
VARCHAR2

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

DOE
DATE

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

UOE
VARCHAR2

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

DOC
DATE

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

UOC
VARCHAR2

The Oracle username of the individual who changed the current 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:	Table: BENCATALOG
Short Name:	BENCATALOG
Status:	Completed
Abstract:	Benthic Species Catalog Table (Woods Hole data only)
Notes:	Loaded by batch 8253, 03-08-2016 14:32

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	BENTHIC
Description:	Benthic Species Catalog Table (Woods Hole data only)

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	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 in grams. 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	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

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

STRATUM

VARCHAR2

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

100

CATCHWGT

NUMBER

100

CATCHNUM

NUMBER

100

CONDITION

VARCHAR2

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

100

ORIGINAL_BENTHIC_KEY

VARCHAR2

100

DATA_SOURCE

VARCHAR2

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

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

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

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	8
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: 301507

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

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

STRATUM

CC ID: 301509

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

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

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

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

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

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

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

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	9
Scale:	3
Status:	Active
Description:	Weight of catch in grams. 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: 301498

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

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

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

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

DOE

CC ID: 301502

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

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

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

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 changed the current record.
General Data Type:	VARCHAR2

Catalog Item ID:	31069
GUID:	gov.noaa.nmfs.inport:31069
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2016-03-08 14:32+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

Table: BENCATALOG

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

RECID

CRUISE_ID

STATION

REPLICATE_NUMBER

STRATUM

H_STRATUM

GEAR_CODE

VESSEL_CODE

SCINAME

NODC_CODE

WH_SPECIES_CODE

CATCHWGT

CATCHNUM

CONDITION

ORIGINAL_BENTHIC_KEY

DATA_SOURCE

DOE

UOE

DOC

UOC

Catalog Details