Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Data Management Systems (DMS) > Benthic Habitat Database >

Table: BENSTRATUM

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

Item Identification

Title: Table: BENSTRATUM
Short Name: BENSTRATUM
Status: Completed
Abstract:

Benthic Grosslein Stratum Codes and Description Support Table
Notes:

Loaded by batch 8235, 03-07-2016 15:27

Entity Information

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

Benthic Grosslein Stratum Codes and Description Support Table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
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
 STRATUM_DESC VARCHAR2 Name of stratum area.
100
 SVDBS_STRATUM VARCHAR2 5 digit stratum from Survey table SVDBS.SVMSTRATUM from which the stratum description was taken.
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

STRATUM

CC ID: 301352
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 2
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

STRATUM_DESC

CC ID: 301353
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Name of stratum area.
General Data Type: VARCHAR2

SVDBS_STRATUM

CC ID: 301354
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

5 digit stratum from Survey table SVDBS.SVMSTRATUM from which the stratum description was taken.
General Data Type: VARCHAR2

DOE

CC ID: 301355
Seq. Order: 4
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: 301356
Seq. Order: 5
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: 301357
Seq. Order: 6
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: 301358
Seq. Order: 7
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: 31019
GUID: gov.noaa.nmfs.inport:31019
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