Metadata Rubric

100%

6 / 6

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

Table: BENCONV

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Benthic Conversion Sorting Factors Support Table (Woods Hole data only)

Description

Benthic Conversion Sorting Factors Support Table (Woods Hole data only)

Entity Type
Data Table

Data Attribute / Type	Description
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.
REPLICATE_NUMBER VARCHAR2	Grab sample replicate number.
GEAR_CODE VARCHAR2	A two character field indicating the gear used for the particular sample. See table BENGEAR for gear code descriptions.
SCINAME VARCHAR2	Scientific name for specimen.
CONV NUMBER	Expansion conversion factor used to adjust weight and number in Benthic Catch Table (BENCAT) to 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.
ORIGWGT NUMBER	Original weight.
ORIGNUM NUMBER	Original number.
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).
RECID NUMBER	Unique record identifier assigned to record.
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

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.

REPLICATE_NUMBER
VARCHAR2

Grab sample replicate number.

GEAR_CODE
VARCHAR2

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

SCINAME
VARCHAR2

Scientific name for specimen.

CONV
NUMBER

Expansion conversion factor used to adjust weight and number in Benthic Catch Table (BENCAT) to 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.

ORIGWGT
NUMBER

Original weight.

ORIGNUM
NUMBER

Original number.

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

RECID
NUMBER

Unique record identifier assigned to record.

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: BENCONV
Short Name:	BENCONV
Status:	Completed
Abstract:	Benthic Conversion Sorting Factors Support Table (Woods Hole data only)
Notes:	Loaded by batch 8235, 03-07-2016 15:27

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	BENTHIC
Description:	Benthic Conversion Sorting Factors Support Table (Woods Hole data only)

Attribute Summary

	Name	Type	Description
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.
100	REPLICATE_NUMBER	VARCHAR2	Grab sample replicate number.
100	GEAR_CODE	VARCHAR2	A two character field indicating the gear used for the particular sample. See table BENGEAR for gear code descriptions.
100	SCINAME	VARCHAR2	Scientific name for specimen.
100	CONV	NUMBER	Expansion conversion factor used to adjust weight and number in Benthic Catch Table (BENCAT) to 100%.
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	ORIGWGT	NUMBER	Original weight.
100	ORIGNUM	NUMBER	Original number.
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).
100	RECID	NUMBER	Unique record identifier assigned to record.
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

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.

100

REPLICATE_NUMBER

VARCHAR2

Grab sample replicate number.

100

GEAR_CODE

VARCHAR2

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

100

SCINAME

VARCHAR2

Scientific name for specimen.

100

CONV

NUMBER

Expansion conversion factor used to adjust weight and number in Benthic Catch Table (BENCAT) to 100%.

100

WH_SPECIES_CODE

VARCHAR2

100

ORIGWGT

NUMBER

Original weight.

100

ORIGNUM

NUMBER

Original number.

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

100

RECID

NUMBER

Unique record identifier assigned to record.

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

CRUISE_ID

CC ID: 301325

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

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Station number.
General Data Type:	VARCHAR2

REPLICATE_NUMBER

CC ID: 301333

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Grab sample replicate number.
General Data Type:	VARCHAR2

GEAR_CODE

CC ID: 301334

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

SCINAME

CC ID: 301335

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

CONV

CC ID: 301336

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	7
Scale:	2
Status:	Active
Description:	Expansion conversion factor used to adjust weight and number in Benthic Catch Table (BENCAT) to 100%.
General Data Type:	NUMBER

WH_SPECIES_CODE

CC ID: 301337

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

ORIGWGT

CC ID: 301338

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	10
Scale:	2
Status:	Active
Description:	Original weight.
General Data Type:	NUMBER

ORIGNUM

CC ID: 301339

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Original number.
General Data Type:	NUMBER

ORIGINAL_BENTHIC_KEY

CC ID: 301326

Seq. Order:	10
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).
General Data Type:	VARCHAR2

RECID

CC ID: 301327

Seq. Order:	11
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.
General Data Type:	NUMBER

DOE

CC ID: 301328

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

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

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

Seq. Order:	15
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:	31016
GUID:	gov.noaa.nmfs.inport:31016
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2016-03-07 15:27+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: BENCONV

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

CRUISE_ID

STATION

REPLICATE_NUMBER

GEAR_CODE

SCINAME

CONV

WH_SPECIES_CODE

ORIGWGT

ORIGNUM

ORIGINAL_BENTHIC_KEY

RECID

DOE

UOE

DOC

UOC

Catalog Details