Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Historical support table containing all acceptable stratum codes.

Notes:

Loaded by batch 9087, 07-28-2016 17:26

Entity Information

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

Historical support table containing all acceptable stratum codes.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
STRGRP_DESC VARCHAR2 Description of stratum group.
100
Primary Key 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
STRATUM_NAME VARCHAR2 Name of stratum area.
100
STRATUM_AREA NUMBER Stratum area measured in square nautical miles.
100
MIDLAT NUMBER Middle latitude in stratum for auditing purposes.
100
MIDLON NUMBER Middle longitude in stratum for auditing purposes.
100
MINLAT NUMBER Minimum latitude in stratum for auditing purposes.
100
MAXLAT NUMBER Maximum latitude in stratum for auditing purposes.
100
MINLON NUMBER Minimum longitude in stratum for auditing purposes.
100
MAXLON NUMBER Maximum longitude in stratum for auditing purposes.
100
BLOCKS NUMBER Statistical area blocks.
100
NOTOWS NUMBER Number of tows for a given stratum.
100
DOE DATE Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS).
100
DOC DATE Date when the current record was updated or changed. Date format (MM/DD/YY HH:MI:SS)
100
UOE VARCHAR2 The Oracle username of the individual who entered the new record.
100
UOC VARCHAR2 The Oracle username of the individual who changed the current record.

Attribute Details

STRGRP_DESC

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

Description of stratum group.

General Data Type: VARCHAR2

STRATUM

CC ID: 337792
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 5
Required: Yes
Primary Key: Yes
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

STRATUM_NAME

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

Name of stratum area.

General Data Type: VARCHAR2

STRATUM_AREA

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

Stratum area measured in square nautical miles.

General Data Type: NUMBER

MIDLAT

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

Middle latitude in stratum for auditing purposes.

General Data Type: NUMBER

MIDLON

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

Middle longitude in stratum for auditing purposes.

General Data Type: NUMBER

MINLAT

CC ID: 337797
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Minimum latitude in stratum for auditing purposes.

General Data Type: NUMBER

MAXLAT

CC ID: 337798
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Maximum latitude in stratum for auditing purposes.

General Data Type: NUMBER

MINLON

CC ID: 337799
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Minimum longitude in stratum for auditing purposes.

General Data Type: NUMBER

MAXLON

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

Maximum longitude in stratum for auditing purposes.

General Data Type: NUMBER

BLOCKS

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

Statistical area blocks.

General Data Type: NUMBER

NOTOWS

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

Number of tows for a given stratum.

General Data Type: NUMBER

DOE

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

Date when record was inserted into Oracle. Date format (MM/DD/YY HH:MI:SS).

General Data Type: DATE

DOC

CC ID: 337789
Seq. Order: 14
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 (MM/DD/YY HH:MI:SS)

General Data Type: DATE

UOE

CC ID: 337790
Seq. Order: 15
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

UOC

CC ID: 337791
Seq. Order: 16
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: 33725
GUID: gov.noaa.nmfs.inport:33725
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-28 17:26+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