Item Identification

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

Materialized view joining pre-FSCS and FSCS data sets into one structure. Contains total number of fish caught at each length for all species at a station.

Notes:

Loaded by batch 9099, 07-29-2016 11:48

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 total number of fish caught at each length for all species at a station.

Data Attributes

Attribute Summary

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 Cruise, 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
LENGTH NUMBER Measured length of species in centimeters (cm). Measure method differs by species.
100
EXPNUMLEN NUMBER Expanded number of specimens at a given length.
100
LOGGED_SPECIES_NAME VARCHAR2 Name of the species, either common, scientific or both.
100
LENGTH_COMMENT VARCHAR2 Comment related to length of individual fish.

Attribute Details

CRUISE6

CC ID: 340086
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: 340091
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: 340092
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: 340093
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: 340094
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: 340095
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: 340096
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 18
Required: No
Primary Key: No
Status: Active
Description:

Concatenation of Cruise, Stratum, Tow and Station values.

General Data Type: VARCHAR2

SVSPP

CC ID: 340097
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: 340098
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

LENGTH

CC ID: 340087
Seq. Order: 10
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

EXPNUMLEN

CC ID: 340088
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 0
Status: Active
Description:

Expanded number of specimens at a given length.

General Data Type: NUMBER

LOGGED_SPECIES_NAME

CC ID: 340089
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 45
Required: No
Primary Key: No
Status: Active
Description:

Name of the species, either common, scientific or both.

General Data Type: VARCHAR2

LENGTH_COMMENT

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

Comment related to length of individual fish.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 33823
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-29 11:48+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2019-05-31
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2020-05-31