Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

View of Benthic Cruise, Station and Catch Tables

Description

View of Benthic Cruise, Station and Catch Tables

Entity Information

Entity Type
Data View

Data Attribute / Type Description
YEAR
VARCHAR2
Year in which cruise was conducted.
PURPOSE_CODE
VARCHAR2
Code referencing purpose of cruise conducted. See table SVDBS.SVCRUISE_PURPOSE for list of purpose codes.
VESSEL
VARCHAR2
Two character field coding vessel name. Code assigned to vessel is in the NFMS master vessel table.
START_DATE
DATE
The date the vessel left the dock for the current cruise. Date format (DD-MON-YYYY).
END_DATE
DATE
The date the vessel returned to port. Date format (DD-MON-YYYY).
OPSID
VARCHAR2
Operation ID. Formatted as 4-digit year, 3 digit vessel cruise number, 4-character vessel code.
VESSEL_NUM
VARCHAR2
The nth consecutive number of a cruise on the given vessel.
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.
FIXED_SITE
VARCHAR2
Fixed site designation used primarily for repeatedly sampled fixed monitoring sites. Used in Sandy Hook data only.
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.
SAMPLE_DATE
DATE
Local date and time station was sampled. (24 hr. notation, formatted DD-MON-YYYY HH24:MI:SS) Time recorded to hour for Woods Hole data, recorded to minute for Sandy Hook data. If Daylight Savings Time was in effect at time of cruise, time is recorded in Daylight Savings Time. Time 00:00:00 indicates time not recorded.
SAMPLE_GMT_DATE
DATE
Greenwich mean date and time sample was taken (24 hr. notation, formatted DD-MON-YYYY HH24:MI:SS). Time recorded to hour for Woods Hole data, recorded to minute for Sandy Hook data. Time 00:00:00 indicates time not recorded. Sample GMT was calculated from SAMPLE_DATE.
ARRIVAL_DATE
DATE
Local date and time of arrival at station (24 hr. notation, formatted DD-MON-YYYY HH24:MI:SS). Not recorded for Woods Hole data. Sandy Hook data recorded to minute accuracy. If Daylight Savings Time was in effect at time of cruise, time is recorded in Daylight Savings Time. Time 00:00:00 indicates time not recorded.
ARRIVAL_GMT_DATE
DATE
Greenwich mean date and time of arrival at station (24 hr. notation, formatted DD-MON-YYYY HH24:MI:SS). Not recorded for Woods Hole data. Sandy Hook data recorded to minute accuracy. Time 00:00:00 indicates time not recorded. Arrival GMT calculated from ARRIVAL_DATE.
LAT
NUMBER
Latitude in degrees, minutes, tenths of minutes. Woods Hole data recorded to nearest minute, Sandy Hook data recorded to the tenth of minute.
LON
NUMBER
Longitude in degrees, minutes, tenths of minutes. Woods Hole data recorded to nearest minute, Sandy Hook data recorded to the tenth of minute.
LORX
VARCHAR2
Loran C time delay, X-Chain, only available for Sandy Hook data.
LORY
VARCHAR2
Loran C time delay, Y-Chain, only available for Sandy Hook data.
DEPTH
NUMBER
Depth (sample intensity) in meters. Some WH data corrected for velocity of sound in H2O.
BOTTEMP
NUMBER
Bottom temperature in tenths of degrees C
SED_TYPE_CODE
VARCHAR2
Bottom/Sediment Type
SED_VOLUME
NUMBER
Sediment volume in tenths of liters
SED_REMOVED
NUMBER
Sediment volume removed in tenths of liters
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).
CRC
VARCHAR2
Original Sandy Hook Cruise Code (Column CRC as taken from the BENTHOS.BRIDGE table).
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.
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.
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.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Item Identification

Title: View: BENV03
Short Name: BENV03
Status: Completed
Abstract:

View of Benthic Cruise, Station and Catch Tables

Notes:

Loaded by batch 8255, 03-08-2016 16:45

Entity Information

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

View of Benthic Cruise, Station and Catch Tables

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
YEAR VARCHAR2 Year in which cruise was conducted.
100
PURPOSE_CODE VARCHAR2 Code referencing purpose of cruise conducted. See table SVDBS.SVCRUISE_PURPOSE for list of purpose codes.
100
VESSEL VARCHAR2 Two character field coding vessel name. Code assigned to vessel is in the NFMS master vessel table.
100
START_DATE DATE The date the vessel left the dock for the current cruise. Date format (DD-MON-YYYY).
100
END_DATE DATE The date the vessel returned to port. Date format (DD-MON-YYYY).
100
OPSID VARCHAR2 Operation ID. Formatted as 4-digit year, 3 digit vessel cruise number, 4-character vessel code.
100
VESSEL_NUM VARCHAR2 The nth consecutive number of a cruise on the given vessel.
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
SAMPLE_DATE DATE Local date and time station was sampled. (24 hr. notation, formatted DD-MON-YYYY HH24:MI:SS) Time recorded to hour for Woods Hole data, recorded to minute for Sandy Hook data. If Daylight Savings Time was in effect at time of cruise, time is recorded in Daylight Savings Time. Time 00:00:00 indicates time not recorded.
100
SAMPLE_GMT_DATE DATE Greenwich mean date and time sample was taken (24 hr. notation, formatted DD-MON-YYYY HH24:MI:SS). Time recorded to hour for Woods Hole data, recorded to minute for Sandy Hook data. Time 00:00:00 indicates time not recorded. Sample GMT was calculated from SAMPLE_DATE.
100
ARRIVAL_DATE DATE Local date and time of arrival at station (24 hr. notation, formatted DD-MON-YYYY HH24:MI:SS). Not recorded for Woods Hole data. Sandy Hook data recorded to minute accuracy. If Daylight Savings Time was in effect at time of cruise, time is recorded in Daylight Savings Time. Time 00:00:00 indicates time not recorded.
100
ARRIVAL_GMT_DATE DATE Greenwich mean date and time of arrival at station (24 hr. notation, formatted DD-MON-YYYY HH24:MI:SS). Not recorded for Woods Hole data. Sandy Hook data recorded to minute accuracy. Time 00:00:00 indicates time not recorded. Arrival GMT calculated from ARRIVAL_DATE.
100
LAT NUMBER Latitude in degrees, minutes, tenths of minutes. Woods Hole data recorded to nearest minute, Sandy Hook data recorded to the tenth of minute.
100
LON NUMBER Longitude in degrees, minutes, tenths of minutes. Woods Hole data recorded to nearest minute, Sandy Hook data recorded to the tenth of minute.
100
LORX VARCHAR2 Loran C time delay, X-Chain, only available for Sandy Hook data.
100
LORY VARCHAR2 Loran C time delay, Y-Chain, only available for Sandy Hook data.
100
DEPTH NUMBER Depth (sample intensity) in meters. Some WH data corrected for velocity of sound in H2O.
100
BOTTEMP NUMBER Bottom temperature in tenths of degrees C
100
SED_TYPE_CODE VARCHAR2 Bottom/Sediment Type
100
SED_VOLUME NUMBER Sediment volume in tenths of liters
100
SED_REMOVED NUMBER Sediment volume removed in tenths of liters
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
CRC VARCHAR2 Original Sandy Hook Cruise Code (Column CRC as taken from the BENTHOS.BRIDGE table).
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.
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
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.

Attribute Details

YEAR

CC ID: 301621
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year in which cruise was conducted.

General Data Type: VARCHAR2

PURPOSE_CODE

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

Code referencing purpose of cruise conducted. See table SVDBS.SVCRUISE_PURPOSE for list of purpose codes.

General Data Type: VARCHAR2

VESSEL

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

Two character field coding vessel name. Code assigned to vessel is in the NFMS master vessel table.

General Data Type: VARCHAR2

START_DATE

CC ID: 301654
Seq. Order: 4
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

The date the vessel left the dock for the current cruise. Date format (DD-MON-YYYY).

General Data Type: DATE

END_DATE

CC ID: 301659
Seq. Order: 5
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

The date the vessel returned to port. Date format (DD-MON-YYYY).

General Data Type: DATE

OPSID

CC ID: 301660
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

Operation ID. Formatted as 4-digit year, 3 digit vessel cruise number, 4-character vessel code.

General Data Type: VARCHAR2

VESSEL_NUM

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

The nth consecutive number of a cruise on the given vessel.

General Data Type: VARCHAR2

RECID

CC ID: 301662
Seq. Order: 8
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: 301663
Seq. Order: 9
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: 301622
Seq. Order: 10
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: 301623
Seq. Order: 11
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: 301624
Seq. Order: 12
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: 301625
Seq. Order: 13
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: 301626
Seq. Order: 14
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: 301627
Seq. Order: 15
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: 301628
Seq. Order: 16
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

SAMPLE_DATE

CC ID: 301629
Seq. Order: 17
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Local date and time station was sampled. (24 hr. notation, formatted DD-MON-YYYY HH24:MI:SS) Time recorded to hour for Woods Hole data, recorded to minute for Sandy Hook data. If Daylight Savings Time was in effect at time of cruise, time is recorded in Daylight Savings Time. Time 00:00:00 indicates time not recorded.

General Data Type: DATE

SAMPLE_GMT_DATE

CC ID: 301630
Seq. Order: 18
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Greenwich mean date and time sample was taken (24 hr. notation, formatted DD-MON-YYYY HH24:MI:SS). Time recorded to hour for Woods Hole data, recorded to minute for Sandy Hook data. Time 00:00:00 indicates time not recorded. Sample GMT was calculated from SAMPLE_DATE.

General Data Type: DATE

ARRIVAL_DATE

CC ID: 301631
Seq. Order: 19
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Local date and time of arrival at station (24 hr. notation, formatted DD-MON-YYYY HH24:MI:SS). Not recorded for Woods Hole data. Sandy Hook data recorded to minute accuracy. If Daylight Savings Time was in effect at time of cruise, time is recorded in Daylight Savings Time. Time 00:00:00 indicates time not recorded.

General Data Type: DATE

ARRIVAL_GMT_DATE

CC ID: 301633
Seq. Order: 20
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Greenwich mean date and time of arrival at station (24 hr. notation, formatted DD-MON-YYYY HH24:MI:SS). Not recorded for Woods Hole data. Sandy Hook data recorded to minute accuracy. Time 00:00:00 indicates time not recorded. Arrival GMT calculated from ARRIVAL_DATE.

General Data Type: DATE

LAT

CC ID: 301634
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Latitude in degrees, minutes, tenths of minutes. Woods Hole data recorded to nearest minute, Sandy Hook data recorded to the tenth of minute.

General Data Type: NUMBER

LON

CC ID: 301635
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Longitude in degrees, minutes, tenths of minutes. Woods Hole data recorded to nearest minute, Sandy Hook data recorded to the tenth of minute.

General Data Type: NUMBER

LORX

CC ID: 301636
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Loran C time delay, X-Chain, only available for Sandy Hook data.

General Data Type: VARCHAR2

LORY

CC ID: 301637
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

Loran C time delay, Y-Chain, only available for Sandy Hook data.

General Data Type: VARCHAR2

DEPTH

CC ID: 301638
Seq. Order: 25
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 0
Status: Active
Description:

Depth (sample intensity) in meters. Some WH data corrected for velocity of sound in H2O.

General Data Type: NUMBER

BOTTEMP

CC ID: 301639
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 3
Status: Active
Description:

Bottom temperature in tenths of degrees C

General Data Type: NUMBER

SED_TYPE_CODE

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

Bottom/Sediment Type

General Data Type: VARCHAR2

SED_VOLUME

CC ID: 301641
Seq. Order: 28
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

Sediment volume in tenths of liters

General Data Type: NUMBER

SED_REMOVED

CC ID: 301642
Seq. Order: 29
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 4
Scale: 1
Status: Active
Description:

Sediment volume removed in tenths of liters

General Data Type: NUMBER

ORIGINAL_BENTHIC_KEY

CC ID: 301644
Seq. Order: 30
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

CRC

CC ID: 301645
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Original Sandy Hook Cruise Code (Column CRC as taken from the BENTHOS.BRIDGE table).

General Data Type: VARCHAR2

DATA_SOURCE

CC ID: 301646
Seq. Order: 32
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: 301647
Seq. Order: 33
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: 301648
Seq. Order: 34
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: 301649
Seq. Order: 35
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: 301650
Seq. Order: 36
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

SCINAME

CC ID: 301651
Seq. Order: 37
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: 301652
Seq. Order: 38
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: 301653
Seq. Order: 39
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: 301655
Seq. Order: 40
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: 301656
Seq. Order: 41
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: 301657
Seq. Order: 42
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

CATALOG

CC ID: 301658
Seq. Order: 43
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

Catalog Details

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