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

Summary

Abstract

Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains individual fish and invertebrate data.

Description

Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains individual fish and invertebrate data.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
CRUISE6
VARCHAR2
Code uniquely identifying cruise. The first four digits indicate the year and the last two digit uniquely identify the cruise within the year. The 5th byte signifies cruises other than groundfish: Shrimp survey = 7 (i.e. 201470), State of Massachusetts survey = 9 (i.e. 201491), Food habits = 5 (i.e.199554)
CRUISE
VARCHAR2
Unique numerical code for a cruise.
STRATUM
VARCHAR2
A predefined area where a net dredge, or other piece of gear was deployed. Code consists of 2 parts: Stratum group code number (2 bytes) and stratum number (3 bytes). Stratum group refers to if area fished is inshore or offshore North or South of Cape Hatteras or the type of cruise (shellfish, State of MA, offshore deepwater). The stratum number (third and fourth digits of code) refers to area defined by depth zone. See SVDBS.SVMSTRATA. The fifth digit of the code increases the length of the stratum number for revised strata after the Hague Line was established. Stratum group code: 01 = Trawl, offshore north of Hatteras; 02 = BIOM; 03 = Trawl, inshore north of Hatteras; 04 = Shrimp; 05 = Scotian shelf; 06 = Shellfish; 07 = Trawl, inshore south of Hatteras; 08 = Trawl, Offshore south of Hatteras; 09 = MA DMF; 99 = Offshore deepwater (outside the stratified area). A change in Bottom Trawl Stratum for the Gulf of Maine-Bay of Fundy has been in effect since Spring 1987, and may be summarized as follows: Previous strata: 01350; Present strata: 01351, 01352.
TOW
VARCHAR2
Sequential number representing order in which station was selected within a stratum.
STATION
VARCHAR2
Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number.
STATUS_CODE
VARCHAR2
Code referencing whether or not a cruise is available in the SVDBS system. See SVDBS.SVCRUISE_STATUS.
ID
VARCHAR2
Concatenation of Cruise6, Stratum, Tow and Station values.
SVSPP
VARCHAR2
A standard code which represents a species caught in a trawl or dredge. Refer to the SVDBS.SVSPECIES_LIST
CATCHSEX
VARCHAR2
Code used to identify species that are sexed at the catch level. See SVDBS.SEX_CODES
INDID
NUMBER
A unique identifier for each fish sampled.
LENGTH
NUMBER
Measured length of species in centimeters (cm). Measure method differs by species.
INDWT
NUMBER
Individual weight (KG) of species being sampled.
SEX
VARCHAR2
Code indicating sex of fish or invertebrate species. See SVDBS.FSCS_SEX_CODES if using fscs data and SVDBS.SEX_CODES if using non FSCS data. Codes 0, 1, 2 and 4 are the only valid codes in fscs tables.
MATURITY
VARCHAR2
Stage of maturation of the fish being sampled. See SVDBS.FSCS_MATURITY_CODES
AGE
NUMBER
Age of specimen in years.
AGE_DATA_FLAG
VARCHAR2
Code to indicate whether or not an age sample was taken. Values: Y = Yes, sample taken; NULL = no age sample taken.
STOM_VOLUME
NUMBER
Volume of the stomach contents of the fish sampled, measured to the nearest tenth of a cubic centimeter (cc).
STOM_WGT
NUMBER
Stomach weight of an individual fish in grams.
CUTTER
VARCHAR2
Name of the individual who was measuring and cutting fish at a FSCS workstation.
RECORDER
VARCHAR2
The name of the individual who recorded data.
IND_FISH_COMMENTS
VARCHAR2
Comment field for an indiviual fish or invertebrate sampled.

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: Table: UNION_FSCS_SVBIO
Short Name: UNION_FSCS_SVBIO
Status: Completed
Abstract:

Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains individual fish and invertebrate data.

Notes:

Loaded by batch 9078, 07-28-2016 12:36

Entity Information

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

Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains individual fish and invertebrate data.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
CRUISE6 VARCHAR2 Code uniquely identifying cruise. The first four digits indicate the year and the last two digit uniquely identify the cruise within the year. The 5th byte signifies cruises other than groundfish: Shrimp survey = 7 (i.e. 201470), State of Massachusetts survey = 9 (i.e. 201491), Food habits = 5 (i.e.199554)
100
CRUISE VARCHAR2 Unique numerical code for a cruise.
100
STRATUM VARCHAR2 A predefined area where a net dredge, or other piece of gear was deployed. Code consists of 2 parts: Stratum group code number (2 bytes) and stratum number (3 bytes). Stratum group refers to if area fished is inshore or offshore North or South of Cape Hatteras or the type of cruise (shellfish, State of MA, offshore deepwater). The stratum number (third and fourth digits of code) refers to area defined by depth zone. See SVDBS.SVMSTRATA. The fifth digit of the code increases the length of the stratum number for revised strata after the Hague Line was established. Stratum group code: 01 = Trawl, offshore north of Hatteras; 02 = BIOM; 03 = Trawl, inshore north of Hatteras; 04 = Shrimp; 05 = Scotian shelf; 06 = Shellfish; 07 = Trawl, inshore south of Hatteras; 08 = Trawl, Offshore south of Hatteras; 09 = MA DMF; 99 = Offshore deepwater (outside the stratified area). A change in Bottom Trawl Stratum for the Gulf of Maine-Bay of Fundy has been in effect since Spring 1987, and may be summarized as follows: Previous strata: 01350; Present strata: 01351, 01352.
100
TOW VARCHAR2 Sequential number representing order in which station was selected within a stratum.
100
STATION VARCHAR2 Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number.
100
STATUS_CODE VARCHAR2 Code referencing whether or not a cruise is available in the SVDBS system. See SVDBS.SVCRUISE_STATUS.
100
ID VARCHAR2 Concatenation of Cruise6, Stratum, Tow and Station values.
100
SVSPP VARCHAR2 A standard code which represents a species caught in a trawl or dredge. Refer to the SVDBS.SVSPECIES_LIST
100
CATCHSEX VARCHAR2 Code used to identify species that are sexed at the catch level. See SVDBS.SEX_CODES
100
INDID NUMBER A unique identifier for each fish sampled.
100
LENGTH NUMBER Measured length of species in centimeters (cm). Measure method differs by species.
100
INDWT NUMBER Individual weight (KG) of species being sampled.
100
SEX VARCHAR2 Code indicating sex of fish or invertebrate species. See SVDBS.FSCS_SEX_CODES if using fscs data and SVDBS.SEX_CODES if using non FSCS data. Codes 0, 1, 2 and 4 are the only valid codes in fscs tables.
100
MATURITY VARCHAR2 Stage of maturation of the fish being sampled. See SVDBS.FSCS_MATURITY_CODES
100
AGE NUMBER Age of specimen in years.
100
AGE_DATA_FLAG VARCHAR2 Code to indicate whether or not an age sample was taken. Values: Y = Yes, sample taken; NULL = no age sample taken.
100
STOM_VOLUME NUMBER Volume of the stomach contents of the fish sampled, measured to the nearest tenth of a cubic centimeter (cc).
100
STOM_WGT NUMBER Stomach weight of an individual fish in grams.
100
CUTTER VARCHAR2 Name of the individual who was measuring and cutting fish at a FSCS workstation.
100
RECORDER VARCHAR2 The name of the individual who recorded data.
100
IND_FISH_COMMENTS VARCHAR2 Comment field for an indiviual fish or invertebrate sampled.

Attribute Details

CRUISE6

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

Code uniquely identifying cruise. The first four digits indicate the year and the last two digit uniquely identify the cruise within the year. The 5th byte signifies cruises other than groundfish: Shrimp survey = 7 (i.e. 201470), State of Massachusetts survey = 9 (i.e. 201491), Food habits = 5 (i.e.199554)

General Data Type: VARCHAR2

CRUISE

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

Unique numerical code for a cruise.

General Data Type: VARCHAR2

STRATUM

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

A predefined area where a net dredge, or other piece of gear was deployed. Code consists of 2 parts: Stratum group code number (2 bytes) and stratum number (3 bytes). Stratum group refers to if area fished is inshore or offshore North or South of Cape Hatteras or the type of cruise (shellfish, State of MA, offshore deepwater). The stratum number (third and fourth digits of code) refers to area defined by depth zone. See SVDBS.SVMSTRATA. The fifth digit of the code increases the length of the stratum number for revised strata after the Hague Line was established. Stratum group code: 01 = Trawl, offshore north of Hatteras; 02 = BIOM; 03 = Trawl, inshore north of Hatteras; 04 = Shrimp; 05 = Scotian shelf; 06 = Shellfish; 07 = Trawl, inshore south of Hatteras; 08 = Trawl, Offshore south of Hatteras; 09 = MA DMF; 99 = Offshore deepwater (outside the stratified area). A change in Bottom Trawl Stratum for the Gulf of Maine-Bay of Fundy has been in effect since Spring 1987, and may be summarized as follows: Previous strata: 01350; Present strata: 01351, 01352.

General Data Type: VARCHAR2

TOW

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

Sequential number representing order in which station was selected within a stratum.

General Data Type: VARCHAR2

STATION

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

Unique sequential order in which stations have been completed. Hangups and short tows each receive a non-repeated consecutive number.

General Data Type: VARCHAR2

STATUS_CODE

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

Code referencing whether or not a cruise is available in the SVDBS system. See SVDBS.SVCRUISE_STATUS.

General Data Type: VARCHAR2

ID

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

Concatenation of Cruise6, Stratum, Tow and Station values.

General Data Type: VARCHAR2

SVSPP

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

A standard code which represents a species caught in a trawl or dredge. Refer to the SVDBS.SVSPECIES_LIST

General Data Type: VARCHAR2

CATCHSEX

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

Code used to identify species that are sexed at the catch level. See SVDBS.SEX_CODES

General Data Type: VARCHAR2

INDID

CC ID: 336896
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

A unique identifier for each fish sampled.

General Data Type: NUMBER

LENGTH

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

Measured length of species in centimeters (cm). Measure method differs by species.

General Data Type: NUMBER

INDWT

CC ID: 336898
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 7
Scale: 3
Status: Active
Description:

Individual weight (KG) of species being sampled.

General Data Type: NUMBER

SEX

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

Code indicating sex of fish or invertebrate species. See SVDBS.FSCS_SEX_CODES if using fscs data and SVDBS.SEX_CODES if using non FSCS data. Codes 0, 1, 2 and 4 are the only valid codes in fscs tables.

General Data Type: VARCHAR2

MATURITY

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

Stage of maturation of the fish being sampled. See SVDBS.FSCS_MATURITY_CODES

General Data Type: VARCHAR2

AGE

CC ID: 336901
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 2
Scale: 0
Status: Active
Description:

Age of specimen in years.

General Data Type: NUMBER

AGE_DATA_FLAG

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

Code to indicate whether or not an age sample was taken. Values: Y = Yes, sample taken; NULL = no age sample taken.

General Data Type: VARCHAR2

STOM_VOLUME

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

Volume of the stomach contents of the fish sampled, measured to the nearest tenth of a cubic centimeter (cc).

General Data Type: NUMBER

STOM_WGT

CC ID: 336904
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 3
Status: Active
Description:

Stomach weight of an individual fish in grams.

General Data Type: NUMBER

CUTTER

CC ID: 336905
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Name of the individual who was measuring and cutting fish at a FSCS workstation.

General Data Type: VARCHAR2

RECORDER

CC ID: 336907
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

The name of the individual who recorded data.

General Data Type: VARCHAR2

IND_FISH_COMMENTS

CC ID: 336908
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 500
Required: No
Primary Key: No
Status: Active
Description:

Comment field for an indiviual fish or invertebrate sampled.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 33643
GUID: gov.noaa.nmfs.inport:33643
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-28 12:36+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2019-05-31
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2019-05-31
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2020-05-31