Metadata Rubric

100%

6 / 6

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

Table: BENTXN

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Benthic Taxonomic Names Table (Woods Hole data only)

Description

Benthic Taxonomic Names Table (Woods Hole data only)

Entity Type
Data Table

Data Attribute / Type	Description
RECID NUMBER	Unique record identifier assigned to record. This record id was taken from the original benthic field TXNSORT.
SCINAME VARCHAR2	Scientific name for specimen.
NODC_CODE VARCHAR2	NODC code for species. (currently not available)
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.
TXN_TYPE VARCHAR2	Taxonomic type code. 1 = Scientific name, 2 = Synonym name, 3 = Common name, 4 = Common synonym name
SYN VARCHAR2	Synonym indicator. S for synonym names, blank for scientific names.
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. This record id was taken from the original benthic field TXNSORT.

SCINAME
VARCHAR2

Scientific name for specimen.

NODC_CODE
VARCHAR2

NODC code for species. (currently not available)

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.

TXN_TYPE
VARCHAR2

Taxonomic type code. 1 = Scientific name, 2 = Synonym name, 3 = Common name, 4 = Common synonym name

SYN
VARCHAR2

Synonym indicator. S for synonym names, blank for scientific names.

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: BENTXN
Short Name:	BENTXN
Status:	Completed
Abstract:	Benthic Taxonomic Names 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 Taxonomic Names Table (Woods Hole data only)

Attribute Summary

	Name	Type	Description
100	RECID	NUMBER	Unique record identifier assigned to record. This record id was taken from the original benthic field TXNSORT.
100	SCINAME	VARCHAR2	Scientific name for specimen.
100	NODC_CODE	VARCHAR2	NODC code for species. (currently not available)
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	TXN_TYPE	VARCHAR2	Taxonomic type code. 1 = Scientific name, 2 = Synonym name, 3 = Common name, 4 = Common synonym name
100	SYN	VARCHAR2	Synonym indicator. S for synonym names, blank for scientific names.
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. This record id was taken from the original benthic field TXNSORT.

100

SCINAME

VARCHAR2

Scientific name for specimen.

100

NODC_CODE

VARCHAR2

NODC code for species. (currently not available)

100

WH_SPECIES_CODE

VARCHAR2

100

TXN_TYPE

VARCHAR2

Taxonomic type code. 1 = Scientific name, 2 = Synonym name, 3 = Common name, 4 = Common synonym name

100

SYN

VARCHAR2

Synonym indicator. S for synonym names, blank for scientific names.

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

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. This record id was taken from the original benthic field TXNSORT.
General Data Type:	NUMBER

SCINAME

CC ID: 301361

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

NODC_CODE

CC ID: 301362

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	NODC code for species. (currently not available)
General Data Type:	VARCHAR2

WH_SPECIES_CODE

CC ID: 301363

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

TXN_TYPE

CC ID: 301364

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Taxonomic type code. 1 = Scientific name, 2 = Synonym name, 3 = Common name, 4 = Common synonym name
General Data Type:	VARCHAR2

SYN

CC ID: 301365

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Synonym indicator. S for synonym names, blank for scientific names.
General Data Type:	VARCHAR2

DOE

CC ID: 301366

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

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

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

Seq. Order:	10
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:	31020
GUID:	gov.noaa.nmfs.inport:31020
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: BENTXN

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

RECID

SCINAME

NODC_CODE

WH_SPECIES_CODE

TXN_TYPE

SYN

DOE

UOE

DOC

UOC

Catalog Details